Other Assistants Menu

The Other Assistants menu of the Spreadsheet Assistant for Microsoft Excel.

  • Add any feature to Excel's quick access toolbar for instant use any time
  • All the Assistants List with a built-in Find an Assistant feature
  • Toggle Auto Complete off and on with one easy-to-find menu item
  • Toggle calculation off and on
  • Toggle move after entry off and on
  • Create local (single-worksheet) range names, not just global ones
The Other Assistants menu in the Spreadsheet Assistant
The Other Assistants menu

The following is the Other Assistants menu that appears when you click on the Other Assistants button. Any of the features can be added to Excel’s quick access toolbar for instant use any time.

If you are having trouble finding a particular feature in the Spreadsheet Assistant, then use the All the Assistants List. The very first item on it is a Find an Assistant feature!

Sometimes we love having Auto Complete on. Sometimes we love having it off. And it’s painful to try and remember where it is among all of Excel’s options. So we added an easy-to-find menu item to toggle it off and on. And we decided toggling features off and on was so useful, we added menu items that toggle calculation and move after entry off and on.

In Excel there are two types of range names: local and global. Creating global names is pretty easy. Creating local names tied to a single worksheet is pretty painful. So, we added a way to create local range names.

Customers who viewed this also viewed