Home / Blog / How to Apply Shading to Alternate Rows in Excel

How to Apply Shading to Alternate Rows in Excel

Excel Logo

Making use of coloration to alternate rows makes your spreadsheet knowledge simpler to learn. In Excel, that is fast and easy to use by formatting your knowledge as a Desk. The row shading is then mechanically utilized to new rows added to the desk.

The right way to Format Your Knowledge As a Desk

Choose the vary you wish to format as a desk. Subsequent, click on the “Format as Desk” button inside the “House” tab after which choose the desk fashion you wish to use.

Format your data range as a table

In case your knowledge vary already accommodates some formatting, it may be a good suggestion to right-click on the desk fashion and choose the “Apply and Clear Formatting” hyperlink. This can take away any present formatting earlier than making use of the desk fashion.

Apply and Clear Formatting when applying tables

You’ll then be prompted for the vary to format and whether or not it has headers. Examine that this vary is right, and alter it if mandatory. Click on the “OK” button to proceed.

Select the range to format as a table

The desk is utilized together with shading on alternate rows. This formatting will mechanically be utilized when new rows are added to the desk.

Alternate shading applied to a range

The right way to Edit the Row Shading Shade

When you aren’t pleased with the colour used for the row shading, you may change it. You can not instantly edit the present Excel desk kinds, however you may create your individual or duplicate an current fashion and edit that.

Let’s check out duplicating and altering the desk fashion we’ve utilized to this knowledge vary. Start by clicking on a cell inside the desk.

From the “Desk Design” tab (final tab on the ribbon), right-click the fashion within the “Desk Kinds” gallery after which click on “Duplicate.”

Duplicate an existing table style

Enter a reputation on your new desk fashion.

To edit the row shading, choose “First Row Stripe” after which click on the “Format” button.

Editing the table style

Click on the “Fill” tab. Choose the colour you wish to use. The “Extra Colours” button will present extra particular coloration choices.

Click on the “OK” button on the backside of the window to proceed.

Change the fill colour of a table row

Again within the “Modify Desk Type” dialog window, you can also make your fashion the default for the spreadsheet by checking the “Set As Default Type for This Doc” field. Click on the “OK” button to avoid wasting your modifications.

Apply the edited style

The duplicated fashion is created, however it isn’t utilized instantly. Click on the “Extra” button to open the desk fashion gallery.

Open the table styles gallery

Choose your customized fashion from the record supplied.

Select your table style from the gallery

Convert Your Desk Again to a Vary

There are numerous further advantages to formatting your Excel knowledge as a Desk, so utilizing one is inspired. Nonetheless, if you don’t want this performance, you may convert your desk again to a variety and nonetheless maintain the alternate row shading.

Click on a cell in your desk, choose the “Desk Design” tab (final tab on the Ribbon), after which click on “Convert to Vary.”

Convert table to range

You’ll be requested whether or not you’re positive you wish to do that. Click on the “Sure” button.

Are you sure to convert to range

With out being a desk, it won’t mechanically apply the shading to rows when they’re added. However you may copy the formatting shortly utilizing the Format Painter button, or an analogous approach.

About Alan Murray

Check Also

How to Troubleshoot Bluetooth Issues on a Mac

Bluetooth provides you the liberty to make use of gadgets like keyboards and headphones wirelessly, …

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.