Prevent Typing With this utility, you can quickly convert cell value between text and number. Editing Group Select Tools: A collection of tools make the selection of various items easier. Insert or generate specified formatting data strings; E. One click will toggle all hidden sheets to be visible, click again will toggle all hidden sheets to be invisible in current workbook. It enhances and adds more than 200 advanced functions for you to easily cope with various kinds of tasks in Excel.
This feature can remove the selected checkboxes at once. With this feature, you can quickly convert a range of Roman data to normal decimal numbers in bulk, and vice versa. Save your time from looking for where to toggle any of the above settings. Quickly swap ranges, columns, rows, and cells in your workbook. Link Tools: A collection of tools for hyperlinks and external references links. Re-run Last Utility: Quickly apply the utility of Kutools for Excel you have just launched before with one click.
Program Details Kutools for Excel program is developed by the company named Detong Technology Ltd. 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. Change Comment Shape: Quickly change the shape of all comments in Excel. How to uninstall KuTools for Excel? Workbook and Sheets Group Workbook Tools: A collection of tools allow you to quickly process the following operations in workbook. This utility can prevent entering duplicate data in a single column with one click. Apply Date Formatting: With this utility you can quickly change the date formatting of the selected range.
Once selected, you can change the font size or color of the selected cells. 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. Undoubtedly, this powerful and user-friendly add-in will save Excel users a mass of working time and greatly improve working efficiency. 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. If you need to open the same multiple workbooks every time in your Excel, this tool can really save your time. For example, it can insert page breaks after every 10 rows in bulk. With this handy feature, you can quickly freeze across all worksheets of the whole workbook at the same time.
Special Filter This feature supports multiple special filter criteria to help you filter easily. Copy Cell Formatting: To copy formatting from one place and apply it to another, you may use Format Painter. 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. 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. It frees you from time-consuming operations.
Delete Hyperlinks: Quickly convert hyperlinks in cells to plain text. You can easily specify the worksheet name by using: month names, day names, numerical sequence, a series, custom list and date in a range. With this utility, you can quickly get it done, and it will save much ink and paper. One click will show all hidden columns in the used range, click again will set all hidden columns to be invisible. Quickly open the folder which the active workbook stays in.
It's a fantastic way to set or limit the scrolling area in your workbook. You can delete all hyperlinks in: selected Range; active worksheet; selected worksheets and all worksheets. This utility helps you to quickly adjust the row height and column width in pounds, centimeters, inches or pixels. 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. Tip: If you select a range, it will insert checkbox into all cells of the range. For example, with this tool you can easily insert multiple worksheets —with the same data structure- from different workbooks into a single worksheet. For example, you can quickly create a file folder for each of employees by using their names to name the file folder.
Select a range that you want to split. 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. How to delete Kutools for Excel You may not notice there would still be leftovers of Kutools for Excel, for example, some read-only files automatically kept by the system or its registry entries, staying right in your drive, even if you have gone through correct process via Control Panel or its default uninstaller. This utility can help you delete all of the web controls with one click. It allows you to quickly hide all the inactive non-selected sheets in the active current workbook with one click.
Supper Filter: This utility supports quickly filtering the whole worksheet by combining multiple conditions. But with the installed, you can … Click the Menus tab to experience the classic style interface and find the Tools menu easily. It supports with one click to alphanumerically sort sheets. 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. It can apply to a range or the whole worksheet.