All Features

Auto Fit→ Adjusts the row heights and column widths on the active sheet so your data fits, like selecting the whole sheet and double clicking the row and column borders.

Quick Table Format→ Turns the selected area into a clean, easy to read table with a header row, row banding and tidy borders. Trim & Clean→ Removes leading and trailing spaces, doubled inner spaces, non-breaking spaces (CHAR 160) and non-printing characters from the selected text cells. Fix Broken Characters→ Repairs garbled characters, sometimes called mojibake, in the selected text. Clean Headers→ Cleans the column headers in the FIRST row of the selected table and leaves the data rows unchanged. Delete Empty Rows→ Removes the fully empty rows inside the selected table area and moves the rest up, but only within that area. Delete Empty Columns→ Removes the fully empty columns inside the selected table area and moves the rest left, but only within that area. Unmerge and Fill→ Unmerges every merged area in the selection and copies each merged value down into the freed cells, so the data becomes filterable and sortable. Fill Blanks→ Fills each blank cell in your selection with the value from the cell above it.

Extract by Pattern→ Finds and pulls out parts of your text using a ready made pattern, and writes what it finds to a new column on the right. Extract Email→ Extracts email addresses from the selected cells into a new column immediately to the right. Extract Phone→ Finds phone numbers in your text and writes them to a new column on the right. Extract URL→ Extracts web addresses (http, https, www and common domains) into a new column to the right. Extract Number→ Finds the first number in each cell and writes it to a new column on the right, kept as text. Take Left→ Takes the first N characters of each cell into a new column to the right. Take Right→ Takes the last N characters of each cell into a new column to the right. Before / After→ Takes the text before or after a marker (first or last occurrence) into a new column to the right. Extract Between→ Extracts the text found between a start marker and an end marker into a new column to the right.

UPPERCASE→ Converts the selected text to UPPER CASE. lowercase→ Converts the selected text to lower case. Proper Case→ Capitalizes the first letter of each word in the selected text. Sentence case→ Converts the selected text to sentence case, capitalizing only sentence starts. Add Prefix / Suffix→ Adds a prefix and/or a suffix to each cell and writes the result into a new column to the right. Remove Duplicates in Cell→ Removes repeated items inside each cell (split by a delimiter) and writes the unique list into a new column to the right. Text to Numbers→ Converts numbers that are stored as text, including ones with a leading apostrophe, into real numbers so they can be used in calculations. Fix Apostrophe Numbers→ Removes the leading apostrophe that keeps numbers stored as text and turns them back into real numbers that calculate. Leading Zeros→ Adds leading zeros to a fixed width (e.g. 42 → 00042) or removes them, for tidy codes and IDs. Formulas to Values→ Replaces the formulas in your selection with the results they currently show, so the cells hold plain values instead of formulas.

Date Picker→ Adds a small calendar button to the cell you selected. Fix Dates→ Turns text dates, number based dates and mixed styles into real Excel dates and applies the display format you choose. Check Dates→ Looks at the dates in your selection and reports how many are real dates, how many are stored as plain numbers, how many are text, and how many look invalid or unclear. Create Date Hierarchy→ Add year, month, quarter, day and more columns next to the selected date column. Create Date Range→ Creates a list of dates between a start date and an end date on a new sheet.

Mask Data→ Creates a masked copy of the columns you choose on a new sheet, so you can share the file without showing sensitive values. Number to Words→ Writes the real numbers in the selected cells as words. Alternate Row Coloring→ Applies soft, modern banded shading to alternate rows in the selection to make long tables easier to read.

Image Validation→ Creates a visual selection list. Create Barcode→ Creates a Code 128 barcode picture for each value in your selection and places the pictures on the sheet. Create QR Code→ Creates a QR code picture for each value in your selection and places the pictures on the sheet. Color Picker→ Picks a color from a point on the screen and lets you copy its HEX code. Export to PDF→ Saves the range you selected as a PDF file on your computer. Insert Checkboxes→ Inserts checkboxes into the selected cells. Add Bullets→ Adds bullet markers to text in the selected cells.

Append Worksheets→ Stacks the data from several worksheets into one combined table, one after another. Append Selected Tables→ Stacks several tables or ranges that you pick, even from different sheets, into one combined table. Lookup from Table→ Brings values from a second table into your main table by matching a key column. Multi Lookup→ Returns every matching row for a value from another table, not just the first.

Group By→ Builds a summary on a new sheet that groups your table by a column you choose and adds totals such as count, sum, average, smallest and largest. Unpivot Columns→ Reshapes a wide table into a long one on a new sheet, turning columns into rows so the data is easier to filter and summarize. Split Data→ Splits the selected table by the values in a column you choose.

Highlight Duplicates→ Highlights duplicate values in the selected cells. Highlight Unique Values→ Highlights values that appear only once in the selected cells. Add Duplicate Count→ Counts how many times each value appears in the selected column and writes the result into a new column on the right. Extract Unique List→ Writes the list of unique values from your selection to a cell you pick, in the order they first appear. Compare Two Lists→ Compares two lists, which can be on different sheets, and shows what is only in the first list, only in the second, and in both. Compare Rows→ Compares two adjacent columns row by row and writes Match/Different results into a new column.

Data Profile→ Builds a report on a new sheet that describes your data, such as how many rows there are, how many blanks and unique values each column has, and the smallest and largest values.

Highlight Formula Cells→ Color every cell that contains a formula. Highlight Error Cells→ Color cells with an Excel error (#DIV/0!, #N/A, #REF!, #VALUE! and more). Highlight External Link Formulas→ Color formulas that reference another workbook. Formula Map Summary→ Write per-column formula/constant/blank/error/link counts to a range you pick. Highlight Constants→ Color non-formula, non-empty constant cells (codes like 0012 are kept). Highlight Blank Cells→ Color truly empty cells. Highlight Inconsistent Formulas→ For each column, colors the formulas that do not match the pattern used by most cells in that column, so an odd formula is easy to spot. Highlight Data Validation Cells→ Color cells that carry a data-validation rule. Highlight Conditional Formatting Cells→ Color cells that have conditional formatting. Highlight Locked Cells→ Color cells whose Locked attribute is on. Highlight Unlocked Cells→ Color cells whose Locked attribute is off. Highlight Rows with Errors→ Color entire rows (within the selection) that contain any error cell. Select Formula Cells→ Selects the cells in your range that contain formulas, so you can review or format them together. Select Constants→ Selects the cells in your range that hold typed values rather than formulas. Select Error Cells→ Selects the cells in your range that show an error, so you can find and fix them. Select Blank Cells→ Selects the empty cells in your range, which is handy before filling them in. Select Visible Cells→ Selects only the visible cells in your range and skips rows or columns that are filtered out or hidden, so a copy takes just what you see. Extract Formula Text→ Write each formula's address and text to a range you pick. List External Link Formulas→ List formulas that reference another workbook to a range you pick. List Named Ranges→ List the workbook's defined names (name, scope, refers-to, visibility). List Hyperlinks→ List the hyperlinks in the selection (address, display text, link). List Comments and Notes→ List cells with comments or notes (address, type, author, text). List Worksheets→ List the workbook's sheets (name, visibility, used size, filters, freeze). Sheet Protection Summary→ List each sheet's protection state (no password is ever asked).

KPI Cards→ Builds 12 KPI card layouts for values, targets, changes, trends, sparklines and progress indicators. Charts→ Inserts professional chart and visualization options bound to your data. Create Dashboard→ Builds one of four ready dashboard layouts (Executive, Sales, HR, Finance) from the selected data. Create Report→ Builds a tidy, printable report from the selected data.

Count by Color→ Counts cells in the selected range that match the fill color of a reference cell. Sum by Color→ Sums numeric cells in the selected range that match the fill color of a reference cell.