Javatpoint Logo
Javatpoint Logo

How to create a Pivot Table in excel

Pivot table is one of the powerful and most widely used Microsoft excel tool that is used to calculate, build, summarize, as well as analyze unlimited excel data quickly. It provides a user-friendly way to present a large amount of excel data, rotates columns to rows or rows to columns, arranges numeric data in an excel spreadsheet, and summarize data by categories.

Steps to create a pivot table in excel document

Follow the below given easiest steps to create a pivot table in excel document -

Note: Using the below steps, you can create a pivot table in Microsoft excel 2007, 2010, 2013, 2016, and 2019.

Step 1: Open a new or an existing Microsoft Excel document where you want to create a pivot table.

Step 2: Prepare an excel sheet to show data on the pivot table, as shown in the screenshot below.

How to create a Pivot Table in excel

Note: Make sure that no blank row is available on your excel document.

Step 3: Select the number of cells that you want to insert on the Pivot Table.

Step 4: Select cell A1 in Sheet 2.

Note: You can also select your desired cell.

Step 5: Go to the Insert tab on the Ribbon and click on the Pivot Table option under the Tables section, as shown in the below screenshot.

How to create a Pivot Table in excel

Step 6: A small Create PivotTable dialog box will appear on the screen in which do the following -

  • Click on the Table/Range textbox and select the cells from the previous data sheet.
  • Select either the New Worksheet or Existing Worksheet checkbox to place a pivot table in your desired location.
  • Click on the OK
How to create a Pivot Table in excel

Note 1: You can also type Table/Range manually in the Select a Table or range text section.

Note 2: In our case, we are already on sheet 2, so we select the Existing Worksheet checkbox option to create a pivot table in an existing document.

Step 7: Now, you can see that a blank pivot table appears on Sheet 2 of your excel document.

How to create a Pivot Table in excel

Step 8: To add Product and Quantity in the pivot Table, tick on the checkboxes associated with these fields under the Choose field to add to the report section.

How to create a Pivot Table in excel

Step 9: Now, you can see your selected fields are added to the pivot table, as shown in the screenshot given below.

How to create a Pivot Table in excel

Note: By default, Row Labels will appear on cell A1.

Step 10: To change the pivot table title, click on the title that you want to change and press the backspace key to remove the previous title. Once the previous title is removed, start typing the new title that you want to add.

The screenshot below shows that a pivot table is created in the Microsoft Excel document.

How to create a Pivot Table in excel




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA