column header not recognized in sort

B

becky

I have a file that I update with exported data. I delete
the current data, then paste the new data in. I leave the
column headings there. I do this with more than one sheet.
However on one of the sheets, when I do a sort it does not
recognize the first row as the headings. I have to go to
data, sort, and check row headings then choose my sort.
It does not remember it the next time either.

Any ideas?

Thanks,
Becky
 
B

Bob Umlas

A list of all text makes Excel think there are no headers in that column.
You can make it think there ARE, but formatting the heading differently,
like Bold, or underling, for example.
Bob Umlas
Excel MVP
 
B

Becky

Thanks Bob, but that didn't work. My headings were
already bold. I made some other formatting changes like
italics and even changed it from text to general, but
still it does not recognize the Headers. I cleared all,
inserted new row. Retyped the headers and still does not
work.

Any other ideas.

Thanks again!
Becky
 
B

Bob Umlas

Sending you message in private email...
Becky said:
Thanks Bob, but that didn't work. My headings were
already bold. I made some other formatting changes like
italics and even changed it from text to general, but
still it does not recognize the Headers. I cleared all,
inserted new row. Retyped the headers and still does not
work.

Any other ideas.

Thanks again!
Becky
Click to expand...
 
Top