Worksheet sorts on first 5 columns only

[Quimera]

I have a worksheet with 3 rows of columns headings.

The first row is standard columns headings.

The second row is a merged cell text line.

The third row is a blank row - which allows me to selct A4 and do a
nrmal sort...but it only allows a sort on columns A to E . The scroll
bar for the columns is greyed out

I know I can enter the selection range for all the data in the upper
left field, but it would be more convenient to be able to select cell A4
for a normal sort on any column.

Thanks for your help.

Joan

 

[Bernie Deitrick]

Joan,

Do you have a column that is completely blank and hidden? That may prevent your selecting more than
5 columns automatically.

Do you have frozen panes or split screen? That may make it seem that you cannot select all columns.

HTH,
Bernie
MS Excel MVP

 

[Quimera]

Hi Bernie,

I unhid the columns and unfroze the panes - but no luck. It must be
something to do with the multiple line headings, so I have re-formatted
them into a single line and all is well.

Thanks,
Joan