Sorting problem

ar · Mar 28th, 2002, 11:03 AM

I have worksheets where the first two rows are the header rows. For most worksheets I just click one of the header rows and click the Sort Ascending button. But for some worksheets sorting does not work where the sorted data is shifted to very top and the header rows are at the bottom. I tried also using the Data – Sort function on the menu bar and selected “Header row” and first heading row is missing. How can solve this problem?

lenze · Mar 28th, 2002, 11:09 AM

I think you will find the sorts will work better if you limit your header rows to one row. If you need to display more than one line in a cell, use Alt+Enter to force a line break in the cell. Make sure you've choosen the wrap text option.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 11:03 AM	#1
ar New Member Join Date: Mar 2002 Posts: 24	I have worksheets where the first two rows are the header rows. For most worksheets I just click one of the header rows and click the Sort Ascending button. But for some worksheets sorting does not work where the sorted data is shifted to very top and the header rows are at the bottom. I tried also using the Data – Sort function on the menu bar and selected “Header row” and first heading row is missing. How can solve this problem?

Mar 28th, 2002, 11:09 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	I think you will find the sorts will work better if you limit your header rows to one row. If you need to display more than one line in a cell, use Alt+Enter to force a line break in the cell. Make sure you've choosen the wrap text option.