Are you manually shading those rows? You could do it using conditional
formatting (i.e. shade every odd row), and this will adjust when a row
is inserted as the new row will take the format of the row above (as
you have pointed out).

Hope this helps.

Pete

On Jul 1, 12:11*am, 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.