Why does the Sort function stop recognizing Header Rows?

F

Frostfire

Suddenly, when I choose sort, it tries to use the column letters, rather than
my header row. I have to highlight the entire document, set this as the
'Print_Area', and then the sort will recognize my header row. It was working
just fine, until recently, and I can't figure out what's changed.
 
M

Mangus Pyke

Suddenly, when I choose sort, it tries to use the column letters, rather than
my header row. I have to highlight the entire document, set this as the
'Print_Area', and then the sort will recognize my header row. It was working
just fine, until recently, and I can't figure out what's changed.
Click to expand...


Check the radio button that says "Header row" ??

MP-
 
F

Frostfire

Mangus Pyke said:
Check the radio button that says "Header row" ??

MP-
Click to expand...

I did, and do. Unfortunatly, it changes it back to the 'no header' option
each time. It didn't used to, it kept the setting of 'Header row,' so it
would recognize my headings and let me sort by them. Now, yes I can click on
that and get my headings to sort by, but I'm wondering why it stopped keeping
that setting.
 
M

Mangus Pyke

I did, and do. Unfortunatly, it changes it back to the 'no header' option
each time. It didn't used to, it kept the setting of 'Header row,' so it
would recognize my headings and let me sort by them. Now, yes I can click on
that and get my headings to sort by, but I'm wondering why it stopped keeping
that setting.
Click to expand...

Hrmm.. I don't have an answer. That's weird.

MP-
 
D

Dave Peterson

Sometimes, if you just change the format of that header row (Bold or italics or
underlined), then excel will see it as different and guess that it's a header
row.

(I don't know why it forgets--but I always select my range to sort anyway.)
 
Top