Here we take New Worksheet as an example.Īfter selecting the New Worksheet, an empty pivot table will appear in the position you have chosen. There are two options offered, namely the New Worksheet and the Existing Worksheet, for you to choose where you want to place the pivot table in the Creat PivotTable dialogue box. Step 3: Choose the place where you want to put the pivot table.īecause we have already selected a data range in step 1,so the next step we need to is just choose where we want the pivot table to be placed. Step 2: Click the PivotTable icon in the Insert tab.Ĭlick the PivotTable icon in the Insert tab and the Creat PivotTable dialogue box will open. Select the data range from which you want to make the pivot table. To use the PivotTable function, follow the steps below: So, PivotTable is a very powerful and useful features of WPS Spresdsheets. In pivot tables, by rotating rows and columns, users can view details from different perspectives.
PivotTables are dynamic tabulations which allow you to quickly combine and compare data to produce tailored information to suit your needs. Insert a PivotTable in a worksheet with Spresdsheets
