A while back a colleague of mine turned me on to a great Excel keyboard shortcut for selecting a range of cells. The key combination is CTRL + SHIFT + END. By holding these 3 keys together Excel selects a range of cells starting with your current cell down to the last used cell on your worksheet. This is quite handy if you frequently use lists, data-tables or recordsets in Excel.
Consider this example. Using the data-set shown below, with your cursor in cell A1, CTRL + SHIFT + END produces a selected range from A1 through C11.
CTRL + SHIFT + END is smart enough to know that the last row containing data is 11 and the last column containing data is C.
This is one of my favorite tips for Getting Things Done with Excel.
If you are feeling kinda nutty, try CTRL + SHIFT + HOME. It works the opposite of CTRL + SHIFT + END. Try it, and you'll understand I mean by "opposite".
3 comments:
Nutty like a Baxter, but it works.
"Nutty like a Baxter"... What does that mean? Anyone know?
If you are on a macbook pro (without END or HOME keys), and using MS Office 2008 for Mac, then try SHIFT+FN+CTRL+RIGHT_ARROW to select from current cell to final non-empty cell (aka "END"). (Or substitute LEFT_ARROW to select in the other direction ie back to "HOME").
Post a Comment