Edit Assistants Menu

Part of the Spreadsheet Assistant — a menu full of editing features for Microsoft Excel.

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.

  • 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
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 very useful. We also use the Copy Active Cell’s Text to Clipboard a lot — this keeps us from pasting images of cells into our emails, 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 copy 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.

Customers who viewed this also viewed