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 300 powerful functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.

Latest update:  Kutools for Excel 23.00
Date: August 18, 2020
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 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.

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:

Super Find:
Find specific text strings only in the comments
Find specific text string only in cell value
Find specific text strings only in the formulas
Find cells which contain date type values based on criteria
Find numbers based on criteria
Search specific text values only in hyperlinks
Find all cells with specific cell formatting
Fuzzy Lookup: Find and replace the similar records from a list of cell values
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

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

Mailing Group:

Create Mailing List: Quickly create a list of recipients in an Excel table
Send Emails: Send personalized emails to multiple recipients in bulk

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
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.
  • To post as a guest, your comment is unpublished.
    Gourav · 20 days ago
    I tried using the split workbook function. It created a the workbook in CSV format as needed but changed the date format to UK format i.e. MM/DD/YYYY? Is there any way to change the default date format?
  • To post as a guest, your comment is unpublished.
    David Lynch 1 · 1 months ago
    how do I copy content of notes to adjacent empty cell

    I've just bought Kutools bcause I need to do this urgently

    thx

  • To post as a guest, your comment is unpublished.
    Jose · 2 months ago
    I've been trying to get a pop up notification once a certain cell has been modified, but so far I have not succeed.
    I have tried the following code but it only works after you manually modified the cell. If that cell changes because it is dependent of another cell, I won't get any pop up. Pleas help me.

    Private Sub Worksheet_Change(ByVal Target As Range)

    Dim xC As String
    Dim xWSName As String
    Dim xA As String
    xC = "C:C"
    xWSName = "Sheet1"
    xA = "A1"
    If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub
    If IsEmpty(Target) Then Exit Sub
    xNum = (Sheets(xWSName).Range(xA).Value)
    If (Target.Value) <> "" Then
    MsgBox Prompt:="Entry Signal ", Title:="Trading notification"
    End If
    End Sub
  • To post as a guest, your comment is unpublished.
    Tom · 2 months ago
    I am trying to copy a range from one tab and paste to another tab with hidden rows using the paste to visible feature but I cannot get it to work. Copying and pasting from the same tab works fine. Please advise.
  • To post as a guest, your comment is unpublished.
    Seyi · 2 months ago
    Hello.

    I have a question regarding the Super Filter feature.

    If i create a super filter that references columns T(Age) and along the line insert a new column before column T.

    The Age column automatically shifts to column U. However, the super filter does not automatically effect this change.

    Is there any workaround this?

    Thanks.
  • To post as a guest, your comment is unpublished.
    Aaron G · 3 months ago
    Bug? When using Distinguish Differences on a column, it does not add a blank row after every change. It does insert the correct number of rows (1 for each change in the column), however, when the changes are one row apart the blank rows are all added at the top of a newly made 'group' of changes.

    For example, I have a column with vendor names. It begins with 26 rows that say 3M. It adds one blank row above this name. Following that I have Advanced Affliates in one row, AG Layne in the next, and 9 rows of Amana Tool. Instead of breaking these apart with a row above each it places 3 rows above Advanced Affiliates and 'groups' the rows of these 3 vendors together. This is repeated throughout the sheet. When a vendor name takes up at least 2 rows in the column it seems to properly add a single row at the top of that group, but if that vendor only takes up one row it 'groups' it with the following vendor name(s) until one of the vendors takes up more than 2 rows, then adds multiple blank lines at the top of the 'group.'

    Here is an example showing how this looks in my sheet: https://i.imgur.com/WoWinn7.jpg
    This function is exactly what I need for my project, but it doesn't seem to be following the intended behavior of the function.

    p.s. I tried to register to comment, but never received the verification email. Posting as guest just to submit this potential bug.
    • To post as a guest, your comment is unpublished.
      Excelfans · 3 months ago
      Hello,
      We have send an email to aarong@charlesmcmurray.com.
  • To post as a guest, your comment is unpublished.
    Craig de Jager · 3 months ago
    I just want to count words in a cell or range of cells, similar to a word count in MS Word. How to please?

  • To post as a guest, your comment is unpublished.
    pathak · 3 months ago
    can i convert number in indian rupees format in words

  • To post as a guest, your comment is unpublished.
    theo · 3 months ago
    How do I turn off the highlighting of the current cell with the corresponding line and column? Thank you
  • To post as a guest, your comment is unpublished.
    Mai · 3 months ago
    I buy Kutools for excel of my computer. But after my computer broken, i can continue use to kutools on new computer??
    • To post as a guest, your comment is unpublished.
      Excelfans · 3 months ago
      Yes, you can.
  • To post as a guest, your comment is unpublished.
    Mike · 3 months ago
    I am trying out Kutools for Excel. I'm excited about the Reading Layout feature but it doesn't highlight the correct row. For example, when I click on C5 it highlights column C, and row 7. Additionally, when I tried to enable reading layout the dropdown was grayed out and nonfunctional. I could only use it after saving and closing the worksheet and reopening it. What can I do to correct this problem?
  • To post as a guest, your comment is unpublished.
    Jade · 4 months ago
    Hi
    When I used the Split workbook as .txt on Kutools Plus, it will add unwanted quotas on the exported text. I noticed this happened when the cells in excel contained commas. How can this be fixed?

  • To post as a guest, your comment is unpublished.
    m.sayed · 4 months ago
    Hi, is any translation in Arabic language?
    thanks.
  • To post as a guest, your comment is unpublished.
    Moeen · 4 months ago
    Is there a way to reverse the speedometer order so green goes to the right side and red goes to the left side?

  • To post as a guest, your comment is unpublished.
    Gilbert · 4 months ago
    I'm trying to convert text numbers and I have downloaded Kutoolls 20.00 which does not seem to have this function It sure does not have it in the area that the previous version had it. I'm sure it is still available but I do not know where to look for it. This is the only reason I would pay for this software as this is the only function that I use in excel that does not work for me.
  • To post as a guest, your comment is unpublished.
    Prashant · 5 months ago
    Dear Sir,
    can i send mail to following type.

    Example ----

    Dear #CustomerName#

    Your Account no. is #Account_number# debit balance is Rs. # Amount #. Please pay the immediately.

    Regards,
    XYZ

    this type of send wiz kutools excel. excel data is ready for me in column.
    if any tutorial please send me.
    Prashant
    prashant@ankurseeds.com
  • To post as a guest, your comment is unpublished.
    hassan.ismail0328@gmail.com · 6 months ago
    Hello, I am using windows 10 and office 2019. I install Kutools on my outlook ,then I started to have winmail to all the senders. If I use a fresh compose mail , it goes well . But if I use reply or forward it comes as winmail. I deleted all the names from my address book but still the same.

    I uninstall the Kutools , everything goes well.


    Please advise if there is any solution.


    Thank you.
  • To post as a guest, your comment is unpublished.
    jayaselvar@gmail.com · 6 months ago
    Sir, I need to convert multiple sentences into sentence case. Kutools is able to do that, but one problem: if I had intentionally capitalised the first letter of a word (for example, a proper noun such as Delhi), Kutools converts its Upper case into lower case. Delhi becomes delhi. This is not right. How to resolve this? Thank you.
  • To post as a guest, your comment is unpublished.
    Stephan Citteur · 6 months ago
    Hi, How can I add USL and LSL in the normal distribution chart for Excel
    The chart looks very nice but I can not add the 2 lines as I can add in a standard Excel scatter chart using NORM.DIST
  • To post as a guest, your comment is unpublished.
    Varun · 7 months ago
    can it work on ipads?
  • To post as a guest, your comment is unpublished.
    cy · 7 months ago
    how many computers can i install into if i purchase for one license?
  • To post as a guest, your comment is unpublished.
    efscottowens@gmail.com · 7 months ago
    pdf to excel
  • To post as a guest, your comment is unpublished.
    sowmissk · 7 months ago
    how to clear cell compare rules or modify the rules
  • To post as a guest, your comment is unpublished.
    sowmissk · 7 months ago
    Sir
    Just now i have downloaded your tools. but the a no "Compare Cells" the Ktools tab. how can i Use the feature
    • To post as a guest, your comment is unpublished.
      Excelfans · 7 months ago
      Hello,

      Please take a look at

      https://www.extendoffice.com/product/kutools-for-excel/excel-compare-two-cells-of-equal.html
  • To post as a guest, your comment is unpublished.
    Diderot · 7 months ago
    Greetings,
    I'm looking for an Excel encryption solution, among other needs, for my company and Kutools appears to fulfill the requirements [and then some]. The only questions I have is if there is either a) a way to trigger the cell encryption process programmatically or b) the encryption algorithm, keysize, and IV or salt is available for dissemination in order for someone to batch upload encrypted data to a spreadsheet, leaving the Kutools plugin to handle the decryption process.

    Thanks for your time,

    -Kevin
  • To post as a guest, your comment is unpublished.
    Ruth · 8 months ago
    How do I create a database using Kutools (Checkbox drop list) and make it accessible for others to capture information who do not have Kutools?
    Can I lock the worksheet to hold that facility?
    • To post as a guest, your comment is unpublished.
      Shafeeq · 6 months ago
      I have the same question, once I save and share the file it is not accessible by others...
      • To post as a guest, your comment is unpublished.
        Ruth · 6 months ago
        Hi Shafeeq, Kutools has to be bought for each individual computer for it to work.
        So in the end Kutools refunded me for my purchase of the upgrade and I went back to the older version.
  • To post as a guest, your comment is unpublished.
    carol · 9 months ago
    how do i put kutools on my excell I downloaded it
    • To post as a guest, your comment is unpublished.
      Heather · 8 months ago
      I have the same question. I have downloaded the paid version but how do I get it on my ribbon in Excel?
  • To post as a guest, your comment is unpublished.
    Michael · 10 months ago
    What is the easiest way to upgrade to the latest version of kutools if you cannot find your license code? Initially bought the program in 2015.
  • To post as a guest, your comment is unpublished.
    Cheila · 1 years ago
    Hi there, if I buy Kutools, will that be one off payment or is it a subscription and I have to renew it every year?
  • To post as a guest, your comment is unpublished.
    4-store · 1 years ago
    cerca vert
  • To post as a guest, your comment is unpublished.
    Jim · 1 years ago
    Ever since I downloaded the program my computer freezes up and then sometimes it stops all together. The problem went away after I uninstalled the program. Is there a fix for this
  • To post as a guest, your comment is unpublished.
    tomi.di.carta@gmail.com · 1 years ago
    hI, very very new user. downloaded and executed KUT, but if i open excel and then a file excel quits. Why?
  • To post as a guest, your comment is unpublished.
    michele · 1 years ago
    vevy very new user..if I open excel and then a file excel quits? what's wrong?
  • To post as a guest, your comment is unpublished.
    Stanley · 1 years ago
    Can i use kutools on my laptop and desk top with single user purchase?
  • To post as a guest, your comment is unpublished.
    Ruediger Krueger · 1 years ago
    Issues installing Kuhtools 20 on Windows 10. Trying .exe returned "Installation forbidden by system policy". Trying msi. returned error with data1.cab. and stopped installation. Please review the the installation files published.

    Thanks alot
  • To post as a guest, your comment is unpublished.
    Eric · 1 years ago
    Greetings, How do you enable ku tools plus?
  • To post as a guest, your comment is unpublished.
    Tim · 1 years ago
    Currency Rates do not update. It gives the following error; An error occurred while attempting to update the currency rates...
  • To post as a guest, your comment is unpublished.
    gene · 1 years ago
    I have 1000 csv files in a folder each with the same column format and headers (first Name, last name, title, address, city, state, zip, phone) with exactly 20 rows of information in each csv. Is there a way I can get those 1000 csvs to automatically copy/paste into one Master csv at the same time vs. opening each one individually and copy/paste? I have Kutools and KT Plus and I am not very technical nor a programmer.
  • To post as a guest, your comment is unpublished.
    Usman · 1 years ago
    i want to repeat kutool utility on selected data. ?
  • To post as a guest, your comment is unpublished.
    prince · 1 years ago
    after install this sw , how can i use this /
  • To post as a guest, your comment is unpublished.
    ian mcevoy · 1 years ago
    convert numbers to text selection
  • To post as a guest, your comment is unpublished.
    jungilwong · 1 years ago
    I cannot create the file "mals.mail" So I want to change the folder.
  • To post as a guest, your comment is unpublished.
    gray_b · 1 years ago
    Am I able to 'Highlight duplicate cells across a whole workbook. Comparing every worksheet to each other and every permutation
  • To post as a guest, your comment is unpublished.
    Eddie · 1 years ago
    I have just downloaded KuTools trial. However, your software is EXE. Which won't unzip on a Mac. Any ideas? Do you have a Mac version?
  • To post as a guest, your comment is unpublished.
    David Lark · 1 years ago
    Copy a defined range of cells in a row from a Worksheet to next blank row in a table in a subsequent worksheet
  • To post as a guest, your comment is unpublished.
    naredra · 1 years ago
    any update
  • To post as a guest, your comment is unpublished.
    narendra · 1 years ago
    hi
    i am not able to use this formula in windows10

    =DATEDIF(M89, N89, "y") &" years, "&DATEDIF(M89, N89, "ym") &" months, " &DATEDIF(M89, N89, "md") &" days" it showing #value!
    and same for this also
    =(MID(T88,4,2)&"/"&LEFT(T88,2)&"/"&RIGHT(T88,2))+0

    kindly help on it
  • To post as a guest, your comment is unpublished.
    Robs · 1 years ago
    Hi, I would like to export a range of data as CSV file with KuTools. But I have errors with the export as I use commas in the currency in the cells.
    So my question is if there is a possibility that KuTools will export my data to csv semicolon delimited.
  • To post as a guest, your comment is unpublished.
    Mark Martin · 1 years ago
    Hello. I just downloaded the Kutools for Excel and giving it a test run. Within one workbook I placed two sheets and I would like to be able to highlight the differences from one sheet to the other. Is this possible??
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 1 years ago
      Yes, we have such feature. Please use this feature, and select the whole worksheet as a range.
      https://www.extendoffice.com/product/kutools-for-excel/excel-compare-ranges,-rows-and-columns.html
  • To post as a guest, your comment is unpublished.
    Kevin · 1 years ago
    Recently installed kutools trial, having real issues with the viewing area when on my laptop with multiple displays and more than one workbook open. Shifting focus causes the viewing area to resize and jump around, if the navigation pane is open everything disappears. Impossible to work with. I thought it might be a conflict with Ablebits, which I have the enterprise version installed, but after uninstalling that and restarting the issue persists. I am using the most recent version of Excel 2019 on windows via a 365 subscription. Hoping this can be fixed as the features seem to be genuinely useful, but only if I can see my workbooks.
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 1 years ago
      Hello,
      Please don't try to post your issue here. This is not the support area. Please try to contact us via email or the forum for the fast support. Thanks. :)
      Please try this version https://download.extendoffice.com/downloads/Kutools-for-Excel/beta/KutoolsforExcelSetup.exe