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.
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.
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 thoughts on “Google Sheets: Highlight and Resize Every Other Row”
It looks like you are using a Mac but on Mac you need to press and hold the Command Key, not the Control key
That is correct. I assume that Mac users know how to make this adjustment.
You must log in to post a comment.