Excel: Shade Every Other Row

Cedarville's Center for Biblical and Theological Studies glowing in the evening light

Cedarville University

Excel: Shade Every Other Row

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, in the "Styles" section, click "Format as Table."
  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 Email this to a Friend

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