sorting range automatically

L

lela2a

This is more a question of amazement rather than needing help. I downloaded
an Excel sheet (populated from a database) from an internal server at work.
Somehow, it is set up so that you don't have to select a range in order to
sort a column - it does it for you (if someone hadn't been instructing me
step-by-step I never would've stumbled upon it). How does that happen and
how can I set up all my worksheets/books to behave that way? I looked for a
macro but there are none...
Thanks!
 
B

Bob Umlas, Excel MVP

It's the nature of the beast - yuo can select just one cell and excel knows
you mean the entire range of contiguous cells around the active cell. This is
called the Current Region and can be found by Ctrl/* or ctrl/A, but you don't
need to actually select the current region to sort - excel will always sort
the current region by the active cell unless there's more than one cell
selected, in which case it will sort that selection by the column of the
active cell.
HTH
 
Top