Sorting

[Guest]

How do I get excel to recognize my header row as a default? I do not want to
check "Header Row" everytime I sort data.

 

[Niek Otten]

Format the headers bold. Excel recognizes that and defaults to Headers rows.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I get excel to recognize my header row as a default? I do not want to
| check "Header Row" everytime I sort data.

 

[Pete_UK]

It often helps if you set the format differently from the rest of the
sheet, eg bold, or different foreground/background colours.

Hope this helps.

Pete

 

[Niek Otten]

Indeed! Apparently any difference in formatting will do. I never noticed that!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| It often helps if you set the format differently from the rest of the
| sheet, eg bold, or different foreground/background colours.
|
| Hope this helps.
|
| Pete
|
| > How do I get excel to recognize my header row as a default? I do not want to
| > check "Header Row" everytime I sort data.
|
|

 

[Guest]

Thank you both so much!! It had been driving me crazy.