microsoft excel spreadsheet shade every other row

#MICROSOFT EXCEL SPREADSHEET SHADE EVERY OTHER ROW HOW TO#

Go back into the “Table Design” tab of the Excel ribbon and click “Quick Styles”, then select your style from the list with your cells highlighted.

Select your custom style from the Quick Styles menu.

This will help to make your data more visually appealing and easier to read. Now that you have your table created and formatted, its time to choose a table style that includes shading for every other row.

Tick “Set as default table style for this document” and press “OK” This feature will make it easy to shade every other line in your Excel spreadsheet.

Switch to the “Fill” tab and select a colorĬlick “Fill” in your Format Cells window and either choose from the list of preset colors or click “More Colors…” to define your shading for the worksheet.

To format the First Row Stripe, just select it from the list and press the “Format” button below it.

Name your zebra stripes Excel style and format the first row stripe.

With the style window in focus, right-click your current style and choose “Duplicate…”. Switch to the “Table Design” tab in your ribbon, then click “Quick Styles”. You can't directly edit the default banded row styles, so it's necessary to duplicate one first. As well as selecting a different color from the Quick Styles list, you can add your own custom colors. If you don't like the color you chose initially, it is possible to change it.

#MICROSOFT EXCEL SPREADSHEET SHADE EVERY OTHER ROW HOW TO#

How to Edit Your Zebra Stripes' Excel Style The formatting will also apply to any new rows you add to the table. You should also tick “My table has headers” if it has them.Įxcel should auto color cells in the zebra stripes pattern, with your header rows highlighted in the color of your choice. If needed, you can modify the table range to include more or fewer cells.

Press “OK” to the “Create Table” prompt.

If you want Excel to keep your formatting before it auto colors cells, you can select “Apply (and Maintain Formatting)” instead. This will remove any current formatting before applying the table style.

In the resulting pop-up menu, you want to right-click on a theme option and press “Apply and Clear Formatting”. Select a color scheme from the dropdown menu.Select the cells and press “Format as Table” in the “Home” tab of the ribbon.To get started shading your worksheet, you'll want to highlight the rows to format as a table and follow the steps below:

Microsoft excel spreadsheet shade every other row