for empty category blog or list

There are no articles in this category. If subcategories display on this page, they may contain articles.

See how Kutools for Excel save your time in Excel 2007/2010

The software is described below, arranged by the Ribbon group in which they appear.

shot-kutools-all-groups

View Group Range and Cells Group Editing Group Formula Group Workbook and Sheets Group Utilities Group

View Group

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 tool has embodied 4 types of working area settings in your Excel. 1. To minimize the Ribbon; 2. To minimize the ribbon and hide the status bar; 3. To minimize the ribbon, hide the status bar and the formula bar; 4. 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 Ribbon, status bar and the formula bar for a large working area. You don’t need to toggle them off one by one.

Toggle Settings:

With this tool 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.

Show / Hide

A collection of tools allow you to quickly show or hide the workbooks, worksheets and ranges.

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.

Interactive Hide / Unhide:

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.

Hide Inactive Worksheets:

It allows you to quickly hide all the inactive worksheets of the active workbook with one click.

Hide Inactive Windows:

If you have opened multiple workbooks in Excel, this tool allows you to quickly hide all the other inactive workbooks with one click.

Unhide All Ranges:

You can quickly unhide all the hidden ranges in active worksheet.

Unhide All Worksheets:

Unhide all hidden worksheets 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

Modify:

A collection of tools allow you to quickly process the following operations in ranges and cells.

Range Randomize Utilities:

With this tool you can easily process the following operations in a range cells for you. 1. Rearrange the selected cells in a random order; 2. Select a cell or multiple cells randomly; 3. Insert a sequence of integers randomly.

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

Change Sign of Values:

With this Excel tool 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.

Force Values in Cells:

Quickly specify a range cells or a cell in your worksheet to recognize the numbers you enter as numeric data. This sometimes occurs when data is imported from other sources. This tool also converts values in cells that are preceded by an apostrophe.

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.

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

Fill Cells with Displayed Values:

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.

Replace Accented Characters:

It is a handy time saver to replace all accented characters at once, without repeatedly finding and replacing each kind of accented character one by one in active workbook.

Flip Selected Cells:

It is a handy tool for you to reverse the number order in columns or rows quickly. For example if you have selected twenty cells in one row, containing the number 1, 2, 3… 19, 20. This Flip Selected Cells tool will reverse the number order to 20, 19, … 3, 2, 1.

Transpose Table Dimensions:

With this handy Transpose Table Dimension tool, you can conveniently convert a cross (two-dimensional) table to a flat (one-dimensional) list at once, and vice versa.

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.

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.

Text tools:

It embodies a lot of handy operations for you to manipulate the text in cells. You can easily change case of the text, add text to the beginning, end or at a specified character position of the text; remove characters from the beginning, end, or at a specified character position from the text; remove spaces from the text; remove characters of a particular type from the text.

Combine (Columns or Rows):

This tool augments Excel with a flexible way to combine columns and (or multiple 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).

Operation:

A collection of tools allow you to you to quickly process the following operations.

Operation Tools:

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.

Kutools Calculator:

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.

Currency Conversion:

It's a handy currency tool, 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.

Editing Group

Select Tools:

A collection of tools make the selection of various items easier.

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

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 Hyperlinks:

Quickly convert hyperlinks in cells to plain text. You can delete the hyperlink in: selected Range; active worksheet; selected worksheets and all worksheets.

Delete Tools:

A collection of tools allow you to quickly process the following operations.

Delete Charts:

Quickly delete all charts from an active worksheet, the selected worksheets and all the worksheets of active workbook.

Delete Lines:

Quickly delete all lines from an active worksheet, the selected worksheets and all the worksheets of active workbook.

Delete Pictures:

Quickly delete all pictures from an active worksheet, the selected worksheets and all the worksheets of active workbook.

Delete Auto Shapes:

Quickly delete all auto shapes from an active worksheet, the selected worksheets and all the worksheets of active workbook.

Delete Smart Arts:

Quickly delete all smart arts from an active worksheet, the selected worksheets and all the worksheets of active workbook.

Delete Text Boxes:

Quickly delete all text boxes from an active worksheet, the selected worksheets and all the worksheets of active workbook.

Delete Embedded OLE Objects:

With this tool you can quickly delete all embedded OLE objects from an active worksheet, the selected worksheets and all the worksheets of active workbook.

