Download kutools free-extendoffice

It is easy for you to process frequent operations! If you are using this software in Windows XP, you need to install the Microsoft. Net framework v2. Subscribe newsletter to stay up-to-date with us please.

The newsletter provides information about the latest software updates and software coupon codes from us. We WON'T spam you with unwanted emails or share your information with any other companies.

Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account. About Us Our team. Displays detailed information about Kutools for Excel, such as version, license information and so on.

One click to highlight all cells formatting as unlocking in the whole workbook. 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.

One click to highlight all cells whose formulas are formatting as hidden in the whole workbook. One click to highlight all cells containing formulas in the whole workbook. Note: The other languages of the website are Google-translated.

Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.

About Us Our team. Kutools - Combines More Than Advanced Functions and Tools for Microsoft Excel Kutools for Excel is a handy Excel add-in with more than advanced features to simplify various kinds of complicated tasks into a few clicks in Excel. Combine multiple worksheet or workbooks into one workbook. Count and sum cells based on background and font color. Full features free trial day, no credit card required.

Kutools tab. View Group. 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 and later versions.

Columns One click to toggle hidden columns visibility in the used range. Worksheets Quickly toggle all hidden sheets visibility 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. 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.

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. Flip Horizontal Range Flip all cells in the selection horizontally with one click. Flip Vertical Range Flip all cells in the selection vertically with one click. 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. Swap Ranges: Quickly swap ranges, columns, rows, and cells in your workbook. 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. 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. Prevent Typing Easily prevent special or certain characters from being typed in cells Only allow specific characters to be entered in a range of cells 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. Clear Data Validation Restrictions This feature will batch clear all data validation restrictions from selection in Excel.

Dynamic Drop-down List This feature can help you quickly create multi-level dependent drop-down lists 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. 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. 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 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 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 between Text and Number: With this utility, you can quickly convert cell value between text and number. 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. 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. Convert Time This feature enables: 1. 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.

Unit Conversion: Quickly convert measurements from one unit to another in your Excel. Conversion of Number Systems This feature can quickly convert among different number systems with only several clicks, without using any formulas. 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. 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. Make up a Number This feature will help you find out all combination numbers that equal to a given sum.

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. 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.

Split Cells This excellent feature can quickly split cell content of one column into multiple columns or rows by certain separators. 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. 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. Dumbbell Plot Chart : Help you to create the dumbbell chart to compare two sets of values point by point. Point in Time Charts 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. Timeline Chart : Only specifying the event column and date column, you can easily create a timeline chart by this cool Timeline Chart in Excel.

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.

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. Progress Bar Chart : Create a progress bar with percentage to express the how many percentages of a project is completed.

Progress Ring Chart : Create a doughnut chart with the percentage of completion showing in the middle of the doughnut. Percentage Ball Chart : Create a ball chart and fill completion part with different color to represent the percentage complete towards a target. The chart is colorful and looks professional. 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. Difference Comparison Charts Step Chart : The Step Chart will create a chart to represent the data trend and date changing at irregular intervals.

Column Chart with Percentage Changed : This feature will create a column chart and clearly display the percentage of changes to every next data points. Slope Chart : Create a slope chart to compare data changes over time by plotting the change between two points only. 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.

Difference Arrow Chart : Create a bar chart with red or green percentage difference arrows. 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. 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. 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. Difference Area Chart : This chart displays the differences between two sets of data clearly by the areas between two line. 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.

The chart looks more professional and impressive for people. 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. Bidirectional Histogram Chart : This Chart is frequently used for comparing two sets of data up and down along a horizontal axis. 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.

Horizontal Waterfall Chart : This Chart helps Excel users to easily create a horizontal waterfall chart or a mini horizontal waterfall chart in Excel. 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. 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.

Category Comparison Charts 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.

Dot Chart : This chart is used to show the frequency of different pieces of data in a set. 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. Marimekko Chart : This chart is used to visualize data from two or more qualitative variables. Lollipop Chart : This chart slims columns to lines, and adds colorful circles at the end of lines to make point values more attractive visually.

Multi Series Area Chart : This chart combines multiple area charts in one chart area for us to easily compare data of different categories. 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.

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. 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.

Multi Series Histogram Chart : This chart combines multiple sets of columns in one chart, so that you can easily distinguish these series. 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.

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. 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. 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.

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. 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. 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. Chart Tools 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. Add Line to Chart : This feature will quickly insert a straight line in a chart, such as an average line, an qualifying line, etc.

Copy Format to Other Charts : Quickly copy formatting from the currently selected chart to multiple charts of the active workbook in bulk. Set Absolute Position of Chart : This tool moves the currently selected chart to the specified position, and resizes the chart to specified range simultaneously. Add Sum Labels to Chart : This feature will add the sum labels for the currently selected stacked chart.

Add Cumulative Sum to Chart : This feature will add an accumulated line with accumulated total labels for the currently selected clustered column chart. Add Trend Lines to Multiple Series : This feature will add a trend line for a scatter chart which contains multiple series of data. 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.

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.

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: Select multiple ranges without holding down Ctrl key; Deselect cells from selected ranges; Reverse selected ranges. Select Range Randomly: With this utility, you can quickly randomly select cells, entire rows or columns from the selection.

Select Merged Cells Select all merged cells in a range with one click. 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.

Select Unlocked Cells With this utility, you can quickly select all unlocked cells from a range. Select Nonblank Cells 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.

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. Insert Titles Rows Sometime we may need to add a title for each row, such as Salary bill.

Insert Random Data With this utility, you can easily process the following operations in a range of cells for you. Insert Sequence Number Quickly insert a unique and consecutive value into a cell in Excel. 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. 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. Insert Numbering With this feature, you can quickly insert numberings for a range of cells with clicks at once. 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: Fill blank cells with values above, below, left or right. Fill blank cells with linear values. 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. Batch Insert Option Buttons With it, you can easily insert option button in a cell or range.

Insert Watermark With this feature, you can insert both picture and text watermarks into the worksheet at ease. Auto Text With this Auto Text feature, you can easily save and reuse all kinds of data in Excel: Save charts as an AutoText entry and reuse with one click; Save a range of data as an AutoText entry and reuse with one click; Save any formulas as AutoText entries and reuse with one click; Save clip arts or pictures as AutoText entries and reuse with one click; 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. Delete Watermark With this feature, you can quickly remove watermarks which are inserted by the Insert Watermark feature of Kutools for Excel. 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. 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. It includes: Add same text strings or characters to the beginning of selected cells Add same text strings or characters to the end of selected cells Add same text strings or characters at the specified position of selected cells 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 cells, includes: Remove leading spaces only from text strings Remove trailing spaces only from text strings Remove both leading spaces and trailing spaces from text strings Remove all excess spaces from text strings 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.

Change Case This handy tool can quickly convert text among upper case, lower case, proper case, and sentence case. Change case of text to lower case. Change case of text to proper case. Change case of text to sentence case. 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. It supports: Reverse text order by nothing. 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.

Apply Date Formatting With this utility you can quickly change the date formatting of the selected range. Copy Cell Formatting To copy formatting from one place and apply it to another, you may use Format Painter. 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.

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.