Moving fast: Ctrl+Arrow, Ctrl+Home/End, Go To (F5)

In this lesson

1. 1. Jump to the bottom

   Real sheets can have hundreds of rows. Scrolling takes a long time.

   A shortcut takes you to the last filled cell in one move.

2. 2. Jump to the right

   The same idea works in every direction.

   Use the Right arrow to jump to the last filled cell in the row.

3. 3. Back to the start

   This shortcut always takes you back to cell A1.

4. 4. Go to the last used cell

   This shortcut goes to the last row and last column that have data.

   It shows you how big the data is.

5. 5. Go To a cell

   The Go To box takes you to any address. It works like the Name Box.

6. 6. Try it yourself

   Use the keyboard only. Do not scroll.

Part of Excel Essentials. Short lessons with practice in a real spreadsheet, checked as you go.