Introduction
Microsoft Excel is the most widely used tool for working with numbers and lists. Shops keep their stock in it, teachers keep marks, accountants build budgets and analysts clean data before it goes anywhere else. Everything in this course works the same way in Excel for Microsoft 365 on Windows and on Mac, and in recent perpetual versions such as Excel 2021, except where a lesson says otherwise. This first lesson is about finding your way: what you are looking at, how cells are named, and how to move around quickly.
This is a reading course. There is nothing to run on this page: open Excel beside it and try each step as you read.
How it works
An Excel file is a workbook. A new workbook usually has one worksheet, and you can add more with the plus button next to the sheet tabs at the bottom. A worksheet is a grid of 1,048,576 rows, numbered from 1, and 16,384 columns, lettered A to Z, then AA to AZ, and so on up to XFD.
Each cell is named by its column letter followed by its row number: B3 is the cell in column B, row 3. A range is a rectangle of cells, written as its top-left and bottom-right cells joined by a colon: A1:D10 is 40 cells, four columns wide and ten rows tall. A whole column is written C:C and a whole row 5:5.
The parts of the window you will use most:
- The ribbon at the top holds the commands, grouped into tabs: Home, Insert, Formulas, Data and others.
- The Name Box, at the left above the grid, shows the address of the active cell. Type an address such as
K200into it and press Enter to jump there. - The formula bar, next to the Name Box, shows what is really stored in the active cell. If a cell shows 150 but the formula bar shows
=A1*3, the cell holds a formula. - The sheet tabs at the bottom switch between worksheets. Double-click a tab to rename it.
- The status bar at the very bottom shows the sum, average and count of the selected cells, without any formula.
Moving with the mouse is fine for small sheets. For anything bigger, the keyboard is much faster: arrow keys move one cell, Ctrl plus an arrow jumps to the last filled cell before a gap, and adding Shift selects everything on the way.
Save your work as an Excel Workbook (.xlsx). Files with macros need .xlsm, and .csv keeps only the values of one sheet, losing formulas and formatting.
Example
A small shop keeps its stock on a sheet called Stock:
| A | B | C | |
|---|---|---|---|
| 1 | Item | Price | Quantity |
| 2 | Pen | 20 | 150 |
| 3 | Notebook | 60 | 80 |
| 4 | Bag | 900 | 12 |
You need to look at the Bag's quantity, then select all the data.
Line by line
- Click any cell, type
C4in the Name Box and press Enter: the active cell moves to C4, the Bag's quantity. - Press Ctrl+Home to go back to A1, the top-left cell of the sheet.
- Press Ctrl+Shift+End to select from A1 to the last used cell, which selects the range
A1:C4. - Look at the status bar: it shows the average, count and sum of the numbers in the selection.
Expected result
After step 1 the Name Box shows C4 and the formula bar shows 12. After step 3 the range A1:C4 is highlighted and the status bar shows Sum: 1222 (20 + 60 + 900 + 150 + 80 + 12), Count: 12 and Average: about 203.67, because text cells are counted but not added.
In the real world
Real workbooks often have dozens of sheets and tens of thousands of rows. People who work in Excel all day rarely scroll: they jump with the Name Box, Ctrl plus arrows and the Go To command, and they check totals in the status bar before writing a single formula. Naming sheets clearly, such as Sales 2026 rather than Sheet3, saves everyone time later.
Common mistakes
- Confusing what a cell shows with what it holds: always check the formula bar.
- Saving as CSV by accident, which throws away formulas, formatting and every sheet but one.
- Scrolling through thousands of rows instead of jumping with Ctrl plus an arrow key.
- Typing in the wrong cell because the active cell was not where you thought; glance at the Name Box first.
Best practices
- Give every sheet a short, meaningful name.
- Keep one table of data per sheet, starting in A1, with headings in row 1.
- Learn the navigation shortcuts below first: they pay off every day.
Keyboard shortcuts
| Action | Windows | Mac |
|---|---|---|
| Jump to the edge of the data in a direction | Ctrl+Arrow key | Command+Arrow key |
| Select to the edge of the data | Ctrl+Shift+Arrow key | Command+Shift+Arrow key |
| Go to cell A1 | Ctrl+Home | — |
| Go to the last used cell | Ctrl+End | — |
| Open Go To | F5 or Ctrl+G | Control+G |
| Next worksheet | Ctrl+Page Down | Option+Right Arrow |
| Previous worksheet | Ctrl+Page Up | Option+Left Arrow |
| Select the whole column | Ctrl+Space | Control+Space |
| Select the whole row | Shift+Space | Shift+Space |
| Save | Ctrl+S | Command+S |
| New workbook | Ctrl+N | Command+N |
Summary
A workbook is a file of worksheets, and a worksheet is a grid of cells named by column letter and row number. Ranges join two cells with a colon. The Name Box shows and jumps to addresses, the formula bar shows what a cell really holds, and the status bar adds up a selection. Keyboard navigation with Ctrl and the arrow keys is the quickest way around.
Quick check
Key takeaways
- A workbook holds worksheets; a worksheet is a grid of cells named by column letter and row number.
- The Name Box shows the active cell's address and can jump to any cell or range.
- Ctrl plus an arrow key jumps to the edge of a block of data, which is the fastest way around a large sheet.
My notes
Write down what you want to remember from this lesson. Notes are saved on this device as you type, and appear on your dashboard.