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
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
Last edited by SEMMatt; 09-01-2011 at 01:04 PM.
CNTRL SHFT 8 will expand your selection (so you must have a cell selected somewhere in A1:P775). Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
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")
Yes it does, thank you!
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.
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.
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.
That's was it.
I had to do CNTRL SHFT 8 first
nice tip though, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks