📎 This article includes 1 downloadable practice file ↓
In this article
Most people learn Excel by clicking around until something works. That’s fine until you see a colleague fly through the same sheet in half the time. The difference is usually not formulas. It’s knowing what’s on the screen and how to move without the mouse. That’s this lesson.
Workbook, worksheet, cell
- A workbook is the file (.xlsx). It holds one or more worksheets, the tabs at the bottom.
- A sheet is a grid of columns (letters A, B, C … XFD) and rows (numbers 1 to 1,048,576). That’s 16,384 columns.
- Where a column meets a row is a cell, named by its column then row:
B6is column B, row 6. - A block of cells is a range, written with a colon:
A2:E11means from A2 to E11.
The parts of the screen
| Part | Where | What it’s for |
|---|---|---|
| Ribbon | Top | All commands, grouped in tabs: Home (formatting), Insert (charts, tables), Formulas, Data (sort, filter), Review, View |
| Name Box | Left, above column A | Shows the current cell’s address; type an address like K500 and press Enter to jump there |
| Formula bar | Right of the Name Box | Shows what’s really in the cell, e.g. the formula behind a number |
| Sheet tabs | Bottom left | Switch, rename (double-click), add (+), move (drag) sheets |
| Status bar | Bottom | Select some numbers and it shows their Sum, Average and Count, no formula needed |
| Zoom | Bottom right | Or Ctrl + mouse wheel |
Moving fast with the keyboard
| Keys | Does |
|---|---|
| Arrow keys | One cell at a time |
| Ctrl + Arrow | Jump to the edge of the data (the last filled cell in that direction) |
| Ctrl + Home / Ctrl + End | Go to A1 / go to the last used cell |
| Ctrl + Shift + Arrow | Select from here to the edge of the data |
| Ctrl + A | Select the whole data block (press again for the whole sheet) |
| Ctrl + Page Down / Page Up | Next / previous sheet |
| F2 | Edit the current cell |
| Ctrl + Z / Ctrl + Y | Undo / redo |
| Ctrl + S | Save (press it often) |
Try it now in the practice file: click A1 on the Data sheet, press Ctrl+Down to reach the last product, Ctrl+Right to reach the last column, then Ctrl+Home to come back.
Typing into cells
- Type and press Enter (moves down) or Tab (moves right).
- Press Esc to cancel a typing mistake before you press Enter.
- Text lines up on the left, numbers and dates on the right. If a “number” sits on the left, Excel is treating it as text; we’ll fix that in later lessons.
#####in a cell just means the column is too narrow. Double-click the border between the column letters to auto-fit.
Saving and file types
| Type | Use |
|---|---|
| .xlsx | Normal workbook (default) |
| .xlsm / .xlsb | Workbooks with macros (.xlsb is also smaller and faster) |
| .csv | Plain data for other software; only one sheet, no formatting or formulas |
| File › Save As › PDF for sending a read-only copy |
Where beginners go wrong
| Habit | Better |
|---|---|
| Scrolling through 5,000 rows with the mouse | Ctrl + Down |
| Dragging to select a long column | Ctrl + Shift + Down |
| Typing a total with a calculator | Select the numbers and read the status bar, or use SUM (Lesson 5) |
| One giant sheet for everything | One sheet per kind of data, clearly named tabs |
Practice
Download this lesson’s workbook below. It has a 10-product list and 8 questions about cells, rows, columns and sheet size. Type your answers in the yellow column; the Check column turns green when you’re right, and the Answers sheet shows a working formula for every task.
📎 Practice files for this article
- 📗Lesson 1 practice workbookA small product list plus 8 questions about cells, rows, columns and the size of a sheet.⬇ XLSX · 13 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
Stuck on a step? Ask a question and the AI answers using this article.