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 16.00
Date: February 16, 2017
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.

 Note: After the installation, please open your Excel application, and you will see features and commands as shown in above screenshot.

arrow blue right bubble View Group:

Track Snap (Backup Current Workbook): Temporarily backup current workbook at any time
Navigation Pane: List all sheets, workbooks, columns and names
Advanced Find and Replace: Easily find and replace in multiple worksheets and workbooks
Work Area Size: Change working area size quickly
Reading Layout View: Easily reading / viewing a large number of rows and columns
Show Columns: Toggle all hidden columns to be visible or invisible
Show Sheets: Toggle all hidden sheets to be visible or invisible
Hide / Unhide Workbooks and Sheets: Hide or unhide workbooks and worksheets
View Options: Toggle workbook and worksheet settings
Set Scroll Area: Set scroll area (hide unselected columns and rows at once)
Hide Non-selected sheets: Hide all inactive (or all not-selected) worksheets
Hide Inactive Windows: Hide other workbooks (all inactive windows)
Unhide All Ranges: Unhide all rows and columns
Unhide All Worksheets: Show all hidden worksheets
Unhide All Windows: Unhide all hidden workbook windows

arrow blue right bubble Range and Cells Group:

Adjust Cell Size: Set row height or column width in inches, pounds, centimeters or pixels
Merge Same Cells: Merge adjacent cells in a column with same data / value
Unmerge Cell: Unmerge cells and fill down values
Flip Horizontal Range: Flip (reverse) data order of columns or rows
Flip Vertical Range: Flip (reverse) data order of columns or rows
Transpose Table Dimensions: Convert 2-dimensional / cross table to list
Transform Range: Transpose (convert) a single column or row to ranges
Swap Ranges: Swap rows, columns or ranges
Sort Range Randomly: Sort or select cells, rows and columns randomly
Compare Cells: Easily compare two ranges of cells if they are equal or different
Select Same & Different Cells: Comparing two ranges to select duplicate or unique values
Prevent Duplicate: Prevent duplicate entries in a column
Prevent Typing: Easily prevent special or certain characters from being typed in cells
Only allow specific characters to be entered in a range of cells
Copy Ranges: Copy multiple selections or ranges
Convert between Text and Number: Convert / force text to number or number to text
Convert between Roman and Number: Convert between roman numerals and numbers
Convert Formula to Text: Quickly convert cell formulas to text strings
Convert Text to Formula: Quickly convert text string to formula
Convert to Date: Identify and convert date format
Convert Time: Convert time to seconds / minutes / hours
Currency Conversion: Convert currency (USD to EURO / USD to GBP)
Unit Conversion: Convert measurement units
Conversion of Number Systems: Convert between different number systems without using formula
Spell Out Numbers: Convert or spell out a number into English words
Change Sign of Values: Change signs of numbers (Fix trailing negative signs / Change all negative values to positive)
Advanced Combine Rows: Quickly combine rows based on same value
Convert Number to Ordinal: Quickly convert numbers to ordinal numeral
To Actual: Replace formulas with calculated values / results in cells
Round (Without Formula): Round cell values without formula
Combine (Rows & Columns): Combine (merge) multiple columns or rows

arrow blue right bubble Editing Group:

Select Range Helper: Select, deselect, and reverse multiple ranges
Select Interval Rows & Columns: Select interval (every other) rows or columns
Select Merged Cells: Find and select merged cells
Select Last Cells: To select last cell of used range or last cell with data of last row or column
Select Cells with Max or Min Value: Select max or min (smallest or greatest) value cell
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

arrow blue right bubble 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

 Note: The features and commands are located at Enterprise tab.

arrow blue right bubble 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
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

arrow blue right bubble 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

arrow blue right bubble 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
Paste into visible range: Copy data and paste into only visible cells / filtered list
arrow blue right bubble Please click on the Worksheet Design to activate the worksheet design tab.

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

Comments  

Permalink +2 Chris Chambers
Is there is a version of this plugin for use on Macs?

c
2014-07-13 01:53 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting Chris Chambers:
Is there is a version of this plugin for use on Macs?

c

Sorry, we don't have a version for Mac. :-)
2014-09-13 02:45 Reply Reply with quote Quote
Permalink +1 Jeremy
Please please pleeeeease make a version that runs on OSX, I would buy all of your products and love you forever. Seriously though, this is a great excel add-in, even if you know formulas/macros to do everything, kutools makes it so much faster and easier.
2014-07-24 15:32 Reply Reply with quote Quote
Permalink +3 David Borean
I am leaving the company I am with and Kutools is installed on their computer. Can you remove it from their computer and I reinstall it on the computer at my new compnay-for free? Keeping the same license?
2014-07-24 19:50 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting David Borean:
I am leaving the company I am with and Kutools is installed on their computer. Can you remove it from their computer and I reinstall it on the computer at my new compnay-for free? Keeping the same license?

Yes, you can install it in your computer with same license.
2014-09-13 02:49 Reply Reply with quote Quote
Permalink 0 Woza
Hi there - I love the add-in but wanted to know why the navigation pane opens up every time I open an excel file. I'd like to opt in manually rather than have it open up every time. Is there a way to manually activate so it doesn't open up by default?
2014-08-04 04:28 Reply Reply with quote Quote
Permalink 0 admin-jay
:-) Hello,

You can disable the Navigation Pane by clicking on Kutools > Navigation. It will not automatically open again after that.
2014-08-04 08:02 Reply Reply with quote Quote
Permalink 0 Jim Stinson
I still have not figured out what this is supposed to do. Got any ideas?
2014-08-18 05:03 Reply Reply with quote Quote
Permalink 0 admin-jay
Hello, please contact me with your issue at jaychivo#extend office.com
2014-08-18 06:46 Reply Reply with quote Quote
Permalink 0 Rajesh
whenever i click on text tools on Kutools Menu it says Kutools for excel is loading and no window opens as shown in help.please let me know
2014-08-21 12:36 Reply Reply with quote Quote
Permalink 0 admin_jay
:-) Please contact me at jaychivo#extend office.com, please replace # with @.
2014-09-13 02:32 Reply Reply with quote Quote
Permalink 0 admin-jay
Hello, please uninstall the software from Control Panel.

and to reinstall the software by using EXE installation package.
2014-08-22 05:39 Reply Reply with quote Quote
Permalink 0 Shahari
Hi, I'm trying to batch convert my xls files to pdf using the file format converter option, but even after adding the files that require to be converted and I press okay, the screen remains there without converting any files. Please assist.
2014-09-12 02:18 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting Shahari:
Hi, I'm trying to batch convert my xls files to pdf using the file format converter option, but even after adding the files that require to be converted and I press okay, the screen remains there without converting any files. Please assist.

Hello, please uninstall the software from Control Panel.

and to reinstall the software by using EXE installation package.
2014-09-13 02:36 Reply Reply with quote Quote
Permalink 0 Ashwin
I wish that: Workbook Split window should have[/b
(1) facility to organise worksheet names alphabatically or as displayed in workbook.
(2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.
2014-09-12 06:15 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting Ashwin:
I wish that: Workbook Split window should have[/b
(1) facility to organise worksheet names alphabatically or as displayed in workbook.
(2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.


You can get it done as follows:
2014-09-13 03:41 Reply Reply with quote Quote
Permalink 0 Ashwin
I do not have any checkbox near "Worksheet Name". Perhaps I have got older version 7.0 installed on my machine. That is why I aksed you for updating to new version without Admin Account (in my another query.) but as you say, Admin Account is a must, I will have to do without older version.

Anyway, thanks,
Regards,
Ashwin

Quoting admin_jay:
Quoting Ashwin:
I wish that: Workbook Split window should have[/b
(1) facility to organise worksheet names alphabatically or as displayed in workbook.
(2)facility to Select All/Deselect All Worksheet. (it becomes difficult to select a single worksheet from many withing a Workbook.


You can get it done as follows:
2014-09-13 07:36 Reply Reply with quote Quote
Permalink 0 Ashwin
I have installed my registered version on a system which requires Admin access for updating/instal ling. I do not wish to bother my Admin every time I update the software. Any solution?
2014-09-12 06:19 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting Ashwin:
I have installed my registered version on a system which requires Admin access for updating/installing. I do not wish to bother my Admin every time I update the software. Any solution?

Sorry, the installation requires Admin account. :-)
2014-09-13 02:43 Reply Reply with quote Quote
Permalink 0 Yitzhak
I'm trying to get a list of exe files from a directory but I get this message :"There are more than 10000 files in the directory , please specify other directory. "

Is there any other way to get the list of files ?
2014-09-16 15:53 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting Yitzhak:
I'm trying to get a list of exe files from a directory but I get this message :"There are more than 10000 files in the directory , please specify other directory. "

Is there any other way to get the list of files ?

Hello, we will try to enhance this feature in upcoming versions.
2014-09-17 05:50 Reply Reply with quote Quote
Permalink 0 SueB
Hi Am using the Kutools Content Converter > Advanced Combined Rows> Key Column (A) - B to H Combined Operations > Only Combine with Separator > New Line. When the function has finished most dates within the columns convert to US dates (want UK dates i.e. 18/09/2014 (18th September 2014). Using the Date Conversion function appears not to apply anything at all.

Any ideas what the problem may be?? Please advice
2014-09-18 10:26 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting SueB:
Hi Am using the Kutools Content Converter > Advanced Combined Rows> Key Column (A) - B to H Combined Operations > Only Combine with Separator > New Line. When the function has finished most dates within the columns convert to US dates (want UK dates i.e. 18/09/2014 (18th September 2014). Using the Date Conversion function appears not to apply anything at all.

Any ideas what the problem may be?? Please advice

:-) Hello, please try to contact me at jaychivo#extend office.com with your sample data.

Please replace # with @.
2014-09-19 07:15 Reply Reply with quote Quote
Permalink 0 Sam,
I need to use the format tools function for all cells in a workbook. I have 40 spreadsheets. Can the formatting - including cell width be copied?
2014-09-22 16:42 Reply Reply with quote Quote
Permalink 0 C. Manzano
I have a field with data to separate into three different fields.

Last Name, First Name, Middle Initial (all in one)

Some records no not have middle initial.

Does anyone know if I can do it using this great tool?

Thanks,
C. Manzano
2014-09-22 18:21 Reply Reply with quote Quote
Permalink 0 andy
on the enterprise /combine tab, is it possible to edit a saved scenario, for the addition of an extra worksheet rather than have to type everything in again? Excel 2013
2014-09-23 04:06 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting andy:
on the enterprise /combine tab, is it possible to edit a saved scenario, for the addition of an extra worksheet rather than have to type everything in again? Excel 2013

Yes, you can. Please try to upgrade to the latest version.
:-)
2014-09-24 02:37 Reply Reply with quote Quote
Permalink 0 Manobala
How to auto increment after x amount of rows using kutool?

example:
A B
1 1 3
2
3
4 3
5 6
6
7 5
8
9 9
10 7

In A column I have incremented with the interval of 2rows and in B column 3rows.

How to do with Kutools?


Thanks!
2014-09-23 10:44 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting Manobala:
How to auto increment after x amount of rows using kutool?

example:
A B
1 1 3
2
3
4 3
5 6
6
7 5
8
9 9
10 7

In A column I have incremented with the interval of 2rows and in B column 3rows.

How to do with Kutools?


Thanks!


Please take a look at: http://www.extendoffice.com/product/kutools-for-excel/excel-fill-blank-cells.html

If that is no the feature you are looking for, please try to contact me at jaychivo#extend office.com. Please replace # with @.

:-)
2014-09-24 02:28 Reply Reply with quote Quote
Permalink 0 Venkat
Hi i have a spanish excel file.
My requirement is to translate the complete content to english.
Right now i couldnt see any translation option.Please advice.
2014-09-24 05:39 Reply Reply with quote Quote
Permalink -1 admin_jay
Quoting Venkat:
Hi i have a spanish excel file.
My requirement is to translate the complete content to english.
Right now i couldnt see any translation option.Please advice.

Hello, Please try to create some sample data in a workbook, and send it to me at jaychivo#extend office.com, please replace # with @.

Please tell me what do you want to accomplish. :-)
2014-09-28 02:06 Reply Reply with quote Quote
Permalink 0 Alan Downie
I see there is an option to change range name to their corresponding cell references. Is there a way to change cell references, i.e.A1,A2 etc. to their corresponding names i.e, REV_WK_TOT etc. in formulae. I have a horizontal row of cells containing formulae using cell references. I later created unique names for each cell and want to convert all the cell references to their names. I have several thousand formulae to convert
Kind regards in advance
Alan
2014-09-28 01:57 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting Alan Downie:
I see there is an option to change range name to their corresponding cell references. Is there a way to change cell references, i.e.A1,A2 etc. to their corresponding names i.e, REV_WK_TOT etc. in formulae. I have a horizontal row of cells containing formulae using cell references. I later created unique names for each cell and want to convert all the cell references to their names. I have several thousand formulae to convert
Kind regards in advance
Alan

Hello Alan, we don't have such feature or utility right now. :-)
2014-09-28 02:19 Reply Reply with quote Quote
Permalink 0 Joel
If I purchase and install will functionality only work on my computer that I would like other to see after everything has been calculated?
2014-10-10 13:42 Reply Reply with quote Quote
Permalink 0 chris74
Hi can you help please.
I am trying to use the "fill worksheet references" tool. But it will not fill with a subtotal value that is calculated from a sheet. What do I need to do to overcome this issue? Thanks. E.g
Worksheet 1
A B C D
Item quantity x rate = total
Insulation 50 £2.50 £125.00
Insulation 50 £2.50 £125.00
Insulation 50 £2.50 £125.00
Insulation 50 £2.50 £125.00
Subtotal £500.00 (I want this cell total to auto fill list from each sheet on to the master sheet) e.g
Work sheet 1 - £500.00
work sheet 2 - £750.00
work sheet 3 - £750.00
2014-10-21 15:36 Reply Reply with quote Quote
Permalink 0 Richjobur
I'm not sure if Kutools will do this for me but I need a utility to expand cell contents containing a range indicated by a hyphen. Cell contents would be for example "7-11". For vertically represented columns the utility would expand the "7-11" so that "7", "8", "9", "10" and "11" would each be in a single cell in a column.
2014-10-23 19:06 Reply Reply with quote Quote
Permalink 0 Yoseph
It is really helpful.
Thanks
2014-10-24 07:57 Reply Reply with quote Quote
Permalink 0 Kent
Hi:

I have 50 worksheets with a piece of data in A42 on each spreadsheet. How do I use KU Tools to get the piece of data on A42 from all of my worksheets to show up on one page?
2014-10-27 19:58 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting Kent:
Hi:

I have 50 worksheets with a piece of data in A42 on each spreadsheet. How do I use KU Tools to get the piece of data on A42 from all of my worksheets to show up on one page?

Hello, please try the Fill Worksheet Reference. For more information about how to use it, please visit: http://www.extendoffice.com/product/kutools-for-excel/excel-fill-cell-reference.html
2014-10-28 06:17 Reply Reply with quote Quote
Permalink 0 mohit
Hi. I have just installed this tool today. It successfully installed and the kutools tab appears but it's not working. Whenever I click on any function tab inside the tool, a small error window shows up.
2014-10-29 07:36 Reply Reply with quote Quote
Permalink 0 admin_jay
Quoting mohit:
Hi. I have just installed this tool today. It successfully installed and the kutools tab appears but it's not working. Whenever I click on any function tab inside the tool, a small error window shows up. I am attaching the screenshot here :

Please tell me the version information of your Office and computer system by sending email to jaychivo#extend office.com. Please replace # with @.
2014-10-29 08:07 Reply Reply with quote Quote
Permalink 0 Peter
How do you protect formulas? I did a Protect Worksheet but then it wouldn't allow any data entry into non-formula cells.
2014-10-30 16:26 Reply Reply with quote Quote
Permalink 0 Peter Pardoe
Hi, is it possible to conbine a .xlsx workbook into a .xlsm workbook?
Thanks
Peter
2014-11-04 14:56 Reply Reply with quote Quote
Permalink 0 Dave
Hello,

I'm running both Excel 2010 and 2013. I'm trying to view two workbooks side by side. The option is available in 2010, but not in 2013. Is there a setting that I have to set in 2013?

I'm running Windows 7, Office 2010 & Office 365.

Thanks,
2014-11-06 12:32 Reply Reply with quote Quote
Permalink 0 Yves Delafonteyne
Hi,

Can I call Kutools commandos in my VBA modules.
Something like :
call kutools_commando

Thanks,

Yves
2014-11-08 10:15 Reply Reply with quote Quote
Permalink 0 Gordon
I noticed that when I protect worksheets, opening them in other computers will not permit to do simple formatting, such as freeze panes, the entire ribbon is greyed out, well most of it.
2014-11-14 19:36 Reply Reply with quote Quote
Permalink 0 FAWAD
Hi,
I am using KU Tool for excel for import of image and matching them with JPEG files in Desktop. However it does not skip pictures of images not found in the folder.
2014-11-24 14:29 Reply Reply with quote Quote
Permalink 0 Greg
There is an error in the calculations when using the "Operation / Multiplication" function. It rounds to 2 if you select a column and if you do multiple selections (holding the Ctrl Key) it miscalculates all of the fields after the initial area selected. This function worked fine about two upgrades ago. Having to use ASAP Tools right now, but prefer Kutools when it worked.
2017-04-13 15:35 Reply Reply with quote Quote
Permalink 0 Adam Dicker
So i have this file with numbers in column n B and an image path in column I.
What I want to do is have the files in column I rename themselves to the files in column B

example column b is 34567 , column I is some image URL bit I want the name of the image to match the newly formed column which in a perfect world would download all files and rename this file to 34567.jog and save all files in one folder after being renamed.

Any help would be great!
Adam
2017-04-26 03:25 Reply Reply with quote Quote
Permalink 0 Admin_jay
Quoting Adam Dicker:
So i have this file with numbers in column n B and an image path in column I.
What I want to do is have the files in column I rename themselves to the files in column B

example column b is 34567 , column I is some image URL bit I want the name of the image to match the newly formed column which in a perfect world would download all files and rename this file to 34567.jog and save all files in one folder after being renamed.

Any help would be great!
Adam


Sorry, we don't have such function yet. :)
2017-05-02 02:46 Reply Reply with quote Quote
Permalink 0 Tony
I'm working on Solid Edge files with embedded excel files but when I try to edit an embedded excel file the active cell jumps from the embedded file to a separate excel workbook I have open. Can you tell me how to stop this?
2017-05-01 14:03 Reply Reply with quote Quote
Permalink 0 Charles
I have requested 2 separate times for license retrieval and I have received no response. Is there a way to escalate this issue?
2017-05-02 18:49 Reply Reply with quote Quote
Permalink 0 Admin_jay
Quoting Charles:
I have requested 2 separate times for license retrieval and I have received no response. Is there a way to escalate this issue?

Please contact me with following informaiton via

Please send me the order id or the email address you use to place the order.

If you have purchased the software via PayPal, please send me the email address of your PayPal account.

Thanks in advance.
2017-05-08 01:38 Reply Reply with quote Quote
Permalink 0 Taylor
If I buy a license, do I get free updates to the software?
2017-05-03 20:20 Reply Reply with quote Quote
Permalink 0 Admin_jay
Quoting Taylor:
If I buy a license, do I get free updates to the software?

It's lifetime license with 2-year free update support. After the 2-year free update support, you cannot update to any new versions, but you can still use the software.
2017-05-08 01:39 Reply Reply with quote Quote
Permalink 0 Sam
I installed "Kutools For Excel 16.00" in Win10,and selected language Chinese,but when I open Excel2016 the language is still English,and there is no item in language lists(Help>Lang uages).the language folder (C:\Users\Publi c\Documents\Kut ools for Excel\Languages ) has many languages such as 简体中文[SimpChines e],Dansk[Danish ] etc.
Can you tell me what's the problem?
Any help would be great!
2017-05-04 10:12 Reply Reply with quote Quote
Permalink 0 Admin_jay
Quoting Sam:
I installed "Kutools For Excel 16.00" in Win10,and selected language Chinese,but when I open Excel2016 the language is still English,and there is no item in language lists(Help>Languages).the language folder (C:\Users\Public\Documents\Kutools for Excel\Languages) has many languages such as 简体中文[SimpChinese],Dansk[Danish] etc.
Can you tell me what's the problem?
Any help would be great!

This is very special issue. We will try to fix it in upcoming versions. It only happens under certain circumstance. :sad:
2017-05-08 01:40 Reply Reply with quote Quote
Permalink 0 AS
Hi - I have purchased license but i have not got any license code. I also checked my spam folder. Where will i get the code?
2017-05-09 09:07 Reply Reply with quote Quote
Permalink 0 Admin_jay
Quoting AS:
Hi - I have purchased license but i have not got any license code. I also checked my spam folder. Where will i get the code?

Please contact me via with your order information. We will resend you the license information.
2017-05-11 02:12 Reply Reply with quote Quote
Permalink 0 Sayb Sourchi
I have just installed this tool for Excel 2016, I have registered the product but cant use it at all.

everytime I try a function the excel sheet, shuts down and closes, I have tried to restart the computer, uninstall and reinstall and re-register the license code but no go.
can anyone help. do these guys have a support phone?
2017-05-09 14:54 Reply Reply with quote Quote
Permalink 0 Admin_jay
Quoting Sayb Sourchi:
I have just installed this tool for Excel 2016, I have registered the product but cant use it at all.

everytime I try a function the excel sheet, shuts down and closes, I have tried to restart the computer, uninstall and reinstall and re-register the license code but no go.
can anyone help. do these guys have a support phone?

Please try to contact me via with your order information. We will fix it for you.
2017-05-11 02:11 Reply Reply with quote Quote
Permalink 0 Mark Grosart
Hi - I'd like to use Kutools for Excel to prepare worksheets my customer can upload images to
The display of the images needs to be constrained to the cell, but when downloaded the full image downloads
1. Is this possible
2. I intend to use this for a large number of customers - do they all need to buy Kutools, or can I prepare a worksheet they complete?
Thanks
2017-05-15 08:28 Reply Reply with quote Quote
Permalink 0 Admin_jay
Quoting Mark Grosart:
Hi - I'd like to use Kutools for Excel to prepare worksheets my customer can upload images to
The display of the images needs to be constrained to the cell, but when downloaded the full image downloads
1. Is this possible > Sorry, we don't have such function.
2. I intend to use this for a large number of customers - do they all need to buy Kutools, or can I prepare a worksheet they complete? >> They don't need to install the Kutools for Excel.
Thanks


1. Is this possible > Sorry, we don't have such function.
2. I intend to use this for a large number of customers - do they all need to buy Kutools, or can I prepare a worksheet they complete? >> They don't need to install the Kutools for Excel.
2017-05-16 07:25 Reply Reply with quote Quote

Add comment


Security code
Refresh