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)
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!
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:
Post a Comment