Wauvel

Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← All tips & shortcuts

Jump to the start or the end

CtrlHomeEditing & references

Leap to cell A1, or to the last used cell, from anywhere in the sheet.

Difficulty

Beginner
Practice file

1What it does

Ctrl + Home snaps the cursor back to A1 from wherever you are; Ctrl + End jumps to the bottom-right corner of the used range — the intersection of the last row and last column that hold data. Ctrl + End is also a quick diagnostic: if it lands far past your real data, there's stray formatting or leftover content bloating the file.

2The shortcut

CtrlHome
  1. 1Press Ctrl + Home to jump to A1 instantly.
  2. 2Press Ctrl + End to jump to the last used cell.
  3. 3If Ctrl + End overshoots your data, clear the extra rows/columns and save.

3Before → after

Press the shortcut to play it on a sample sheet.

or press the keys for real

Before — cursor somewhere in the middle

ABCD
1
2
3
4•

Ctrl + Home snaps to A1; Ctrl + End jumps to the last used cell. If End overshoots your data, stray formatting is bloating the sheet.

4When you use it

  • Return to the top of a large sheet without scrolling.
  • Jump to where the data ends to check its true extent.
  • Diagnose a bloated file when Ctrl + End lands far past the data.

5Related functions

Want these moves already done for you? Wauvel's free tools download as branded, formula-driven Excel models — Tables, named ranges, and all.

Learn the moves here — or let Wauvel run them on your numbers.

Get my free report →