Download Kutools for Excel v26.10 Multilingual + License Key

View Group

Navigation Pane:

Contain 5 panes: Workbook & Sheet pane, AutoText pane, Name Manager pane, Column list pane, and Advanced Find and Replace pane.

Navigation Pane does not only list all the workbooks, worksheets, columns and names in a built-in pane for you, but it also augments Excel with a fascinating feature which lets you easily take a glance at all the workbooks, worksheets, and switch between all of them. And what's more? You can quickly select and go to the specific column and name in your workbooks. You can drag and drop the Navigation Pane to any position in your working area, and it can be activated to hide or show with one click.

Reading Layout

Automatically highlight the entire row or column of the active cell.

It is inevitable that lines or columns will be misread when we check for formulas or data in a worksheet with a large number of rows and columns. Reading Layout will highlight the line and column of the current cell. That will make it easier to check for data or enter data.

Bigger Formula Bar

This feature will enhance the formula bar, and display cell content of the active cell in a window. In the window, you can easily view long cell content or formula fully. And it also supports to edit cell value in the window.

Snap (Backup Current Workbook)

Take snapshots of the current workbook for restoring the workbook easily.

This utility can take a snapshot of the current workbook with one click at any time, and click on the snapshot item will restore the workbook to the snapshot. Please note that this utility will only keep the snapshot available before closing the workbook, if the workbook has been closed, all snapshots of the workbook will be cleaned.

Data Form

Use this feature to view, edit, or delete data entries easily in Excel. This feature shows the data in the specified range (or the entire sheet) row by row. In the Data Form dialog, we can read, add, delete, or edit the data in rows.

View Options

With this utility, you can quickly toggle any of the following settings: gridlines, horizontal scrollbar, vertical scrollbar, row and column headers, page breaks, formula view, sheet tabs, status bar, formula bar, full-screen display, comment visibility, and object visibility. Save your time from looking for where to toggle any of the above settings. It's all done interactively, so you can see the preview before you commit to it.

Show / Hide

A collection of tools allow you to quickly show or hide the workbooks, worksheets and ranges, Excel window settings, etc.

Ranges & Cells Group

Range

A collection of utilities allow you to quickly process the following operations in ranges and cells.

Copy Ranges:

Normally Excel does not allow you to copy multiple selected ranges, but with this utility, you can copy multiple selected ranges at once.

Compare Cells

Quickly compare two columns of cells, find out, and highlight the exactly same cells between them or the differences. It supports case-sensitive comparison.

Prevent Typing

Prevent duplicate data from being typed in, prevent certain characters from being typed in, and only allow to enter specified characters in a range of cells.

 Dynamic Drop-Down List

This feature can help you quickly create multi-level dependent drop-down lists in Excel. It supports to create 2-level drop-down lists, and 3-5 level drop-down lists.

 Colored Drop-Down List

This feature can help you color (add conditional formatting to) drop-down list vales or rows based on corresponding selected at ease.

 Picture Drop-Down List

This feature can help you create multiple drop down lists with their relative images with only several clicks. When selecting an item from the drop down list, its relative image will be displayed, and when choose another, the image will be changed dynamically.

 Multi-Select Drop-Down List

After enabling this feature, you can select multiple items from the drop-down lists in the specified data validation (drop-down list) range.

 Drop-Down List With Check Boxes

This feature will add a check box before each list of the drop-down list in the data validation (drop-down list) range. If you enable this feature, you can tick the check boxes to select multiple items from the drop-down lists.

 Searchable Drop-Down List

This feature helps to create a searchable drop down list. When you type the corresponding characters, only the matching items are displayed in the drop down list

 Create Simple Drop-Down List

This feature will help you quickly add data validation (drop-down list) for the selections with only 2 steps in Excel.

 Update Dynamic Drop-Down List

This feature helps to update the 2-5 level dynamic drop down list created by the Dependent Drop-down List feature of Kutools for Excel when the original data change.

 Expand Dynamic Drop-Down List Range

If you have applied the Dynamic Drop-down list feature of Kutools for Excel to create 2-5 level dependent drop down list in a specific range of cells, this feature will help to extend the original dependent drop down lists range to a specific range of cells.

 Convert To Date:

With this utility, you can quickly identify and convert some non-standard date format which cannot be identifying by Excel as the normal data format. For example, it can easily convert and identify the following styles of date (such as "20120825", "2003 1 2 11:12:13.14PM", "2012.8.13") to the local date format (US) as "8/25/2012", "1/2/2003 11:12:13 PM", and "8/13/2012" in Excel.

 Convert Time

This feature enables:
1. One click to convert time to seconds only;
2. One click to convert time to minutes only;
3. One click to convert time to an hour only;
4. And convert time to seconds/minutes/hours and save to a new location.

 Number To Words

This utility can spell out numbers into English and Chinese words in Excel. For example, it can spell out the "12.75" to "Twelve Dollars and Seventy-five Cents".

 Convert Between Roman And Number

With this feature, you can quickly convert a range of Roman data to normal decimal numbers in bulk, and vice versa.

 Change Sign Of Values

With this Excel utility, you can easily fix trailing negative signs; change all negative signs to positive; change all positive signs to negative and reverse the sign of all values. You don't need to use a formula for processing the above operations. Real more... Tutorial

 Convert Number To Ordinal

With this feature, you can quickly convert selected normal numbers to an ordinal numeral in bulk, such as converting 1 to 1st, 2 to 2nd, 11 to 11th, 25 to 25th, etc.

 Data Association

With this feature, you can correlate the data in two workbooks and view the two sheets side by side in real-time filtering.

 Make Up A Number

This feature will help you find out all combination numbers that equal to a given sum. It supports to specify the output number of combination results, and the number of combination elements.

 Date Picker

The feature shows a drop-down calendar beside the currently selected date cell, and users can click any date to overwrite the original date at ease.

 Currency Conversion:

It's a handy currency utility, which brings you a quick way to convert more than 50 currencies in your Excel by using the latest exchange rates from the reliable Internet website. You can easily convert a single value or volume values from range cells, and get the latest exchange rates at any time by updating from the reliable website (requires an Internet connection).

 Unit Conversion:

Quickly convert measurements from one unit to another in your Excel. It supports the following measurements: Angle, Bits bytes, Distance, Energy, Force, Source, Volume, Mass, Liquid, Time and Temperature.

 Number Systems Conversion

This feature can quickly convert among different number systems with only several clicks, without using any formulas. It includes converting binary to hex, octal to decimal, decimal to hex, ascii to hex, etc.

 Convert Between Text And Number:

With this utility, you can quickly convert cell value between text and number. It can also convert values in cells that are preceded by an apostrophe to the number.

 Convert Between Roman And Number

With this feature, you can quickly convert a range of Roman data to normal decimal numbers in bulk, and vice versa.

 Convert Formula To Text:

With this utility, you can easily convert formulas to text format in selection.

 Convert Text To Formula:

With this utility, it will convert formulas which have been stored as text format into real formulas.

 Combine Rows, Columns Or Cells Without Losing Data

With this utility, you can combine selected cells based on rows or columns, and combine data from multiple columns (or rows) into a single cell.

For example, you can combine the data in columns A-D, and put it all into column A. You have three options to handle the data that has been combined. You can Keep it, delete it, or create merged cells. As an option, you can specify one or more characters to insert between the combined data (for example, new line or insert a text).

 Split Cells

This excellent feature can quickly split cell content of one column into multiple columns or rows by certain separators. In addition, this feature can also split cell content into number column/row and text string column/row.

 Split Names

With this feature, you can easily split full names in a column to the first, middle and last name columns separately as you need.

 Merge Same Cells

Merge adjacent cells that contain the same value in each column with one click. Please select columns, and click "Merge Same Cells", then all vertically adjacent cells with the same value will be merged in bulk.

 Unmerge Cell & Fill Value

This utility will unmerge the merged cells in a range with one click, and auto-fill each unmerge cell with the corresponding content from the original merged cell.

 Advanced Combine Rows

With this utility, you can quickly combine multiple duplicate rows into one record based on a key column, and it also can apply some calculations such as sum, average, count and so on for other columns.

