Google Sheets: Highlight and Resize Every Other Row

Select non sequential rows

EdTech Books by Alice Keeler

  • Student Engagement
  • Google Classroom
  • Student Centered Classrooms
  • Google Apps for Littles
  • Math and Google Apps
  • Ditch That Homework
Google Sheets: Highlight and Resize Every Other Row

Select non sequential rows

Sometimes when creating a spreadsheet I need to have a blank row below my data. This has several uses: Creating a calendar, Check off box, Visual appeal.

Highlight Every Other Row on a Spreadsheet alternate rows

Control Key to Select Alternate Rows

Hold down the Control key and click on the row indicator to select it. Holding down the Control key allows you to select individual rows.  Select the all the rows you wish to resize.

Resize One Row

With multiple rows selected, resize one row by holding the cursor over the edge of the row indicator. Hold down the mouse on the line separating rows, drag to resize. All of the selected rows will resize to the same size.

Fill

While the rows are still selected, use the paint can in the toolbar to fill the rows in a specified color. Consider other formatting options such as bold or word wrap to apply to the selected rows.

2 responses to “Google Sheets: Highlight and Resize Every Other Row”

Leave a Reply

© 2025 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.