Show Classic Menu on Quick Access Toolbar

This feature adds a small icon at the leftmost of the Quick Access Toolbar to help you easily view and use the classic menu in Excel 2007 and later versions.

Columns

One click to toggle hidden columns visibility in the used range. With this utility, you can quickly toggle hidden columns visibility with one click. One click will show all hidden columns in the used range, click again will set all hidden columns to be invisible.

Worksheets

Quickly toggle all hidden sheets visibility in the current workbook. One click will toggle all hidden sheets to be visible, click again will toggle all hidden sheets to be invisible in the current workbook.

Work Area

This utility has embodied 3 types of working area settings in your Excel as follows:

• 1. To minimize the ribbon and hide the status bar;
• 2. To minimize the ribbon, hide the status bar and the formula bar;
• 3. To minimize the ribbon, hide the status bar, the formula bar, and the ribbon.

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.

Set Scroll Area:

It's a fantastic way to set or limit the scrolling area in your workbook. If you move around your worksheet a lot, or if you have data you don't want readers to explore, this tool is convenient for you to limit the visible area of your worksheet to only that which has actual data.

Unhide All Ranges:

You can quickly unhide all the hidden ranges in active worksheet.

Hide Unselected sheets:

It allows you to quickly hide all the inactive (non-selected) sheets in the active (current) workbook with one click.

Unhide All Hidden Sheets:

Unhide all hidden sheets of the active workbook with one click. Normally you have to unhide all hidden worksheets one by one in Excel.

Hide Inactive Windows:

If you have opened multiple workbooks in Excel, this tool allows you to quickly hide all the other inactive workbooks with one click.

Unhide All Hidden Windows:

Unhide all hidden workbooks with one click. Normally you have to unhide all hidden workbooks one by one in Excel.

Hide/Unhide Workbooks and Sheets:

Interactively hide or unhide multiple workbooks and worksheets at one time. Normally you have to hide or unhide the workbook and worksheet one by one in Excel. This is a handy tool for you to handle a large workbook with a bundle of worksheets.

Flip Horizontal Range

Flip all cells in the selection horizontally with one click. For example, if you have a row data, such as: 1, 2, 3, you can quickly reverse its order horizontally to 3, 2, 1.

Flip Vertical Range

Flip all cells in the selection vertically with one click. For example, if you have selected a column, containing the number 1, 2 and 3, this utility will reverse the order vertically to 3, 2, and 1.

Transpose Table Dimensions:

With this handy Transpose Table Dimension utility, you can conveniently convert a cross (two-dimensional) table to a flat (one-dimensional) list at once, and vice verse.

Transform Range:

Quickly transform a vertical column into rows with multiple columns. For example, you may have a single column of data which contains your customer's information, and each customer consists of 5 rows information (such as, name, sex, Tel, Email, and Address). With this tool you can transform the single-column of data into a five-column data table.

Swap Ranges:

Quickly swap ranges, columns, rows, and cells in your workbook. The ranges for swapping must be identical in the same size. For example, you can't swap two columns with one column. You can quickly swap the cells or ranges on the same worksheet, on different worksheets or different workbooks. The formatting of cells will also be swapped, and the swap operation does not affect the formulas in the two ranges, and they continue referring to the original cells.

Sort / Select Range Randomly:

With this utility, you can quickly sort cells in a range randomly, to sort cells based on each row or column randomly, to sort entire row or column randomly, to randomly select cells, entire rows or columns.

Paste to Visible

This feature enables to paste the copied data into visible cells only, ignoring all of the filtered cells and hidden cells.

Set Scroll Area

It's a fantastic way to set or limit the scrolling area in your workbook. If you move around your worksheet a lot, or if you have data you don't want readers to explore, this tool is convenient for you to limit the visible area of your worksheet to only that which has actual data.

Unhide all Ranges

You can quickly unhide all the hidden ranges in active worksheet.

