Design the layout and format of a PivotTable - Microsoft Support
To outline the data in the classic PivotTable style, click Show in Outline Form. To see all data in a traditional table format and to easily copy cells to another worksheet, click Show in Tabular …
Outline (group) data in a worksheet - Microsoft Support
Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. You can create an outline of rows (as shown in the example below), an outline of …
Subtotal and total fields in a PivotTable - Microsoft Support
For outer row labels in compact or outline form, you can display subtotals above or below their items, or hide the subtotals, by doing the following: On the Design tab, in the Layout group, …
Set PivotTable default layout options - Microsoft Support
Report Layout - Pick from Compact, Outline or Tabular report layout. Blank Rows - The PivotTable will automatically insert a blank row after each item. PivotTable Options - This will …
Download free, pre-built templates - Microsoft Support
You can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business …
Create a template - Microsoft Support
Learn how to edit, save, and create a template in Office. You can create and save a template from a new or existing document or template.
Repeat item labels in a PivotTable - Microsoft Support
Repeated labels are shown only when the PivotTable is in tabular form. They are not shown when compact form or outline form are applied. If you need to, you can change the format in Report …
Change the style of your PivotTable - Microsoft Support
If you want to change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells, and lines are displayed, you can design the layout and format of a PivotTable.
Add, edit, find, and delete rows by using a data form
When a row of data is very wide and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows. A data form provides a convenient means to enter or …
Save a workbook as a template - Microsoft Support
Excel creates a new workbook that is based on your template. If you often use the same layout or data in a workbook, save it as a template so you can use the template to create more …
Try it with templates - Microsoft Support
Try a template to learn more about Word, Excel and PowerPoint. Or choose from thousands of free Office templates for any project.