Sorting a sheet with multiple heading rows (Excel XP)

Topic

New Reply

Howdy everyone,

My friend is trying to sort a sheet which has multiple heading rows. Excel’s help says to wrap the text to make it look like two rows, but as you’ll see in the attachment this is a case where the column headings spread across multiple rows, so wrapping just isn’t going to work.

Anyway around this?

Thanks in advance.

Reply | Quote

Replies

1) you can explicitly give the range to sort and not include the header rows

2) Excel will allow 2 header rows, if they appear to be header rows. Fill in all the blanks cells in the 2nd row (with a space, eg) and have them all bold and excel should “guess” that it is a header row. With it blank, it does not seem to be a header row to excel

Steve

Reply | Quote

If you insert a hidden blank row between the two rows, Excel will guess that only the lower of the two (visible) rows is intended to be the header – you will have to ensure that any descriptions are meaningful using only that row. If this is going to be sorted by a VBA routine then that doesn’t matter – but then you can set the sort range directly in any event…

Reply | Quote

This still requires no blank cells in this row.

It may be better to insert the hidden blank row underneath the 2 header rows, as excel will more likely assume there is no header row…

Steve

Reply | Quote

Is your friend trying to sort using the menu command or VBA code?

Reply | Quote