Delete Linked OLE Objects:

Quickly delete all linked OLE objects from an active worksheet, the selected worksheets and all the worksheets of active workbook.

Superscript / Subscript (Formatting):

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.

Alternate Row Shading:

Quickly apply shading 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.

Date Tools:

With this tool you can randomly insert a formatted date into a cell, or make a fast change the formatting of existing date. You can easily insert the date with the formatting, the date only or the formatting only with this tool.

Formula Group

Exact (Formula) Copy:

With this tool you can 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 $.

Convert References:

This tool will convert the notation of references to cells in the formulas in your selected range. You can:

Convert formulas to absolute referencing ($F$5)
Convert formulas to relative referencing (F5)
Convert formulas to relative rows and absolute columns ($F5)
Convert formulas to absolute rows and relative columns (F$5)

For example: [=F5*(G12/100)] becomes [=$F5*($G12/100)]

More Tools:

More tools for handling formulas in Excel.

Replace Range Names:

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.

Error Condition Wizard:

This tool is sophisticated 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.

Workbook and Sheets Group

Workbook Tools:

A collection of tools allow you to quickly process the following operations.

Merge Workbooks:

With this tool you can easily merge multiple workbooks into a single workbook, merge specified worksheets from different workbooks into a single workbook, and merge all the Excel files from a folder into a single workbook and more. You can set to merge or unmerge the blank worksheets and the hidden worksheets.

Split Workbook:

Easily split active workbook into individual Excel file (one file contains one worksheet), and each Excel file carries the name of the worksheet. You can set to skip all the blank and hidden worksheets.

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.

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.

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. If you need to open the same multiple workbooks every time in your Excel, this tool can really save your time.

Worksheet Tools:

A collection of tools allow you to quickly process the following operations.

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, charts, Excel 4.0 macro sheets, and dialog sheets in active workbook. It supports with one click to alphanumerically sort sheets.

Rename Multiple Worksheets:

Quickly rename multiple worksheets of the active workbook at one time. You can choose to rename multiple worksheets by using the worksheet names from a range cells.

Create List of Sheet Names:

With this tool you can quickly create a list of all worksheet names of the active workbook in a new workbook, which contains hyperlinks or macro buttons for quickly navigate to other worksheets.

Copy Multiple 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 cells that contain your worksheet names for the copied worksheets or the inserted worksheets.

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

Delete Blank Worksheets:

Quickly delete all the blank worksheets (included hidden worksheets) from the active workbook.

Perpetual Calendar:

This tool embodies following features:

Quickly insert a calendar picture of specified month in your current worksheet.
Quickly create a new workbook to lay out a specified month calendar (or 12 months), each worksheet contains one calendar month in the new workbook.

Import / Export:

A collection of tools allow you to quickly process the following operations.

Export Range to File:

Easily export a range of date to a file, either an Excel workbook, a CSV, a simple HTML or all formatting HTML.

Export Range as Graphic:

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.

Insert File at Cursor:

Quickly insert complete content of worksheet, text 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.

Filename List:

Microsoft Windows^® does not provide a way to print a list of the filenames 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 subdirectory and create hyperlinks to the filenames.

Printing:

A collection of tools allow you to quickly process the following operations.

Print Multiple Workbooks Wizard:

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.

Print Multiple Selection Wizard:

Quickly printing multiple non-contiguous ranges without a page break between ranges. Normally, when you print a multiple selection, Excel inserts a page break between each range in your selection. You can also rearrange the order of selections to be printed.

Copy Page Setup:

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.

Utilities Group

Utilities:

A collection of tools allow you to quickly process the following operations.

Remove All Macros:

Quickly remove any of the following macros from your workbook: VBA modules, UserForms, Excel 5/95 dialog worksheets, or Excel 4 XLM macro worksheets.

Cell Comment Tools:

This tool does not only allow you to change the appearance of all comments easily, but also embodies other enhanced Excel comment management features for you, such as list all commenets in a new workbook or worksheet, find and replace the text in comments, add or remove user name from comments and so on.

Re-run last utility:

Quickly apply the latest utility you have applied from Kutools for Excel.

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

for empty category blog or list

Kutools for Excel

e-Newsletter

See how Kutools for Excel save your time in Excel 2007/2010

View Group

Ranges and Cells Group

Editing Group

Formula Group

Workbook and Sheets Group

Utilities Group