Module 01 · Lesson 02
The Excel screen
Six parts you'll use every single day.
Excel basics4 min
| Part | What it does |
|---|---|
| Ribbon | Tabs (Home, Insert, Page Layout…) holding every tool. Press Alt to see letter shortcuts. |
| Name Box | Shows the selected cell (B5). Type an address here and press Enter to jump to it. |
| Formula bar | Shows what is really in the cell: the value or the formula. |
| Cell | Where a column meets a row: column B, row 5 = B5. |
| Sheet tabs | Pages of the workbook. Right-click to rename or colour. |
| Status bar | Select numbers: Sum, Average and Count appear here, no formula needed. |
Move & select
- Ctrl↓
- Jump to the last filled cell below
- CtrlHome
- Go back to cell A1
- CtrlShift↓
- Select from here to the end of the data
- CtrlA
- Select the whole table (press twice: whole sheet)
- ShiftSpace
- Select the whole row
- CtrlSpace
- Select the whole column
Type & edit
- F2
- Edit the cell without retyping
- CtrlD
- Copy the cell above down (Fill Down)
- CtrlEnter
- Type once, fill every selected cell
- AltEnter
- New line inside the same cell
- CtrlZ
- Undo (Ctrl+Y redo)
- Ctrl;
- Insert today's date