Sort whith 3 row column heading

K

KathyB

I've searched the forum on sorting and can't find this problem. My shee
in Excel 2002 has three rows of data that serve as column headings.
need for others to be able to easily sort using the toolbar sort keys.
When I do this, it doesn't recognize the column headings and sorts the
too. If I choose the data range myself, it works - but the users nee
a one touch simple method. Any ideas
 
E

Earl Kiosterud

Kathy,

You need your column headings in one row. You can use Alt-Enter as you
enter them to break into separate lines within the cell, or set the cells to
wrap (Format - Cells - Alignment - Wrap text).
 
A

Andy B

An alternative is to insert a blank row under the headings, and hide the
row. If you then click on any data cell, Excel will then see the contiguous
range as the data only.

--
Andy.


Earl Kiosterud said:
Kathy,

You need your column headings in one row. You can use Alt-Enter as you
enter them to break into separate lines within the cell, or set the cells to
wrap (Format - Cells - Alignment - Wrap text).
Click to expand...
 
Top