Insert a line and maintain formatting

[Daniel]

Hi

I have Excel 2002, how do I insert a line and maintain the formatting
sequence of the cells above and below where I have
inserted the line.

thanks

Daniel

 

[Bev and Rob Boon]

Hi Daniel
Insert the row needed and then choose the row above click on the format
painter and then click on the row you just inserted. All cells in the row
will pick up the formatting of the row above.

Cheers
Rob

 

[David McRitchie]

Hi Daniel,
If you format entire columns, which I believe is more efficient, you
don't need to copy anything.

If you want to extend the formulas and Extend Formulas option
is not working for you, then take a look at
Insert rows and maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm