Kutools for Excel 7.5.5 (x86 + x64) + Crack

Kutools - Combines More Than 120 Advanced Functions and Tools for Microsoft Excel

Working with Microsoft® Excel®, you will suffer from repetitive operations, especially when dealing with charts, tables, reports and so on. If you are tired of searching lots of blank sheets and cells, or frustrated by renaming lots of workbooks one by one, Kutools for Excel is what you need right now. Besides the commonly used functions that Excel have, it enhances and adds more advanced functions for easily operating. For example, you can merge table and cells, remove blank cells, and batch operations with one click in Excel. Kutools for Excel is undoubtedly an incredible handy add-in to save your time and effort.



See how Kutools for Excel save your time in Excel 2013 / 2010 / 2007 / Office 365
The software is described below, arranged by the Ribbon group in which they appear.
Utilities locating in the Kutools tab:




Track Snap (Backup Current Workbook):
This utility has been renamed as Track Snap, which 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.
Navigation 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.
Work Area Size:
This utility has embodied 3 types of working area settings in your Excel. 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. It's quite handy when you need to quickly minimize or hide the status bar and the formula bar for a large working area. You don't need to toggle them off one by one.
Reading Layout View:
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 current cell. That will make it easier to check for data or enter data.
Show Columns:
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.
Show Worksheets:
Quickly toggle all hidden sheets visibility in current workbook. One click will toggle all hidden sheets to be visible, click again will toggle all hidden sheets to be invisible in current workbook.
Show / Hide
A collection of tools allow you to quickly show or hide the workbooks, worksheets and ranges.
Hide / Unhide Workbooks and Sheets:
Interactively hide or unhide multiple workbooks and worksheets at one time. Normally you have to hide or unhide the workbook and worksheet one by one in Excel. This is a handy tool for you to handle a large workbook with a bundle of worksheets.
View Options:
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.
Set Scroll Area:
It's a fantastic way to set or limit the scrolling area in your workbook. If you move around your worksheet a lot, or if you have data you don't want readers to explore, this tool is convenient for you to limit the visible area of your worksheet to only that which has actual data.
Hide Non-selected sheets:
It allows you to quickly hide all the inactive (non-selected) sheets in the active (current) 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 Ranges:
You can quickly unhide all the hidden ranges in active worksheet.
Unhide All Sheets:
Unhide all hidden sheets of active workbook with one click. Normally you have to unhide all hidden worksheets one by one in Excel.
Unhide All Windows:
Unhide all hidden workbooks with one click. Normally you have to unhide all hidden workbooks one by one in Excel.

Ranges and Cells Group

Range Converter:
A collection of utilities allow you to quickly process the following operations in ranges and cells.
Merge Same Cells:
Merge adjacent cells that contain the same value in a single column with one click. Please just select a single column, and click "Merge Same Cells", then all adjacent cells with same value will be merged.
Unmerge Cell:
This utility will unmerge the merged cells in a range with one click, and auto-fill each unmerge cell with the corresponding content from original merged cell.
Flip Horizontal Range:
Flip all cells in the selection horizontally with one click.
For example, if you have a row data, such as: 1, 2, 3, you can quickly reverse its order horizontally to 3, 2, 1.
Flip Vertical Range
Flip all cells in the selection vertically with one click.
For example, if you have selected a column, containing the number 1, 2 and 3, this utility will reverse the order vertically to 3, 2, and 1.
Transpose Table Dimensions:
With this handy Transpose Table Dimension utility, you can conveniently convert a cross (two-dimensional) table to a flat (one-dimensional) list at once, and vice verse.
Transform Range:
Quickly transform a vertical column into rows with multiple columns. For example, you may have a single column of data which contains your customer's information, and each customer consists of 5 rows information (such as, name, sex, Tel, Email and Address). With this tool you can transform the single-column of data into a five column data table.
Swap Ranges:
Quickly swap ranges, columns, rows and cells in your workbook. The ranges for swapping must be identical in the same size. For example, you can't swap two columns with one column. You can quickly swap the cells or ranges on the same worksheet, on different worksheets or different workbooks. The formatting of cells will also be swapped, and the swap operation does not affect the formulas in the two ranges, and they continue referring to the original cells.
Sort Range Randomly:
With this utility, you can quickly sort cells in a range randomly, to sort cells based on each row or column randomly, to sort entire row or column randomly, to randomly select cells, entire rows or columns.
Compare Ranges:
With this utility, you can quickly compare two ranges and select the same / duplicate cells or entire rows, different / unique cells or entire rows.
Prevent Duplicate:
This utility can prevent entering duplicate data in a single column with one click. This utility achieves the same function as Excel's Data validation feature, but you just need to select a single column and then apply this utility, then you cannot type in duplicate values in the same column.
Copy Ranges:
Normally Excel does not allow you to copy multiple selected ranges, but with this utility you can copy multiple selected ranges at once.
Content Converter:
A collection of tools allow you to you to quickly process the following operations.
Convert between Text and Number:
With this utility, you can quickly convert cell value between text and number. It can also convert values in cells that are preceded by an apostrophe to number.
Convert Formula to Text:
With this utility, you can easily convert formulas to text format. Disadvantage: It will convert all cells of range into text format. We will enhance it in new version for only converting formula cells into text format.
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. 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.
Currency Conversion:
It's a handy currency utility, which brings you a quick way to convert more than 50 currencies in your Excel by using the latest exchange rates from the reliable Internet website. You can easily convert a single value or volume values from a range cells, and get the latest exchange rates at any time by updating from the reliable website (requires Internet connection).
Unit Conversion:
Quickly convert measurements from one unit to another in your Excel. It supports the following measurements: Angle, Bits bytes, Distance, Energy, Force, Source, Volume, Mass, Liquid, Time and Temperature.
Spell Out Numbers:
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".
Change Sign of Values:
With this Excel utility, you can easily fix trailing negative signs; change all negative signs to positive; change all positive signs to negative and reverse the sign of all values. You don't need to use a formula for processing the above operations.
Advanced Combine Rows:
With this utility, you can quickly combine multiple duplicate rows into one record based on key columns, and it also can apply some calculations such as sum, average, count and so on for other columns.
To Actual:
Quickly 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.
Round (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.
Combine (Rows & Columns):
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).

Editing Group

Select Tools:
A collection of tools make the selection of various items easier in Excel.
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 Interval Rows & Columns:
With this utility, you can easily select specific number of rows or columns at a specified interval in a large worksheet. For example, you can quickly select three rows at two rows interval.
Select Merged Cells:
Select all merged cells in a range with one click. Please just select a range and click "Select Merged Cells", then all merged cells in this range will be selected.
Select Cells with Max or Min Value:
This tool does not only select the minimum or maximum value in a selected range of cells but also goes to the exact position of the minimum or maximum value. In Excel, you can use the MIN and MAX function to select the minimum or maximum value, but it cannot go to the exact position of minimum or maximum value.
Select Cells with Error Value:
Selects all cells on the active worksheet with formula that produce an error value (such as #DIV/0!, #N/A ).
Select Unlocked Cells:
With this utility, you can quickly select all unlocked cells from a range. Tip: please specify a range before applying this utility.
Select Specific Cells:
Selects cells or entire row from a specified range that meet certain criteria. Once selected, you can apply other operations (such as, formatting or delete) to the cells or entire row.
Select Cells with Format:
Selects cells with the same formatting from a range cells according to the formatting of the base cell or the base cell attributes. Normally you can use this tool to determine how many cells with the same formatting of the base cells. Once selected, you can change the font size or color of the selected cells.
Select Duplicate & Unique Cells:
This utility can help you quickly select the duplicate or unique values or entire rows from a column or a range.
Insert Tools:
A collection of insert tools.
Insert Titles Rows:
Sometime we may need to add a title for each row, such as Salary bill. This utility can quickly insert titles for rows.
Insert Blank Rows & Columns:
This handy tool will save your time, and make it convenient for you to quickly insert multiple blank rows or columns at specific interval at a time.
Insert Sequence Number:
Quickly insert a unique (and consecutive) value into a cell in Excel. You can add text prefix or suffix and specify the number of digits for the number. For example, you can easily insert a series number as Kutools-XXXX-2011 (XXXX indicates the sequence number).
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.
Insert Random Data
With this utility, you can easily process the following operations in a range cells for you. A. Insert a sequence of integers randomly; B: Insert or generate random date; C. Insert or generate password (random data strings); D. Insert or generate specified formatting data strings; E. Insert or generate a custom list.
Insert 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 overwrite 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 fixed value, such as 0.
Batch Insert Check Box:
With it, you can easily insert check box in a cell or range. Tip: If you select a range, it will insert check box into all cells of the range.
Batch Insert Option Button:
With it, you can easily insert option button in a cell or range. Tip: If you select a range, it will insert option button into all cells of the range.
Delete Tools:
A collection of tools allow you to quickly process the following operations.
Delete Blank Rows:
With this tool you can quickly delete blank rows in selected range, selected worksheets, active worksheets and all worksheets. Normally it's quite difficult to delete all blank rows in a workbook with too many worksheets in Excel, but with this tool you can get it done with one click.
Delete Hidden (Visible) Rows & Columns:
With this utility, you can quickly delete all blank rows or blank columns, hidden rows or hidden columns and visible rows or visible columns from selected range, selected sheets, active sheet or all sheets.
Delete Illustrations & Objects:
With this utility, you can:
1. Delete Charts
2. Delete Lines
3. Delete Pictures
4. Delete Auto shapes
5. Delete Smart Arts
6. Delete Text Boxes
7. Delete Embedded OLE Objects