Google Sheets - Alternating Colors

One popular request I often get from people that are looking at large sheets with lots of data is how to alternate the color of the rows to make it easier to read across and not lose your line.  Setting alternating colors is very easy with Google Sheets.  Simply -

1. Highlight the columns you want to assign alternating colors to

2. Go to the Format Menu and select Alternating colors... (towards the bottom of the menu)

3. Set your formatting -
 A. Choose if you have a header and/or footer on your sheet - it will use darker highlights on those cells
 B. Select the Formatting styles that are preset OR click on the + to create a custom style
 C. Make any modifications you would like to the colors (Note: if you selected a preset style, as soon as you make a color change it will create a custom style)

6. Click Done

If you want to remove alternating colors, go back to the Format Menu and select Alternating colors... and at the bottom of the window is the choice "Remove alternating colors."

Popular posts from this blog

Google Script - Create a Drop-Down List from Spreadsheet Column

Google Sheets - Flipping Your Rows & Columns

Google Forms - Copy Summary Graph/Diagram to Use Elsewhere

2017 MACUL Conference - Adding Pre-Conference Sessions to your Registration

Google Script - Automatic Invoice Numbering