Tabular form displays one column per field and provides space for field headers. Compact form is saves space and makes the PivotTable more readable and is therefore specified as the default layout form for PivotTables. Expand and Collapse buttons are displayed so that you can display or hide details in compact form. Row labels take up less space in compact form, which leaves more room for numeric data. To make substantial layout changes to a PivotTable or its various fields, you can use one of three forms:Ĭompact form displays items from different row area fields in one column and uses indentation to distinguish between the items from different fields. Note that the procedures in this topic mention both Analyze and Options tabs together wherever applicable. Important: The PivotTable Tools tab on the ribbon comes with two tabs - Analyze (in Excel 2013 and later versions) or Options (Excel 2010 and Excel 2010) and Design.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |