Insert a Row

[smandula]

How do you insert a new row imbetween rows
without bringing down the Color of the above
row?
It always happen's
Any suggestions would be appreciated.
The only thing would possibly be a Macro with cleanup

With Thanks

 

[smandula]

I found a solution.

Copy a Blank row,
Then use copy insert

I would welcome other solutions

 

[Gord Dibben]

Tools>Options>Edit. Uncheck "extend data range formats and formulas"


Gord Dibben MS Excel MVP