Editing Group

Charts

Here list some popular chart templates, and help you quickly to create these charts by one or several clicks.

 Super Find

• Find specific text strings only in the comments: This feature is able to look for the specific value in comments within the selection, active sheet or the whole workbook.
• Find specific text strings only in the formulas: This feature can help Excel users quickly search the specific text strings in formulas only within the selection, active sheet, selected sheets, or the whole workbook.
• Search specific text values only in hyperlinks: This feature can quickly find the specified text value in hyperlinks added in the current selection, active sheet, selected sheets, or the entire workbook.
• Find specific text string only in cell value: This feature enables to search the specified text string by text length, uppercase, lowercase, and by part of the string.
• Find cells which contain date type values based on criteria: With this feature, you can quickly find all date cells, or find cells containing the specified date in the selection, active sheet, selected sheets, or the entire workbook.
• Find numbers based on criteria: With this feature, you can quickly find numbers in a certain numerical interval, such as greater/less than a certain number, between two numbers, etc. This feature also supports to find out duplicates or unique values at ease.
• Find all cells with specific cell formatting: This feature can quickly find out cells by specified cell formatting, such as bold, italic, strikethrough, color, etc. In addition, it also supports to look for cells which are with comments and formula.

 Fuzzy Lookup

Comparing to exact searching, this feature can help Excel users to find out similar searching results, such as text strings with the misspelling.

 Find & Replace In Multiple Workbooks

This feature will enable the Find and Replace pane, and help us find and replace values in multiple worksheets and workbooks easily

 Select Range Helper

It is a useful utility to help you select, deselect, and reverse multiple selections in the active workbook. With it, you can quickly do the following operations:

1. Select multiple ranges without holding down Ctrl key;
2. Deselect cells from selected ranges;
3. Reverse selected ranges.

 Select Range Randomly:

With this utility, you can quickly randomly select cells, entire rows or columns from the selection.

 Select Interval Rows & Columns

With this utility, you can easily select a specific number of rows or columns at a specified interval in a large worksheet. For example, you can quickly select three rows at two rows interval.

 Select Merged Cells

Select all merged cells in a range with one click. Please just select a range and click "Select Merged Cells", then all merged cells in this range will be selected.

 Select Last Cell

With this feature, you can one click to select the last cell of the used range, last cell with data of the last row or last cell with data of the last column.

 Select Cells With Max Or Min Value:

This tool does not only select the minimum or maximum value in a selected range of cells but also goes to the exact position of the minimum or maximum value. In Excel, you can use the MIN and MAX function to select the minimum or maximum value, but it cannot go to the exact position of minimum or maximum value.

 Select Cells With Error Value

Selects all cells on the active worksheet with a formula that produce an error value (such as #DIV/0!, #N/A ).

 Select Unlocked Cells

With this utility, you can quickly select all unlocked cells from a range. Tip: please specify a range before applying this utility.

 Select Nonblank Cells

With this feature, you can select all non-blank cells from a range with just one click. With this feature, you can select all non-blank cells from a range with just one click.

 Select Specific Cells

Selects cells or an entire row from a specified range that meet certain criteria. Once selected, you can apply other operations (such as, formatting or delete) to the cells or entire row.

 Select Cells With Format

Selects cells with the same formatting from range cells according to the formatting of the base cell or the base cell attributes. Normally you can use this tool to determine how many cells with the same formatting of the base cells. Once selected, you can change the font size or color of the selected cells.

 Select Duplicate & Unique Cells

This utility can help you quickly select the duplicate or unique values or entire rows from a column or a range.

 Select Same & Different Cells

With this feature, you can easily compare two ranges of cells, find, select, and highlight the duplicates or unique values between both ranges.

 Insert Titles Rows

Sometime we may need to add a title for each row, such as Salary bill. This utility can quickly insert titles for rows.

 Insert Blank Rows & Columns:

This handy tool will save your time, and make it convenient for you to quickly insert multiple blank rows or columns at a specific interval at a time.

 Duplicate Rows / Rows Based On Cell Value

This feature will help you copy and insert rows n times based on cell value in the specified column easily.

 Insert Random Data

With this utility, you can easily process the following operations in a range of cells for you. A. Insert a sequence of integers randomly; B: Insert or generate random date; C. Insert or generate password (random data strings); D. Insert or generate specified formatting data strings; E. Insert or generate a custom list.

 Insert Sequence Number

Quickly insert a unique (and consecutive) value into a cell in Excel. You can add text prefix or suffix and specify the number of digits for the number. For example, you can easily insert a series number as Kutools-XXXX-2011 (XXXX indicates the sequence number).

 Find Missing Sequence Number

With this feature, you can quickly find and insert missing numbers in a sequence list.

 Fill Custom Lists

Using this feature, you can quickly create your own custom lists and keep them into the list box, and then fill them into the worksheet cells vertically or horizontally.

 List All Combinations

Based on given text strings and values, this feature can quickly figure out all possible combinations and list them in a column.

 Insert Barcode

With this handy feature, you can easily insert multiple barcodes based on the cell values in the specified range. It supports multiple types of barcode, including UPC-A, UPC-B, EAN-13, EAN-8. Case Code, Codabar(NW-7), Code-39, Code-128, etc.

 Insert QR Code

With this handy feature, you can easily insert multiple QR codes in bulk based on cell values in the specified range.

 Insert Bullet

With this feature, you can quickly insert bullets at the beginning of multiple selected cells. In addition, you can quickly remove bullets from multiple selected cells with one click only.

 Insert Numbering

With this feature, you can quickly insert numberings for a range of cells with clicks at once. It also supports to quickly remove numberings from multiple cells with clicks.

 Insert Date

With this tool, you can quickly insert a formatted date into a cell, just pick up a date with its date formatting and insert into a cell.

 Fill Blank Cells

This utility can save you time and help you quickly fill blank cells without overwriting original values in selections. With it, you can:

1. Fill blank cells with values above, below, left or right.
2. Fill blank cells with linear values.
3. Fill blank cells with a fixed value, such as 0.

 Batch Insert Check Boxes

With it, you can easily insert checkbox in a cell or range. Tip: If you select a range, it will insert checkbox into all cells of the range.

 Batch Insert Option Buttons

With it, you can easily insert option button in a cell or range. Tip: If you select a range, it will insert an option button into all cells of the range.

 Insert Watermark

With this feature, you can insert both picture and text watermarks into the worksheet at ease.

 Insert Pictures From Path(URL)

With this utility, you can quickly insert images from related URLs or file paths in Excel with only several clicks.

 Auto Text

With this Auto Text feature, you can easily save and reuse all kinds of data in Excel:

1. Save charts as an AutoText entry and reuse with one click;
2. Save a range of data as an AutoText entry and reuse with one click;
3. Save any formulas as AutoText entries and reuse with one click;
4. Save clip arts or pictures as AutoText entries and reuse with one click;
5. Easily import and export saved AutoText entries.

 Delete Blank Rows

With this tool, you can quickly delete blank rows in the selected range, selected worksheets, active worksheets, and all worksheets. Normally it's quite difficult to delete all blank rows in a workbook with too many worksheets in Excel, but with this tool, you can get it done with one click.

 Delete Hidden (Visible) Rows & Columns

With this utility, you can quickly delete all blank rows or blank columns, hidden rows or hidden columns and visible rows or visible columns from a selected range, selected sheets, active sheet or all sheets.

 Delete Watermark

With this feature, you can quickly remove watermarks which are inserted by the Insert Watermark feature of Kutools for Excel.

 Delete Illustrations & Objects

With this utility, you can:

1. Delete Charts
2. Delete Lines
3. Delete Pictures
4. Delete Auto Shapes
5. Delete Smart Arts
6. Delete Text Boxes
7. Delete Embedded OLE Objects
8. Delete Linked OLE Objects.

 Delete Web Controls

This utility can help you delete all of the web controls with one click.

 Batch Delete Check Boxes

This feature can remove the selected checkboxes at once.

 Batch Delete Option Buttons

With this feature, you can delete all option buttons in a specific range with only one click.

 Remove All Macros

Quickly remove any of the following macros from your workbook: VBA modules, UserForms, Excel 5/95 dialog worksheets, or Excel 4 XLM macro worksheets.

 Batch Remove All Macros

With this feature, you can easily remove all macros from multiple workbooks at once in Excel.

 Add Text

This feature can add the same text strings or characters into multiple selected cells in bulk. Read more... Tutorial
It includes:

1. Add same text strings or characters to the beginning of selected cells
2. Add same text strings or characters to the end of selected cells
3. Add same text strings or characters at the specified position of selected cells
4. Add same text strings or characters before every uppercase, lowercase, letter, or number

 Extract Text

With this feature, you can quickly extract text strings between two characters or symbols from selected cells.

 Extract Email Address

With this feature, you can quickly extract the email addresses from text strings of selected cells in Excel.

 Remove Spaces

This feature can remove various kinds of space from a range of cell. Read more... Tutorial
It includes:

1. Remove leading spaces only from text strings
2. Remove trailing spaces only from text strings
3. Remove both leading spaces and trailing spaces from text strings
4. Remove all excess spaces from text strings
5. Remove all kinds of spaces from text strings

 Remove Leading Zeros

With this feature, you can one click to remove leading zeros from all selected cells immediately.

 Remove By Position

With this feature, you can easily remove characters from the beginning / end of text strings, or remove given numbers of characters from the specified position. Read more... Tutorial

 Remove Characters

It’s a handy tool to remove all kinds of characters from text strings in a range. Read more... Tutorial
It includes:

1. Remove numeric characters from cells
2. Remove alphabetic characters from cells
3. Remove non-numeric characters from cells
4. Remove non-alphabetic characters from cells
5. Remove non-printable characters from cells
6. Remove non-alphanumeric characters from cells
7. Remove customized characters from cells

 Subscript Numbers In Chemical Formulas

This feature is able to format all numbers which should be made subscript in chemical equations as a subscript in bulk.

 Change Case

This handy tool can quickly convert text among upper case, lower case, proper case, and sentence case. It includes:

1. Change case of text to all caps / upper case.
2. Change case of text to lower case.
3. Change case of text to proper case.
4. Change case of text to sentence case.
5. Change case of text to toggle case.

 Reverse Text Order

With this feature, you can quickly reverse the word order in each selected cell in bulk. Read more... Tutorial
It supports:

1. Reverse text order by nothing. For example, reverse “Kutools for Excel” to “lecxE rof slootuK”;
2. Reverse text order by space. For example, reverse “Kutools for Excel” to “Excel for Kutools”;
3. Reverse text order by comma or other separators. For example, reverse “Word, Excel, PowerPoint, Outlook” to “Outlook, PowerPoint, Excel,Word”;

 Replace Accented Characters

With this feature, you can easily replace all kinds of accented characters with regular chars in the entire workbook.

 Mark Keyword

The Mark Keyword feature can simultaneously color multiple keywords only within cells or color the entire cells containing these keywords in the specified range in Excel.

 Alternate Row / Column Shading

Quickly apply shade to alternate rows for a range cells in a worksheet from using the Conditional Formatting and standard formatting to improve the readability of your worksheet in Excel, and you don't need to know how to use the Conditional Formatting and standard formatting.

 Distinguish Differences

With this amazing feature, you can insert page breaks, blank cells, add bottom borders, or Fill cells/rows when the cell value changes in the specified key column.

 Superscript / Subscript (Formatting)

Easily format text as superscript or subscript in a cell. You can also apply the Bold and Italic attributes and the case (upper or lower) for alphabet characters. It's a perfect tool for you to work with mathematical or chemical formulas in Excel.

 Apply Date Formatting

With this utility you can quickly change the date formatting of the selected range. Real more... Tutorial

 Copy Cell Formatting

To copy formatting from one place and apply it to another, you may use Format Painter. But the Format Painter will copy all the formatting of the cell and apply it to another. This utility can help you copy some specific formatting of the cell and apply it to another.

 Clear Characters Formatting

Normally Excel does not support a tool to clear various types of cell format at once, but with this utility, you can easily clear all cell formats from a range with one click.

 Adjust Cell Size

This utility helps you to quickly adjust the row height and column width in pounds, centimeters, inches or pixels. It can apply to a range or the whole worksheet.

 Convert Hyperlinks

With this utility, you can quickly convert text (URL) into hyperlinks, apply multiple hyperlink addresses to cell content (text) and convert multiple hyperlink address into text in Excel.

 Find And Break Broken Links

It can list all links (external reference) of the active worksheet and break all broken links by replacing it with appreciate value in Excel.

 Remove Hyperlinks Without Losing Formatting

Quickly convert hyperlinks in cells. You can delete all hyperlinks in: selected Range; active worksheet; selected worksheets and all worksheets, and remain original cell formatting.

 Change Comment Shape

Quickly change the shape of all comments in Excel.

 Create Comment List

This feature will extract and list all comments in a new worksheet or workbook as you specified.

 Format Comment

This feature will copy the formatting of the comment of the active cell, and apply the formatting to all of the other comments in bulk.

 Find / Replace Comment Text

This feature enables to find certain data in comments and replace with given content in the active sheet or the whole workbook.

 Remove / Add User Name In Comment

This feature will save you time greatly to batch add, remove, and change user names in all comments of the active worksheet or the entire workbook.

 Convert Comment And Cell

With this feature, it’s quite easy to convert between comments and cell contents. It’s able to achieve:

1. Convert cell contents to comments
2. Convert comments to cell contents
3. Insert cell contents to comments
4. Insert comments to cell contents

 AutoFit Comment

This smart feature will resize all comments to fit their contents accordingly in bulk in active worksheet or the entire workbook.

 Reset Comment Position

With this feature, you can one click to reset all comments back to the default positions in the active worksheet or the whole workbook immediately.

 Always Show Comment

This feature will display the comment of the actively selected cell all the time, no matter where you move your mouse to.

Formula Group

Kutools Functions

A collection of built-in functions.

 Date & Time

1. Add years to date
2. Add months to date
3. Add days to date
4. Add hours to date
5. Add minutes to date
6. Add seconds to date
7. Add weeks to date
8. Remove time from date
9. Count days, hours and minutes between dates
10. Convert number (of days) to year month day
11. Convert number (of seconds) to hh:mm:ss time format
12. Convert date to ordinal date
13. Convert date to quarter

 Statistical

1. Count the number of a word
2. Count total words
3. Number of non-working days between two dates
4. Number of working days between two dates
5. Count the number of the day of the week
6. Count cells equal to A, B, or C
7. Count cells which equal to A and B
8. Count unique values
9. Count cells with unique values (include the first duplicate value)
10. Count the number of values separated by comma
11. Sum based on the same text

 Text

1. Extract the nth word in cell
2. Extract cells with unique values
3. Extract cells with unique values (include the first duplicate value)
4. Extract strings between specified text
5. Cell contains specific text then return value
6. Abbreviated name or word
7. Connected value by specific character (string)

 Lookup & Reference

1. Look for a value in list
2. Find where the character appears Nth in a string
3. Find the value that appears most often
4. Index and match on multiple columns
5. Find the largest number less than

 Math & Trig

1. Sum absolute values
2. Sum numbers in a cell
3. Calculate age based on birthday
4. SUMPRODUCT with criteria
5. Calculate days in year
6. Calculate days in month

Date & Time Helper

It's a date & time calculator. With it, you can easily solve following issues:

1. Add specified number of years, months, weeks, days, or hours, minutes, seconds to a date or time
2. Subtract specified number of years, months, weeks, days, or hours, minutes, seconds from a date or time
3. Calculate difference between two dates / times
4. Calculate age based on a given date

 LOOKUP Across Multiple Sheets

Comparing to the VLOOKUP function which can look for a value from one range only, this feature will help Excel users to batch look for multiple values across multiple worksheets at a time easily.

 LOOKUP And Sum

With this feature, you will find row or column in the selection based on the given criteria, and return the summation of found row or column.

 LOOKUP From Right To Left

Different from the VLOOKUP function which can only look for a value in the leftmost column of a range, this feature enables you to look for values in any column of a range, and return values in another column as you need.

 LOOKUP From Bottom To Top

If there are multiple matched values, the VLOOKUP function will search from top to bottom and return the first matched value. But this feature will reverse the lookup order (from bottom to top) and return the last matched value.

 LOOKUP Between Two Values

With this feature, you can look for a value between two values, and return a matched value easily.

 Replace 0 Or #N/A With Blank Or A Specified Value

If the lookup value is not found or empty, the VLOOKUP function will return #N/A error value or 0. This feature will fix this problem, and return empty or a specified value for those unfounded lookup values and empty value.

 Convert Name To Reference Range

This tool augments Excel with a feature for replacing a name reference in the selected formulas with the corresponding reference. For the cells contain formulas, this is a quite handy feature for you to continue using name references without affecting the selected formulas.

 Hide / Unhide Range Name

With this feature, you can quickly show or hide all range names in the current workbook.

 Error Condition Wizard

This tool is sophisticatedly designed for adding error condition to a formula or group of formulas. With this tool, you can easy to display a custom message for formulas that produce errors. This means that instead of e.g. #VALUE!. You can have your own error message displayed.

 Dynamically Refer To Worksheets

This utility can help you quickly to fill same cell references from multiple worksheets into one worksheet. You can fill them vertically or horizontally. Supposing you have a workbook which contains multiple worksheets, and now you want to extract all the same cell references (A1, for example) from other worksheets into one worksheet, with this function, you can quickly get the result =Sheet1!A1, =Sheet2!A1, =Sheet3!A1, =Sheet4!A1… into a master worksheet.

 Convert Refers (References)

Convert notation of references to cells in the formulas in selection.

For example: [=F5*(G12/100)] becomes [=$F5*($G12/100)]. With this feature, you can:

1. Convert formulas to absolute referencing ($F$5)
2. Convert formulas to relative referencing (F5)
3. Convert formulas to relative rows and absolute columns ($F5)
4. Convert formulas to absolute rows and relative columns (F$5)

 Monitor Precedents / Dependents Of Ranges

These features can help you quickly automatically display all dependents and precedents in a selected range in real time with one click. It includes:

1. Monitor Precedents of Ranges
2. Monitor Dependents of Ranges
3. Monitor Precedents and Dependents

Workbook & Sheets Group

Workbook

A collection of tools allow you to quickly process the following operations in the workbook.

Worksheets

A collection of tools allow you to quickly process the following operations in worksheets.

Combine (Worksheets)

With this utility, you can achieve:

1. Quickly combine multiple worksheets / ranges from workbooks into one worksheet;
2. Quickly merge / combine all worksheets of the same name across workbooks into one worksheet;
3. Quickly merge / combine worksheets or workbooks into one workbook;
4. Quickly summarize / calculate data from multiple worksheets into one worksheet.

Table Merge

Update or merge two tables by a given matching column from two worksheets or workbooks.

Split Data

Split data in a range into multiple worksheets based on specific columns or fixed rows.

Format Converter

Convert Excel file Format between XLSX and XLS, and convert Excel files to PDF files.

1. Convert multiple XLSX files to XLS files in Excel
2. Convert multiple XLS files to XLSX files in Excel
3. Convert multiple excel workbooks to PDF files in Excel

Split Workbook

Split each worksheet of the active workbook as an individual workbook, TXT file, CSV file, or PDF file.

Worksheet Design

This is added to toggle the Design Tools added by Kutools for Excel.

Printing

A collection of tools allow you to quickly process the following operations.

Split To Columns

With this utility, you can quickly print columns in multiple segments to fit on one printed page in Excel.

Let's say you have 200 names in a column and want to print them in columns of 50 on one printed page. With this utility, you can quickly get it done, and it will save much ink and paper.

Import / Export

A collection of tools allow you to quickly process the following operations.

Security Group

Password Manager

This feature can add and manage passwords, which are used to open password-protected workbooks. After adding passwords in this manager, corresponding workbooks can be opened directly when using Combine Worksheets or other features of Kutools for Excel.

Encrypt Cells

With this utility, you can encrypt the selected cells. (the formula cells cannot be encoded). Here is the Usage:

1. Select the range that you want to encrypt.
2. Click "Encrypt Cells".
3. Input the password. (The password can be letters, numbers and special characters)
4. Choose one of masks: none, special char, or specail string.

Decrypt Cells

This utility will only decrypt the cells which have encrypted with Encrypt Cells of Kutools for Excel.

Protect Worksheet

With this utility, you can quickly protect multiple worksheets with the same password in the current workbook. Here is the usage:

1. Only the unprotected worksheets will be listed in the dialog box, please select the worksheets that you want to protect and click "OK".
2. Enter a password to protect worksheets, and you can set other options for how you would like the worksheets to be protected.
3. Click "OK".

Unprotect Worksheet

If multiple worksheets are protected by the same password, this utility can quickly unprotect these worksheets in bulk. Here is the usage:

1. Only the protected worksheets will be listed in the dialog box, please select the worksheet you want to unprotect and click OK.
2. Enter the password to unprotect the worksheets.

Encrypt Workbooks

With this utility, you can quickly protect multiple workbooks with the same password at the same time.

Decrypt Workbooks

If multiple workbooks are protected by the same password, this utility can quickly unprotect these workbooks in bulk.

Mailings Group

Create Mailing List

With this feature, you can quickly create a list of recipients in an Excel table.

Send Emails

This feature will help you to send personalized emails to multiple recipients in bulk.

Filter & Statistic Group

Sort

Quickly sort data by special criteria in Excel.

Super Filter

This utility supports quickly filtering the whole worksheet by combining multiple conditions. You can add, delete or disable the conditions easily.

Special Filter

A collection of tools help you to quickly filter data with special criteria.

Count By Color

Calculate cells by background color or font color.

This utility will calculate the cells based on cell background color or font color in the range and generate a report with information, such as how many cells that have the same background/font color, the sum value of same background/font color cells, the average value of same background/font color cell, the max value of same background/font color and the min value of same background/font color cell.

Paging Subtotals

Insert a row into each printed page for analyzing and calculate each column.

Insert a row into each printed page for analyzing and calculating each column. It supports count, average, and sum values in the corresponding column, find out the max / min value from the specified column, and product and count numbers of the column.

Pivot Table

A collection of tools for PivotTable.

Common Processing

Re-Run Last Utility

Quickly apply the utility of Kutools for Excel you have just launched before with one click.

Search

Type in your keywords in the search box, it will immediately list all features related to the given keywords. And you click one of search results to enable the specified feature at once.

Feedback

Submit errors that you meet when running Kutools for Excel. And any suggestions about Kutools for Excel can also be sent here.

Help

Detailed information about Kutools for Excel.

Protect Group

Lock Cells

One click to set the formatting of current selection as lock.

Unlock Cells

One click to set the formatting of current selection as unlock.

Highlight Unlocked

One click to highlight all cells formatting as unlocking in the whole workbook.

Hide Formulas

One click to hide the formulas in cells of selection. The hidden formulas will not display in the formula bar after you protect the worksheet.

Unhide Formulas

One click to show all hidden formulas in the selection.

Highlight Hidden

One click to highlight all cells whose formulas are formatting as hidden in the whole workbook.

View Group

Highlight Formulas

One click to highlight all cells containing formulas in the whole workbook.

Highlight Names

One click to highlight all named ranges in the whole workbook.

Monitor Group

Monitor Precedents / Dependents

These features can help you quickly automatically display all dependents and precedents in a selected range in real time with one click. It includes:

1. Monitor Precedents of Ranges
2. Monitor Dependents of Ranges
3. Monitor Precedents and Dependents

Settings

In the Design Tools Settings center, you can configure as follows:

1. Enable the protect options to automatically protect and unprotect worksheets;
2. Specify the highlight colors for unlocked ranges, formulas hidden ranges, formulas cells, and named ranges.

Close Design

Click to exit the Design tab.