How to Shade Every Other Row in Microsoft Excel

[ad_1]

Laptops

shade every other row in excel.Staring at text or numerals in columns and rows isn’t exactly easy on the eyes. There are many pre-formatted color plans you could try, or you could just save the hassle of looking through them and elect to color shade alternating lines.

Laptops

It’s sleek, professional-looking, and a breeze to do with Excel’s built-in tools.

Shade Every Other Row in Microsoft Excel

  1. Open an Excel workbook.
Laptops

2.Highlight the section you want to apply the effect to. Don’t alternate rows or columns, just highlight an entire area, as shown.

Laptops

3.Under the Home tab, click Conditional Formatting.

Laptops

4.Select New Rule.

Laptops

5.In the Format Style drop-down, choose Classic.

6.Choose Use a formula to decide which cells to format.

Laptops

7.Enter the following formula into the appropriate area: =MOD(Row(),2)=1.

Laptops

8.Click Format.

Laptops

9.Click the Fill tab and select a color.

Laptops

10.Click OK.

Laptops

11.Click OK once more to apply the formatting.

Laptops

source link

[ad_2]

Source link

Leave a Reply

Your email address will not be published. Required fields are marked *