Excel: Shade Every Other Row

Before you start...

Coloring every other row in an Excel document makes it more readable. Rather than coloring each row individually, use the following instructions to quickly perform this task.

Using a Preset Style

  1. Under the Home tab in the ribbon, click "Format as Table" in the Styles section.
  2. Select the preset style that best fits your information.
  3. When the "Format as Table" box opens, make sure that all your information is selected > Press [OK].

Using a Customized Style

  1. Use your mouse to highlight the range of cells that require conditional formatting.
  2. Go to the "Home" tab > Locate the "Styles" group > Choose the "Conditional Formatting" option.
  3. Choose "New Rule...." > Select "Use a formula to determine which cells to format."
  4. Under "Format values where this formula is true:" enter: =MOD(ROW(),2)=1.
  5. Click [Format…] > Choose the "Fill" tab > Choose a color. (The lightest gray or pale yellow are generally best when printing.)
  6. Click [OK] > Click [OK].


Keywords: every other, rows, color, light, dark, shade, shading, color, coloring, grey, gray, yellow, readability, read, easy, easier

Atomic Learning Video

Help Page Feedback

Did this content help you? *


What is your opinion about the content? *


Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty