Spreadsheet Assistant's Edit Assistants Menu

Time-Saving editing features for Microsoft Excel.

Download a trial version now!

The following are just a few of the time-saving data features added by the Spreadsheet Assistant that make Microsoft Excel easier to use:

  • Change Case of text in cells
  • Copy Active Cell's Text to Clipboard (text and values only)
  • Fix (text flow) a paragraph. Use Excel as a word processor
  • Clear Hyperlinks from pasted web content
  • Delete all Objects to remove stray images and shapes
  • Add any feature to Excel's Quick Access Toolbar for instant use

The following is the Edit Assistants menu that appears when you click on the Edit Assistants button. Any of the features can be added to Excel’s Quick Access Toolbar for instant use any time.

Edit Assistants menu in Microsoft Excel
The Edit Assistants menu

The Edit Assistants menu is full of useful features. The ones you choose to use will depend heavily on the work you need to do. We have found that the Change Case feature is useful. We also use the Copy Active Cell’s Text to Clipboard a lot — this keeps us from pasting images of cells into our e-mails, and lets us paste text and values only.

The Fix (text flow) A Paragraph feature lets you use Excel as a word processor!

If you have ever copied and pasted web pages into Excel, then you know such pages are full of hyperlinks and images of all sizes and shapes. Cleaning them manually is painful if not impossible. With the Clear Hyperlinks and Delete all Objects features, this becomes just a few seconds of work.

Return to the Spreadsheet Assistant overview to explore all the other assistant menus.

Customers who viewed this also viewed