Preferences for sorting to always have header row
 

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.

Preferences for sorting to always have header row
 

Format the header row as Bold

--
Kind regards,

Niek Otten

"Helenka" wrote in message ...
| 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.

Preferences for sorting to always have header row
 

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

"Helenka" wrote in message ...
| 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.

Preferences for sorting to always have header row
 

Please post your table (or the first 10 rows)

--
Kind regards,

Niek Otten

"Helenka" wrote in message ...
| 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
|
| "Helenka" wrote in message ...
| | 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.
|
|
|