XLEV8 Add-in Suite – Word

Popular Macros

Full XLEV8 Word macro listing (as of 6/25/2022)

Copy and Paste

Copy Special Picker – Uses picker prompt to provide special copy options for user to select from (unformatted text, formats, selection range, copy document file to clipboard, etc.).

Copy Formats – Sets the selection range to grab formatting that can be pasted with the Paste Formats macro or via Paste Special Picker (formats option).

Copy Active Workbook To Clipboard – Copies the saved active workbook to the clipboard so that it can be pasted to an email or a folder.

Paste Special Picker – Uses picker prompt to help expedite paste special tasks (text, formats, pictures, links, etc.).

Paste Formats – With a source range set using the Copy Formats macro, uses that range to apply formatting to the area selected when the Paste Formats macro is run.

Data and Content

Find Replace Picker – Uses picker prompt to run a find/replace process using saved custom find/replace parameters.  Helpful if you find and replace the same values frequently.

Insert Picker – Uses picker prompt to provide options for quickly inserting common items (page break, section break, picture, table, shape, etc.).

Insert Shape Picker – Uses picker prompt to insert a shape (circle, rectangle, rounded rectangle, triangle, line, line with arrow) with default shape formating, if set.

Comment Picker – Uses picker prompt to expedite applying a review comment action to the selection (add comment, delete comment, copy comment contents, paste clipboard contents to comment, etc.).

 

Formatting

Format Picker – Uses picker prompt to apply formatting types or call other formatting pickers (alignment, font, borders, highlight/fill color, etc.).

Print Picker – Uses picker prompt to apply common print settings or perform common printing tasks (print current page, set orientation, etc.).

Toggle Number Format – Loops through common number formats (default is General->Accounting no decimals->Currency no decimals->Percentage one decimal->Short date->Text) for the selected range, based on the number format of the first character in the range.  Up to five number formats can be customized using the Assign Word Macro Defaults macro or the Number Format Picker macro.

Toggle Highlight Color – Loops through common highlight colors (default is no fill->yellow->orange->red->purple->green) for selected text, based on the fill color of the first character in the selection.  Up to five colors can be customized using the Assign Word Macro Defaults macro or the Highlight Color Picker macro.

Toggle Font Color – Loops through common font colors (default is no color->yellow->orange->red->purple->green) for all selected text, based on the font color of the first character.  Up to five colors can be customized using the Assign Word Macro Defaults macro or the Font Color Picker macro.

Alignment Picker – Uses picker prompt to apply horizontal alignment (left, center, right, etc.) to the selected range.

Productivity

Open File Folder – Opens a file explorer window to the folder that the active document is saved in.

Email File Link – Creates link to active document to copy to an email or clipboard. If email is selected, creates an email containing the link, and also prompts user whether or not to attach the file.

Email Text – Copies the text in the active document to a new email.

Search Macros – Shows a form where user can search for a macro by name (within the add-in) to run. Also shows the description, category/group, subgroup/menu, and any keyboard shortcut assigned to the macro.

Search Commands – Shows a form where user can search for a specific Excel command by name to run. Also shows the Command Picker shortcut, which can be set in the form.

Misc Picker – Uses picker prompt where user can select from miscellaneous actions (open new window, toggle clipboard pane, toggle selection pane, toggle ruler, etc.).

Custom Macros

You can add up to 20 of your own custom macros to the Word add-in!  If you already have a few macros you use in your personal macro file, you can put them in a custom add-in file and use them within the Word add-in.  This is helpful for a few reasons:

  • Reference your own macros in the XLEV8 ribbon tab, with keyboard shortcuts, or from the Search Macros box
  • Set keyboard shortcuts more more easily and in bulk compared to setting them one at a time for your Normal.dot macro file
  • Share your custom add-in file with co-workers so they can leverage your work
  • Cut out issues with multiple versions of your Normal.dot macro file when Word crashes

Screenshots

Videos

Don't miss great tips, tricks, news, and events!

  • Get our 105 Excel Tips e-book free!
  • Get monthly insights and news
  • Valuable time-saving best practices
  • Unlock exclusive resources

Almost there! We just need to confirm the email address is yours. Please check your email for a confirmation message.