In the Menu, select Format > Conditional Formatting. Highlight the cells whose rows you wish to select.You can also use conditional formatting and filtering to select every other row. As with Format as a Table, you can now Filter by Color to select every alternate row.Īll the rows with the yellow cells are shown.Īs with Excel, you can select every other row in a Google Sheet by selecting the first row and then holding down the CTRL key and selecting each alternate row thereafter.Click OK again to apply the formatting to your worksheet.In the Fill tab, select the color to format each alternate row, and click OK.The MOD Function, here, tests whether a number is even or odd by returning the remainder of the ROW formula divided by 2.The ROW Function returns the row number of the cell.Select (1) Use a formula to determine which cells to format and then (2) enter the formula:.In the Ribbon, go to Home > Cells >Conditional Formatting. You can use Conditional Formatting and Filtering to select every other row. Click the drop-down arrow on any of the column headings and select Filter by Color.Next, in the Ribbon, select Home > Editing > Sort & Filter > Filter.Then, to remove the table, in the Ribbon, select Table > Convert to Range.In the Ribbon, go to Home > Cells > Format as Table and select the formatting. You can use Format as Table and filtering to select every other row. With the CTRL key still held down, click on every other row header until all the rows you need are selected.Holding down the CTRL key on the keyboard, click in the row header of the second row.

Click on the row header to select the first row.Select Every Other Row Keyboard and Mouse There are a few ways to select every other row. When you’re working with data in Excel, you have a need to select the data in every other row. This tutorial demonstrates how to select every other row in Excel and Google Sheets.

Shade every other row in excel for mac