Saturday, April 11, 2009

Top 10 Navigation Tips for Microsoft Excel

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:

  1. [Ctrl]+[Home] takes you to cell A1
  2. [Ctrl]+[End] takes you to the last data cell in your worksheet
  3. [Ctrl]+[PgDn] takes you to the next worksheet
  4. [Ctrl]+[PgUp] takes you to the previous worksheet
  5. [End]+[↑] takes you to the top of the row
  6. [End]+[↓] takes you to the bottom of the row
  7. [End]+[→] takes you to the furthest right entry in the row
  8. [End]+[←] takes you to the furthest left entry  in the row
  9. [Ctrl]+[A] selects/highlights all cells that you are using in a worksheet
  10. [Shift]+[Spacebar] selects/highlights your row

http://businesstoolsblog.com/

No comments:

Post a Comment