Pivot Table report Editing pg 242

Editing Your PivotTable Report

You can format the report and the content of the report in the normal way you use formatting in Excel. For instance, you can format numbers, font etc.

You can also change or edit the content (numbers and words) in the report the normal way we do in Excel. The report does not contain any formulas.

You can delete the sheet and the Report to save disk space, if you want. You can always rebuild it again.

If you make any changes in the underlying data, you may want to update the report (if you do not delete the report). Just click any cell in the report, then right-click once. A floating menu will appear. Select Refresh. The report will be updated.


242