Sort whith 3 row column heading

  • Thread starter Thread starter KathyB
  • Start date Start date
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
 
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).
 
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...
 
Back
Top