Kutools for Excel: Powerful Excel Toolbox

s2smodern

Kutools for Excel: Powerful Excel Toolbox

Kutools for Excel is a powerful Excel toolbox that frees you from performing time-consuming operations in Excel. The toolbox has more than 200 powerful functions for Excel 2016, 2013, 2010, 2007 and Office 365.

Latest update: Kutools for Excel 17.00 Date: March 27, 2018	We welcome all questions, feedback and bug reports. We usually need the following information: Contact us A brief description of the issue and how it can be replicated (if applicable). Your Operating system (Windows 10, 8, Windows 7, etc) and the version information of your Microsoft Office. Screenshots that illustrate the problem - How do I take a screenshot? http://www.take-a-screenshot.org
Subscribe Update Newsletter:

Kutools for Excel Feature Tutorials:

You can quickly access the feature tutorials by typing in a feature name in the following search box. For example, if you want to know how to use the Reading Layout View, you just need to type in Reading keyword in the search box.

Select Cells with Error Value: Select cells with error values

Select Specific Cells: Select specific cells, rows, and Columns

Select Cells with Format: Select cells based on formatting

Select Unlocked Cells: Quickly select all unlocked cells

Select Unblank Cells: Easily select non-blank or non-empty cells

Select Duplicate & Unique Cells: Find duplicate or unique cells/rows in a range

Insert Titles Rows: Insert title rows into a range

Insert Blank Rows & Columns: Insert blank rows or columns every other rows / columns

Insert Date: Insert date with date formatting

Batch Insert Check Box: Quickly insert multiple checkboxes at once

Batch Insert Option Button: Quickly insert multiple option buttons at once

Insert Watermark: Quickly insert and remove watermarks

AutoText: Easily create and insert Auto Text entry

Insert Sequence Numbers: Create and insert unique sequence numbers

Find Missing Sequence Number: Quickly find and fill missing numbers in sequence

Fill Custom Lists: Create custom lists and fill cells with them

List All Combinations: Quickly generate/list all possible combinations of certain lists

Insert Bullet Or Numbering: Quickly Insert Bullets Or Numberings In Multiple Cells In Excel

Insert Random Data: Using random number generator to generate numbers and password

Fill Blank Cells: Fill blank cells with value above or 0

Delete Blank Rows: Remove or delete all blank rows from bottom / a range

Delete Rows & Columns: Delete blank or hidden rows (columns)

Delete Tools: Delete all charts, text boxes and embedded OLE objects

Delete Web Controls: Remove all html objects such as checkbox

Batch Delete Check Box: Remove / delete multiple checkboxes

Batch Delete Option Button: Batch delete option buttons

Remove All Macros: Remove all macros within worksheet or workbook

Batch Remove All Macros: Batch remove or delete all macros from workbooks

Remove Spaces: Remove spaces before / after text or remove extra spaces from text

Change Case: Change case of text to all caps, lower and proper

Subscript numbers in Chemical Formulas: Subscript all numbers in chemical equations correctly

Remove by Position: Remove or delete characters from beginning / end of text strings

Reverse Text Order: Reverse text string or words order

Replace Accented Characters: Replace multiple accented characters with regular chars

Extract Text: Quickly extract certain text from cells

Extract Email Address: Extract email address from text string

Add Text: Add the same text in a range of cells

Split Names: Split first, middle and last names

Split Cells: Quickly split cell contents by space or other delimiters

Delete Characters: Remove numeric, alphabetic, non-printable or alphanumeric characters from cells

Alternate Row / Column Shading: Shade every other row/column

Superscript / Subscript (Formatting): Format text as superscript or subscript

Apply Date Formatting: Apply date formatting to a range of dates

Copy Cell Formatting: Copy a cell formatting from one cell to other cells

Clear All Cells Formatting: Completely clear all formatting of a range cells

Convert Hyperlinks: Extract url links from hyperlinks or to convert plain text links to hyperlinks

Find and Break Broken Links: Find and break broken links (external references)

Delete Hyperlinks: Remove all hyperlinks of ranges, sheets and workbook

Kutools Calculator: Fetches values from cells for operations and paste results into cells

Operation Tools: Apply mathematical operations to a range without formula

Change Comment Shape: Change the shape of comment box

Cell Comment Tools: Modify multiple cell comments

Create Comment List: Quickly extract and list all comments to new worksheet or workbook

Format Comment: Quickly format all comments based on a comment

Find / Replace Comment Text: Quickly find and replace text in comments

Remove / Add User Name in Comment: Quickly change/remove/add author name in comments

Convert Comment and Cell: Quickly convert between cell contents and comments

AutoFit Comment: Automatically resize comment boxes to fit the contents

Formula Group:

Functions:

Count by Cell Color: Using a function to count / sum cells by fill or font color
Count Char: Count the occurrences of a character in a string
Extract Numbers: Extract numbers from mixed text string with function
Reverse Text: Easily reverse order of characters in a cell with functions
Sum by font bold: Quickly sum bold values / numbers only
Count by font bold: Easily count the number of only bold cells in a range
SUMVISIBLE: Easily sum/count/average visible cells, rows, or columns only

Formulas:

Add hours / minutes / seconds to date: Easily add hours /minutes / seconds to a datetime
Add years / months / days / weeks to date: Add years / months / days / weeks to date
Calculate age based on birthday: Calculate age by date of birth
Sum numbers in a cell: Sum all digits/numbers in a cell
Sum absolute values: Easily sum absolute values in a range
Look for a value in list: Quickly lookup a value and return a different cell from the table
Count weekends between two dates: Quickly count numbers of weekends/weekdays/specific day of week between two dates
Find nth occurrence of a character: Easily find position of nth occurrence of a character in text string
Count words in range: Quickly count the number of words
Find most common value: Quickly count the number of words
Remove time from date: Quickly Remove Time From Date Time Format Permanently

Exact Formula Copy: Copy exact formulas without changing cell references

Convert References: Convert cell reference to relative / absolute reference

Replace Range Names: Replace name in formulas with cell reference

Hide / Unhide Range Name: Easily hide or unhide named range

Error Condition Wizard: Replace formulas error messages with zero, blank cells, or customize text

Dynamically Refer to Worksheets: Quickly Fill cell references from multiple worksheets

Trace Precedents and Dependent: Quickly trace all dependents or precedents

Workbook and Sheets Group:

Workbook Tools

Split Workbook: Split or save each sheet / worksheet from workbook as one separate Excel file

File Format Converter: Convert multiple XLSX files to XLS or PDF files

Insert Workbook Information: Insert file name or path into cell / header or footer

Open Containing Folder: Open current directory / folder of active workbook

Copy Full Path: Copy and insert the active workbook file name and path

Auto Open Those Workbooks Next Time: Automatically open specified workbooks when Excel starts

Combine Worksheets:
1. Combine multiple worksheets / ranges from workbooks into one worksheet
2. Combine / merge all worksheets of same name across workbooks into one worksheet
3. Combine / merge worksheets or workbooks into one workbook
4. Summarize and calculate data from multiple worksheets into one worksheet

Worksheet Tools

Synchronize Worksheets: Synchronously select same cells in all worksheets

Sort Sheets: Sort or arrange sheets / worksheets alphabetically

Freeze Panes Multiple Worksheets: Freeze panes across multiple worksheets

Unfreeze Panes Multiple Worksheets: Unfreeze panes on multiple worksheets

Rename Multiple Worksheets: Rename multiple worksheets

Create List of Sheet Names: Create an index of sheets in active workbook

Copy Multiple Worksheets: Copy or insert multiple worksheets

Create Sequence Worksheets: Create a new workbook with customized worksheet names

Perpetual Calendar: Insert a monthly or a yearly calendar in Excel

Split Data: Split data into multiple sheets

Delete Blank Worksheets: Delete all blank worksheets with one click

Delete All Hidden Sheets: Delete all hidden worksheets with one click

Delete All Inactive Sheets: Delete all sheets except current / active one from workbook

Combine Workbooks: Merge multiple worksheets or workbooks into one workbook

Table Merge: Update Or Merge Tables By Matching Column From Two Worksheets / Workbooks

Export Range to File: Export or save a range as CSV, HTML and Workbook

Export Range as Graphic: Export range as image file

Export Graphics: Save and export charts graphs (pictures or shapes) as JPEG image files

Insert File at Cursor: Insert contents of CSV, Excel, Text or PRN files at cursor position

Filename List: Get and create a list of filenames in a folder or directory

Create Folders Based on Cell Contents: Create folders based on cell values

Print Multiple Workbooks Wizard: Print multiple workbooks from a directory

Print Multiple Selection Wizard: Print multiple ranges / selections into one page

Print Pages in Reverse Order: Easily print pages in reverse order

Insert Page Break Every Row: Quickly insert page break every x rows in Excel worksheet

Add Border to Each Page: Quickly add and print border around each page

Copy Page Setup: Copy and apply page setup settings from one worksheet to others

Paging Subtotals: Inserting and printing subtotals on each printed page

Print First Page of Each Worksheet: Quickly print first page of each worksheet

Import Pictures: Insert multiple pictures into cells and arrange them neatly

Match Import Pictures: Import pictures into cells based on cell value

Print Multiple Columns: Printing a list into multiple columns to fit on each printed page

Print Current Page: Print current printed page of active cell

Security Group:

Encrypt Cells: Encrypt and decrypt selected cell values or contents

Decrypt Cells: Encrypt and decrypt selected cell values or contents

Protect Worksheet: Protect multiple sheets / worksheets at a time

Unprotect Worksheet: Unprotect multiple worksheets / sheets at once

Create Mailing List: Easily Create Mailing List In Excel

Send Emails: Send Emails Based On Mailing List In Excel

Filter & Statistic Group:

Count by Color: Calculate cells value based on cell background or shading color

Paging Subtotals: Inserting and printing subtotals on each printed page

Advanced Sort: Easily sort data by last name / month / frequency / text length

Super Filter: Filter data based on cell value with multiple criteria

Filter Bold: Filter All Cells By Bold Characters

Filter Italic: Filter All Cells By Italics

Filter Strikethrough: Filter Cells With Strikethrough

Filter Comment: Filter All Cells With Comments

Filter Formula: Filter All Cells Which Containing A Formula

Filter Merged: Filter Merged Cells

Special Filter:
Filter Cells By Uppercase / Lowercase
Filter Cells By Text Length
Filter Cells By Workday/Weekend/Specific Day Of The Week
Filter Cells By The Font Color
Filter Cells By The Background Color

Paste into visible range: Copy data and paste into only visible cells / filtered list

Selection Lock: Easily configure cells to be locked or unlocked

Selection Unlock: Easily configure cells to be locked or unlocked

Highlight Unlocked: Quickly highlight / color all unlocked cells

Formulas Hide: Quickly hide or unhide formulas

Formulas Unhide: Quickly hide or unhide formulas

Highlight Hidden: Quickly highlight cells with hidden formulas

Highlight Formulas: Quickly highlight all formula cells

Highlight Names: Quickly highlight all named ranges

Show Headers: Quickly hide and show column and row headers

Show Formulas: Easily show or display all cell formulas

150 Comments
RSS
Login

Sort by Newest
- Best
- Popular
- Newest
- Oldest

You are guest ( Sign Up? )

or post as a guest, but your post won't be published automatically.

People in conversation:

Loading comment... The comment will be refreshed after 00:00.

To post as a guest, your comment is unpublished.
Joseph Naill · 2 days ago
Can you select a range of worksheets or specific worksheets from the navigation pane?
- Reply
- Share
To post as a guest, your comment is unpublished.
jerome · 10 days ago
Hello.
Please is there a way to remove duplicates only if they are subsequent? And making it to count from 1 again once there is a break.
I tried the select duplicates feature but it does not start to count again after a break. It recognizes if the value was counted before. Please help. Thanks
- Reply
- Share
To post as a guest, your comment is unpublished.
Alessandro Tieghi · 2 months ago
Kutools do not start when excel starup
- Reply
- Share
- To post as a guest, your comment is unpublished.
  Jay Chivo · 2 months ago
  
  Hello,
  Please go to check your Excel add-ins manager. Please go to download and install the software with the EXE installation package.
  BTW, Please don'r post such question here. We will not answer you quickly. Please contact us with the email.
  
  Reply
  
  Share
To post as a guest, your comment is unpublished.
Simon Greenwood · 2 months ago
Every time I try to use the Kutools plugin for Excel, it crashes. Excel simply closes down. Is this a known issue? Is there a solution? Thanks. Si
- Reply
- Share
To post as a guest, your comment is unpublished.
Damodar · 2 months ago
Is there an issue of using the Right Mouse Button with Kutools Add-in in Office 365
- Reply
- Share

← Previous
1
2
3
4
...
19
Next →

Login to your account

Password Reset

Reminder