Excel Tip for Selecting a Range of Cells [Stuff for Getting Things Done]

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.

image

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”.

Original post here: Tim Kwiatkowski

25 January 2008 | excel | Comments

Comments:

  1.  
  2.  
  3.