how can I sort with header not on row 1

T

tryer

Hi,
I would like to sort 'by header' when the headers are on row 5. I know
that I can highlight all the rows from 5 to bottom of the sheet
manually then sort by header row but with a large sheet this is time
consuming. I would like to select the entire sheet and then sort by
header(on row 5)
Is this possible?
 
K

Ken Wright

Get to know your shortcut keys:-

Select A5 and hold down CTRL+SHIFT and hit the END key, or hold down
CTRL+SHIFT and hit the RIGHT arrow and then the down ARROW

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
G

Guest

You shouldn't have to select the range before sorting, unless you have blank
rows within the range you want to sort. If you simply select a cell within
the range of data, then choose Data>Sort, Excel does a pretty good job of
determining what the bounds of that range are.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

writing a sort macro 2
Sort confusion 2
Excel "remembering" sort criteria 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Sorting issue with frozen panes 11
SORT Header Row(s) 1
Header rows 4
Macro to sort variable data range fails 1

Top