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