Skip to content

Module 01 · Lesson 02

The Excel screen

Six parts you'll use every single day.

Excel basics4 min
PartWhat it does
RibbonTabs (Home, Insert, Page Layout…) holding every tool. Press Alt to see letter shortcuts.
Name BoxShows the selected cell (B5). Type an address here and press Enter to jump to it.
Formula barShows what is really in the cell: the value or the formula.
CellWhere a column meets a row: column B, row 5 = B5.
Sheet tabsPages of the workbook. Right-click to rename or colour.
Status barSelect 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