If none of the built-in PivotTable styles meet your needs, you can always create your own. In this video, learn how to create a PivotTable style.
- [Instructor] The built-in pivot table style gallery contains a lot of good color schemes, style to reflect your personal aesthetic, or perhaps your company's graphic art guidelines, you can do so using the new pivot table quick style dialogue box. I'll demonstrate how to use this tool in this movie. My sample file is O four O two create style, and you can find it in the chapter four folder of your exercise files collection. I have applied one of the built-in styles to this pivot table, but let's say now that I want to create my own. I'll click any cell in the pivot table. of the ribbon, I'll move my mouse pointer over the in-ribbon gallery. Click the down arrow that appears, and click new pivot table style. And doing so displays the new pivot table quick style dialogue box. I can give the style a name, so I'll call it 2019 guidelines. And now I can select the elements that I want to change. So I'll scroll down in the table element panel, and I'll click header row. And now I can change its format. Now go ahead and click the format button. And you should see the format cells dialogue box. Mine opened to the font tab, but whichever tab you had open last is what you will see here. So I have font and this is a header, so I will make the text bold. And I will also change its color because I think I want to go with a darker background. I'll change the text color to white. So I have color. And I'll change it from automatic to the white square top left corner. And there we go. My preview looks blank because I have white text on a white background, but we'll fix that now. I'll go to the fill tab, and for the background color I'll make it purple. So I'll click the background color control. Go down, click purple. Right that looks good. I'll click okay. And I see in my preview that everything looks nice. It's the color of purple that I want, and my text is white. to do the subtotal rows. and I'll click subtotal row one a very light blue, so I'll click there. And I will have that style applied when the pivot table style is ready. And in fact that's the only change I'll make here. You can change any other elements that you want. I'll go ahead and click okay, and the style appears in the gallery. It doesn't appear in the ribbon at the moment, but if you move your mouse pointer over the gallery and click the down arrow, you'll see that it appears here at the top in a new custom section. So I'll click that. Now we don't currently have any subtotal formatting that's obvious, but if I go to the subtotals button on the design contextual tab, click down and then I'll click show all subtotals at bottom of group. Then the formatting is applied. And you can see it's applied Click okay and when you do, Excel will apply another style to your pivot table. So as you can see, you have a lot of tools to control exactly how your pivot table appears within Excel.
Note: This course was recorded in Office 365 for Mac. However, much of the content will be useful to those working with Office for Mac 2019 and 2016.
- Formatting data for use in a PivotTable
- Creating a new PivotTable
- Connecting to external data sources
- Summarizing totals and other data fields
- Creating calculated fields
- Summarizing field data
- Sorting and filtering PivotTables
- Working with Excel slicers
- Formatting PivotTables styles and layouts
- Applying conditional formats
- Summarizing data visually using a PivotChart