How do you format every other row in Excel?

Answer 1

You can copy-and-paste blocks of rows. Formsy the first two rows as you wish, copy them, select an even number of rows, and paste your selection.