• 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
Google Sheets: How to Shade Every Other Row

Google Sheets: How to Shade Every Other Row

Posted on December 28, 2019 by Mel Hawthorne Leave a Comment

Google Sheets spreadhseets aren’t always easy to look at – endless rows of records and data can be confusing to look at, but there are ways to make it easier. Zebra stripes are one of the best tools for this – two colors alternate between rows, which means the human eye can follow them and tell them apart without having to strain quite so much.

It’s easy to apply this formatting tool to your entire document – don’t worry, you won’t have to shade each row individually!

In order to shade your document, click on the Format tab at the top. About halfway down the menu that pops up, you’ll find a dedicated option labelled Alternating colors. Click on it, and your document will immediately have zebra stripes applied to it – the default is white and grey.

A sidebar will open and let you select some more options according to your preferences.

The menu and sidebar

Here, you can pick what you want to use – either a pre-made colour scheme or something entirely custom. You can limit which range of cells your formatting applies to if you only want it to cover part of the document, and you can change individual colour shades to something you like. Should you want to delete the colours again, you can do so with a simple click on the bottom right.

Click on “Remove alternating colors” to go back to your plain white document!

Tip: The standard shading colours are white and a soft pastel tone, such as yellow, green or even grey – no bright or aggressive colours. While you can use pink and orange, for example, you don’t usually need to – having one colour to set off the white every other row is usually more than enough!

You Might Also Like

  • How to Convert Google Sheets to PDFHow to Convert Google Sheets to PDF
  • Setting Up Macros in Google SheetsSetting Up Macros in Google Sheets
  • Google Sheets: Protect CellsGoogle Sheets: Protect Cells
  • How to Spell Check in Google SheetsHow to Spell Check in Google Sheets
  • How to Highlight Text in Google SheetsHow to Highlight Text in Google Sheets
  • Adding a Watermark to Google SheetsAdding a Watermark to Google Sheets
  • Google Sheets: How to Round NumbersGoogle Sheets: How to Round Numbers
  • Google Sheets vs Excel ComparisonGoogle Sheets vs Excel Comparison
  • Google Sheets Won't Let Me Type - Fix GuideGoogle Sheets Won't Let Me Type - Fix Guide

Filed Under: Internet Tagged With: Google Sheets

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

  • Android 10: How to Adjust the Keyboard Size
  • OneNote Error Code 0xE00001AE – Fix
  • WhatsApp: How to Change Your Phone Number
  • Fix OneNote Error 0xe00001bb: Section Is Corrupted
  • Zoom: How to Show the Unread Message Icon
  • How To Calculate Tips on Android
  • What to Do If Chrome Download Needs Authorization
  • Fix OneNote Error 0xE401065D, 0xE000145C, 0xE4010640

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

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2021 Technipages · All Rights Reserved · Privacy