Prevent Duplicate

This utility can prevent entering duplicate data in a single column with one click. This utility achieves the same function as Excel's Data validation feature, but you just need to select a single column and then apply this utility, then you cannot type in duplicate values in the same column.

Prevent Typing

1. Easily prevent special or certain characters from being typed in cells
2. Only allow specific characters to be entered in a range of cells

Validate Email Address

This feature is designed to set up data validation for selected range(s), which only allows Email addresses to be entered.

Validate IP Address

This feature will quickly set data validation to accept only IP address entries in the selected range(s).

Validate Phone Number

This feature will quickly set data validation to accept only phone numbers entered in the specified format. This feature will set data validation for one or multiple selections simultaneously.

Clear Data Validation Restrictions

This feature will batch clear all data validation restrictions from selection in Excel

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.

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.

Clear Advanced Drop-down List

This feature is designed to remove the advanced drop down lists which applied Kutools for Excel’s Multi-select Drop-own List, Drop-down List with Check Boxes or Searchable Drop-down List feature from selected cells, the active sheet or the active workbook.

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.

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

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.

Link Sheets

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 Data to Rows

This feature helps to easily split delimited text into different rows by a certain separator with just a few clicks.

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.

Data Distribution Charts

1. Bubble Chart: Guide you to create a bubble chart with several clicks only.
2. Normal Distribution / Bell Curve Chart: Help you create Normal Distribution Graph, Frequency Histogram, and a comparison chart of these two charts quickly.
3. Dumbbell Plot Chart: Help you to create the dumbbell chart to compare two sets of values point by point.
4. Dynamic Pie Of Pie Chart: Help you to create a chart with two pies that not only shows proportions of the sum of each row or column in the selected range, but also displays proportions of the data in a row or column at the same time.
5. Scrollable Line Chart: Help you to create a dynamic scrolling line chart with only several clicks. With this chart, you can decide how many rows of data to display in the chart at a time, and drag the scrollbar to view the data’s changing continuously.

Point in Time Charts

1. Gantt Chart: Just specify the task column, start date column, and end date column (or duration column), you can quickly create a Gantt Chart in Excel with this feature.
2. Timeline Chart: Only specifying the event column and date column, you can easily create a timeline chart by this cool Timeline Chart in Excel.

Progress Charts

1. Speedometer: Guide you create a 180° speedometer chart or 270° speedometer chart easily in Excel.
2. Bullet Chart: The Bullet Chart will display one or multiple sets of data series in ranges of performances (fair, good, excellent), and compare the actual value and target values of every data series in a small space. This feature can create both vertical and horizontal bullet chart.
3. Thermometer Chart: This Thermometer Chart can guide you to quickly create a thermometer chart in Excel based on refereed cells or manually typed values. It can show the Y axis labels as percentages or normal numbers as you need.
4. Target and Actual Chart: This Target and Actual Chart can quickly create an actual vs target chart in Excel with several clicks only.
5. Progress Bar Chart: Create a progress bar with percentage to express the how many percentages of a project is completed.
6. Progress Ring Chart: Create a doughnut chart with the percentage of completion showing in the middle of the doughnut.
7. Percentage Ball Chart: Create a ball chart and fill completion part with different color to represent the percentage complete towards a target.
8. Project Status Spectrum Chart: The Project Status Spectrum Chart is frequently used to compare and display the progresses of multiple projects in Excel. The chart is colorful and looks professional.
9. Project Status Bead Chart: As one type of progress charts in Excel, the Project Status Bead Chart is used to display the progresses of multiple projects simultaneously. It can also show the completion percentages of multiple projects.
10. Battery Chart: This feature helps to create a battery chart in Excel with just a few clicks. It is a great visual way of viewing the percentage complete and the percentage remaining for a task. According to the battery chart, you can easily know how far through you are for the task.
11. Alternative Progress Bar Chart: This feature helps to create a battery chart in Excel with just a few clicks. It is a great visual way of viewing the percentage complete and the percentage remaining for a task. According to the battery chart, you can easily know how far through you are for the task.

