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, go to the Home tab, click on the Fill Color icon, and 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 go to Home, click on the Fill Color icon, and 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.

See all How-To Articles