 View Group:
|
| Track Snap (Backup Current Workbook): Backup current workbook at any time |
| Navigation Pane: List all sheets, workbooks, columns and names |
| Work Area Size: Change working area size quickly |
| Reading Layout View: Easily reading / viewing a large number of rows and columns |
| Show Columns: Toggle all hidden columns to be visible or invisible |
| Show Worksheets: Toggle all hidden sheets to be visible or invisible |
| Interactive Hide / Unhide: Hide or unhide workbooks and worksheets |
| Toggle Settings: Toggle workbook and worksheet settings |
| Set Scroll Area: Set scroll area (hide unselected columns and rows at once) |
| Hide Non-selected sheets: Hide all inactive (or all not-selected) worksheets |
| Hide Inactive Windows: Hide other workbooks (all inactive windows) |
| Unhide All Ranges: Unhide all rows and columns |
| Unhide All Worksheets: Show all hidden worksheets |
| Unhide All Windows: Unhide all hidden workbook windows |
Range and Cells Group:
|
| Adjust Cell Size: Set row height or column width in inches，pounds, centimeters or pixels |
| Merge Same Cells: Merge adjacent cells in a column with same data / value |
| Unmerge Cell: Unmerge cells and fill down values |
| Flip Horizontal Range: Flip (reverse) data order of columns or rows |
| Flip Vertical Range: Flip (reverse) data order of columns or rows |
| Transpose Table Dimensions: Convert 2-dimensional / cross table to list |
| Transform Range: Transpose (convert) a single column or row to ranges |
| Swap Ranges: Swap rows, columns or ranges |
| Compare Ranges: Comparing two ranges to select duplicate or unique values |
| Prevent Duplicate: Prevent duplicate entries in a column |
| Copy Ranges: Copy multiple selections or ranges |
| Date Format Converter: Identify and convert date format |
| Currency Conversion: Convert currency (USD to EURO / USD to GBP) |
| Unit Conversion: Convert measurement units |
| Spell Out Numbers: Convert or spell out a number into English words |
| Change Sign of Values: Change signs of numbers (Fix trailing negative signs / Change all negative values to positive) |
| To Actual: Replace formulas with calculated values / results in cells |
| Round (Without Formula): Round cell values without formula |
| Combine (Rows & Columns): Combine (merge) multiple columns or rows |
Editing Group:
|
| Select Range Helper: Select, deselect, and reverse multiple ranges |
| Select Interval Rows & Columns: Select interval (every other) rows or columns |
| Select Merged Cells: Find and select merged cells |
| Select Cells with Max or Min Value: Select max or min (smallest or greatest) value cell |
| Select Cells with Error Value: Select cells with error values |
| Select Specific Cells: Select specific cells, rows, and Columns |
| Select Cells with Format: Select cells based on formatting |
| Insert Titles Rows: Insert title rows into a range |
| Insert Blank Rows & Columns: Insert blank rows or columns every other rows / columns |
| Date Picker: Insert date with date formatting |
| Insert Sequence Numbers: Create and insert unique sequence numbers |
| Insert Random Data: Using random number generator to generate numbers and password |
| Fill Blank Cells: Fill blank cells with value above or 0 |
| Delete Blank Rows: Remove or delete all blank rows from bottom / a range |
| Delete Rows & Columns: Delete blank or hidden rows (columns) |
| Delete Tools: Delete all charts, text boxes and embedded OLE objects |
| Delete Web Controls: Remove all html objects such as checkbox |
| Remove All Macros: Remove all macros within worksheet or workbook |
| Remove Spaces: Remove spaces before / after text or remove extra spaces from text |
| Change Case: Change case of text to all caps, lower and proper |
| Remove by Position: Remove or delete characters from beginning / end of text strings |
| Reverse Text Order: Reverse text string or words order |
| Replace Accented Characters: Replace multiple accented characters with regular chars |
| Add Text: Add the same text in a range of cells |
| Delete Characters: Remove numeric, alphabetic, non-printable or alphanumeric characters from cells |
| Alternate Row / Column Shading: Shade every other row/column |
| Superscript / Subscript (Formatting): Format text as superscript or subscript |
| Apply Date Formatting: Apply date formatting to a range of dates |
| Copy Cell Formatting: Copy a cell formatting from one cell to other cells |
| Clear All Cells Formatting: Completely clear all formatting of a range cells |
| Convert Hyperlinks: Extract url links from hyperlinks or to convert plain text links to hyperlinks |
| Find and Break Broken Links: Find and break broken links (external references) |
| Delete Hyperlinks: Remove all hyperlinks of ranges, sheets and workbook |
| Force Values in Cells: Convert / force text to number or number to text |
| Kutools Calculator: Fetches values from cells for operations and paste results into cells |
| Operation Tools: Apply mathematical operations to a range without formula |
| Change Comment Shape: Change the shape of comment box |
| Cell Comment Tools: Modify multiple cell comments |
Formula Group:
|
| Exact Formula Copy: Copy exact formulas without changing cell references |
| Convert References: Convert cell reference to relative / absolute reference |
| Replace Range Names: Replace name in formulas with cell reference |
| Error Condition Wizard: Replace formulas error messages with zero, blank cells, or customize text |
Workbook and Sheets Group:
|
|
Workbook Tools
|
| Insert Workbook Information: Insert file name or path into cell / header or footer |
| Open Containing Folder: Open current directory / folder of active workbook |
| Copy Full Path: Copy and insert the active workbook file name and path |
| Auto Open Those Workbooks Next Time: Automatically open the specified workbooks while Excel start-up |
|
Worksheet Tools
|
| Synchronize Worksheets: Synchronously select same cells in all worksheets |
| Sort Sheets: Sort or arrange sheets / worksheets alphabetically |
| Rename Multiple Worksheets: Rename multiple worksheets |
| Create List of Sheet Names: Create an index of sheets in active workbook |
| Copy Multiple Worksheets: Copy or insert multiple worksheets |
| Create Sequence Worksheets: Create a new workbook with customized worksheet names |
| Perpetual Calendar: Insert a monthly or a yearly calendar in Excel |
| Split Data: Split data into multiple sheets |
| Delete Blank Worksheets: Delete all blank worksheets with one click |
| Delete All Hidden Sheets: Delete all hidden worksheets with one click |
| Merge Workbooks: Merge multiple worksheets or workbooks into one workbook |
| Split Workbook: Split or save each sheet / worksheet of one workbook as separate excel file |
| Export Range to File: Export or save a range as CSV, HTML and Workbook |
| Export Range as Graphic: Export range as image file |
| Export Graphics: Save and export charts graphs (pictures or shapes) as JPEG image files |
| Insert File at Cursor: Insert contents of CSV, Excel, Text or PRN files at cursor position |
| Filename List: Get and create a list of filenames in a folder or directory |
| Create Folders Based on Cell Contents: Create folders based on cell values |
| Print Multiple Workbooks Wizard: Print multiple workbooks from a directory |
| Print Multiple Selection Wizard: Print multiple ranges / selections into one page |
| Copy Page Setup: Copy and apply page setup settings from one worksheet to others |
| Paging Subtotals: Inserting and printing subtotals on each printed page |
| Import Pictures: Insert multiple pictures into cells and arrange them neatly |
| Print Multiple Columns: Printing a list into multiple columns to fit on each printed page |
| Print Current Page: Print current printed page of active cell |
Security Group:
|
| Encrypt Cells: Encrypt and decrypt selected cell values or contents |
| Decrypt Cells: Encrypt and decrypt selected cell values or contents |
| Protect Worksheet: Protect multiple sheets / worksheets at a time |
| Unprotect Worksheet: Unprotect multiple worksheets / sheets at once |
Filter & Statistic Group:
|
| Count by Color: Calculate cells value based on cell background or shading color |
| Paging Subtotals: Inserting and printing subtotals on each printed page |
| Super Filter: Filter data based on cell value with multiple criteria |