If you want to shade every other row in a PowerPoint

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 800 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 12 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

It is just a common training to add color to alternate rows within an Excel Spreadsheet to make it simpler and to enhance readability. In a spreadsheet, if you will find several rows to be colored, and you have to do it one by one, it will soon be time-consuming and tiring as well. One of the greatest methods to make points clearer is to color every switch row in the sheet. The feature applies to MS Excel 2007 and higher versions.

This article describes how to highlight every other row in excel. You can quickly color every other row in Excel, as there are different rows or columns in your spreadsheet. Please check out the two probable techniques below…

How Excel highlight Every Other Row by Using the “Format as Table” option 

1. On a new spreadsheet, choose the cell range that you want to color the alternate row, or press Ctrl + A to choose the whole data. For example, I have selected a variety of data from F5 to H13. Please browse the screenshot.

Figure 1: Shading drop-down gallery

Within the Shading drop-down gallery, you will find various options to change the fill of selected table (or cells). To learn more about the top nine options, refer to the points 3-A to 3-I in our Add Solid Fills to Shapes in PowerPoint 2013 tutorial. Even though the linked tutorial explains various fill options for shapes, the options work similarly with table cells.

Selecting the Table Background option (highlighted in green within Figure 1, above) opens another sub-gallery containing only the same top seven options as within the Shading drop-down gallery, as shown in Figure 2.

Figure 2: Table Background sub-gallery

Even though the top seven options within the Shading drop-down gallery and the Table Background sub-gallery look similar (compare in Figures 1 and 2), they act differently when you try to apply any of them on only a set of few cells within a table as shown in Figure 1, above. The difference is:

• Options within the Shading drop-down gallery get applied to only the selected cells within a Table.
• Options within the Table Background sub-gallery get applied to the entire Table, even though you have selected only a few cells within the Table.

Note: If you choose any of the Table Background options for a table that is already filled with a color, gradient, picture etc., then you won't be able to see the changes. To make the changes visible, you need to select the entire table and then select the No Fill option within the Shading drop-down gallery.

Select any of the Shading options to recolor the selected cells within your table, as shown within Figure 3.

Figure 3: Table cells applied with a fill color

Save your presentation often.

Apply an Effect to the Table (or Selected Cells):

1. Select the entire table or just the rows you want to apply an effect to. Access the Table Tools Design contextual tab (highlighted in red within Figure 4) of the Ribbon. Then, click the Effects button (highlighted in blue within Figure 4). This opens the Effects drop-down gallery that you see in Figure 4.
2. 
   
   Figure 4: Effects drop-down gallery
3. Let's explore the options within the Effects drop-down gallery, as marked in Figure 4, above. For more info on these options, refer to the tutorials linked. Even though the linked tutorials explain effects applied to shapes, the options work similarly with table cells.

A. Cell Bevel

4. Select this option to apply Bevel effects to the table cells. Even though you have selected the entire table, the Cell Bevel effect gets applied to each and every cell within the selected table. To learn more about this option refer to our Apply Bevel Effects to Shapes in PowerPoint 2013 tutorial.

B. Shadow

5. This option is used to apply a shadow effect to the selected table. Even though you have selected few cells within table, the Shadow effect gets applied to the entire table. For more info, refer to our Apply Shadow Effects to Shapes in PowerPoint 2013 tutorial.

C. Reflection

6. Adds a reflection to the selected table. Again, even though you have selected few cells within table, the Reflection effect gets applied to the entire table. Refer to our Apply Reflection Effects to Shapes in PowerPoint 2013 tutorial to learn more about this option.
7. Select any Effect option for your table (cells). Figure 5 shows how a shadow effect has been applied to the selected table.
8. 
   
   Figure 5: Table applied with shadow effect
9. Save your presentation often.

---

See Also:

Table Basics: Fills and Effects for Tables in PowerPoint (Glossary Page)

Fills and Effects for Tables in PowerPoint 2011 for Mac

You May Also Like: Insert Tables in PowerPoint 2013 for Windows | Presentation Management: Ensure Compliance

---

Popular Posts

PowerPoint Tutorials
These PowerPoint tutorials have many screen shots that show you exactly what you see in your computer!

10 Tips for Pecha Kucha
Read 10 amazing Pecha Kucha tips that will help you create and deliver a better Pecha Kucha presentation.

Jigsaw Graphics for PowerPoint

Here are 10 jigsaw graphics containing different shapes. These graphics are available in both black and white and are contained within separate sample presentations that you download. Additionally, these jigsaw graphics are vector shapes, so you can easily edit them within your Microsoft Office program by changing fills, lines, and effects or even applying Shape Styles.

Download and use these Jigsaw Graphics in your slides for just $4.99+

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Fills and Effects for Tables in PowerPoint 2013 for Windows.