help with header row format

[Guest]

Hi,
The first row in my excel file is the header. When I insert a new row after
that, the new row takes the format, color etc of the header. How can I avoid
the new rows inserted form taking the format of the forst row?

Thanks

 

[Guest]

If it's Excel 2003, when you insert the new row under the header row youy
should get a small icon appearing which has a drop down arrow providing
format options. You can select to format the new row as the line above, the
line below, or clear formatting.

 

[Guest]

I don see any icon. It inserts the new row with the same size, color, format
etc. form the first row.

 

[Guest]

Turn on or off Insert Options
Click Options on the Tools menu, and click the Edit tab.
Select or clear Show Insert Options buttons.