How do you make private table in excel?

Answer 1

A pivot table in Excel is a summary table of the original spreadsheet. To create a pivot table, first open the original spreadsheet then remove any blank columns and rows. The columns also should have headings so as they will be carried over to the Field List. Next, format the cells properly for their data type. Highlight the data range of the spreadsheet. Click the Insert tab and select the PivotTable button from the Tables group. Select PivotTable from the list and double check the Table/Range value. Check the radio button for New Worksheet and click ok.