• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Highlight Every Other Row in Excel

March 19, 2021 by Andrew Childress
How to highlight every other row in Excel

Highlighting every other row in a spreadsheet makes data easier to read. Let's learn how to highlight every other row in Microsoft Excel.

Highlighting every other row in a spreadsheet makes data easier to read. It does that by adding visual contrast. Let’s learn how to highlight every other row in Microsoft Excel.

How to Highlight Every Other Row in Excel

Consider a long list of data like this one. As you can tell, it can be a little tough to read. That’s especially true if you’re sharing it virtually, for example. It will appear smaller to your audience.

Highlight every other row in Excel

This is a great time to highlight every other row of your data. One row will remain with the default white background, while the next will be shaded in a different color. You might think you have to do this with the Fill feature, line by line. But thanks to Excel, the spreadsheet will do the work for you.

Begin by highlighting your dataset. On the Home tab, in the Styles group, click on Conditional Formatting. Then, from the dropdown, choose New Rule.

How to highlight every other row in Excel

You’ll see a window appear, called New Formatting Rule. In this case, you’ll want to click Classic, and then on the bottom option: Use a formula to determine which cells to format.

highlight alternating rows in Excel

Next, under Format values where this formula is true, you’ll need to input a quick formula. Begin by typing =MOD. Since you want every other row to be highlighted, continue with (ROW(),2). Your complete formula should read:

=MOD(ROW(),2)

Highlight every other row in Microsoft Excel

When finished, click on CustomFormat, then Fill. You’ll see a series of theme color thumbnails. Click one to apply it as a highlight, or choose More Colors to customize your own hues. Be sure to choose a light shade that won’t make cell contents hard to read.

Alternate highlights Excel

Finally, click OK. As you can see, Excel will instantly highlight every other row of your data.

Highlighted alternate rows Excel

This quick edit makes your data look cleaner and easier to read.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Mid rows selected ExcelInsert Multiple Rows in Excel
Next Post:Standard Error in ExcelStandard error in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top