- In the previous movie I showed you how…to print a Pivot Table.…In this movie I will show you how…to set some print options that might be useful.…As my sample file, I will use the Set Options…Excel workbook and you can find that in the…chapter seven folder of the exercise files collection.…If you want to set options for your pivot table…click any cell within the pivot table, and then click…the analyze contextual tab and click the options button.…

That's in the pivot table group at the left side…of this tab of the ribbon.…There are a number of options that you can set here.…Those include layout and format, totals and filters,…display, and also printing.…Let's focus on the checkbox's available…on the printing tab.…There are three checkbox's available to you.…The first is whether or not to print the expand…and collapse buttons when they are displayed…on a pivot table.…

So for example, if you take a look at the left side…of the pivot table here for 2014,…you see that there is a collapse button.…It looks like a minus sign.…

Resume Transcript Auto-Scroll

Author

Released

1/13/2016

Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.