Move to Last Cell in Worksheet in Excel (Ctrl + End)
In large or complex worksheets, finding the last used cell manually can be slow. This shortcut allows you to instantly jump to the bottom-right cell that contains data.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + End | Cmd + End |
What Does This Shortcut Do?
This shortcut moves the active cell to the last used cell in the worksheet, based on rows and columns that have contained data or formatting.
How to Use the Shortcut
- Click anywhere inside the worksheet
- Press Ctrl + End (Windows) or Cmd + End (Mac)
- The cursor jumps to the final used row and column
Tips & Best Practices
- Extra formatting can extend the last used cell unexpectedly
- Clear unused rows or columns to reset the worksheet boundary
- Use Ctrl + Shift + End to select everything to the last cell
FAQ
- Q: Why does Ctrl + End go too far?
- Excel counts formatted cells as used, even if they contain no data.
- Q: Does this work in Excel Tables?
- Yes, but it may jump beyond the table if extra formatting exists.
- Q: Can I reset the last used cell?
- Yes, delete unused rows/columns and save the workbook.