How to remove pivot table

Click the PivotTable Tools Analyze or Options tab in the Ribbon. In the Actions group, click Clear. A drop-down menu appears. Click Clear All.

Edit a pivot table. Click anywhere in a pivot table to open the editor. Add data—Depending on where you want to add data, under Rows, Columns, or Values, click Add. Change row or column names—Double-click a Row or Column name and enter a new name.

Step 1: Select the pivot table range. Step 1.1: We can select the pivot table like this also. Place a cursor inside the pivot table > Go to Options> Select > Entire Pivot Table. Step 2: Once you have selected the pivot table range, you click on the delete option to delete or remove the excel pivot table.

Those old items can appear if you change the pivot table source data – for example, you might remove a few obsolete products, or change a sales rep’s name. When you refresh the pivot table, the new data can appear, but the old names still show up in the drop down lists, that you use for filtering.

Locate the Source Data

Follow these steps, to find the source data for a pivot table: Select any cell in the pivot table. On the Ribbon, under the PivotTable Tools tab, click the Analyze tab (in Excel 2010, click the Options tab). In the Data group, click the top section of the Change Data Source command.

Click the tab that contains your data (e.g., Sheet 2) at the bottom of the Excel window. Add or change your data. Enter the data that you want to add to your pivot table directly next to or below the current data.

In it are four areas (Filters, Columns, Rows, and Values) where various field names can be placed to create a PivotTable.

Mastering pivot tables takes time – Sure, creating a pivot table requires a few clicks inside Excel but truly mastering the tool takes time. First-time users of pivot tables might see it as confusing and overwhelming.

COLUMNS. You can drag fields to the COLUMNS area. The fields that are put in COLUMNS area appear as columns in the PivotTable, with the Column Labels being the values of the selected fields. Drag the field Region to COLUMNS area.

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.

To see the PivotTable Field List: Click any cell in the pivot table layout. The PivotTable Field List pane should appear at the right of the Excel window, when a pivot cell is selected. If the PivotTable Field List pane does not appear click the Analyze tab on the Excel Ribbon, and then click the Field List command.

The pivot table error, “field name is not valid”, usually appears because one or more of the heading cells in the source data is blank. To create a pivot table, you need a heading for each column. Check for hidden columns in the source data range, and add headings if they’re missing.

Right click at any cell of the pivot table, and select Hide Field List option from the context menu. If you want to show the Field List again, right click at the pivot table, and select Show Field List.

Manually refresh

To update the information to match the data source, click the Refresh button, or press ALT+F5. You can also right-click the PivotTable, and then click Refresh. To refresh all PivotTables in the workbook, click the Refresh button arrow, and then click Refresh All.

Grouping Rows or Columns

Groups and outlines allow you to quickly hide and unhide rows or columns in an Excel spreadsheet. The Groups feature creates row and column groupings in the Headings section of the worksheet. Each group can be expanded or collapsed with the click of a button.

Click the Data tab. Click Group. Select Columns and click OK. Click – to collapse.

To open the PivotTable Options window: Right-click on any cell in the pivot table. In the right-click menu, click PivotTable Options.