XLEV8 Add-in Suite – Excel

Copy Special Picker – Uses picker prompt to provide special copy options for user to select from (copy formulas, copy formats, copy sum of selected cells, copy sheet name/range address, copy workbook file to clipboard, etc.).

Copy Select Sum – Sums the amounts in the selected visible cells (if numeric values), then copies the total to the clipboard as a raw text value so it can be pasted in Excel or another program (i.e. email message).  If only one cell is selected, the raw text value of the cell (regardless of text/number) is copied to the clipboard.

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 (values, formulas, formats, etc.), including some custom macro options such as pasting unique values. Includes option to transpose.

Paste Values Number Formats – With cell range copied to the clipboard, pastes values and number formats to visible cells only (helpful when pasting values to filtered cells).

Paste Formulas – With cell range copied to the clipboard, pastes fomulas, starting with the active cell.

Filter Picker – Uses picker prompt to help expedite filter actions (unfilter column/all columns, filter to current cell value, filter to/exclude zeroes and/or blanks, etc.).

Filter This – Filters the selected column based on values of selected cells. Works with one cell selected or multiple cells selected.

Filter Freeze – For the selected range, adds AutoFilter and freeze panes, and prompts user whether or not to auto-fit the columns to fit contents.

Quick Sort – Prompts user for sort column(s) and sort direction(s), and applies to the selected range.  Allows user to set entry as a default to quickly apply again later.

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 Row/Column/Cell – Based on what user has selected, inserts cell (shifts down), row (shifts down), or column (shifts right).  If a range has been copied to the clipboard, prompts user whether to insert the contents or not.

Modify Fields – Add or modify column headings, formulas, and formats quickly for data source reports that you run repetitively.

Swap Values – With two cells selected in one sheet, swaps the formulas/values.

Unpivot Table – Takes a data set with multiple columns and restructures/transposes it to be in a database-friendly format.  Flexible options allow to specify multiple leading columns and multiple header rows.

Comment Picker – Uses picker prompt to expedite applying a cell comment action to the active cell (add comment, delete comment, copy comment contents, paste clipboard contents to comment, toggle comment visibility, re-size comment, re-position comment, etc.).

Insert Shape Picker – Uses picker prompt to insert a shape (circle, rectangle, rounded rectangle, triangle, line, line with arrow) with user-defined default shape formatting.

Reverse SIgn – For all selected cells, reverses the sign for the cell values.  If the cell contains a formula, the formula is wrapped in -().

Select Cells Matching Values – Using the selected range, prompts user for a text value to use to selects cells that contain a matching value within the formula.  Those cells can then be updated, formatted, cleared, etc.

Formula Picker – Uses picker prompt to show different formula action types (recalculate, run formula-related macros, show formula dialog box, etc.).

Show Cell References – Shows a form where user can search references contained in the active cell formula.

Add Named Ranges From List – Creates named ranges based on a list of range names and the sheet and cell range they should be applied to.

Break All Links – Breaks all links in the active workbook.

Refresh Workbook Links – Refreshes all external links in the active workbook.

Link List – Adds a sheet that lists out all external links in the active workbook.

Cell Action Picker – Uses picker prompt to help launch other cell-related picker prompt macros (primarily formatting).

Toggle Cell Highlight – Loops through common cell fill colors (default is no fill->yellow->orange->red->purple->green) for all selected cells, based on the fill color of the top-left cell.  Up to five colors can be customized using the Assign Macro Defaults macro or the Highlight Color Picker macro.

Toggle Sheet Color – Loops through common sheet tab colors (default is no color->yellow->orange->red->purple->green) for all selected sheets, based on the sheet tab color of the active sheet.  Up to five colors can be customized using the Assign Macro Defaults macro.

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

Toggle Border – Loops through common border formats (default is Bottom regular->Top regular and buttom double->Outside thick->All regular->Bottom dashed->None) for all selected cells, based on the border format of the top-left cell.  Up to five border formats can be customized using the Assign Macro Defaults macro or the Border Picker macro.

Note Merge – Applies merge cells, wrap text, and align top/left to the selected range of cells.  Useful to make several cells that have notes/instructions consistently-sized.

