How to Shade or Color Every Other Row or Column in Excel Office 365?
Tags: kutoolsexceltutorial, shadeorcoloreveryoth, kutools
Published: 2020-10-27 09:24:59

---
title: How to Shade or Color Every Other Row or Column in Excel Office 365?
published: true
date: 2020-10-23 10:23:43 UTC
tags: KutoolsExcelTutorial,ShadeorColorEveryOth,Kutools
canonical_url: https://geekexcel.com/how-to-shade-or-color-every-other-row-or-column-in-excel-office-365/
---

In this tutorial, we will guide you to learn the steps to **Shade or Color Every Other Row or Column in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Shade or Color Every Other Row:

- First, you need to **highlight the range** that you want to shade or color.

![Example range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-range-2.png)<figcaption id="caption-attachment-16289">Example range</figcaption>

- Go to the **Kutools Tab, select** the **Format** option, **choose** the **Alternate Row/Column Shading** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Kutools-Tab-2.png)<figcaption id="caption-attachment-16290">Kutools Tab</figcaption>

- Then, it will open the **Alternate Row / Column Shading Dialog box**.
- After that, You need to **choose** the **Rows** option under the **Apply shading to** section.

Then, you need to choose the shading method options:

- **Conditional formatting –** This option uses conditional formatting to apply shading to alternate rows. If you insert any new rows within the range, the alternate row shading will be adjusted automatically.
- **Standard Formatting –** It uses standard formatting to apply shading to alternate rows.
- **Remove existing alternate shading –** This option will remove all conditional formatting and background shading.
- **Shade color –** You need to **select** the **color** using the drop-down arrow as you need.
- **Shade every – ** Specify the number of rows that you want to shade.
- **Leave existing color for non-shaded rows –** If the selected range is filled with background color, and you don’t want to remove the background color after you apply this utility, you need to check this option.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-the-OK-button-6.png)<figcaption id="caption-attachment-16291">Click the OK button</figcaption>

- Finally, **click** the **OK** button.
- Now, you can see that the selected range has been shaded every other row as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-38.png)<figcaption id="caption-attachment-16292">Result</figcaption>

## Steps to Shade Color Every Other Column:

- First, you need to **select the range** that you want to shade.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-28.png)<figcaption id="caption-attachment-16293">Input Range</figcaption>

- On the **Kutools Tab, select** the **Format** option, **choose** the **Alternate Row/Column Shading** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Kutools-Tab-2.png)<figcaption id="caption-attachment-16290">Kutools Tab</figcaption>

- Now, it will open the **Alternate Row / Column Shading Dialog box**.
- You need to **choose** the **Columns** option under the **Applying shading to** section.
- **Conditional formatting –** This option uses conditional formatting to apply shading to alternate rows. If you insert any new rows within the range, the alternate row shading will be adjusted automatically.
- **Standard Formatting –** It uses standard formatting to apply shading to alternate rows.
- **Remove existing alternate shading –** This option will remove all conditional formatting and background shading.
- **Shade color –** You need to **select** the **color** using the drop-down arrow as you need.
- **Shade every – ** Specify the number of rows that you want to shade.
- **Leave existing color for non-shaded rows –** If the selected range is filled with background color, and you don’t want to remove the background color after you apply this utility, you need to check this option.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-20.png)<figcaption id="caption-attachment-16294">Hit the OK button</figcaption>

- Then, **click** the **OK** button.
- Finally, you can get the result as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-18.png)<figcaption id="caption-attachment-16295">Output</figcaption>

## Remove All Conditional Formatting Shading & Background Color:

- **Select the input range** which contains conditional formatting or background color that you want to remove.

![Input](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-10.png)<figcaption id="caption-attachment-16296">Input</figcaption>

- On the **Kutools Tab, select** the **Format** option, **choose** the **Alternate Row/Column Shading** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Kutools-Tab-2.png)<figcaption id="caption-attachment-16290">Kutools Tab</figcaption>

- After that, it will open the **Alternate Row / Column Shading Dialog box**.
- In that dialog box, you need to **select** the **Remove existing alternate row shading** option.
- Then, **click** the **OK** button.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-11.png)<figcaption id="caption-attachment-16297">Click the OK button</figcaption>

- It will open a prompt box, if you **click Yes,** the conditional formatting and background color will be deleted.
- If you **click No,** the background color will be deleted.

![Click Yes or No option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/6-7.png)<figcaption id="caption-attachment-16298">Click Yes or No option</figcaption>

## End of the Article:

In the above tutorial, we guided you to understand the steps to **Shade or Color Every Other Row or Column in Excel Office 365** using **Kutools.** Leave your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Trace All Dependents or Precedents in Excel Office 365?](https://geekexcel.com/how-to-trace-all-dependents-or-precedents-in-excel-office-365/)
- [How to Change Font Color in Microsoft Excel 365?](https://geekexcel.com/how-to-change-font-color-in-microsoft-excel-365/)