software

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.

Format the header row as Bold

--
Kind regards,

Niek Otten

quot;Helenkaquot; gt; 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.
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.

quot;Niek Ottenquot; wrote:

gt; Format the header row as Bold
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Helenkaquot; gt; wrote in message ...
gt; | Can I change the default preferences in Excel to 'My Data has Header Row'? I
gt; | often use the icons for sort ascending in the toolbar and the data always
gt; | sorts the header row with it.
gt;
gt;
gt;

Please post your table (or the first 10 rows)

--
Kind regards,

Niek Otten

quot;Helenkaquot; gt; 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.
|
| quot;Niek Ottenquot; wrote:
|
| gt; Format the header row as Bold
| gt;
| gt; --
| gt; Kind regards,
| gt;
| gt; Niek Otten
| gt;
| gt; quot;Helenkaquot; gt; wrote in message ...
| gt; | Can I change the default preferences in Excel to 'My Data has Header Row'? I
| gt; | often use the icons for sort ascending in the toolbar and the data always
| gt; | sorts the header row with it.
| gt;
| gt;
| gt;