🟢 Beginner 15 minbeginner path

Beginner Excel: Interface, Rows, Columns & Navigation

This is your first real tour of Excel. You'll learn the Ribbon, the Name Box, the Formula Bar, how to move around a workbook with your keyboard, how to select ranges, and how to save and reopen your files without losing work.

Learning objectives

Identify every part of the Excel window by name.
Move around a worksheet with the mouse and the keyboard.
Select single cells, ranges, whole rows, whole columns, and the whole sheet.
Save, close, and reopen an .xlsx workbook.

Step-by-step

1. The Ribbon and tabs

The Ribbon runs across the top. Home, Insert, Page Layout, Formulas, Data, Review, and View each hold related tools. You'll spend most of your time on the Home tab (fonts, alignment, number formatting, sort & filter, find/replace).

2. Name Box and Formula Bar

The Name Box (top-left) shows the address of the active cell — you can type any address like Z500 and press Enter to jump there. The Formula Bar (to its right) shows whatever is really inside the cell — very useful when a formula displays as a value.

3. Rows, columns, and cells

Rows run horizontally and are numbered. Columns run vertically and are lettered A through XFD. A cell is the intersection: B7, AA12. Right-click a row or column header to insert, delete, or resize.

4. Navigating with the keyboard

Arrow keys move one cell. Ctrl+Arrow jumps to the last non-empty cell in that direction. Ctrl+Home returns to A1. Ctrl+End goes to the last used cell. Page Down/Up moves one screen.

5. Selecting ranges

Click and drag, or click one cell and Shift+click another. Shift+Arrow extends selection one cell at a time. Ctrl+Shift+Arrow extends to the last filled cell. Ctrl+A selects the current region; press again to select the whole sheet.

6. Saving and reopening

Ctrl+S saves. First save asks for a filename — use .xlsx. File → Recent shows your last workbooks. Turn on AutoSave when the file is stored in OneDrive or SharePoint.