Here are the steps to shade every other row in Excel:
1. Select the range of cells you want to format.
2. On the Home tab, in the Styles group, click Conditional Formatting.
3. Click New Rule.
4. Select 'Use a formula to determine which cells to format'.
5. Enter the formula =MOD (ROW (),2).
6. Click the Format button and choose a color for the shading.
7. Click OK twice.
You can also use Format as Table option to apply color to alternate rows in Excel. Here's how:
1. Highlight your dataset.
2. Go to Home > Format as Table.
3. Choose from the menu that appears the alternating color style you want.
