How to Highlight Cells in Google Sheets(Quick & Easy Guide )

In this tutorial ,we will walk you through the steps on How to Highlight Cells in Google Sheets

Highlight Cells in Google Sheets

To higlight cells in Google Sheets,Select the desired cells and Click on the Fill Color icon and Select the color as per your requirement.

How to Highlight Cells in Google Sheets(Overview of Steps)

  • Open Google Sheets
  • Select the cells with data on Google Sheet that you want to Highlight
  • Navigate to the quick acces menu toolbar and click on Fill color icon
  • From the fill color drop-down Select the desired Color
  • The Selected cells will be Highlighted as per the Selection

Let’s go through the above steps in detail.

How To Highlight Cells In Google Sheets : Step by Step Guide

Enclosed are the steps to Highlight Cells In Google Sheets :

Step 1 : Open Google Sheets

Step 2 : Select the cells with data on Google Sheet that you want to Highlight

  • You can select the cells using your mouse cursor .
  • To choose an entire range,simply click on the first cell and drag you mouse cursor until all the desired cells are selected as shown blue.
  • You will notice,the selected cells are Highlighted Blue

Alternatively you can also click on the First cell ( in example A2) and then press and hold the Shift key and click on the last cell ( in example B8)

How to Highlight Cells in Google Sheets

Step 3 : Navigate to the quick acces menu toolbar and click on Fill color icon

Click on the Fill Color option on top right quick access menu.

Step 4 : From the fill color drop-down Select the desired Color.

  • From the fill Color Select the desired color after which the text should be atleast visible.

Step 5 : The Selected cells will be Highlighted as per the Selection

  • In case you need to change the color,just go back to the fill color option and select the color as per your need.
  • To reset and revert to the default settings you can click on the Reset option under “Fill Color” drop-down

How to Highlight Cells in Google Sheets (Summary)

We hope this tutorial on How to Highlight Cells in Google Sheets was useful.

Related articles :

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets

How to Get Absolute value in Google Sheets ( Easy Guide )