Difference Comparison Charts

1. Step Chart: The Step Chart will create a chart to represent the data trend and date changing at irregular intervals.
2. Column Chart with Percentage Changed: This feature will create a column chart and clearly display the percentage of changes to every next data points.
3. Slope Chart: Create a slope chart to compare data changes over time by plotting the change between two points only.
4. Threshold Value Chart: Compare data points with a given threshold value, and show the differences between data points and the threshold value by column direction, column height, and color.
5. Difference Arrow Chart: Create a bar chart with red or green percentage difference arrows.
6. Matrix Bubble Chart: This chart represents data points by bubbles in a matrix. It's fit to compare multiple sets of data horizontally and vertically.
7. Bar with Bubble Chart: This chart shows two sets of data horizontally: use bars to show one set of data in left side, and use bubbles to show the other set of data in right side.
8. Difference Comparison Chart: This chart will compare two sets of data series and show the exact difference between two sets of data series directly in a bar chart. The differences can be shown as normal bars or arrows as you need.
9. Difference Area Chart: This chart displays the differences between two sets of data clearly by the areas between two line.
10. Progress Pie Chart: With this utility, you can quickly create multiple progress pie charts side by side in one graph, and Excel users can compare the progress of each category at glance.
11. Radial Bar Chart: A Radial Bar Chart is also named Multilayered Doughnut Chart, which evolves from the classical bar chart and displays on a polar coordinate system. The chart looks more professional and impressive for people.
12. Alternative Rose Chart: As a type of alternative chart of the radar chart, it also can be called radial lollipop chart. It likes a bar chart with a zero value in the middle of the grid, and frequently be used for comparisons between a series of data.
13. Nightingale Chart: As a transformation of normal column/bar chart, the Nightingale Chart shows series of values on a polar coordinate grid, which looks more attractive with the special shape and bright colors.
14. Bidirectional Histogram Chart: This Chart is frequently used for comparing two sets of data up and down along a horizontal axis.
15. Multiple Series Line Chart: This Chart helps Excel users to create a line chart with multiple series which are grouped side by side in the same chart in order to easily compare these multiple sets of values at a glance.
16. Smooth Area Chart: This Chart helps Excel users to create an area chart with smooth lines in Excel.
17. Horizontal Waterfall Chart: This Chart helps Excel users to easily create a horizontal waterfall chart or a mini horizontal waterfall chart in Excel.
18. Interval Lable Bar Chart: This Chart helps Excel users to generate a bar chart with category labels above the bars which help free up more chart space.
19. Stacked Difference Chart: This type of chart generates special column or bar chart to help visually show the changes between two sets of data with up and down or left and right arrows.
20. Dynamic Column Chart: This feature helps to create a dynamic column chart with a drop-down list to display data for one series at a time by selecting the series from the drop-down list.
21. Dynamic Ranking Bar Chart: This feature helps to create a scrollable dynamic bar chart in descending ranking order to display only the top N values of a series.
22. Truncate the Y-axis Chart: This feature generates a truncated Y-axis column chart, which is useful in the case of problems with the axis scale. When your data is really differential, it helps to avoid the very large number overwhelming the chart, making both small series and big series precise simultaneously.

Category Comparison Charts

