Sort Default

[Bons]

I have a very small and slightly annoying prob..... When I go to do a Sort
---- sometimes the Header Row box is marked but most of the time the No
Header Row box is marked. What makes it go back and forth??? AND Is there a
way to make Header Row the default????? I know in the grand scheme of things
this is trivial....but I do this many times a day and would like for the
default to always be Header. You guys and gals here are so knowledgable....I
KNOW somebody can fill me in on this!! Thanks in advance!!!!!!!!!! This
discussion group Rocks!

 

[Bob Umlas]

If the header row sorta looks like the other rows, it's not easy for Excel
to know if it is or not, and the setting isn't stored anywhere.
You can "enforce" the header being checked by simply setting it to BOLD (or
italic -- something different).
HTH
Bob Umlas
Excel MVP