Hi,
How do I make the first row the column header so when I insert a new row
(just below the header) it doesn't take the format (size,color, style etc) if
the first row? I don't want to keep clicking a button all the time. There
must be a way to disable this.

The reason for this is that I have a program that exports data form SQL
server to excel and everyting it does that all the rows take the format of
the first row.

Any ideas?

Thanks

Hi Chris

Click on Tools|Options, and under the Edit tab, untick "Extend list formats
and formulas" option

--
ve_2nd_at. Randburg, Gauteng, South Africa


"Chris" wrote:

Hi,
How do I make the first row the column header so when I insert a new row
(just below the header) it doesn't take the format (size,color, style etc) if
the first row? I don't want to keep clicking a button all the time. There
must be a way to disable this.

The reason for this is that I have a program that exports data form SQL
server to excel and everyting it does that all the rows take the format of
the first row.

Any ideas?

Thanks