1. Color Grouping Chart: This feature can create a chart and color columns or bars based if the corresponding values of these data points fall in the specified range.
2. Dot Chart: This chart is used to show the frequency of different pieces of data in a set.
3. Variable Width Column Chart: It creates a column chart with different column widths, and use column widths and column heights to two data in two dimensions.
4. Marimekko Chart: This chart is used to visualize data from two or more qualitative variables.
5. Lollipop Chart: This chart slims columns to lines, and adds colorful circles at the end of lines to make point values more attractive visually.
6. Multi Series Area Chart: This chart combines multiple area charts in one chart area for us to easily compare data of different categories.
7. Proportion Stacked Chart: This chart can reflect the proportion of each point value in a series with small squares, and it's an alternative to pie chart.
8. BiDirection Bar Chart: This chart displays two sets of data side by side. In the chart, you can get the differences between the two sets data at a glance.
9. Stacked Chart with Percentage: This Stacked Chart with Percentage feature will create a stacked chart, and show the percentage labels for each data point and the total numbers for each data series.
10. Multi Series Histogram Chart: This chart combines multiple sets of columns in one chart, so that you can easily distinguish these series.
11. Multi Layer Column Chart: This chart can create a column chart to show multiple series of data in a chart, and each series of data stays at an individual layer in Excel.
12. Forecast Chart: This chart will help you quickly create a line chart to combine both series of actual values and predicting values within one line, and distinguish them with solid line and dotted line in Excel.
13. Threshold Value Area Chart: This chart can not only figure out whether a value meets the target or not at a glance, but also compare all the exceeded amount and the dropped values by the area sizes.
14. Rectangular Pie Chart: The Rectangular Pie Chart generates a multi-layer rectangular comparison chart. In the chart, the rectangular pies are placed overlay. Each rectangular pie presents a set of data, and the square size of the rectangular pie is bigger, the presented value is greater.
15. Half Pie Chart: Differing from the Excel built-in chart tool to create a full pie or doughnut chart, This Half Pie Chart can help you quickly create a half-pie or half-doughnut chart for saving space, catching attention, or for other reasons.
16. Price Tag Chart: This new type of chart looks like a price tag, which acts like a column chart but the appearance is more novel and beautiful.
17. Check Box Line Chart: The type of chart helps create an interactive line chart with checkboxes in Excel. The checkboxes control the data series in the chart, when unchecking a checkbox, the corresponding data series will disappear from the chart; when checking it, the data series will reappear.
18. Alternative Stacked Column Chart: This Alternative Stacked Column Chart shows different series as parts of the same single column bar, which helps to compare the values of the series at a glance.
19. Dynamic Polyline Chart: This feature generates a dynamic polyline chart with scroll bar, which highlights a specific data point in a two-dimensional dataset by scrolling the scroll bar and selecting an item in the list.

Chart Tools

1. Color Chart by Value: This feature will modify the columns or bar color in a clustered column or bar chart, based on the specified data range.
2. Add Line to Chart: This feature will quickly insert a straight line in a chart, such as an average line, an qualifying line, etc.
3. Copy Format to Other Charts: Quickly copy formatting from the currently selected chart to multiple charts of the active workbook in bulk.
4. Set Absolute Position of Chart: This tool moves the currently selected chart to the specified position, and resizes the chart to specified range simultaneously.
5. Add Sum Labels to Chart: This feature will add the sum labels for the currently selected stacked chart.
6. Add Cumulative Sum to Chart: This feature will add an accumulated line with accumulated total labels for the currently selected clustered column chart.
7. Move X-axis to Negative/Zero/Bottom: This feature will move the X axis to the bottom of the current selected chart.
8. Add Trend Lines to Multiple Series: This feature will add a trend line for a scatter chart which contains multiple series of data.
9. Change Chart Color According to Cell Color: This feature will change the fill color of columns, bars, scatters, etc. based on the fill color of corresponding cells in the chart data range.
10. Add Poly Line: The Add Poly Line feature can add a smooth curve with an arrow for a single series of column chart in Excel.
11. Detach Chart: The Detach Chart feature can one click to break the links between the chart and the original chart source data.

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.

Find Duplicates

With just a few clicks, this feature effortlessly helps you quickly select, hide, identify or highlight duplicates excluding their first appearances.

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.

Add Rows

This right-click feature allows you to quickly insert a specified number of rows above or below the selection.

