How to Jump to the Last Used Cell in Excel (Ctrl+End)

Ctrl+End moves the cursor to the last cell of the used range — the intersection of the furthest row and the furthest column Excel considers occupied. On a Mac it is Cmd+End, or Fn+Ctrl+Right on a keyboard without a dedicated End key. **The last used cell is often not where your data ends.** This is the single thing worth understanding about the shortcut, because it explains almost every surprise it produces. Excel tracks the used range as the largest rectangle that has ever contained content or formatting in this session's history of the file, and deleting content does not always shrink it. A stray space typed into BC4000 years ago, a fill colour applied to an entire column, a pasted range later cleared — any of these leave the used range extended, so Ctrl+End lands in an empty cell far below and to the right of anything you can see. **That makes it a genuine diagnostic.** If Ctrl+End takes you to R98000 in a spreadsheet with four hundred rows of data, the file is carrying tens of thousands of rows of phantom used range. That is the usual explanation for a workbook that is inexplicably large, slow to open, or slow to recalculate, and for a scroll bar whose thumb is a sliver. Checking with Ctrl+End is the fastest way to confirm the diagnosis. **Fixing it takes a specific sequence.** Select the first genuinely empty row beneath your data, press Ctrl+Shift+Down to select to the bottom, and delete the entire rows — not their contents, the rows themselves. Repeat with columns to the right using Ctrl+Shift+Right. Then save, close and reopen the file. The used range is only recalculated on save, so skipping that step makes it look as though nothing happened. **Ctrl+End is not the same as Ctrl+Down.** Ctrl+End goes to the corner of the used range, once, regardless of gaps. Ctrl+Down moves to the edge of the current contiguous block and stops at the first blank cell, so on data with gaps it takes several presses to reach the bottom. One answers 'how far does this sheet extend'; the other answers 'where does this run of data stop'. **The counterpart is Ctrl+Home**, which returns to A1 regardless of freeze panes or scroll position. Together they bracket the sheet — one keystroke to each corner — which is the fastest way to get a sense of an unfamiliar workbook's real dimensions before you start working in it. **Adding Shift selects instead of moving.** Ctrl+Shift+End selects everything from the current cell to the last used cell, which is the standard way to grab an entire data region for copying or formatting when you do not know how far it extends. Just be aware that it inherits the same phantom-range problem: on a file with a bloated used range, Ctrl+Shift+End selects the phantom area too, and applying formatting to that selection makes the bloat permanent. **On a Mac keyboard without an End key**, Fn+Ctrl+Right does the same job, and Fn+Ctrl+Left is the Home equivalent. Compact Apple keyboards omit the navigation cluster entirely, which makes these two of the more useful Fn combinations to know for anyone doing spreadsheet work on a laptop.