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.
--
Noel O'K


"Chris" wrote:

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