WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to delete a pivot table in WPS Spreadsheet

July 31, 2023
9.7K Views

As data analysis becomes increasingly important in our professional and personal lives, pivot tables have emerged as a valuable asset. These dynamic tools enable us to extract valuable insights from complex datasets effortlessly.

However, once their purpose is fulfilled, the question arises: How do we delete them?

In this article, a step-by-step process of deleting pivot tables in popular spreadsheet applications like Microsoft Excel, WPS Spreadsheet, and Google Sheets will be looked into. By understanding this essential skill, you'll gain greater control over your data and streamline your analysis workflows.

How to Delete a Pivot Table in Microsoft Excel

Microsoft Excel provides users the features of creating and analyzing pivot tables. With a few clicks, users can easily select their data, arrange fields, and generate a dynamic summary of their information. Deleting pivot tables is also simple, with just a few clicks, we can discard the pivot table from the worksheet.

Microsoft Excel Windows

Here is the procedure of deleting the pivot table in a few easy steps:

Step 1: Open the Worksheet that contains the pivot table

Microsoft Excel worksheet

Step 2: To delete the Pivot Table, users can simply select the entire pivot table using their cursor and press delete on their keyboard.

Microsoft Excel pivot table select

Step 3: Users can also follow the alternate method. Click on any cell of the entire pivot table.

Microsoft Excel pivot table cell

Step 4: Click on “Analyze” at the top on the toolbar followed by “Select”.

Step 5: Click on “Entire PivotTable”, this will select the entire Pivot Table. Simply press Delete on your keyboard to discard the Pivot Table.

Microsoft Excel toolbar

Microsoft Excel Web

In a few easy steps, Pivot Tables can be deleted in Microsoft Excel Web. Here is how:

Step 1: Open excel file on your Microsoft Excel Web

Microsoft Excel Web Book

Step 2: Select the entire pivot table using your cursor and simply press delete.

Microsoft Excel Web Book deleting Pivot Table

How to delete a pivot table in WPS Spreadsheet

WPS Spreadsheet is a versatile and user-friendly that allows users to easily create, edit, and format spreadsheets to meet their specific needs. Furthermore, it also helps users create, edit, delete and analyze Pivot Tables.

To delete a Pivot Table in WPS Spreadsheet, you can follow these simple steps:

Step 1: Open the Spreadsheet containing pivot tables on WPS Spreadsheet

Step 2: Locate the Spreadsheet and right click on any cell within the post

WPS Office Select Pivot Table

Step 3: Select “PivotTable” that appears on the menu followed by “Delete PivotTable

WPS Office delete Pivot Table

Step 4: Click “Yes” to confirm.

How to delete a Pivot Table in Google Sheets

Google Sheets offers several benefits for data management and collaboration, and it also users to create Pivot Tables which is a very powerful tool for data analysis and visualization.

Deleting Pivot Tables can sometimes be confusing for some users, however, there are 2 easy methods of successfully deleting Pivot Tables from your Google Sheet.

Method 1

Step 1: Open Google sheets and open the file which needs to be edited

Step 2: Click on the uppermost cell of the Pivot Table

Google Sheets Pivot Table Cell

Step 3: Press Delete on your keyboard to delete the Pivot Table

Method 2

Step 1: Open Google Sheet, open the file that needs to be edited

Step 2: If the Pivot Table Is present in a separate sheet, simply delete the sheet by right clicking on the sheet down below and select Delete

Google Sheet Delete

FAQ

How do I delete a Pivot Table and keep data?

To delete a Pivot Table while keeping the underlying data intact, follow these steps:

  • In Microsoft Excel: select the entire Pivot Table by clicking on any cell within the table.

Press the Delete key on your keyboard to remove the Pivot Table while retaining the data.

Alternatively, you can right-click on the Pivot Table and choose "Delete" from the context menu.

  • In the WPS Spreadsheet: right-click on any cell within the Pivot Table and select "PivotTable" from the menu, followed by "Delete PivotTable."

  • In Google Sheets: select the uppermost cell of the Pivot Table and press the Delete key on your keyboard.

Where is the Pivot Table tool in Excel?

The Pivot Table tool can be accessed by clicking on the “Insert” at the top of the toolbar followed by “Pivot Table” at the top left of the toolbar

Microsoft Excel Pivot Table

How do I convert a Pivot Table into a Normal Table?

  • Select the Pivot Table.

  • Select the table with a right-click.

  • Select Copy from the menu.

  • Go to the worksheet where you need the table, then use the right-click menu to paste it into a cell.

  • Select the option for Paste.

Final Words

Unlocking the power of pivot tables is crucial for efficient data analysis in applications like Microsoft Excel, WPS Spreadsheet, and Google Sheets. Now that you've learned how to delete pivot tables effortlessly, you can take control of your data and streamline your workflows.

Use WPS Spreadsheet to efficiently create Pivot tables with its easy to use interface and analyze data effectively. So, bid farewell to unnecessary tables and embrace a more focused and organized analysis process. Happy analyzing!


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.