Unfortunately, there is no equivalent alternating colors option that works on columns.
#Undo excel highlight every other row how to#
How To Alternate Colors In Google Sheets Columns Alternatively, use conditional formatting to apply alternating row colors to your entire spreadsheet. This technique could be adapted to columns by switching the ROW function to a COLUMN function. To shade every other row in Excel, highlight your dataset and go to Home > Format as Table, then choose from the menu that appears the alternating color style you want. If the row is blank in column B, then the conditional formatting is not applied. This formula works by checking that the row is an odd-numbered row AND not blank in column B, i.e. You’ll want to change this to match the top-left cell of your range. Notice the $ sign in front of the A, so that the conditional formatting is applied to the whole row.Īlso, this rule is operating on a range that starts from cell B16 (see the GIF above). Here are the methods to highlight every second row in Microsoft Excel: 1. Highlight your data range, open the conditional formatting sidebar, and set the custom formula rule to:
The alternating color bands are left in place whether there is data or not.īut the good news is that you can use regular conditional formatting to achieve the dynamic alternating colors. Unfortunately, you can’t use the alternating rows tool because it gets applied to a static range. How do you apply alternate colors in Google Sheets if your table is dynamic and changes size? You can also set custom colors under the default styles and even save your color scheme as a custom style with the big plus button. If you check them, you can set a different color for the headers and footers. There are two checkboxes in the alternating colors sidebar, which allow you to toggle headers and footers on or off. Select one of the default styles and click Done: It’s super easy to add alternating row colors in Google Sheets. How To Alternate Colors In Google Sheets Rows Here’s an example of alternating row bands applied to a checklist in Google Sheets: In this post, you’ll learn how to alternate colors in Google Sheets and add row or column banding to your data tables.
0 kommentar(er)