Add Below

This right-click feature enables you to directly insert an equivalent number of rows below the selected row(s).

Add Columns

This right-click feature allows you to quickly insert a specified number of columns to the left or right of the selection.

Add to Right

This right-click feature enables you to directly insert an equivalent number of columns to the right of the selected column(s).

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.

Date & Time

This is a series of built-in functions to convert time to seconds / minutes/ hours in Excel.

Statistical & Math

This is a series of built-in functions to count/sum/average visible cells only, and count/sum by color, including:

1. Average Visible cells
2. Count Visible Cells
3. Sum Visible Cells
4. Count by cell color
5. Count by font color
6. Count by font bold
7. Count characters
8. Count shades
9. Sum by cell color
10. Sum by font color
11. Sum by font bold

Text

This series of built-in functions contain:

1. Extract Numbers: Extract numbers from mixed text string with the function
2. Reverse Text: Easily reverse order of characters in a cell with 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

Look for a value in list

With this feature, you can look up a specific value and return its corresponding data from another column in Excel with several clicks only.

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.

Multi-condition Lookup

With this feature, you can lookup the matched values in different columns based on multiple criteria with only several clicks in Excel.

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.

One-to-many Lookup (returns multiple results)

In contrast to the VLOOKUP function, this function helps to return multiple values in a cell that meet the given conditions. You can perform different operations on the returned results, such as merging them with some separator (comma, space, line break, etc.) or performing some calculations, such as multiplying, averaging, getting the maximum value, etc.

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

Split Workbook

Easily split each worksheet of the active workbook as an individual Excel Workbook, Excel 97-2003 Workbook, or TXT/CSV/PDF file, and each file carries the name of the worksheet. You can set to skip all the blank and hidden worksheets. Real more... Tutorial

File Format Converter

Normally in Excel, you can apply the Save as feature to save the Excel file format from XLSX to XLS, or vice versa, also can save the Excel file to PDF file. But if you have multiple Excel files need to be converted formats, this way will not be a good choice. So with this File Format Converter function, you can quickly and easily finish the following operations:

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

Insert Workbook Information

Quickly insert workbook name or saving path of the current workbook or current worksheet name in the header, footer, or a specified cell.

Open Containing Folder

Quickly open the folder which the active workbook stays in.

Copy Full Path

Quickly copy the full path of the active workbook, and then you can paste the full path of the active workbook to the place you want to use it.

Hide Inactive Windows

This feature will hide all inactive workbooks with one click.

Unhide All Hidden Windows

This is a handy feature to help you one click to unhide all hidden workbooks in bulk.

Hide/Unhide Workbooks and Sheets:

Interactively hide or unhide multiple workbooks and worksheets at one time. Normally you have to hide or unhide the workbook and worksheet one by one in Excel. This is a handy tool for you to handle a large workbook with a bundle of worksheets.

Auto Open Those Workbooks Next Time

With this tool, you can easily configure which open workbooks to be opened automatically next time while you launch the Excel. If you need to open the same multiple workbooks every time in your Excel, this tool can really save your time.

Compare Worksheets

Compares two specified worksheets in two different workbooks side by side and marks the differences in the same cell position with different background colors, bottom border colors, or font colors as you specified.

Synchronize Worksheets

Quickly toggle all the worksheets of the active workbook pointing on the same row number (each worksheet has the same range selection and upper left cell as the active sheet).

Sort Sheets

With this tool, you can quickly rearrange all worksheets in the active workbook. It supports one click to alphanumerically sort sheets, one click to reverse current sheet orders, one click to sort sheets by color, and move up/down a certain sheet’s order separately.

Freeze Panes Multiple Worksheets

With this handy feature, you can quickly freeze across all worksheets of the whole workbook at the same time.

Unfreeze Panes Multiple Worksheets

This feature enables to unfreeze across all worksheets of the whole workbook at a time.

Rename Worksheets

Quickly rename multiple worksheets of the active workbook at one time. You can choose to rename multiple worksheets:
1. Insert the specified content at the beginning/ending of original sheet names, or replace original sheet names in bulk;
2. Replace with contents from the specified range of cells;
3. Replace with contents from the same cells in corresponding sheets.

Create List of Sheet Names

With this feature, you can quickly list the worksheet names of the active workbook in a new worksheet, and add hyperlinks or macro buttons linking to corresponding worksheets.

Copy Worksheets

Quickly make multiple copies of the active worksheet, or to insert multiple worksheets with customized worksheet names into your workbook. You can specify a range of cells that contain your worksheet names for the copied worksheets or the inserted worksheets.

Create Sequence Worksheets

Quickly create a new workbook with customized worksheet names. You can easily specify the worksheet name by using: month names, day names, numerical sequence, a series, custom list and date in a range. For example, you can quickly create a new workbook with worksheet names: Company-1, Company-2, Country-1, and Country-2, etc.

Perpetual Calendar

This utility can quickly create a new workbook to lay out a calendar with specified number of months, and each worksheet contains one calendar month in the new workbook.

Split Data

This utility can split data in a range into multiple worksheets based on specific columns or fixed rows.

Hide Unselected sheets:

It allows you to quickly hide all the inactive (non-selected) sheets in the active (current) workbook with one click.

Unhide All Hidden Sheets:

Unhide all hidden sheets of the active workbook with one click. Normally you have to unhide all hidden worksheets one by one in Excel.

Hide/Unhide Workbooks and Sheets:

Interactively hide or unhide multiple workbooks and worksheets at one time. Normally you have to hide or unhide the workbook and worksheet one by one in Excel. This is a handy tool for you to handle a large workbook with a bundle of worksheets.

Delete Blank Worksheets

Quickly delete all the blank worksheets (included hidden worksheets) from the active workbook.

Delete All Hidden Sheets

Quickly delete all hidden worksheets from the active (current) workbook.

Delete All Inactive Sheets

This feature will quickly delete all worksheets except the active one from the current workbook with only one click.

Print Multiple Workbooks Wizard

Quickly print multiple workbooks and text files from a specified directory or across multiple directories. You can specify the type of files to be printed from a directory or multiple directories. You can choose to generate a summary report if any errors occurred while printing, you will have it in the report.

Print Multiple Selections Wizard

Quickly printing multiple non-contiguous ranges without a page break between ranges. Normally, when you print multiple selections, Excel inserts a page break between each range in your selection. You can also rearrange the order of selections to be printed.

Print First Page of Each Worksheet

With this feature, you can quickly print the first pages of each worksheet in the current workbook with only one click.

Print Pages in Reverse Order

This feature will reverse the printing order and print the active worksheet from the last page to the first one with only one click.

Print Current Page

This utility allows you to quickly print the printed page (current page) which active cell locates in with one click.

Print Specified Pages

With this utility, you can easily print only odd or even pages, or the specified range of pages in active worksheet.

Print Circle Invalid Data

With this feature, you can print all of circle data in selection or worksheet easily.

Print Charts Only

This feature will help you print charts only in Excel. It supports to print all charts together on one paper, or print each chart on a separate paper easily.

Copy Page Setup

Quickly copy the page setup setting from active worksheet to the other worksheets in the same workbook. Page setup settings include items such as headers, footers, margins, page orientation, and so on.

Paging Subtotals

Sometimes when we print the salary sheet and sales revenue report in Excel, we may want to print additional information (such as Sum, Max value) on each printed page. With this utility, you can insert two new rows at the end of each printed page. The first row contains operation titles, and the second row contains relative data.

Insert Page Break Every Row

This handy feature will quickly insert page breaks after every specified number of rows in the active worksheet. For example, it can insert page breaks after every 10 rows in bulk.

Add Border to Each Page

