How to Add Yellow Shading to a Row in Google Sheets

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 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.

select a row in google sheets

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.

how to use fill color in google sheets

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.

highlight a row in google sheets

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.

See also newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.