Google Sheet Alternate Row Color - Web first, open the sheet and select the data range in which you’d want to color alternate rows. Choose your desired colors for the even and odd rows by clicking on the color swatches. There are two checkboxes in the alternating colors sidebar, which allow you to toggle headers and footers on or off. If your sheet has a header or footer, you should include it in your selection, as well. Go to format > alternating colors. This will open the ‘ alternating colors ’ toolbar on the right. For this guide, i’ll choose the range a1:h20. Select one of the default styles and click done: Once you have selected your desired colors, click on the “apply” button. Then, from the top menu format > alternating colors.
Go to format > alternating colors. Web first, open the sheet and select the data range in which you’d want to color alternate rows. Select one of the default styles and click done: Once you have selected your desired colors, click on the “apply” button. Then, from the top menu format > alternating colors. There are two checkboxes in the alternating colors sidebar, which allow you to toggle headers and footers on or off. This will open the ‘ alternating colors ’ toolbar on the right. For this guide, i’ll choose the range a1:h20. If your sheet has a header or footer, you should include it in your selection, as well. Choose your desired colors for the even and odd rows by clicking on the color swatches.