With this feature, you can one click to quickly add borders to each page in the active worksheet in bulk.

Export Range to File

Easily export a range of data to a file, either an Excel workbook, a CSV, a simple HTML or all formatting HTML.

Export Range as Graphic

Quickly convert a range (and the graphic objects displayed in the range) of the active worksheet to an image in Gif, JPEG, TIF or PNG format.

Export Graphics

Normally if you want to export a chart from Excel, you may need to copy this chart and paste it on a drawing tool, and then save it as an image file. With this utility, you can export a lot of graphics as images quickly.

Import Pictures

This utility can help you import multiple pictures. You can specify the arrangement rule and height for all pictures.

Match Import Pictures

This fantastic feature can import and insert pictures based on cell contents in one column/ row.

Insert File at Cursor

Quickly insert complete content of worksheet, CSV file, text file or PRN file into current cursor position of active worksheet. For example, with this tool you can easily insert multiple worksheets –with the same data structure- from different workbooks into a single worksheet.

Filename List

Microsoft Windows^® does not provide a way to print a list of the file names contained in a directory. With this tool, you can easily create a new workbook containing a list of the filenames from a specified directory, you can choose to include the sub-directory and create hyperlinks to the file names.

Create Folders Based on Cell Contents

This utility can help you easily create lots of file folders in a specified location using the cell contents as file folder names in Excel. For example, you can quickly create a file folder for each of employees by using their names to name the file folder.

Advanced Sort

With this utility, you can quickly sort data in selection by Text length, Month, Last name, Day, Absolute value, Odd and even number, Mail domain, and Frequency. With the built-in Excel Sort command, you can only sort data by values, Cell Color, Font Color and Cell Icon.

Sort Range Randomly:

With this utility, you can quickly sort cells in a range randomly, to sort cells based on each row or column randomly, to sort entire row or column randomly.

Filter Bold

This feature will quickly filter out all bold cells in the column containing the active cell with only one click.

Filter Italic

This feature will automatically filter out cells by italics formatting in the column containing the active cell with only one click.

Filter Strikethrough

This feature will automatically filter out cells by strikethrough formatting in the column containing the active cell with only one click.

Filter Comment

This feature will filter out all cells containing comments in a selected column.

Filter Formula

This feature will filter out all cells containing formulas in a selected column.

Filter Merged

This feature will automatically filter out all merged cells in the column containing the active cell with only one click.

Special Filter

This feature supports multiple special filter criteria to help you filter easily. It includes:

1. Filter Cells By Uppercase / Lowercase
2. Filter Cells By Text Length
3. Filter Cells By Workday/Weekend/Specific Day Of The Week
4. Filter All Cells By Bold Characters
5. Filter All Cells By Italics
6. Filter Cells With Strikethrough
7. Filter All Cells With Comments
8. Filter All Cells Which Containing A Formula
9. Filter Merged Cells
10. Filter Cells By The Font Color
11. Filter Cells By The Background Color

PivotTable Special Time Grouping

With this feature, you can easily create a PivotTable and group the data by special date or time criteria, such as fiscal year, half year, week number, day of week, half an hour, minutes, etc.

Languages

Set and change displaying language of Kutools for Excel.

Toolbar mode

Set and change the toolbar mode of Kutools tab and Kutools Plus tab to the suit your toolbar.

Setting Center

It includes the following Settings：
1: Disable or enable the Kutools add-in for Excel.
2: Clear configurations and caches of this add-in.
3: Set the language of the software.
4: Check the user's registration information.

Resister

If you have purchased a license, you can register the software here, or you can click on the "Purchase" button to purchase a license from our website.

Check for Updates

Check and install the latest version of Kutools for Excel.

Configure Synchronization

Synchronize Kutools configuration between devices with an OneDrive Account.

Get Help

Get help from our website https://www.extendoffice.com.

About

Displays detailed information about Kutools for Excel, such as version, license information and so on.