See all How-To Articles

How to Highlight Multiple Rows in Excel & Google Sheets

This tutorial demonstrates how to highlight multiple rows in Excel and Google Sheets.

 

highlight multiple rows 5

 

Highlight Adjacent Rows

Say you have a data set with prices, and you want to highlight Rows 3, 4, and 5.

 

highlight multiple rows 7

 

  1. To select rows, select the first one (Row 3) by clicking on the row number and drag the cursor to the last row you want (Row 5).

 

highlight multiple rows 3

 

  1. Now, highlight the rows you selected in Step 1. In the Ribbon, (1) go to the Home tab, (2) click on the Fill Color icon, and (3) choose the color.

 

highlight multiple rows 4

 

As a result, the selected rows are highlighted.

 

highlight multiple rows 5

 

Highlight Non-Adjacent Rows

Suppose you have the same data set, and you want to highlight non-adjacent rows (Rows 2, 4, and 6).

 

highlight multiple rows 7

 

  1. Select the first row you want to highlight (Row 2), hold the CTRL key, and click on the numbers of each other row you want to highlight (Rows 4 and 6).

 

highlight multiple rows 1

 

  1. To highlight selected rows, in the Ribbon (1) go to Home, (2) click on the Fill Color icon, and (3) choose the color from the pallet.

 

highlight multiple rows 2

 

After that, all selected rows are highlighted.

 

highlight multiple rows 6

 

Highlight Rows in Google Sheets

  1. Select adjacent rows by selecting the first one and dragging the cursor to the last row you want to highlight (here, Rows 2 and 3).
  2. In the Toolbar, click on the Fill color icon.
  3. Then choose a color from the palette.

 

highlight multiple rows 8

 

As a result, the selected rows are highlighted.

 

highlight multiple rows 9

 

The process of highlighting non-adjacent rows in Google Sheets is the same as it is in Excel.