Inserting Alternating Rows
May 24, 2018 - by Bill Jelen
Today's question from the Atlanta Power Excel seminar.
I have data formatted with every other row in grey. When I insert two new rows in the middle of the data, both of the new rows end up grey instead of following the pattern.
Take a look at the workbook in the image below. The even numbered rows have a grey fill.
When you select A5:A6 and Insert Rows, you get two new blank rows. But both rows are grey.
I have a solution to this, but it requires a trip back to 3rd grade math.