Preferences for sorting to always have header row

[Guest]

Can I change the default preferences in Excel to 'My Data has Header Row'? I
often use the icons for sort ascending in the toolbar and the data always
sorts the header row with it.

 

[Niek Otten]

Format the header row as Bold

--
Kind regards,

Niek Otten

| Can I change the default preferences in Excel to 'My Data has Header Row'? I
| often use the icons for sort ascending in the toolbar and the data always
| sorts the header row with it.

 

[Guest]

Thanks, but I tried that and it doesn't work. Also tried freezing the row and
tried formatting the row to repeat on pages. Thanks anyway.

 

[Niek Otten]

Please post your table (or the first 10 rows)

--
Kind regards,

Niek Otten

| Thanks, but I tried that and it doesn't work. Also tried freezing the row and
| tried formatting the row to repeat on pages. Thanks anyway.
|
| "Niek Otten" wrote:
|
| > Format the header row as Bold
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| >
| > | Can I change the default preferences in Excel to 'My Data has Header Row'? I
| > | often use the icons for sort ascending in the toolbar and the data always
| > | sorts the header row with it.
| >
| >
| >