Wednesday, December 12, 2012

Navigating the Seas of Excel

It’s Back to Basics Week, so today we are going to review the topic of navigating in Excel. Sailing the Seas of your Excel worksheets can be drudgery for any Excel sailor, so we all need a few simple tricks. Imagine that you wish to go to your last entry at the bottom of a list that contains 20 records, scrolling to where you wish to go is simple and effective. When you have a list containing 20,000 records, however, it can be more than dreary.

As any Slick Excel Seafarer knows, keyboard shortcuts rule when it comes to saving time sailing from one location to another on your spreadsheet.

Here are a few Navigation Tricks you can make without ever touching a mouse (or getting sent to the brig):

1. Control / Down Arrow: Goes to last cell in column with data

2. Control / Right Arrow: Goes to last cell in row with data

3. Control / End: Goes to last row, column and cell

4. Control / Home: Returns to cell A1

Mouse Tricks (Every ship has Mice)

Another way to navigate to the end of your data (whether in a column or row) is to precisely hover your pointer on the adjacent Border of Cell in your range and double-click. If you wish to navigate to the last cell in a column of data that starts with cell C1, for example, you can select C1 and double-click on the Bottom Border of the cell.

Another Alternative (It's always good to have Choices)
When you know the Exact Address of some remote cell, simply enter the address (e.g. G2100) in the Name Box and Avast Me Hearties; you are swiftly transported directly to that location.

So, put on your Pirate Patch and try a different way or two of Navigating on the Excel Seas.  You can sail to where you want to be in The Blink of an Eye, Laddie!


No comments: