Note: After the installation, please open your Excel application, and you will see features and commands as shown in above screenshot.
 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 |
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 |
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 |
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. 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 |
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 |
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 |
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
c
Sorry, we don't have a version for Mac.
Yes, you can install it in your computer with same license.
You can disable the Navigation Pane by clicking on Kutools > Navigation. It will not automatically open again after that.
and to reinstall the software by using EXE installation package.
Hello, please uninstall the software from Control Panel.
and to reinstall the software by using EXE installation package.
(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:
Anyway, thanks,
Regards,
Ashwin
Quoting admin_jay:
Sorry, the installation requires Admin account.
Is there any other way to get the list of files ?
Hello, we will try to enhance this feature in upcoming versions.
Any ideas what the problem may be?? Please advice
Please replace # with @.
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
Yes, you can. Please try to upgrade to the latest version.
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 @.
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.
Kind regards in advance
Alan
Hello Alan, we don't have such feature or utility right now.
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
Thanks
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
Please tell me the version information of your Office and computer system by sending email to jaychivo#extend office.com. Please replace # with @.
Thanks
Peter
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,
Can I call Kutools commandos in my VBA modules.
Something like :
call kutools_commando
Thanks,
Yves
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.
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. :)
Please contact me with following informaiton via jaychivo
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.
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.
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.
Please contact me via jaychivo
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 jaychivo
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
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.
I do not understand your question, I use version 7.5 of Kutools.
Regards
Herman
Hello, you should try: https://www.extendoffice.com/product/kutools-for-excel/excel-insert-multiple-pictures.html
Hi, Im' sorry but this link doesn't answer in my question. I am using "match import pictures", but as you can see in photo from the bellow link, it load only the first photo with the same name/path and nothing else. Any solution for this please? Thanks.
https://www.dropbox.com/s/zhsp0h0y0oe2ert/example.jpg?dl=0
Please contact us via jaychivo
Also, I am finding that after a few uses of this function, Kutools and my other add-ins disappear. Is there a way to fix this?
Thank you,
I N
Please try to contact us via jaychivo
Please help me
Thanks
Marco
Please try to contact us with your order information via jaychivo
We will solve it for you.
Please try to contact us with your order informaiton. You can contact me via jaychivo
We will solve it for you.
Please try to use this formula: =IF(SUM(INDIREC T("B1"))>=$C$1, "",A2)
I am having one odd issue that maybe you could help with.
I have a sheet with data out to column w and almost 12,000 rows. I am splitting the data by a value of one of the columns and naming the sheets after the name of the data in those columns and it ALMOST works perfectly. Its splitting out all the data as it should into the properly named new sheets, but what is happening is I am getting about 30 sheets not named properly and named as the default sheet name. Those sheets have the data they should, but are just not taking the name of the column values like all the others. Is this just too big of an operation and it is having errors, or is there something I could do to the master sheet to help fix what may be happening because it seems to be the same data groups doing it each time.
Thank you!
I just installed the software and used your free trial and loved it.
Im trying to split the data into multiple worksheets and im only getting the new tabs and the header.. no data
didnt have this problem in the free trial version.
How do I resolve?
big project due Monday.. please help
Please try to create some sample data in new workbook and try it again.
If the problem persists with the sample workbook, please contact me via jaychivo
Please attach the sample workbook in your email.
i use your kutools a lot but currently we only use your very old version 5. We tried 6 but you changed the way photos are imported therefore you kindly helped us revert back to the old version.
My new laptop will not open up the user interface big enough for me to actually select the option the photos and the sizes therefore can no longer continue to use this version. I have seen the newest version is 16 so it has come a long way over the past few years. the newer version isn't as good as the older one with regards to the importing of the photos. but it is useable :)
please can someone contact me via my email address so i can call someone to explain what it is i am trying to do to see if i have missed the function. I end up getting duplicate photos at the end.
Thank you for your help.
Please contact us via jaychivo
Please try to reinstall the software. If the problem persists after installation, please contact me via jaychivo
I have a pivot table with multiple row fields wherein i have to look for a specific value. Is it possible to use Kutools and get data for these multiple row fields. I have mentioned an example below-
Status Count
Closed --- 2
Dev ---- 1
Live ----- 1
Open ----- 5
Test ---- 3
Live ----- 1
Dev ----- 1
In this case if we want to count total number of defects that were raised in Dev Environment then ideally the count should be 2 [ Closed-1+Open-1 ]. So can you please confirm if it is possible to calculate the total count using Lookup formula of Kutools. If yes, can you please assist on how this can be done ?
I love this product. Do you have a portable version that i could use at work?
Thank You,
Steve
Sorry, we don't have a portable version. :)
We just started a trial version yesterday & heavily used the 'Advanced Combine option' yesterday without issue. Today I'm having to submit the combine request twice before the function works.
Windows 10 running Excel 2016
Thank you
Can you get it done? If no, please try to contact us with the detailed information via jaychivo
I have problem to use Kutool Excel after purchase and when in open excel and try to use Kutool and Enterprise but excel shut down after click. Even I create new excel file but it's also the same. Delete, Download and install it's still same.