Create a pivot table based on the data in the current file

To create a pivot table using the data from the current file, follow these steps:

1.Select one of the following elements required to create a pivot table:

•A range of data in the source table which will be used as the basis of the future pivot table. The range of data should be selected with the column headings.

•A single cell within the data range, or an empty cell adjacent to the range if you want to use the entire range.

•The cell on the current sheet into which you want to insert the pivot table. This cell will become the upper left cell of the table. The selected cell should not contain any data.

2.Open the Create Pivot Table dialog box in one of the following ways:

•On the Insert tab, click  Pivot table. In the menu that opens, select Use this file data.

•When working in macOS, select the Insert > Pivot table > Use this file data command from the command menu.

3.If you selected a cell to insert a pivot table in the first step, in the Data source box of the Create pivot table window, specify the range of data from the source table from which you want to create the pivot table.

4.If you selected a data range, a single cell within a range, or an adjacent blank cell in the first step, specify where to insert the table:

•New sheet: Insert the table in a new sheet. The new sheet will be created automatically. By default, the new sheet will be named Pivot table <No.>, where No. is the number of the pivot table in the document you are working on. If needed, you can edit the sheet name.

•Existing sheet: Insert the table on the sheet that is currently displayed on the screen. In the Specify a destination cell box, enter the cell address manually or click to select an empty cell in the workspace where you want the upper-left cell of the pivot table to be located. There should be at least two empty rows above the initial cells for filters.

5.Click OK.