Shortcut to select all data on a worksheet?

**SEMMatt** · 09-01-2011, 12:55 PM

Hello,

Is there a shortcut to select all data in a worksheet without selection all rows and cells?

Like if I have data in A1 to P775; how can I select just that data?

Thanks,
Matt

**ChemistB** · 09-01-2011, 12:57 PM

CNTRL SHFT 8 will expand your selection (so you must have a cell selected somewhere in A1:P775). Does that work for you?

**ChrisHowk** · 09-01-2011, 01:01 PM

You can make a macro with the shortcut you want (Ctrl+"x") that reads:

Range("A1:P775").Select

Then when you are in your sheet just press (Ctrl+"x")

**SEMMatt** · 09-01-2011, 01:04 PM

Yes it does, thank you!

**ChemistB** · 09-01-2011, 01:07 PM

Be careful with this because blank rows or columns will stop the expansion (and rightly so). I usually check with another shortcut
CNTRL + . <--- that's a period
That'll take you to the 4 corners of your selected range so you can verify, it is what it is.

**SEMMatt** · 09-01-2011, 01:12 PM

Hi ChemisB, appreciate the help but I tried CNTRL + . and that didn't do anything nor did CNTRL .

Is that only for Mac? I'm using a PC.

**ChemistB** · 09-01-2011, 01:30 PM

Hitting CNTRL and Period simultaneously (i.e. shortcut) moves the active cell to the next corner of the selected range. If you don't have a selected range (ie if you didn't do CNTRL SHFT 8 first), nothing will happen. If you have a column or row selected, the active cell moves from the top (or left) to bottom (or right). Hope that helps.