Better Format for Pivot Table Headings скачать в хорошем качестве

Better Format for Pivot Table Headings

When you create a pivot table, Excel applies a default pivot table style. If there are two or more fields in the Row Labels area, you might see dividing lines, below the item headings. These lines can make it difficult to see which group the headings are connected to. To make the pivot table easier to read, you can add blank rows, or create a new pivot table style, with lines above the headings Watch this video to see how to see how to add the blank rows, or create a new style. For more pivot table formatting tips, visit this page on my Contextures site: http://www.contextures.com/excel-pivo... Video Timeline 00:00 Introduction 00:30 Add Blank Rows 01:05 Remove Blank Rows 01:26 Duplicate Pivot Table Style 01:53 Modify Pivot Table Style 02:34 Change Heading Border 03:18 Apply Modified Style 03:48 Get More Excel Tips Instructor: Debra Dalgleish, Contextures Inc. Get Debra's weekly Excel tips: http://www.contextures.com/signup01 More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu... #ContexturesExcelTips