headermask image

Business Tools Blog

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

If you liked my post, feel free to subscribe to my rss feeds

Money Making Options

Post meta

This entry was written by Sandi Mays and posted on April 11, 2009 at 12:21 am and filed under Excel. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment(Latest is displayed first) or leave a trackback: Trackback URL.

Share with others

Post Top 10 Navigation Tips for Microsoft Excel to digg. Post Top 10 Navigation Tips for Microsoft Excel to Reddit add to stumbleupon Google Bookmark myweb bookmark on del.cio.us newsvine Tailrank magnolia Furl co.mments shadows simpy blinklist

One Comment

  1. Sandi - The [End] + Arrow Key shortcuts are very useful, but y ou should clarify their behavior.

    Unlike the others in your list, these can be accomplished by pressing the keys sequentially, not necessarily at the same time, which makes them even more handy. (In fact, I didn’t know you could press them concurrently, so I learned something).

    If the active cell is empty, the action takes you to the first non-empty cell in that direction.

    If the active cell is not empty, the action takes you to the filled cell just before the first empty cell in that direction.

    If you also hold down the Shift key, the action selects all cells between the active cell and the cell it would select without Shift pressed.

    1. Jon Peltier on April 11th, 2009 at 6:17 am

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*