• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Google Sheets: How to Shade Every Other Row

Google Sheets: How to Shade Every Other Row

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

  • Google Sheets: How to Use the Google Translate Formula
    Google Sheets: How to Use the Google Translate Formula
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix Guide
    Google Sheets Won't Let Me Type - Fix Guide
  • Troubleshooting Google Sheets Not Printing
    Troubleshooting Google Sheets Not Printing
  • Troubleshooting Google Sheets Not Working
    Troubleshooting Google Sheets Not Working

Filed Under: Internet Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know!

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

  • How to Print Labels from Excel Using MS Word Mail Merge
  • What Is NVMe Over TCP (NVMe/TCP)
  • Android Mobile Hotspot: How to Change the Password and Name
  • Windows 10: How to Force Quit and App
  • What is Dumpster Diving?
  • How to Download iOS 16 Beta 3 on iPhone or iPad
  • What is a Security Compromise?
  • Mastodon: How to DM Someone

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.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy