Cookies help us deliver our services. By using our services, you agree to our use of cookies.
Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Kutools for Excel 18.00 HOT

300+ Powerful Features You Must Have in Excel

Kutools-for-Excel

Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combine sheets quickly, merge cells without losing data, paste to only visible cells, count cells by color and so on. 300+ powerful features / functions for Excel 2019, 2016, 2013, 2010, 2007 or Office 365!

Read More Download Buy now

Office Tab 13.10HOT

Adding Tabbed Interface for Office

Office Tab

It enables tabbed browsing, editing, and managing of Microsoft Office applications. You can open multiple documents / files in a single tabbed window, such as using the browser IE 8/9/10, Firefox, and Google Chrome. It's compatible with Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365. Demo

Read More Download Buy now

Kutools for Outlook 10.00NEW

100+ Powerful Features for Outlook

Kutools-for-Outlook

Kutools for Outlook is a powerful add-in that frees you from time-consuming operations which majority of Outlook users has to perform daily! It can save your time from using Microsoft Outlook 2019, 2016, 2013, 2010 or Office 365!

Read More Download Buy now

Kutools for Word  8.90NEW

100+ Powerful Features for Word

Kutools-for-Word

Kutools for Word is a powerful add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It can save your time from using Microsoft Word / Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365!

Read More Download Buy now

Classic Menu for Office

Bringing Back Your Familiar Menus

Restores the old look and menus of Office 2003 to Microsoft Office 2019, 2016, 2013, 2010, 2007 or Office 365. Don’t lose time in finding commands on the new Ribbon. Easy to deploy to all computers in enterprises and organizations.

Read More Download Buy now

Kutools for Excel 4.00: More features and faster!

Date: April 18, 2012

We will continue to improve and add more functions and features to Kutools for Excel in the upcoming versions of the software. Free download the new version from here.

Note: if you would like to give us feedbacks about how the software can be improved or enhanced, please don’t hesitate to send E-mail to: sales@extendoffice.com.

1. Supports Windows XP system.

2. Extremely reduce the add-in loading time while Microsoft Office Excel starts up.

3. The following features have been enhanced in the aspect of processing huge data speed: all text tool's features (Change Case, Add Text…), Navigation Pane, Operation tools, Currency Conversion, Unit Conversion, Select Cells with Max or Min Value, Range Randomize Utilities and Insert Sequence Number.


arrow blue right bubbleNew features locating under Modify group:

1. Transpose Table Dimensions

This utility will transpose two-dimension table (a range) with row headings and column headings into one-dimension table or vice versa.

Note: the one-dimension table must contain three columns, the first column will be converted as the row headings of the two-dimension table, the second column will be converted as the column headings of the two-dimension table, and the third column will be converted as the data of two-dimension table.

kte-4.00-1

2. Flip Selected Cells

This utility will flip the selected cells.

For example, if you have selected a column, containing the number 1, 2 and 3, this utility will reverse the order to 3, 2, and 1.

kte-4.00-2

3. Fill Cells with Displayed Values

This utility will fill the cells of selected range by converting formulas to their calculated values and converting the values or formulas in selected cells to the way they are formatted.

For example, cell A1 with the value 03/21/2012 formatted as Wednesday. This utility will put Wednesday in cell A1.
For example, this utility will convert [=A2*(C19/12)] to the calculated value and use it to fill the cell.

kte-4.00-3

4. Inert blank Rows/Columns

This utility allows you to quickly insert specific number of blank rows or columns at a specified interval.

kte-4.00-4

5. Replace Accented Characters

This utility can quickly help you replace all accented characters at once. Normally you have to repeatedly use the find and replace function to replace multiple accented characters in Excel.

kte-4.00-5

6. Fill Blank Cells

This utility can quickly fill the blank cells as follows:

Fill the blank cells with above cell data, below cell data, left cell data or right cell data.
Fill the blank cells with linear values.
Fill the blank cells with fixed value.

kte-4.00-6


arrow blue right bubbleNew features locating under Select Tools group:

1. Select Range Helper

This utility includes the following three functions:

Union Selection: without holding down the CTRL key to quickly select multiple ranges.
Deselect Cells: to deselect cells from selected ranges.
Inverse Selection: to select the inverse selection of selected ranges.

kte-4.00-7

2. Select Interval Rows/Columns

This utility allows you to quickly select a specific number of rows or columns at a specified interval.

kte-4.00-8

3. Compare Ranges for Duplicate Values

This utility can help you compare two ranges and select the duplicate values or unique values between two ranges. Normally you can use the conditional formatting to select duplicate values, but it’s too complicated.

Note: the two comparing ranges must contain the same number of columns.

kte-4.00-9


arrow blue right bubbleNew features locating under Utilities group:

1. Copy Multiple Ranges

Normally you cannot copy multiple selected ranges in Excel, but with this utility you can copy multiple selected ranges at once.

kte-4.00-10

2. Adjust Cell Size

This utility helps you to specify the row height and column width in pounds, centimeters, inches or pixels. It can apply to a range or the whole worksheet.

kte-4.00-11

3. Create Folders based on Cell contents

This utility easily creates a lot of folders in a certain specified folder, based on the contents in selected cells.

kte-4.00-12


arrow blue right bubbleNew features locating under Worksheet Tools group:

1. Delete All Hidden Sheets

This utility can delete all hidden sheets from the workbook with one click.

kte-4.00-13


arrow blue right bubbleImproved features:

1. Interactive Hide / Unhide

Add Very Hidden option: you can set the sheet status as: Visible, Hidden and Very Hidden.

kte-4.00-14

2. Create Sequence Worksheets

Add Filled with Worksheet tabs color option: it will shade the sheet tabs with the colors in the cells of the selected range.

kte-4.00-15

3. Sort Sheets

Add Color Sort option: it can sort all sheet tabs according to their sheet tab color.

kte-4.00-16

4. Cell Comment Tools

Add Convert Tab: it can convert contents of cells into comments or convert comments into contents of cells.

kte-4.00-17

5. Replace Range Names

This utility will replace the name reference with the corresponding cell reference. In the new version, we redesign the utility interface. It can list all the name references in a list.

List all name references of the specified range:
List all name references of specified worksheet:
List specified name reference:

kte-4.00-20

Setting Center:

You can access the Setting Center of Kutools for Excel by clicking Start > All Programs > Kutools for Excel > Setting Center.

kte-4.00-21

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.

Feature Tutorials