With this utility you can quickly apply shading to alternate row or column for a range cells in a worksheet from using Conditional Formatting and standard formatting to improve the readability of your worksheet in Excel, and you don’t need to know to use the Conditional Formatting and standard formatting. Dose for Excel‘s Alternate Row / Column Shading utility quickly shade every other rows or columns in the selected range of cells.
- Shade or color every other row
- Shade or color every other column
- Remove all conditional formatting shading and background color
Click DOSE » Format » Alternate Row / Column Shading
![Excel Alternate Column Row Shading](https://zbrainsoft.com/wp-content/uploads/2024/01/6-4.png)
Shade or color every other row
- Example: shade every 1 row in a selected range.
- Select range that you want to shade every nth row.
- Check Rows option in Apply shading to box, then check Conditional formatting option.
- Pick colors to shade every row in selected range, a colors template is shown in the pane to help you view your changes before implementing.
- Specify the nth row number to shade in Shade every box, and keep the Leave existing color for non-shaded rows option checked if you want.
![Excel Alternate Column Row Shading](https://zbrainsoft.com/wp-content/uploads/2024/01/7.png)
Then click Apply. In below example, you will see how rows are shaded according to your parameters. See the result as shown in the below screenshot.
![Excel Alternate Column Row Shading](https://zbrainsoft.com/wp-content/uploads/2024/01/10.png)
Shade or color every other column
- Example: shade every 1 column in a selected range.
- Select range that you want to shade every nth column.
- Check Columns option in Apply shading to box, then check Conditional formatting option.
- Pick colors to shade every column in selected range, a colors template is shown in the pane to help you view your changes before implementing.
- Specify the nth column number to shade in Shade every box, and keep the Leave existing color for non-shaded columns option checked if you want.
![Excel Alternate Column Row Shading](https://zbrainsoft.com/wp-content/uploads/2024/01/13.png)
Then click Apply. In below example, you will see how columns are shaded according to your parameters. See the result as shown in the below screenshot.
![Excel Alternate Column Row Shading](https://zbrainsoft.com/wp-content/uploads/2024/01/14.png)
Remove all conditional formatting shading and background color
- Example: remove conditional formatting shading and background color from selected range in Excel.
- Select range that you want to remove shading from.
- Check Remove existing alternate row shading option.
- Then click Apply. See the below screenshot.
![Excel Alternate Column Row Shading](https://zbrainsoft.com/wp-content/uploads/2024/01/17-1.png)
Demo
More Features:
How to Remove Leading Or Trailing Or Extra Spaces In Excel
Remove Leading Or Trailing Or Extra Spaces From Excel Cells You can remove leading spaces,…
Compare Lists in Excel
Compare Lists in Excel If you ever want to compare lists by looking up for…
Excel Insert Before After
Insert Text Before Or After In Excel Cells You can add text before first letter…
How to insert a date picker in Excel
Add Date Pickers to Your Excel Sheets in No Time Effortlessly streamline data entry and…
Excel Fill Blank Cells
Fill Blank Cells In Excel Range Fill blank cells in a range of cells could…
Excel Batch Delete Check Boxes
Excel Batch Delete Check Boxes In Excel Batch deleting check boxes in selected cells without…