Kutools - Combines More Than 300 Advanced Functions and Tools for Microsoft Excel |
|
Kutools for Excel is a handy Excel add-in with more than 300 advanced features to simplify various kinds of complicated tasks into a few clicks in Excel. For example, Excel users can easily combine worksheets with several clicks, merge cells without losing data, paste to only visible cells, and so on. Undoubtedly, this powerful and user-friendly add-in will save Excel users a mass of working time and greatly improve working efficiency. ![]()
|
The software is described below, arranged by the Ribbon groups in which they appear.
![]() |
|||
![]() |
![]() |
![]() |
![]() |
View Group | Ranges & Cells Group | Editing Group | Formula Group |
![]() |
|||
![]() |
![]() |
![]() |
![]() |
Workbooks & Sheets Group | Security Group | Mailings Group | Filter & Statistic Group |
![]() |
||||
![]() |
![]() |
![]() |
![]() |
![]() |
Protect Group | View Group | Monitor Group | Options Group |
Note: The Design tab is turned off by default. Excel users can toggle it by Kutools Plus > Worksheet Design.
Contain 5 panes: Workbook & Sheet pane, AutoText pane, Name Manager pane, Column list pane, and Advanced Find and Replace pane.
Navigation Pane does not only list all the workbooks, worksheets, columns and names in a built-in pane for you, but it also augments Excel with a fascinating feature which lets you easily take a glance at all the workbooks, worksheets, and switch between all of them. And what's more? You can quickly select and go to the specific column and name in your workbooks. You can drag and drop the Navigation Pane to any position in your working area, and it can be activated to hide or show with one click.
Automatically highlight the entire row or column of the active cell.
It is inevitable that lines or columns will be misread when we check for formulas or data in a worksheet with a large number of rows and columns. Reading Layout will highlight the line and column of the current cell. That will make it easier to check for data or enter data.
This feature will enhance the formula bar, and display cell content of the active cell in a window. In the window, you can easily view long cell content or formula fully. And it also supports to edit cell value in the window.
Take snapshots of the current workbook for restoring the workbook easily.
This utility can take a snapshot of the current workbook with one click at any time, and click on the snapshot item will restore the workbook to the snapshot. Please note that this utility will only keep the snapshot available before closing the workbook, if the workbook has been closed, all snapshots of the workbook will be cleaned.
Use this feature to view, edit, or delete data entries easily in Excel. This feature shows the data in the specified range (or the entire sheet) row by row. In the Data Form dialog, we can read, add, delete, or edit the data in rows.
With this utility, you can quickly toggle any of the following settings: gridlines, horizontal scrollbar, vertical scrollbar, row and column headers, page breaks, formula view, sheet tabs, status bar, formula bar, full-screen display, comment visibility, and object visibility. Save your time from looking for where to toggle any of the above settings. It's all done interactively, so you can see the preview before you commit to it.
A collection of tools allow you to quickly show or hide the workbooks, worksheets and ranges, Excel window settings, etc.
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.
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.
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.
This utility has embodied 3 types of working area settings in your Excel as follows:
This feature will display the comment of the actively selected cell all the time, no matter where you move your mouse to.
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.
You can quickly unhide all the hidden ranges in active worksheet.
It allows you to quickly hide all the inactive (non-selected) sheets in the active (current) workbook with one click.
Unhide all hidden sheets of the active workbook with one click. Normally you have to unhide all hidden worksheets one by one in Excel.
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 workbooks with one click. Normally you have to unhide all hidden workbooks one by one in Excel.
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.
A collection of utilities allow you to quickly process the following operations in ranges and cells.
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 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.
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.
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.
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.
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.
This feature enables to paste the copied data into visible cells only, ignoring all of the filtered cells and hidden cells.
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.
You can quickly unhide all the hidden ranges in active worksheet.
Normally Excel does not allow you to copy multiple selected ranges, but with this utility, you can copy multiple selected ranges at once.
Quickly compare two columns of cells, find out, and highlight the exactly same cells between them or the differences. It supports case-sensitive comparison.
Prevent duplicate data from being typed in, prevent certain characters from being typed in, and only allow to enter specified characters in a range of cells.
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.
This feature is designed to set up data validation for selected range(s), which only allows Email addresses to be entered.
This feature will quickly set data validation to accept only IP address entries in the selected range(s).
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.
This feature will batch clear all data validation restrictions from selection in Excel
A collection of tools about drop-down lists in Excel.
This feature will help you quickly add data validation (drop-down list) for the selections with only 2 steps in Excel.
This feature can help you color (add conditional formatting to) drop-down list vales or rows based on corresponding selected at ease.
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.
After enabling this feature, you can select multiple items from the drop-down lists in the specified data validation (drop-down list) range.
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.
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.
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.
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
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.
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.
A collection of tools allow you to you to quickly process the following operations.
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.
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.
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".
With this feature, you can quickly convert a range of Roman data to normal decimal numbers in bulk, and vice versa.
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
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.
With this feature, you can correlate the data in two workbooks and view the two sheets side by side in real-time filtering.
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.
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.
A collection of tools allow you to you to quickly process the following operations.
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).
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.
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.
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.
With this feature, you can quickly convert a range of Roman data to normal decimal numbers in bulk, and vice versa.
With this utility, you can easily convert formulas to text format in selection.
With this utility, it will convert formulas which have been stored as text format into real formulas.
Convert the real value or formula in selected cells into the displaying values.
For example, you may insert a random number with inputting =RAND()*100 in a cell, and it displays 75.1203 in the cell. With this tool, you will remove the formula of =RAND()*100, but remain the displaying value of 75.1203.
Batch round numbers in selected range to the given decimal places without formula.
In Excel we can round numbers with functions or Format Cells command, however, both ways do not change the actual value of cells after rounding. This utility will round numbers in a range, and make the actual value of cells as displayed value. It supports the common round, round up, round down, and round to even.
A series of tools combine or merge cells, rows, and columns, and split cells, etc.
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).
This feature helps to easily split delimited text into different rows by a certain separator with just a few clicks.
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.
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 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.
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.
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.
Here list some popular chart templates, and help you quickly to create these charts by one or several clicks.
Search in specified scope (comments, cells, formulas, or hyperlinks), and search by specified criteria (date type, number, or specified formatting) in Excel.
Comparing to exact searching, this feature can help Excel users to find out similar searching results, such as text strings with the misspelling.
This feature will enable the Find and Replace pane, and help us find and replace values in multiple worksheets and workbooks easily
A collection of tools make the selection of various items easier in Excel.
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:
With this utility, you can quickly randomly select cells, entire rows or columns from the selection.
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 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.
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.
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.
Selects all cells on the active worksheet with a formula that produce an error value (such as #DIV/0!, #N/A ).
With this utility, you can quickly select all unlocked cells from a range. Tip: please specify a range before applying this utility.
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.
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.
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.
This utility can help you quickly select the duplicate or unique values or entire rows from a column or a range.
With this feature, you can easily compare two ranges of cells, find, select, and highlight the duplicates or unique values between both ranges.
A collection of insert tools.
Sometime we may need to add a title for each row, such as Salary bill. This utility can quickly insert titles for rows.
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.
This feature will help you copy and insert rows n times based on cell value in the specified column easily.
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.
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).
With this feature, you can quickly find and insert missing numbers in a sequence list.
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.
Based on given text strings and values, this feature can quickly figure out all possible combinations and list them in a column.
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.
With this handy feature, you can easily insert multiple QR codes in bulk based on cell values in the specified range.
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.
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.
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.
This utility can save you time and help you quickly fill blank cells without overwriting original values in selections. With it, you can:
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.
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.
With this feature, you can insert both picture and text watermarks into the worksheet at ease.
With this utility, you can quickly insert images from related URLs or file paths in Excel with only several clicks.
With this Auto Text feature, you can easily save and reuse all kinds of data in Excel:
A collection of tools allow you to quickly process the following operations.
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.
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.
With this feature, you can quickly remove watermarks which are inserted by the Insert Watermark feature of Kutools for Excel.
With this utility, you can:
This utility can help you delete all of the web controls with one click.
This feature can remove the selected checkboxes at once.
With this feature, you can delete all option buttons in a specific range with only one click.
Quickly remove any of the following macros from your workbook: VBA modules, UserForms, Excel 5/95 dialog worksheets, or Excel 4 XLM macro worksheets.
With this feature, you can easily remove all macros from multiple workbooks at once in Excel.
It embodies a lot of handy operations for you to manipulate the text in cells.
This feature can add the same text strings or characters into multiple selected cells in bulk. Read more... Tutorial
It includes:
With this feature, you can quickly extract text strings between two characters or symbols from selected cells.
With this feature, you can quickly extract the email addresses from text strings of selected cells in Excel.
This feature can remove various kinds of space from a range of cell. Read more... Tutorial
It includes:
With this feature, you can one click to remove leading zeros from all selected cells immediately.
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
It’s a handy tool to remove all kinds of characters from text strings in a range. Read more... Tutorial
It includes:
This feature is able to format all numbers which should be made subscript in chemical equations as a subscript in bulk.
This handy tool can quickly convert text among upper case, lower case, proper case, and sentence case. It includes:
With this feature, you can quickly reverse the word order in each selected cell in bulk. Read more... Tutorial
It supports:
With this feature, you can easily replace all kinds of accented characters with regular chars in the entire workbook.
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.
A collection of tools for formatting.
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.
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.
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.
With this utility you can quickly change the date formatting of the selected range. Real more... Tutorial
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.
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.
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.
A collection of tools for hyperlinks and external references (links).
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.
It can list all links (external reference) of the active worksheet and break all broken links by replacing it with appreciate value in Excel.
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.
A collection of comment tools.
Quickly change the shape of all comments in Excel.
This feature will extract and list all comments in a new worksheet or workbook as you specified.
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.
This feature enables to find certain data in comments and replace with given content in the active sheet or the whole workbook.
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.
With this feature, it’s quite easy to convert between comments and cell contents. It’s able to achieve:
This smart feature will resize all comments to fit their contents accordingly in bulk in active worksheet or the entire workbook.
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.
This feature will display the comment of the actively selected cell all the time, no matter where you move your mouse to.
Performs common math operations in cells, such as addition, subtraction, multiplication, division, etc. For example, you can easily use this tool to increase a column of prices of various products by 2 percent.
With this calculator, you can carry out more than 10 types of mathematical operation. You can easily retrieve a value from a selected cell for calculating, and paste the calculating result into a specific cell. You can also use the keyboards to handle the calculator for operation.
A collection of built-in functions.
This is a series of built-in functions to convert time to seconds / minutes/ hours in Excel.
This is a series of built-in functions to count/sum/average visible cells only, and count/sum by color, including:
This series of built-in functions contain:
The Formula Helper feature lists some commonly-used formulas, including:
It's a date & time calculator. With it, you can easily solve following issues:
Easily copy all the formulas without adjusting the relative cell references.
Normally Excel will adjust the cell references if you copy your formulas to another location. Then if you want to process this operation in your Excel without using this tool, you have to lock all references with $.
A collection of formulas about VLOOKUP function.
With this feature, you can look up a specific value and return its corresponding data from another column in Excel with several clicks only.
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.
With this feature, you can lookup the matched values in different columns based on multiple criteria with only several clicks in Excel.
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.
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.
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.
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.
With this feature, you can look for a value between two values, and return a matched value easily.
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.
A collection of name tools.
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.
With this feature, you can quickly show or hide all range names in the current workbook.
More tools for handling formulas in Excel.
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.
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 notation of references to cells in the formulas in selection.
For example: [=F5*(G12/100)] becomes [=$F5*($G12/100)]. With this feature, you can:
These features can help you quickly automatically display all dependents and precedents in a selected range in real time with one click. It includes:
A collection of tools allow you to quickly process the following operations in the 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
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:
Quickly insert workbook name or saving path of the current workbook or current worksheet name in the header, footer, or a specified cell.
Quickly open the folder which the active workbook stays in.
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.
This feature will hide all inactive workbooks with one click.
This is a handy feature to help you one click to unhide all hidden workbooks in bulk.
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.
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.
A collection of tools allow you to quickly process the following operations in 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.
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).
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.
With this handy feature, you can quickly freeze across all worksheets of the whole workbook at the same time.
This feature enables to unfreeze across all worksheets of the whole workbook at a time.
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.
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.
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.
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.
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.
This utility can split data in a range into multiple worksheets based on specific columns or fixed rows.
It allows you to quickly hide all the inactive (non-selected) sheets in the active (current) workbook with one click.
Unhide all hidden sheets of the active workbook with one click. Normally you have to unhide all hidden worksheets one by one in Excel.
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.
Quickly delete all the blank worksheets (included hidden worksheets) from the active workbook.
Quickly delete all hidden worksheets from the active (current) workbook.
This feature will quickly delete all worksheets except the active one from the current workbook with only one click.
With this utility, you can achieve:
Convert Excel file Format between XLSX and XLS, and convert Excel files to PDF files.
Split each worksheet of the active workbook as an individual workbook, TXT file, CSV file, or PDF file.
A collection of tools allow you to quickly process the following operations.
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.
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.
With this feature, you can quickly print the first pages of each worksheet in the current workbook with only one click.
This feature will reverse the printing order and print the active worksheet from the last page to the first one with only one click.
This utility allows you to quickly print the printed page (current page) which active cell locates in with one click.
With this utility, you can easily print only odd or even pages, or the specified range of pages in active worksheet.
With this feature, you can print all of circle data in selection or worksheet easily.
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.
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.
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.
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.
With this feature, you can one click to quickly add borders to each page in the active worksheet in bulk.
With this utility, you can quickly print columns in multiple segments to fit on one printed page in Excel.
Let's say you have 200 names in a column and want to print them in columns of 50 on one printed page. With this utility, you can quickly get it done, and it will save much ink and paper.
A collection of tools allow you to quickly process the following operations.
Easily export a range of data to a file, either an Excel workbook, a CSV, a simple HTML or all formatting HTML.
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.
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.
This utility can help you import multiple pictures. You can specify the arrangement rule and height for all pictures.
This fantastic feature can import and insert pictures based on cell contents in one column/ row.
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.
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.
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.
This feature can add and manage passwords, which are used to open password-protected workbooks. After adding passwords in this manager, corresponding workbooks can be opened directly when using Combine Worksheets or other features of Kutools for Excel.
With this utility, you can encrypt the selected cells. (the formula cells cannot be encoded). Here is the Usage:
1. Select the range that you want to encrypt.
2. Click "Encrypt Cells".
3. Input the password. (The password can be letters, numbers and special characters)
4. Choose one of masks: none, special char, or specail string.
This utility will only decrypt the cells which have encrypted with Encrypt Cells of Kutools for Excel.
With this utility, you can quickly protect multiple worksheets with the same password in the current workbook. Here is the usage:
1. Only the unprotected worksheets will be listed in the dialog box, please select the worksheets that you want to protect and click "OK".
2. Enter a password to protect worksheets, and you can set other options for how you would like the worksheets to be protected.
3. Click "OK".
If multiple worksheets are protected by the same password, this utility can quickly unprotect these worksheets in bulk. Here is the usage:
1. Only the protected worksheets will be listed in the dialog box, please select the worksheet you want to unprotect and click OK.
2. Enter the password to unprotect the worksheets.
With this utility, you can quickly protect multiple workbooks with the same password at the same time.
If multiple workbooks are protected by the same password, this utility can quickly unprotect these workbooks in bulk.
With this feature, you can quickly create a list of recipients in an Excel table.
Quickly sort data by special criteria in Excel.
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.
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.
This utility supports quickly filtering the whole worksheet by combining multiple conditions. You can add, delete or disable the conditions easily.
A collection of tools help you to quickly filter data with special criteria.
This feature will quickly filter out all bold cells in the column containing the active cell with only one click.
This feature will automatically filter out cells by italics formatting in the column containing the active cell with only one click.
This feature will automatically filter out cells by strikethrough formatting in the column containing the active cell with only one click.
This feature will filter out all cells containing comments in a selected column.
This feature will filter out all cells containing formulas in a selected column.
This feature will automatically filter out all merged cells in the column containing the active cell with only one click.
This feature supports multiple special filter criteria to help you filter easily. It includes:
Calculate cells by background color or font color.
This utility will calculate the cells based on cell background color or font color in the range and generate a report with information, such as how many cells that have the same background/font color, the sum value of same background/font color cells, the average value of same background/font color cell, the max value of same background/font color and the min value of same background/font color cell.
Insert a row into each printed page for analyzing and calculate each column.
Insert a row into each printed page for analyzing and calculating each column. It supports count, average, and sum values in the corresponding column, find out the max / min value from the specified column, and product and count numbers of the column.
A collection of tools for PivotTable.
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.
Quickly apply the utility of Kutools for Excel you have just launched before with one click.
Type in your keywords in the search box, it will immediately list all features related to the given keywords. And you click one of search results to enable the specified feature at once.
Submit errors that you meet when running Kutools for Excel. And any suggestions about Kutools for Excel can also be sent here.
Detailed information about Kutools for Excel.
Set and change displaying language of Kutools for Excel.
Set and change the toolbar mode of Kutools tab and Kutools Plus tab to the suit your toolbar.
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.
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 and install the latest version of Kutools for Excel.
Synchronize Kutools configuration between devices with an OneDrive Account.
Get help from our website https://www.extendoffice.com.
Displays detailed information about Kutools for Excel, such as version, license information and so on.
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.
These features can help you quickly automatically display all dependents and precedents in a selected range in real time with one click. It includes:
In the Design Tools Settings center, you can configure as follows:
Click to exit the Design tab.
I usualy work with Excel and I found Kutools as a tool to make work more effective. In fact, Kutools is an excellent work tool.
Now, I'm working on an Excel document that I need make some changes too. It's an important document, include all of students and it has many worksheets, so I will use kutools to turn my task more easier and faster.
Thank you for this great tool.
I have been using KUTools for Word for several months now and simply cannot do without it. It is the best tools for Word, for sure!
I am an officer, I often use Office for my work and the tool (Kutools) is very useful for me.
I can save a lot of time on many Word and Excel operations. Ex: you can spit last-mid-first name very easily by some mouse-click (If only use Excel without add-in as this tool, you need to combine "RIGHT", "LEFT", "MID", "FIND" or "SEARCH" functions to split name),.....
I really like it, five star!
From Thanh Nhan, an officer from VN
Wonderful software to improve productivity, save time and make more money in the process.
KuTools for Outlook is the best add-on for Outlook that I have found, and I have looked at a lot of add-ons. KuTools extends Outlook greatly and makes me more productive. I cannot imagine using Outlook without KuTools.
- Jeffrey Wisniewski
Мне не нужно много писать, вы лучшие в своём деле, я всем рекомендую только вас , спасибо вам !!!
Ku Tools for Word, Ku Tools for Excel, and Office Tabs are the very best tools in my software library. I use them every single day, because hey are all filled with tools that are guaranteed to at least double your productivity, when you are working in either Word or Excel.
These tools are worth their weight in gold and besides my personal experience, now I will share my background, so you can trust my recommendation.
I have been teaching software applications for over twenty years, and spend 12 hours a day on the computer. Here are just a few of the applications:
As a chess master …
Once every three months I hold webinars where I teach my students how to use the high end features of high end chess database software.
As a financial analyst …
I use Excel to build templates, design business models, crunch numbers, and make projections.
As a published author …
I use Microsoft Word to write books, format the content to publish on Amazon, and have spent many hours customizing Word in order to multiply my productivity.
About two weeks ago, I counted the number of applications I’ve used in the last 6 months, and the total came to exactly 33.
I know software. Ku Tools is one of the best and most useful I’ve ever seen.
I am using KuTools for Excel. As a 70 year old I find some of Excel's functions very complicated & time consuming to work out how to use them.
Excel is an excellent program but with KuTools it becomes superb. KuTools make complicated tasks easy & also saves loads of time.
I recommended very highly.
Ed Burton - UK
Kutools Continues to add and improve on an already fantastic excel add-in. The latest 22.00 version release added multiple chart template Automations with just a button click. The charts come with examples on the correct use on how to shape your data to be able to use them in your reports for data analysis correctly
They Also expanded addition Routine functions for dates and times, a formula helper I been use Kutools add-in for years. I have the Excel, Word and outlook Kutoold add-in. Like the others this upgraded expanded excel add-in makes all my daily routines and reports quick to generate and more efficient and more productiveness.
Kutools is constantly expanding and improving and is a must have utility to add to your productivity tools. I highly recommend all the Kutools add-in’s.
This latest Excel version 22 is a must have. Thanks for a great set of tools that makes the daily routines in my job easier and more productive
Stephen
#recommendation #efficieny #Excel
I am a student of International Trade. So I work a lot on data especially HS codes which contain more than five thousand rows and descriptions!
After having used Kutools add-ins for Excel, I could remove a big burden from my shoulder! Kutools for Excel does make your life much easier and more efficient if you are "full time" Excel user! It really saves your time. Because it completes tasks within seconds that otherwise would take hours from you if you do manually!
Hats off to the developers and team!
Thanks!
I have used Office Tab for some years and it is great. I recently started using the Office Favourites and find them really useful to access any group of office files easily. However it is annoying that I seem to have to open an office application before accessing My favourites. Would it be possible to add a way to open favourites in the Office Tab settings App ?
Kutools is absolutely the business! It does all the stuff that Excel should do but can't! The functions are unbelievable and every time I discover another one it just makes me smile and laugh how handy it is. Well done to the dev's. And this is not a paid review either. It's just a bloody handy tool. Many thanks!
Just started using your product for excel and wanted to relay my appreciation. This thing is fantastic. Keep up the great work.