Range Selection
 

I have multiple sheets having varying rows of data. I need to select all
data in each sheet for sorting without click and drag, perhaps for a macro.
Any suggestions? I am stumped!

Range Selection
 

I'm not clear exactly on what you're trying to do, however, to quickly select
a proper list of data, start by selecting the upper left most cell in the
list then press Ctrl+Shift+(Right Arrow), then Ctrl+Shift+(Down Arrow).

Does that work?




--
Hope this Helps!
Camilo

Objective: To help one person each day!

Feedback is greatly appreciated! Please let me know if I've answered your
question or if my post was helpful to you?


"cfspahn24" wrote:

I have multiple sheets having varying rows of data. I need to select all
data in each sheet for sorting without click and drag, perhaps for a macro.
Any suggestions? I am stumped!

Range Selection
 

Sorry, this does not accomplish what I need. I need to select the entire
range within the sheet that contains data. Sort of like the "select all"
command in some programs. Any suggestions? Anyone?

"Camilo" wrote:

I'm not clear exactly on what you're trying to do, however, to quickly select
a proper list of data, start by selecting the upper left most cell in the
list then press Ctrl+Shift+(Right Arrow), then Ctrl+Shift+(Down Arrow).

Does that work?




--
Hope this Helps!
Camilo

Objective: To help one person each day!

Feedback is greatly appreciated! Please let me know if I've answered your
question or if my post was helpful to you?


"cfspahn24" wrote:

I have multiple sheets having varying rows of data. I need to select all
data in each sheet for sorting without click and drag, perhaps for a macro.
Any suggestions? I am stumped!

Range Selection
 

You can click on the "select all" button--it's to the left of the column headers
and above the row headers.

Or hit ctrl-a (depending on your version of excel and what is selected, you may
have to hit it a couple of times)

cfspahn24 wrote:

I have multiple sheets having varying rows of data. I need to select all
data in each sheet for sorting without click and drag, perhaps for a macro.
Any suggestions? I am stumped!

--

Dave Peterson