This textbook is available Logo
New Perspectives Microsoft Office 365 & Excel 2019 Comprehensive 1st Edition

New Perspectives Microsoft Office 365 & Excel 2019 Comprehensive (1st Edition)

Book Edition1st Edition
Author(s)Carey, Parsons
SubjectComputer Science
Section 11.1: Session 11.1 Visual Overview: Layouts, Sorting, Filtering, and Grouping
Section 11.2: Session 11.2 Visual Overview: Conditional Formats and Calculations
Section 11.3: Session 11.3 Visual Overview: PivotTable Measures
Chapter 11, Section 11.1, Quick Check , Exercise 1
Page EX 11-23

How does the Compact layout differ from the Tabular layout?


  • The compact and tabular layouts are the widest layout types that can be used in the excel pivot tables.
  • The compact is the new one, and the tabular layout is the old type layout for the pivot tables.
  • The compact has more features than the tabular layout has, but sometimes the tabular layout is preferred by the experts.
  • There is another name also called for the layout tabular is the Outlined layout. This layout shows the subtotal at the bottom of the layout, not at the top.

Verified Answer

Compact layoutTabular layout
It is a newer layout in excel, and it enables all tables default pivot tables.It is the original layout used by the pivot tables until excel 2003.
It is used to save horizontal space. The columns are looked like a single column.The tabular layout is similar to the outlined layout, and the row labels have appeared in their column.
The field headings are useless in a compact layout; the user can hide these headings.In this tabular layout, the top option no uses, but this layout is useful when the user copies the pivot table to other worksheets.
How would you rate this answer and explanation?
Did you like this example?
Subscribe for full access
Page EX 11-23