Apply color to alternate rows or columns
Adding a color to alternate rows or columns (often called color banding) can make the data in your worksheet easier to scan. To format alternate rows or columns, you can quickly apply a preset table format. By using this method, alternate row or column shading is automatically applied when you add rows and columns.
Select the range of cells that you want to format.
Click Home > Format as Table .
Pick a table style that has alternate row shading.
To change the shading from rows to columns, select the table, click Design , and then uncheck the Banded Rows box and check the Banded Columns box.
Tip: If you want to keep a banded table style without the table functionality, you can convert the table to a data range . Color banding won't automatically continue as you add more rows or columns but you can copy alternate color formats to new rows by using Format Painter .
Use conditional formatting to apply banded rows or columns
You can also use a conditional formatting rule to apply different formatting to specific rows or columns.
On the worksheet, do one of the following:
To apply the shading to a specific range of cells, select the cells you want to format.
To apply the shading to the whole worksheet, click the Select All button.
Click Home > Conditional Formatting > New Rule .
In the Select a Rule Type box, click Use a formula to determine which cells to format .
To apply color to alternate rows, in the Format values where this formula is true box, type the formula =MOD(ROW(),2)=0 .
To apply color to alternate columns, type this formula: =MOD(COLUMN(),2)=0 .
These formulas determine whether a row or column is even or odd numbered, and then applies the color accordingly.
Click Format .
In the Format Cells box, click Fill .
Pick a color and click OK .
You can preview your choice under Sample and click OK or pick another color.
To edit the conditional formatting rule, click one of the cells that has the rule applied, click Home > Conditional Formatting > Manage Rules > Edit Rule , and then make your changes.
To clear conditional formatting from cells, select them, click Home > Clear , and pick Clear Formats .
Need more help?
Expand your skills.
EXPLORE TRAINING >
Get new features first
JOIN MICROSOFT 365 INSIDERS >
Was this information helpful?
Thank you for your feedback.
Book categories, collections.
- Technology Articles
- Software Articles
- Microsoft Products Articles
- PowerPoint Articles
How to Apply Styles to Tables in PowerPoint 2013
Powerpoint 2013 for dummies.
Sign up for the Dummies Beta Program to try Dummies' newest way to learn.
After you’ve created a table in PowerPoint 2013, you can set its style by using the controls under Table Tools on the Ribbon. The easiest way to format a table is by applying one of PowerPoint’s predefined table styles.
Before you apply a style, however, use the check boxes that appear at the left side of the Design tab under Table Tools on the Ribbon. These check boxes determine whether PowerPoint uses special formatting for certain parts of the table:
Header Row: Indicates whether the style should format the first row differently than the other rows in the table
Total Row: Indicates whether the style should format the last row differently than the other rows in the table
Banded Rows: Indicates whether alternating rows should be formatted differently
First Column: Indicates whether the style should format the first column differently than the other column in the table
Last Column: Indicates whether the style should format the last column differently than the other columns in the table
Banded Columns: Indicates whether alternating columns should be formatted differently
After you’ve set the Quick Style options, you can apply a Table Style to the table by clicking the style you want to apply. If the style doesn’t appear in the Table Styles group under Table Tools on the Ribbon, click the More button to reveal the Table Styles gallery. This gallery displays all the built-in styles provided with PowerPoint.
In addition to using one of the preselected table styles, you can format each cell and line in your table by using the following controls under Table Tools:
Shading: Sets the background color for the selected cells.
Borders: Lets you control which edges of the selected cells have borders.
Effects: Applies bevels, shadows, and reflections. (Note that you can apply bevels to individual cells, but shadows and reflections apply to the entire table.)
About This Article
This article is from the book:.
- PowerPoint 2013 For Dummies ,
About the book author:
Doug Lowe is the bestselling author of more than 40 For Dummies books. He's covered everything from Microsoft Office to creating web pages to technologies such as Java and ASP.NET, and has written several editions of both PowerPoint For Dummies and Networking For Dummies.
This article can be found in the category:
- PowerPoint ,
- PowerPoint 2013 For Dummies Cheat Sheet
- How to Create a Hyperlink to Another PowerPoint 2013 Slide
- 9 Things That Often Go Wrong in PowerPoint 2013
- How to Add Recurring Text or Other Elements in PowerPoint 2013
- How to Add Comments to PowerPoint 2013 Presentations
- View All Articles From Book
- Manage Templates
- Slide Library
- Agenda Wizard
- Manage Colors
- Insert Shapes
- Arrange and Align Shapes
- Edit Shapes
- Paragraph Styles
- Paint Formatting
- Format Text
- Create table from text boxes
- Convert table to text boxes
- Convert text to table
- Insert columns and rows
- Paste Excel data without formatting
- Set cell margins
- Express Table layout
- Autofit columns
- Evenly space columns
- Align shapes over tables
- Harvey Balls for Tables
- Status Indicators for Tables
- Customizable Shortcut Keys
- Search Shortcut Keys
- Customize the Format Toolbar
- Lock or Unlock Objects
- Set Proofing Language
- Slide Numbering
- Footers & Footnotes
- Refine Slides
- Format Images
- Format Charts
- Review Slides
- Share Slides
- Slide Library for Teams
- Share Custom Settings
- Create Faster
PPT Productivity PowerPoint add-in has 180+ time saving features. Format Tables features include shortcuts to create tables from boxes, convert tables to boxes, paste data into a table without the source formatting, auto table size optimizer and more. PPT Productivity lets you format your tables quickly in PowerPoint!
Adding row stripes to PowerPoint Tables helps make your data easier to read. However Standard PowerPoint does not auto update row stripes when rows are added or deleted.
PPT Productivity's Table Stripes feature gives you the power to add row stripes to your PowerPoint Tables with ease. If you check the box to indicate you have a header row, stripes are only applied to subsequent rows. Stripes will alternate between each row resulting in clear, easy to read Tables.
If you have applied row stripes to your Table and then insert or delete row(s), simply toggle the stripes on and off to reset. The Table Stripes function will recognize the new number of rows and re-apply the Stripes accordingly.
Management Consultants use table stripes rather than row and column borders to improve the readability of tables. Currently PowerPoint does not enable users to save table templates, but if you have created a table layout you would like to reuse you can save it to the Slide Library .
You can quickly insert it into any other presentation from the Slide Library Toolbar.
Want to see our tools in action?
Book a personalized demo with our PowerPoint professionals
Download 30 Day Free Trial
Download your 30 day free trial - Microsoft Office for Windows
30 day money back guarantee
2 Methods to Alternate Row or Column Colors in Your Word Table
In this article, we will introduce 2 methods for you to alternate row or column colors in your Word table.
When it comes to a long table, we always find it pretty tiresome to stare at those numbers and try so hard not to make a mistake. But now, we have 2 awesome ways to deal with such an issue that is to apply different colors for odd and even rows or columns. Following are details:
Method 1: Create a New Table Style
- Firstly, select the entire target table.
- Then, click “Design” tab under “Table Tools”.
- Next, in “Creating New Style from Formatting” dialog box, name the new style first.
Note: In the following example, we will demonstrate the way to set different colors for odd and even rows. And the same way can be employed to alter column color.
- Then, choose “Header row” for “Apply formatting to”.
- And click “Format” button on the left down side.
- Now in “Borders and Shading” dialog box, fist click “Borders” to choose whatever setting you need.
- Then click “Shading” and choose a color for “Fill”.
- Now you are back to “Creating New Style from Formatting” dialog box, choose “Odd banded rows” for “Apply formatting to”.
- Then repeat from step 7 to 11.
- Again, in “Creating New Style from Formatting” dialog box, this time you choose “Even banded rows”.
- And repeat from step 7 to 11, too.
- Now, you can choose a storage location for the new style, by selecting either “Only in this document” or “New documents based on this template”.
Now you can find the new style in “Table Styles” gallery. Select the table and choose the style, then you will have it on your table. And when you insert a row into the table, the color of other rows will change accordingly.
After colors are set to columns, you may find all table borders missing. Just choose “All Borders” in “Borders”.
Method 2: Insert an Excel Spreadsheet
- To begin with, open Word, and place cursor where the table goes.
- Next, click “Insert” tab.
- Then click “Table” option.
- Now select the entire sheet and make sure that “Home” tab is displayed.
- Then, click “Conditional Formatting”.
- Now in “Conditional Formatting Rules Manager” dialog box, choose “This Worksheet” for “Show formatting rules for”.
- In dialog box of “New Formatting Rule”, choose “Use a formula to determine which cells to format” for rule type.
- Then enter “=MOD(ROW(),2)=1” in “Format values where this formula is true” text box. This is to format odd rows.
- The “Format Cells” dialog box will pop up. Click “Border” first to choose necessary borders.
- Then click “Fill”, and choose a background color.
- Now go back to “Conditional Formatting Rules Manager” dialog box, and repeat step 8, 9, 10.
- Then enter “=MOD(ROW(),2)=0” in “Format values where this formula is true” text box to format even rows.
- And repeat from step 12 to 15.
You can directly edit on Excel sheet or paste a Word table there.
Alter Header Row Color
- Firstly, select header row and repeat step 6, 7, 8.
- Only in “New Formatting Rule” dialog box, you need to choose “Format only unique or duplicate values” for rule type.
Comparison of 2 Methods
Deal with the imminent failure of computer program.
Users of all kinds of digital devices are aware of the incremental crushes of programs installed. And for many people, we have the possibility of encountering with Word collapse. A damaged word can surely cause a lot trouble. One of the best ways to undermine it is to take routine backups both online and off-site. So you can turn to the latest version even if Word gets corrupted due to accident user errors.
Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including damaged Excel data fix and pdf repair software products. For more information visit www.datanumen.com
Leave a Reply Cancel reply
Your email address will not be published. Required fields are marked *
How to format a table in PowerPoint
In the last tutorial, we covered various methods to insert a table in PowerPoint. IN this tutorial we will be sharing multiple ways to format a table. We will be discussing how to customize the colors, borders, and other various attributes
10 ways to format a Powerpoint Table
- Format design attributes of a table — Style
- Format design attributes of a table — Color Combination
- Format design attributes of a table — Shading, Borders, Effects
- Format design attributes of a table — Draw & Erase Borders
- Format layout attributes of a table — View / Hide Gridlines
- Format layout attributes of a table — Insert Rows and Columns
- Format layout attributes of a table — Merge / Split Cells
- Format layout attributes of a table — Cell Size
- Format layout attributes of a table — Alignment
- Format layout attributes of a table — Table Size
Method #1: Format design attributes of a table — Style
Step #1: open powerpoint slide.
Open an existing slide in PowerPoint that has a table you want to format.
Click to select the table.
Drag and resize the table using the border handles if necessary.
The top menu bar changes to show new Table Tools.
Click on the Design tab under Table Tools to change the ribbon.
Step #2: Format the Table Style.
In the section Table Style Options, you have 6 choices:
- Header Row — to emphasize the topmost row as header
- Total Row — to emphasize the lowermost row for showing totals
- Banded Rows — to emphasize every alternate row.
- First Column — to emphasize the leftmost column
- Last Column — to emphasize the rightmost column
- Banded Columns — to emphasize every alternate column
Click on the choices you would like to display and ensure there is a tick mark present.
PowerPoint will change the table according to your choice.
Method #2: Format design attributes of a table — Color Combination
Step #2: Format the Table Color Combination.
In the section Table Styles, click the color combination you want from the selection.
Method #3: Format design attributes of a table — Shading, Borders, Effects
Step #2: Format the Table Shading, Borders, and Effects.
In the section Table Styles, you have three choices:
- Shading — to change the color shading of the background of a single cell.
- Borders — to show or hide internal/external borders, and to show or hide diagonal borders.
- Effects — to add visual effects to the table, such as a shadow or a reflection.
Select according to your requirement.
Method #4: Format design attributes of a table — Draw & Erase Borders
Step #2: Format the Table by drawing and erasing its borders.
In the section Draw Borders, you have five tools:
- Line Type — to draw solid, dashed, or dotted border lines
- Line Weight — to specify the thickness of the border line
- Pen Color — to specify the color of the border line
- Draw Table — to draw border lines for creating new cells, or for dividing cells.
- Eraser — to erase border lines for merging neighboring cells.
Use these tools to draw the borders of your table as you like.
Method #5: Format layout attributes of a table — View / Hide Gridlines
Click on the Layout tab under Table Tools to change the ribbon.
Step #2: Format the Table layout by showing/hiding its gridlines.
In the section Table, you have the option View Gridlines.
Click on View Gridlines to show the gridlines.
Click again on View Gridlines to hide the gridlines
Use this tool to change your table attribute.
Method #6: Format layout attributes of a table — Insert Rows and Columns
Step #2: Format the Table layout by inserting or deleting rows and columns.
In the section Rows & Columns, you have the five options:
- Delete — to delete a row, column, or a table
- Insert Above — to insert a new row above the present row
- Insert Below — to insert a new row below the present row
- Insert Left — to insert a new column to the left of the present column
- Insert Right — to insert a new column to the right of the present column
Click on the option you need to change the table attributes.
Method #7: Format layout attributes of a table — Merge / Split Cells
Step #2: Format the Table layout by merging or splitting cells.
In the section Merge, you have the two options:
- Merge Cells — to merge a few adjoining cells to form a single cell
- Split Cells — to split a single cell vertically or horizontally to form new cells.
Method #8: Format layout attributes of a table — Cell Size
Step #2: Format the Table layout by modifying the cell size.
In the section Cell Size, you have the two options:
- Height — specify the height of selected cells. Distribute it equally among the selected rows.
- Width — specify the height of selected cells. Distribute it equally among the selected columns.
Method #9: Format layout attributes of a table — Alignment
Step #2: Format the Table layout by defining the text alignment in the cell.
In the section Alignment, you have the eight options:
- Left align — to align the text in a cell to its extreme left.
- Center align — to align the text in a cell to its center .
- Right align — to align the text in a cell to its extreme right.
- Top align — to align the text in a cell to its top.
- Middle align — to align the text in a cell to its middle.
- Bottom align — to align the text in a cell to its bottom.
- Text Direction — to align the text in a cell as horizontal, rotated by 90- or 270-degrees, or stacked.
- Cell Margins — to define the margin between the cell borders and the text inside.
Method #10: Format layout attributes of a table — Table size
Step #2: Format the Table layout by changing its size.
In the section Table Size, you have the three options:
- Height — to define the height of the table.
- Width — to define the width of the table.
- Lock Aspect Ratio — to enable to maintain the aspect ratio when you change any dimension of the table.
There you have it. We have shared 10 different ways to format a PowerPoint table. If you have any suggestions, feel free to comment.
Leave a Comment Cancel reply
Save my name, email, and website in this browser for the next time I comment.
Format tables in PowerPoint
When you create a table from the Insert Table dialog box or the Table button , the table is automatically formatted with one of the preset table styles.
Format the table
You can format an entire table or individual cells by using the commands on the Table Design and Layout tabs, which appear after positioning the cursor inside the table or selecting a table element (table is active):
Working with tables in PowerPoint is almost the same as working with tables in Word. See also Select table elements in Word .
Modify table style options
On the Table Design tab, in the Table Style Options group, select or clear any of the six options:
- The selected Header Row checkbox determines the first row of the table contains column headings.
Note : PowerPoint tables don't support formulas. You can create an Excel spreadsheet on a PowerPoint slide to use any Excel formulas and functions.
- Select the First Column checkbox to determine the leftmost column of the table contains row headings.
- Select the Last Column checkbox to specify the rightmost column for summarizing the earlier columns.
- The Banded Rows and Banded Columns options alternate the background color of rows and columns (see how to change the background color for the selected cells below).
Note : Certain Table Style Options may have a different effect depending on the Table Style you've chosen. You might need to experiment to get the look you want.
Apply a predefined Table style
When you create a table from the Insert Table dialog box or the Table button , the new table is automatically formatted with one of the preset table styles used by default (see below for how to change the preset style used by default ). Styles include a variety of borders, colors, and other attributes that give a table a professional appearance.
PowerPoint offers several predefined styles you can use for the table. You can change the table style if desired or remove all styles from the table, leaving it plain black and white.
To choose any of the predefined styles , do the following:
1. Select the table.
2. On the Table Design tab, in the Table Styles group, in the Table Styles gallery, click the More arrow to see the complete list of styles:
3. Select the table style you prefer:
The Table Styles gallery includes four categories of styles:
- Best Match for Document includes styles use theme colors applied to the slide,
- Light , Medium , and Dark include styles with few, medium, or more formatting.
- Predefined styles vary depending on the Theme applied for the presentation or slide (see more about Themes ). For example, if the Facet theme is applied:
4. Point to table styles to preview their effects on the table.
5. Click the thumbnail to apply the corresponding style.
Note : The selected style overrides the table's previously added style changes.
To remove all styles from the table , on the Table Design tab, in the Table Styles group, in the Styles Gallery , click the More arrow, then select Clear Table :
Apply the border styles
See how to change the color of the table borders in PowerPoint .
Apply background colors and shading
To fill one or more cells with a specific color, select the cell or cells, then do one of the following:
Using the ribbon tab
On the Table Design tab, in the Table Styles group, click the Shading button to choose a fill type from the color picker:
- Select one of the six shades of each of the 10 theme colors in the Theme Colors palette. Colors in this palette depend on the current Theme .
- Select one of the 10 standard colors available in all Microsoft documents in the Standard Colors palette, regardless of the theme. The colors in this palette are the same on all computers.
- Select any of the non-standard colors you have used recently if there are any in the Recent Colors palette.
- Click No Fill to make the object transparent.
- Click More Fill Colors... to use non-theme colors (see how to apply a solid color for more details).
1. Click the Eyedropper . The cursor changes to the shape of an eyedropper.
2. Click any element on the slide to select that color:
- Choose No Gradient to remove gradient filling,
Note : You can see another set of variants if the selection has filling already:
- Select More Gradients... to open more gradient options. See more about how to work with gradients .
Or click More Textures... to open the Format *** pane with more fill options. See more about how to use a texture fill .
The table fill color is only visible in cells with an individual fill set to No Fill (or a translucent fill, in which case it blends).
Using the Format pane
Right-click the selection and choose Format Shape... in the popup menu:
On the Format Shape pane, on the Shape Options tab, in the Fill & Line group, in the Fill section, choose the one you need:
The No fill option also is used to clear the selected cell or cells fill formatting.
See how to apply a solid color .
Note : By default, fill colors are opaque (other background formatting does not show through). A transparency setting of 100% makes the fill color invisible, while the default value for an opaque color is 0%.
See how to work with gradients for more details.
See how to insert a picture .
- Insert any graphic object such as a picture, SmartArt, chart, diagram, etc., from the Clipboard .
You can select from various textures, including fabric, marble, granite, wood grain, and Formica-like textures in various colors. See how to use a texture fill .
Format linked or embedded tables
You can't format linked or embedded table data in the same way that you can format a PowerPoint table on a slide:
- An embedded table opens in an Excel window on the slide,
- A linked table opens in a separate Excel window.
The correct way is to modify the source document, not the linked object on the slide, as any content or formatting changes the linked object on the slide. Any content or formatting changes you make to the linked object will be overwritten the next time you open the presentation because PowerPoint will update the linked object to reflect the information in the source document.
Clear background colors and shading
To clear a cell fill color, select the cell or cells you want to clear, then do one of the following:
- On the Table Design tab, in the Table Styles group, on the Shading menu, click No Fill .
- On the Format Shape pane, on the Shape Options tab, in the Fill & Line group, in the Fill section, choose No fill .
To clear the table fill color, click inside the table to activate it, then on the Table Design tab, in the Table Styles group, click the Shading button to open the dropdown list, then from the Table Background list, choose No Fill :
Please, disable AdBlock and reload the page to continue
Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.
Fill Settings for Shapes, Diagrams, Text Boxes and Charts in Powerpoint
Theme elements in PowerPoint
be the expert in your office
An Excel Blog For The Real World
A blog focused primarily on Microsoft Excel, PowerPoint, & Word with articles aimed to take your data analysis and spreadsheet skills to the next level. Learn anything from creating dashboards to automating tasks with VBA code!
3 Ways To Alternate Row Colors in Excel [Guide]
Implementing Row Banding (Alternating Colors)
While Excel does not have a dedicated row banding button to alternate row colors, there are a few creative ways we can obtain this effect. In this article we will walk through three solutions that will provide a way forward for how you might want to accomplish this:
Using an Excel Table
Using Conditional Formatting
Using a VBA Macro
Method 1: Utilize An Excel Table
An Excel Table is an object you can insert to allow for your data to be dynamically referenced throughout your spreadsheet. There are limitations that come with the Table object (such as every column has to have a unique heading), but if you can live with some of the restrictions, this is a great way to alternate row colors automatically.
Converting your spreadsheet range to a table object is as easy as
Select your data range
Navigate to the Insert Tab on your Ribbon Menu
Click the Table Button
Tell the dialog box if your selection included headers
Alternatively, you can select your data range and use the keyboard shortcut Ctrl + t to get to the insert Table dialog box.
If you do not like one of the default Table Style options, you can create your own Table format to get specific row colors. Just click New Table Style at the very bottom of the Table Styles gallery in Excel Ribbon.
Method 2: Conditional Formatting
If you don’t want to utilize an Excel table, you can alternatively utilize conditional formatting rules to get alternating colors.
The only disadvantage to this method is you (as of this writing) cannot reference named ranges in conditional formatting rules. This means if you add a new row to the bottom of the table at a later date, you will need to update the conditional formatting data range to ensure the new row is included in the rule.
Note: If you insert a row inside your currently formatted rows, the conditional formatting rule will automatically adjust to include it.
To create this color banding, you will need to select the cell range you are targeting and add a new Conditional Formatting rule.
Navigate to the Home Tab
Click the Conditional Formatting menu button
Select New Rule…
In the New Formatting Rule dialog box, select “ Use a formula to determine which cells to format ”
Enter one of the MOD functional rules noted below:
For even-numbered rows , you’ll want to use one of the following formulas:
For odd-numbered rows , you’ll want to use one of the following formulas:
Click the Format Button and select the specific formatting you wish to apply (I just chose a fill color of gray)
Click OK Button
Repeat steps 1-7 for the secondary color
Once you’ve created both your primary and secondary banding conditional formatting rules, you should see the alternating colors automatically apply.
Method 3: VBA Coded Macro
Maybe you are looking for a solution that is more ad-hoc or on-demand. For times where you want to quickly format a table before sending it off to the executives, having a personal macro that can band your data in a pinch might be the right answer for your needs.
The below code allows you to select a range on your spreadsheet and quickly alternate two different colors across the rows. Just programmatically define the two color codes you wish to use (you can reference VB colors or an RGB color code for more flexibility/variety) at the beginning of the code.
The remaining VBA code loops through each row and alternates the fill colors applied based on odd/even rows. If you would like to learn a bit more about the technique used to determine odd/even rows, you can check out this article: VBA To Determine If Number Is Odd Or Even .
Sub AlternateRowColors() 'PURPOSE: Alternate row fill colors based on selected range 'SOURCE: www.TheSpreadsheetGuru.com/the-code-vault Dim rng As Range Dim x As Long Dim LightColorCode As Long Dim DarkColorCode As Long 'Define Colors (Input) LightColorCode = vbWhite DarkColorCode = RGB(242, 242, 242) 'Ensure a Range is Selected If TypeName(Selection) <> "Range" Then Exit Sub 'Store Selected range to a variable Set rng = Selection 'Check for more than 1 row selected If rng.Rows.Count = 1 Then Exit Sub 'Loop through each row in selection and color appropriately For x = 1 To rng.Rows.Count If x Mod 2 = 0 Then rng.Rows(x).Interior.Color = DarkColorCode 'Even Row Else rng.Rows(x).Interior.Color = LightColorCode 'Odd Row End If Next x End Sub
Download The Excel Example File
If you would like to get a copy of the Excel file I used throughout this article, feel free to directly download the spreadsheet by clicking the download button below.
I Hope This Helped!
Hopefully, I was able to explain how you can use a number of different methods in Excel to alternate row colors in a given cell range. If you have any questions about these techniques or suggestions on how to improve them, please let me know in the comments section below.
About The Author
Hey there! I’m Chris and I run TheSpreadsheetGuru website in my spare time. By day, I’m actually a finance professional who relies on Microsoft Excel quite heavily in the corporate world. I love taking the things I learn in the “real world” and sharing them with everyone here on this site so that you too can become a spreadsheet guru at your company.
Through my years in the corporate world, I’ve been able to pick up on opportunities to make working with Excel better and have built a variety of Excel add-ins , from inserting tickmark symbols to automating copy/pasting from Excel to PowerPoint. If you’d like to keep up to date with the latest Excel news and directly get emailed the most meaningful Excel tips I’ve learned over the years, you can sign up for my free newsletters . I hope I was able to provide you some value today and hope to see you back here soon! - Chris
Become an expert in Excel, PowerPoint, Word, and the rest of the Microsoft Office Suite. Check out all the free tutorials and VBA code snippets!
Latest Blog Posts
Guru Solutions, LLC | © 2015-2022 | ALL RIGHTS RESERVED Excel, PowerPoint, Word, & the rest of the Office Suite are registered trademarks of the Microsoft Corporation This site is not affiliated with Microsoft Corporation.
Help Center Help Center
- Help Center
- Trial Software
- Product Updates
- Report Components
Stripe table rows and columns
Specifies whether to format table rows and columns. Before you use TableStyleOptions , specify the table style using the StyleName property on the Table object you want to apply the options to. The table style determines the formatting of the table, for example, the color of the banding and first- and last-column emphasis.
The mlreportgen.ppt.TableStyleOptions class is a handle class.
tableStyles = TableStyleOptions() creates a TableStyleOptions object. This object uses the properties of the table style assigned to the StyleName property of the table you assign the properties to. The table uses the TableStyleOption object only if the associated table sets the StyleName property.
BandedColumns — Alternating color for columns true | false
Alternating color (banding) for columns, specified as:
true — Colors alternate for columns.
false — Columns use same color.
BandedRows — Alternating color (banding) for rows true | false
Alternating color for rows, specified as:
true — Colors alternate for rows.
false — Rows use same color.
FirstColumn — Emphasis for first column in table true | false
Emphasis for first column in table, specified as:
true — First column uses emphasis styling, e.g., stronger color, emphasized font.
false — Regular styling on first column.
FirstRow — Emphasis for first row of table true | false
Emphasis for first row of table, specified as:
true — First row uses emphasis styling, e.g., stronger color, emphasized font.
false — Regular styling on first row.
Id — ID for this PPT API object character vector | string scalar
ID for this PPT API object, specified as a character vector or string scalar. A session-unique ID is generated as part of object creation. You can specify an ID to replace the generated ID.
LastColumn — Emphasis for last column in table true | false
Emphasis for last column in table, specified as:
true — Last column uses emphasis styling, e.g., stronger color, emphasized font.
false — Regular styling on last column.
LastRow — Emphasis for last row of table true | false
Emphasis for last row of table, specified as:
true — Last row uses emphasis styling, e.g., stronger color, emphasized font.
false — Regular styling on last row.
Tag — Tag for this PPT API object character vector | string scalar
Tag for this PPT API object, specified as a character vector or string scalar. A session-unique tag is generated as part of the creation of this object. The generated tag has the form CLASS:ID , where CLASS is the object class and ID is the value of the Id property of the object.
Specifying your own tag value can help you to identify where an issue occurred during presentation generation.
Style a Table
This example shows how to control the formatting of a table based on the Medium Style 2 - Accent 1 table style in the default PPT template. Change the values of each of the styling properties from false to true , or the reverse, to understand their effects.
Introduced in R2016a
- Create and Format Tables
You clicked a link that corresponds to this MATLAB command:
Run the command by entering it in the MATLAB Command Window. Web browsers do not support MATLAB commands.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
- Switzerland (English)
- Switzerland (Deutsch)
- Switzerland (Français)
- 中国 (English)
You can also select a web site from the following list:
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
- América Latina (Español)
- Canada (English)
- United States (English)
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- United Kingdom (English)
- Australia (English)
- India (English)
- New Zealand (English)
Contact your local office
Fills and Effects for Tables in PowerPoint 2013 for Windows
Learn about fills (shading) and effects in PowerPoint 2013 for Windows. Using these techniques, you can make certain rows, columns, or cell stand out.
Author: Geetesh Bajaj
Product/Version: PowerPoint 2013 for Windows
OS: Microsoft Windows 7 and higher
Date Created: April 3, 2014 Last Updated: April 3, 2014
Tables in PowerPoint help you to make your numerical data or other content look organized. They also make it easy for your audience to quickly comprehend the data. You can make this task even more effective by selecting particular cells in the table, or the entire table, and then changing their shading and applying some effects to them so that they are highlighted.
Highlight Complete Rows and Columns
If you want to highlight complete rows and columns, you may find using the Header Row and similar options easier. These options are explained in our Table Style Options in PowerPoint 2013 for Windows tutorial.
Follow these steps to learn how you can alter the look of your PowerPoint tables using Shading and Effects options in PowerPoint 2013 for Windows :
Apply Shading to the Table (or Selected Cells):
- Select the entire table or just the rows/columns that you want to change the fill for. Access the Table Tools Design contextual tab (highlighted in red within Figure 1 ) of the Ribbon . Then, locate the Shading button and click the down-arrow (highlighted in blue within Figure 2 ). This opens the Shading drop-down gallery that you see in Figure 1 , below.
- 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 .
- 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.
- Select any of the Shading options to recolor the selected cells within your table, as shown within Figure 3 .
- Save your presentation often.
Apply an Effect to the Table (or Selected Cells):
- 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 .
- 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
- 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.
- 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.
- 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.
- Select any Effect option for your table (cells). Figure 5 shows how a shadow effect has been applied to the selected table.
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
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 .
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Media Kit | Feedback | Site Map | About Us | Contact Us Link to Us | Privacy | Testimonials PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates
Plagiarism will be detected by Copyscape
The horizontal rows on the periodic table of the elements are called periods. Every element in a period has the same number of atomic orbitals. For instance, hydrogen and helium are in the first period, so they both have electrons in one or...
On the periodic table, the seven horizontal rows are called periods. On the left-hand side of the periodic table, the row numbers are given as one through seven. Moving across a period from left to right, the atomic number of the elements i...
The intersection of a vertical column and horizontal row is called a cell. The location, or address, of a specific cell is identified by using the headers of the column and row involved. For example, cell “F2” is located at the spot where c...
Select the range of cells that you want to format. · Click Home > Format as Table. · Pick a table style that has alternate row shading. · To change the shading
This is instruction how to apply different colors for odd and even rows or columns in Word and PowerPoint. For creating directly in
This is instruction how to apply different colors for odd and even rows or columns in Powerpoint.
Banded Rows: Indicates whether alternating rows should be formatted differently. First Column: Indicates whether the style should format the first column
PPT Productivity's Table Stripes feature gives you the power to add row stripes to your PowerPoint Tables with ease. If you check the box to
Method 1: Create a New Table Style · Choose “Borders and Shading”.
In the section Table Styles, click the color combination you want from the selection. PowerPoint will change the table according to your choice.
The Banded Rows and Banded Columns options alternate the background color of rows and columns (see how to change the background color for the selected cells
If you do not like one of the default Table Style options, you can create your own Table format to get specific row colors. Just click New Table
Package: mlreportgen.ppt. Stripe table rows ... BandedRows — Alternating color (banding) for rows
Select the entire table or just the rows/columns that you want to change the fill for. Access the Table Tools Design contextual tab (highlighted