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
Quick Navigation
Summary
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.