From the course: Excel: PivotTables in Depth
Join today to access over 24,600 courses taught by industry experts.
Apply a PivotTable style
From the course: Excel: PivotTables in Depth
Apply a PivotTable style
- [Instructor] When you create a PivotTable, Excel applies some formatting that lets you distinguish the labels and organizational layers from the data in the body of the PivotTable. Excel comes with a substantial number of built-in styles from which to choose. So if you want to change your PivotTable's formatting, you can do so quickly. In this movie, I will show you how to work with formatting in a PivotTable and apply styles. My sample file is 04_01_ApplyStyle, and you can find it in the chapter four folder of the exercise files collection. This workbook contains a PivotTable and it has some basic formatting applied to it. I have a background color for my headers and also for the grand total and the values in the grand total and also the labels. For the row labels control column labels control, and retail and wholesale sales types are all bold as well. So that's the overall formatting. But before I show you how to work with styles, I want to show you what happens when you apply…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.