These are my top 10 Navigation Tips … I do them without thinking, but have recently had to show a few younger folks that using your mouse isn’t the most efficient way to navigate Excel. For anyone else who needs a navigation refresher, these will make working in your spreadsheets much faster:
- [Ctrl]+[Home] takes you to cell A1
- [Ctrl]+[End] takes you to the last data cell in your worksheet
- [Ctrl]+[PgDn] takes you to the next worksheet
- [Ctrl]+[PgUp] takes you to the previous worksheet
- [End]+[↑] takes you to the top of the row
- [End]+[↓] takes you to the bottom of the row
- [End]+[→] takes you to the furthest right entry in the row
- [End]+[←] takes you to the furthest left entry in the row
- [Ctrl]+[A] selects/highlights all cells that you are using in a worksheet
- [Shift]+[Spacebar] selects/highlights your row
No comments:
Post a Comment