How do you view a pivot table in Excel?

Posted on by Muna Meyer

How do you view a pivot table in Excel?

Click the PivotTable. This displays the PivotTable Tools tab on the ribbon. To display the PivotTable Field List, if necessary, on the Analyze or Options tab, in the Show group, click Field List.

How do I unhide a pivot table in Excel 2010?

Right-click any cell in the pivot table and select Show Field List from the menu. This will make the field list visible again and restore it’s normal behavior. The field list will disappear when a cell outside the pivot table is selected, and it will reappear again when a cell inside the pivot table is selected.

How do I change the view of a pivot table?

Follow these steps:

  1. Click anywhere inside the pivot table to activate the PivotTable Tools context tab on the Ribbon.
  2. Select the Design tab on the Ribbon.
  3. Click the Report Layout icon and choose the layout you like from the menu that appears. Changing the layout of the pivot table.

How do I see all details in a pivot table?

Expand or collapse levels in a PivotChart

  1. To see the details for the current item, click Expand.
  2. To hide the details for the current item, click Collapse.
  3. To hide the details for all items in a field, click Collapse Entire Field.
  4. To see the details for all items in a field, click Expand Entire Field.

How do I change the default layout of a pivot table?

To get started, go to File > Options > Data > Click the Edit Default Layout button. Layout Import – Select a cell in an existing PivotTable and click the Import button. That PivotTable’s settings will be automatically imported and used in the future.

How do I manually sort a pivot table?

Sorting Data Manually

  1. Click the arrow. in Row Labels.
  2. Select Region in the Select Field box from the dropdown list.
  3. Click More Sort Options. The Sort (Region) dialog box appears.
  4. Select Manual (you can drag items to rearrange them).
  5. Click OK.

Where is the pivot table tools option?

If you’ve selected an Excel table, you’ll see the Table Tools with a Design tab. If you’ve selected a PivotTable, you’ll see the PivotTable Tools with an Analyze and a Design tab. The Table Tools aren’t available on the ribbon in Excel for the web, so you won’t be able to use them to make design changes to your table.

How do I expand an entire PivotTable?

Expand or Collapse the Pivot Field

  1. Right-click the pivot item, then click Expand/Collapse. In this example, I right-clicked on Boston, which is an item in the City field.
  2. Select on of the Expand/Collapse options: To see the details for all items in the selected pivot field, click Expand Entire Field.

How do I drill down details in a PivotTable?

Drill into PivotTable data

  1. In your OLAP cube or Data Model PivotTable, pick an item (like Accessories in our example) in the field (like the Category field in our example).
  2. Click the Quick Explore button.
  3. In the Explore box, pick the item you want to explore, and click Drill Down.

How do I unhide a pivot table?

On the Options or Analyze tab (depending on the Excel version you are using) on the ribbon, in the PivotTable group, click Options. In the PivotTable Options dialog box, click the Data tab. Under PivotTable Data, clear or select the Enable show details check box to disable or enable this option.