Step 2: The Save As window appears , select the folder containing the installation file and select Save to download Kutools.
After downloading Kutools, click on the downloaded. Step 1: The installation window appears, select Next. Step 2: Read the terms of use and select I accept the terms in the License Agreement and select Next. Step 3: In the Installation section, select the Kutools user and select Next.
Step 4: Select the installation directory and select Install to install. After the installation process has finished, select Finish. In addition to the two Kutools TM tabs and the Kutools Plus tab, there is another tab that is the Design tab as shown below:. Specifically instructions for using good features of Kutools for Excel:. Thus the working area will be expanded, you choose to customize in Work Area Size to customize the interface as you like.
The Reading Layout feature will automatically highlight the entire row or column of the cell you choose to help you see the exact data not to be confused with other rows when working with a spreadsheet with a large number of rows and columns. Prevent Typing feature helps you prevent duplicate data from entering Prevent Duplicate or prevent certain characters from being entered and allows only the specified characters in a range of cells Prevent Typing. So if in the column Number list if you enter duplicates will appear notice.
Excel does not support copying multiple selected ranges, but with the Copy Ranges feature , you can copy multiple selected ranges at once. 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. 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.
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. 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. Formula Group. 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.
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. Error Condition Wizard This tool is sophisticatedly designed for adding error condition to a formula or group of formulas. Dynamically Refer to Worksheets This utility can help you quickly to fill same cell references from multiple worksheets into one worksheet.
Convert Refers References Convert notation of references to cells in the formulas in selection. 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. 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.
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. 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. 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. Create Sequence Worksheets Quickly create a new workbook with customized worksheet names. 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. 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. Print Multiple Selections Wizard Quickly printing multiple non-contiguous ranges without a page break between ranges. 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. Copy Page Setup Quickly copy the page setup setting from active worksheet to the other worksheets in the same workbook.
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.
Insert Page Break Every Row This handy feature will quickly insert page breaks after every specified number of rows in the active worksheet. 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 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.
Import Pictures This utility can help you import multiple pictures. 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. 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. Download Kutools for Excel
0コメント