From the course: Excel: PivotTables in Depth
Join today to access over 24,600 courses taught by industry experts.
Change the PivotTable layout
From the course: Excel: PivotTables in Depth
Change the PivotTable layout
- [Instructor] Excel pivot tables let you summarize your data in formats that are easy to read and very helpfully easy to modify. You can also change your pivot tables layout, choosing whether to display blank rows below each item and selecting from three report layouts with subtle but important differences that are important for you to know about. I'll describe the layout options available to you in this movie. My sample file is 04_03 layout, and you can find it in the chapter four folder of the exercise files collection. When Excel creates a pivot table, if you haven't made any changes to the default format, it will give you something like this. We have subtotals at the top of each group. In this case, we have employee title and then sales region, and there'll be no blank rows between the individual elements. So you see that we go directly from Southwest for sales associate to the total for sales associate one. If you want to change how your layout appears, you can go to the design…
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.
