Course contents · Excel interface and options

Moving around a workbook

Open the practice in the trainer →

In large tables the mouse is slow. Here is how to get where you need quickly.

Keys

Ctrl+←↑→↓to the edge of the data region; with Shift — select to the edge
Ctrl+Home / Ctrl+Endto A1 / to the last used cell of the sheet
PgUp / PgDn, Alt+PgUp / PgDnone screen up/down, left/right
Ctrl+PgUp / PgDnprevious / next sheet
Ctrl+Backspacescroll back to the active cell if you lost it
F5 or Ctrl+Gthe Go To dialog: an address, range or name; the Special… button opens Go To Special
Ctrl+F / Ctrl+Hfind / replace

The Name Box

Type an address (T60), a range (B2:B51) or a name into the Name Box and press Enter — Excel goes there and selects it. Select a range and type a new word into the Name Box, and the range gets that name.

Go To Special

Home → Find & Select → Go To Special (or F5 → Special…). Selects all formulas, constants, blanks, the last cell or visible cells only, at once. Example: select the blank cells and fill them all with one Ctrl+Enter.

The View tab

Right-click the arrows left of the sheet tabs to get a list of all sheets — handy when there are dozens.

Excel for Mac. Use ⌘+arrows instead of Ctrl+arrows. Go To is Ctrl+G or fn+F5; Go To Special is Edit → Find → Go To → Special. There is no Navigation pane in Excel for Mac. Freeze Panes is on the View tab, as in Windows.

Tasks in the Excel emulator

  1. This is a real trainer sheet with a 50-row list. Go to B2 and press Ctrl+↓ — you land at the end of the list. In B52 sum the whole column (tip: Alt+=).
  2. Use the Name Box (left of the formula bar) to go to G45 and type the number 45 there.
  3. Ctrl+End jumps to the last used cell of the sheet — a number is hidden there. In D1 write a reference to that cell.

Solve the tasks in the trainer →

Check yourself

  1. How do you quickly select all blank cells in a table?
  2. What does Freeze Top Row do?