Instead of hard coding your formats use conditinal formatting. Instead of
Cell is Change to Formula is and add a formula like

=mod(row(), 2)=0

Now add your format and your spreadsheet should be dynamically formatted.
--
HTH...

Jim Thomlinson


"Scott Wonser" wrote:

How do I maintain alternate row shading after inserting a new row in Excel.
On some of our printed documents such as phone lists we like to have
alternate shaded rows. Currently, when we insert a row it compies the
format of the previous row so we end up with two shaded rows together. Not
the look I want.
--
Thankyou, Scott.