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!