Large spreadsheets can be much easier to manage when you use fill colors to highlight rows that are important, or share similarities. For example, highlighting multiple rows with a yellow fill color could let you highlight good months in a sales report. It draws the attention of the reader without affecting the data in the spreadsheet.
But if you want to highlight your cells with fill color, you might not be sure how to do so. Our article below will show you how to select a row in Google Sheets and apply a fill color to that row. If you need to combine some of the cells in that row into one big cell, then learn how to use the cell merging feature in Google Sheets to achieve that result.
How to Use Fill Color in Google Sheets
The steps in this article were performed in the Google Sheets application that is accessible through the Google Chrome Web browser. Once you complete the steps in this guide, you will have a row (or rows) in your Google Sheets spreadsheet that have a fill color that you select. You can use this same method to apply a fill color to a column, or to a group of cells.
Step 1: Sign into your Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet to which you wish to add fill color to a row or rows.
Step 2: Click the row number to the left of the spreadsheet to select the entire row. Note that you can select multiple rows by holding down the Ctrl key on your keyboard and clicking additional rows.
Step 3: Click the Fill Color button in the toolbar at the top of the window, then select the color that you want to use to fill the selected row.
If you wish to remove the fill color from a selected row, then click the Reset button at the top of the Fill Color menu from step 3.
Do you have a spreadsheet on which you need to change the width of a lot of columns? Learn how to change multiple column widths in Google Sheets so that you don’t need to change each column individually.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.