How To Highlight A Row In Google Sheets

Last Updated on October 30, 2023 by Jake Sheridan

In this tutorial, you will learn how to highlight a row in google sheets.

It’s good to have a lot of data, but often spreadsheets contain too much data to be easy to quickly read and interpret. When this happens, one solution is to highlight important information in the spreadsheet so users’ eyes are drawn to it. The instructions below outline how to highlight a row in Google Sheets, but can be easily adapted for columns, individual cells, or any spreadsheet range.

Here’s how to highlight a row in Google Sheets

Step 1

The first step is to select the row you want to highlight. One way to do this is to click on the row number to the left of the cells. This will select all cells in the row from the first column to the last

Step 2

Click on the Fill Color icon in the toolbar and a menu of fill or highlight colors will appear. Choose a color swatch from the menu

Step 3

The selected row will highlight in that color

Step 4

If the row text is hard to read after adding the highlight, you can change the text color by opening clicking on the Text Color icon beside the Fill Color icon and selecting a color

Step 5

The text color will immediately update


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to highlight a row in google sheets. Want more? Check out all the Google Sheets Tutorials.