This is crazy!!!

[Guest]

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

 

[Guest]

Hi Chris

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