Add Banding – Adds conditional formatting to the selected range that displays alternating cell fill color based on row number (odd/even) for VISIBLE rows.  This is very helpful for making rows easier to read.

Red Green CF Variance – Adds green/red font conditional formatting to selected cells based on value > 0 or < 0. Optional condition to ignore user-specified "NA" value (quotes required).  This is useful for distinguishing variance values from other values in the sheet.

Sheet Action Picker – Uses picker prompt to expedite performing a sheet action (add, delete, rename, copy, etc.), including some custom macro sheet actions.

Table of Contents – Loops through all existing sheets and creates a table of contents sheet with hyperlinks to each sheet in the workbook.  The list includes hidden worksheets, and the rows for hidden worksheets are hidden within the table of contents.

First Sheet – Jumps to the first unhidden sheet in the workbook.  Useful when used with the Table of Contents macro and Follow Hyperlink macro so you can quickly jump to the table of contents, and follow one of the hyperlinks to any other sheet in the file.

Tab Toggle – Toggles to the most recently viewed sheet in the active workbook.

Multi Sheet Format – Uses a settings sheet to apply several functions/formats to the selected sheets that cannot be set to multiple sheets with default Excel functionality.

Unhide All Sheets – Unhides all hidden sheets in the workbook (Excel only allows unhiding one sheet at a time by default).

Save Sheets To PDF – Uses a settings sheet to save specified sheet(s) to one or more PDF files.

Cell Values Select Sheets – Selects sheets in the active workbook that match the values in the selected cells.  Very useful with the Table of Contents macro when you have a list of sheet names and want to select the sheets with those names to print, copy, move, delete, etc.

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

Create Subfolders – Uses a settings sheet to create folders within the supplied path.

Search Macros – Search for macros in the add-in by name to quickly run. Also shows the description, category/group, subgroup/menu, any keyboard shortcut assigned to the macro, and other details.

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

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

Follow Hyperlink – Follows hyperlink referenced in active cell (if any).

Cell Jump Picker – Uses picker prompt to show options to quickly navigate to cells (top/bottom/left/right/custom) or specify the cell name/address to jump to.

Select To Bottom – Selects all cells from the active cell down to the bottom cell in the column that is not blank, including blank cells in between.

Select To Right – Selects all cells from the active cell right to the right-most cell in the row that is not blank, including blank cells in between.

Misc Picker – Uses picker prompt where user can select from miscellaneous actions (freeze panes, unhide columns/rows, group columns/rows, toggle formula calculation, toggle new window, etc.).

Folder Picker – Uses picker prompt to open Windows File Explorer to common or custom folder paths.

Macro Usage – Creates a new workbook with a list of macros that have been run within the Excel, Word, and PowerPoint add-ins, including a timestamp and run method, as well as a PivotTable summarizing by month.

Assign Macro Shortcuts – Uses a settings sheet to quickly assign keyboard shortcuts to macros available in the XLEV8 add-in.  Similar macros are used to set shortcuts for the Word and PowerPoint add-ins.

Refresh PowerPoint Slide – Uses a settings sheet to efficiently refresh PowerPoint slides based on the source file/range and size/position of the slide items.

Bulk Import Contacts – Uses a settings sheet to quickly import bulk contacts into Outlook.

Bulk Import Appointments – Uses a settings sheet to quickly import bulk appointments into Outlook.

Create Send Meeting Requests – Uses a settings sheet to quickly create/display and optionally send meeting requests that you can quickly send in Outlook.

Create Send Email Messages – Uses a settings sheet to quickly create/display and optionally send email messages that you can quickly send in Outlook.

Export Outlook Contacts – Exports contacts from selected Outlook account to a new sheet in the active workbook.

Export Outlook Appointments – Exports appointments from selected Outlook account to a new sheet in the active workbook.

You can add up to 20 of your own custom macros to the Excel add-in!  If you already have a few macros you use in your personal macro workbook, you can put them in a custom add-in file and use them within the Excel 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 Personal.xlsb 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 Personal.xlsb macro file when Excel crashes