Backup Assistant
Automatically backup files when you open them and before you modify them.
Spreadsheet Assistant's Data Assistants Menu
Time-saving data management features for Microsoft Excel.
The following are just a few of the time-saving data features added by the Spreadsheet Assistant that make Microsoft Excel easier to use:
- Expand the Pivot Table Range with a single click
- Add new data to a pivot table source without manual reselection
- Add any feature to Excel's quick access toolbar for instant use
- A full suite of data-handling tools on one menu
The following is the Data Assistants menu that appears when you click on the Data Assistants button. Any of the features can be added to Excel’s quick access toolbar for instant use any time.
One of the most useful features on the Data Assistants menu is often overlooked: the Expand the Pivot Table Range feature. When you add data to the bottom of a pivot table’s source worksheet, the data is not automatically added to the pivot table. Instead, you must go to the pivot table, figure out how to change the data, and select the entire range manually. Painful.
With the Expand the Pivot Table Range feature, you click in the pivot table and click this feature. Instantly, you are presented with a dialog showing the top left and suggesting the new bottom right corner for your data.
Return to the Spreadsheet Assistant overview to explore all the other assistant menus.
Customers who viewed this also viewed
Cell Color Assistant
Create your own toolbar of buttons to quickly format cells and rows.
Column Navigator
Quickly find and go to any column via a descriptive list.
File Assistant
See a list of the past 100 files you have opened and easily re-open any.
Sheet Navigator
Move from sheet to sheet with ease via a list of all your sheets.
Row Extractor
Extract rows of data into columns for easy review and printing.