Note: After the installation, please open your Excel application, and you will see features and commands as shown in above screenshot.
 View Group:
|
| Track Snap (Backup Current Workbook): Temporarily backup current workbook at any time |
| Navigation Pane: List all sheets, workbooks, columns and names |
| Advanced Find and Replace: Easily find and replace in multiple worksheets and workbooks |
| 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 Sheets: Toggle all hidden sheets to be visible or invisible |
| Hide / Unhide Workbooks and Sheets: Hide or unhide workbooks and worksheets |
| View Options: 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 |
| Sort Range Randomly: Sort or select cells, rows and columns randomly |
| Compare Cells: Easily compare two ranges of cells if they are equal or different |
| Select Same & Different Cells: Comparing two ranges to select duplicate or unique values |
| Prevent Duplicate: Prevent duplicate entries in a column |
Prevent Typing: Easily prevent special or certain characters from being typed in cells
Only allow specific characters to be entered in a range of cells |
| Copy Ranges: Copy multiple selections or ranges |
| Convert between Text and Number: Convert / force text to number or number to text |
| Convert between Roman and Number: Convert between roman numerals and numbers |
| Convert Formula to Text: Quickly convert cell formulas to text strings |
| Convert Text to Formula: Quickly convert text string to formula |
| Convert to Date: Identify and convert date format |
| Convert Time: Convert time to seconds / minutes / hours |
| Currency Conversion: Convert currency (USD to EURO / USD to GBP) |
| Unit Conversion: Convert measurement units |
| Conversion of Number Systems: Convert between different number systems without using formula |
| 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) |
| Advanced Combine Rows: Quickly combine rows based on same value |
| Convert Number to Ordinal: Quickly convert numbers to ordinal numeral |
| 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 Last Cells: To select last cell of used range or last cell with data of last row or column |
| 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 |
| Select Unlocked Cells: Quickly select all unlocked cells |
| Select Unblank Cells: Easily select non-blank or non-empty cells |
| Select Duplicate & Unique Cells: Find duplicate or unique cells/rows in a range |
| Insert Titles Rows: Insert title rows into a range |
| Insert Blank Rows & Columns: Insert blank rows or columns every other rows / columns |
| Insert Date: Insert date with date formatting |
| Batch Insert Check Box: Quickly insert multiple checkboxes at once |
| Batch Insert Option Button: Quickly insert multiple option buttons at once |
| Insert Watermark: Quickly insert and remove watermarks |
| AutoText: Easily create and insert Auto Text entry |
| Insert Sequence Numbers: Create and insert unique sequence numbers |
| Find Missing Sequence Number: Quickly find and fill missing numbers in sequence |
| Fill Custom Lists: Create custom lists and fill cells with them |
| List All Combinations: Quickly generate/list all possible combinations of certain lists |
| Insert Bullet Or Numbering: Quickly Insert Bullets Or Numberings In Multiple Cells In Excel |
| 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 |
| Batch Delete Check Box: Remove / delete multiple checkboxes |
| Batch Delete Option Button: Batch delete option buttons |
| Remove All Macros: Remove all macros within worksheet or workbook |
| Batch Remove All Macros: Batch remove or delete all macros from workbooks |
| 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 |
| Subscript numbers in Chemical Formulas: Subscript all numbers in chemical equations correctly |
| 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 |
| Extract Text: Quickly extract certain text from cells |
| Extract Email Address: Extract email address from text string |
| Add Text: Add the same text in a range of cells |
| Split Names: Split first, middle and last names |
| Split Cells: Quickly split cell contents by space or other delimiters |
| 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 |
| 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 |
| Create Comment List: Quickly extract and list all comments to new worksheet or workbook |
| Format Comment: Quickly format all comments based on a comment |
| Find / Replace Comment Text: Quickly find and replace text in comments |
| Remove / Add User Name in Comment: Quickly change/remove/add author name in comments |
| Convert Comment and Cell: Quickly convert between cell contents and comments |
| AutoFit Comment: Automatically resize comment boxes to fit the contents |
Formula Group:
|
Functions:
Count by Cell Color: Using a function to count / sum cells by fill or font color
Count Char: Count the occurrences of a character in a string
Extract Numbers: Extract numbers from mixed text string with function
Reverse Text: Easily reverse order of characters in a cell with functions
Sum by font bold: Quickly sum bold values / numbers only
Count by font bold: Easily count the number of only bold cells in a range
SUMVISIBLE: Easily sum/count/average visible cells, rows, or columns only
|
Formulas:
Add hours / minutes / seconds to date: Easily add hours /minutes / seconds to a datetime
Add years / months / days / weeks to date: Add years / months / days / weeks to date
Calculate age based on birthday: Calculate age by date of birth
Sum numbers in a cell: Sum all digits/numbers in a cell
Sum absolute values: Easily sum absolute values in a range
Look for a value in list: Quickly lookup a value and return a different cell from the table
Count weekends between two dates: Quickly count numbers of weekends/weekdays/specific day of week between two dates
Find nth occurrence of a character: Easily find position of nth occurrence of a character in text string
Count words in range: Quickly count the number of words
Find most common value: Quickly count the number of words
Remove time from date: Quickly Remove Time From Date Time Format Permanently
|
| 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 |
| Hide / Unhide Range Name: Easily hide or unhide named range |
| Error Condition Wizard: Replace formulas error messages with zero, blank cells, or customize text |
| Dynamically Refer to Worksheets: Quickly Fill cell references from multiple worksheets |
| Trace Precedents and Dependent: Quickly trace all dependents or precedents |
Note: The features and commands are located at Enterprise tab.
Workbook and Sheets Group:
|
|
Workbook Tools
|
| Split Workbook: Split or save each sheet / worksheet from workbook as one separate Excel file |
| File Format Converter: Convert multiple XLSX files to XLS or PDF files |
| 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 specified workbooks when Excel starts |
Combine Worksheets:
1. Combine multiple worksheets / ranges from workbooks into one worksheet
2. Combine / merge all worksheets of same name across workbooks into one worksheet
3. Combine / merge worksheets or workbooks into one workbook
4. Summarize and calculate data from multiple worksheets into one worksheet |
|
Worksheet Tools
|
| Synchronize Worksheets: Synchronously select same cells in all worksheets |
| Sort Sheets: Sort or arrange sheets / worksheets alphabetically |
| Freeze Panes Multiple Worksheets: Freeze panes across multiple worksheets |
| Unfreeze Panes Multiple Worksheets: Unfreeze panes on multiple worksheets |
| 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 |
| Delete All Inactive Sheets: Delete all sheets except current / active one from workbook |
| Combine Workbooks: Merge multiple worksheets or workbooks into one workbook |
| 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 |
| Print Pages in Reverse Order: Easily print pages in reverse order |
| Insert Page Break Every Row: Quickly insert page break every x rows in Excel worksheet |
| Add Border to Each Page: Quickly add and print border around each 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 |
| Print First Page of Each Worksheet: Quickly print first page of each worksheet |
| Import Pictures: Insert multiple pictures into cells and arrange them neatly |
| Match Import Pictures: Import pictures into cells based on cell value |
| 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 |
| Create Mailing List: Easily Create Mailing List In Excel |
| Send Emails: Send Emails Based On Mailing List In Excel |
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 |
| Advanced Sort: Easily sort data by last name / month / frequency / text length |
| Super Filter: Filter data based on cell value with multiple criteria |
| Paste into visible range: Copy data and paste into only visible cells / filtered list |
Please click on the Worksheet Design to activate the worksheet design tab.
 |
| Selection Lock: Easily configure cells to be locked or unlocked |
| Selection Unlock: Easily configure cells to be locked or unlocked |
| Highlight Unlocked: Quickly highlight / color all unlocked cells |
| Formulas Hide: Quickly hide or unhide formulas |
| Formulas Unhide: Quickly hide or unhide formulas |
| Highlight Hidden: Quickly highlight cells with hidden formulas |
| Highlight Formulas: Quickly highlight all formula cells |
| Highlight Names: Quickly highlight all named ranges |
| Show Headers: Quickly hide and show column and row headers |
| Show Formulas: Easily show or display all cell formulas |
· 2 days agoSorry, we don't have such version.
· 6 days agoHello,