Data Cleaner
Clean and standardize spreadsheet data.
Pivot Table Assistant
An add-in for Microsoft Excel that makes working with pivot tables far easier.
- Easily expand a pivot table's data range when new data is added
- Format fields with one click
- Compress columns for better reading
- Hide un-needed single total rows
- Refresh all your pivot tables with one click
The Pivot Table Assistant add-in for Microsoft Excel takes only seconds to install and makes working with pivot tables far easier. It is compatible with Microsoft Excel 2010-2021 and Office 365.
The Pivot Table Assistant is designed to save you time when you work with Microsoft Excel pivot tables. It adds a set of very useful options which can be added to Excel's quick access toolbar as a dropdown menu and made available from any tab.
The resize columns feature will resize the columns in a pivot table so that extremely wide columns are displayed in a compressed format. The normal Excel default is to make the columns as wide as the text, which makes it difficult to see a table that has long text entries.
The expand a pivot table data range feature makes it easy to check and modify the data range of a pivot table. Whenever you add data to a pivot table, you will find out very quickly that expanding the data range is not an easy task.
The Format Fields feature lets you format pivot table data fields with format settings that stay persistent and do not reset when the table is changed.
Pivot Table Tools menu
The Pivot Table Tools menu option gives you additional helpful features:
- Set the print area and titles with just a single click
- Freeze or unfreeze panes
- Bold total rows
- Change sub-total names to remove unneeded words like "sum of"
- Insert underlining at page breaks so your printout looks nice!
Related add-ins
Address Assistant
Split and combine address data in Excel.