Excel Productivity Tools
Utilities that save time on repetitive Excel work: bulk renames, batch formatting, sheet management.
Add Prefix and Suffix to Cells
Bulk-add text to the start and/or end of every cell in your selection, with formulas left untouched
AutoFit All Columns on All Sheets
Run AutoFit on every column of every visible sheet so the workbook is consistently readable in one click
Bulk Add Hyperlinks
Convert every URL-like cell in your selection into a clickable hyperlink in one pass
Bulk Find and Replace From Table
Read a 2-column table of find/replace pairs and apply every pair to your data range in one pass
Combine All Sheets Into One
Stack the data from every worksheet in a workbook into a single Combined sheet, with one header row at the top
Convert Formulas to Values
Replace every formula in your selection with its current evaluated value, in place, preserving the display format
Count Words and Characters Per Cell
Add word and character counts to the two columns next to your text column in one pass
Delete All Hidden Sheets
Remove every hidden and very-hidden sheet from the workbook with one confirmation prompt
Export Each Sheet to CSV
Save every visible worksheet as its own CSV file in the workbook's folder, in one click
Extract Email Addresses From Text
Pull every email address out of messy free-form text into a clean adjacent column
Extract Numbers From Text
Pull every number out of a column of text cells and write them comma-separated to the next column.
Find and Replace Across All Sheets
Replace text in every worksheet of your workbook in one go, with case and whole-cell options
Freeze Top Row on All Sheets
Apply Freeze Panes at row 2 to every visible sheet in the workbook so headers stay visible during scrolling
Highlight All Formula Cells
Color every cell containing a formula light yellow so you can see at a glance which cells are calculated versus hardcoded
Highlight Rows Containing Keyword
Color every row in your selected range where any cell contains a keyword you type in.
Insert Blank Row On Change
Insert a blank row above every cell where a chosen column's value changes from the row above.
Insert Row Numbers
Fill the selected column with sequential integers starting at any number, no formulas, no fill-handle dragging
Letter Grade From Numeric Scores
Convert a column of numeric scores into letter grades using a configurable A/B/C/D scale
List All Sheet Names
Generate an index sheet at position 1 with a hyperlinked list of every other sheet in the workbook
List Cells With Formula Errors
Find every #REF!, #VALUE!, #N/A, and other formula error in your selection and list them on a new sheet
Protect All Sheets With Password
Apply the same sheet-level protection password to every sheet in the workbook in one shot
Reverse Row Order
Flip the order of rows in your selection top-to-bottom in place, keeping all columns aligned
Sort Sheets Alphabetically
Reorder every tab in the active workbook A to Z or Z to A in one click
Split Full Names Into First and Last
Take a single column of full names and split it into First Name and Last Name columns to the right
Split Sheet by Column Value
Break one big sheet into many sheets, one per unique value in the column you choose
Swap Two Columns
Swap the data in two columns in one click, supporting both adjacent and Ctrl-clicked non-contiguous columns
Unhide All Sheets
Make every hidden and very-hidden sheet in the workbook visible at once
Unprotect All Sheets
Remove sheet protection from every tab of the workbook with a single password prompt