• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Excel: Shade Every Other Row

Excel: Shade Every Other Row

Posted on February 25, 2020 by Mel Hawthorne Leave a Comment

Looking at large amounts of data can be quite straining on the eyes. Thankfully Excel has a useful function to make it easier – alternate row styling. Simply put: Zebra striping. Shading rows in alternate colours is a great way to make large amounts of data easier to work with.

Don’t worry, you won’t have to colour your rows manually. You can apply it all in just a few clicks. Here’s how to add colour to your file.

First, select your entire table, then click on Format as Table in the Home tab of your Excel menu.

Format as Table

You’ll see a series of options and colour choices. Pick whichever one you prefer. The presets include options featuring different shades of colour, outlines and heading tones. When you’ve found an option you like, click on it. The styling will be applied to your table immediately.

A table with alternate row shading applied.

Tip: If you want to change the colouring, simply repeat the steps and click on a different pre-set.

You Might Also Like

  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • How to Add a PDF to Excel
    How to Add a PDF to Excel
  • Excel: Add Watermark
    Excel: Add Watermark
  • Fix Excel Freezing or Slow
    Fix Excel Freezing or Slow
  • Excel Calculations Are Wrong
    Excel Calculations Are Wrong
  • How to Convert Excel Spreadsheet to PDF
    How to Convert Excel Spreadsheet to PDF
  • How to Spell Check in Excel
    How to Spell Check in Excel
  • How to Merge Sheets in Excel
    How to Merge Sheets in Excel
  • Excel: Make Header Row
    Excel: Make Header Row

Filed Under: Office Tagged With: Excel 2019

Reader Interactions

Did this help? Let us know! Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Fix Skype Error: Exchange Needs Your Credentials
  • Fix Skype Notifications Not Working on Windows 10
  • Teams in Outlook: We Couldn’t Schedule the Meeting
  • VR Oculus Quest 2: How to Configure a New Room-Scale Boundary
  • VR Oculus Quest 2: How to Adjust Boundary Sensitivity
  • Dropbox: How To Change the Date Format
  • Microsoft Teams: There Was a Problem Saving the Photo
  • VR Oculus Quest 2: How to Set up Oculus Link

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

Follow me on Twitter, or visit my personal blog.

You May Also Like

© Copyright 2021 Technipages · All Rights Reserved · Privacy