Note: The other languages of the website are Google-translated. Back to English
登入  \/ 
x
or
x
註冊  \/ 
x

or

Kutools for Excel:強大的Excel工具箱

Kutools for Excel 是功能強大的Excel工具箱,可讓您免於在Excel中執行耗時的操作。 該工具箱具有適用於Excel 300、2019、2016、2013、2010和Office 2007的365多種強大功能。

最新更新:  Kutools for Excel 25.00
日期:08 年 2021 月 XNUMX 日
我們歡迎所有問題,反饋和錯誤報告。 我們通常需要以下信息: 聯絡我們
  • 問題的簡要說明以及如何復制(如果適用)。
  • 您的操作系統(Windows 10、8,Windows 7等)和Microsoft Office的版本信息。
  • 可以說明問題的屏幕截圖-如何拍攝屏幕截圖? http://www.take-a-screenshot.org

訂閱時事通訊:


Kutools for Excel功能教程:


您可以通過在以下搜索框中輸入功能名稱來快速訪問功能教程。 例如,如果您想知道如何使用 閱讀版式視圖,您只需要輸入 閱讀 搜索框中的關鍵字。

查看組:

跟踪快照(備份當前工作簿): 隨時臨時備份當前工作簿
導航窗格: 列出所有工作表,工作簿,列和名稱
高級查找和替換: 在多個工作表和工作簿中輕鬆查找和替換
工作區大小: 快速更改工作區大小
閱讀版式視圖: 輕鬆讀取/查看大量行和列
顯示列: 將所有隱藏的列切換為可見或不可見
顯示表: 切換所有隱藏的工作表以使其可見或不可見
隱藏/取消隱藏工作簿和工作表: 隱藏或取消隱藏工作簿和工作表
查看選項: 切換工作簿和工作表設置
設置滾動區域: 設置滾動區域(一次隱藏未選擇的列和行)
隱藏未選中的工作表: 隱藏所有非活動(或所有未選擇的)工作表
隱藏不活動的Windows: 隱藏其他工作簿(所有不活動的窗口)
取消隱藏所有範圍: 取消隱藏所有行和列
取消隱藏所有工作表: 顯示所有隱藏的工作表
取消隱藏所有窗口: 取消隱藏所有隱藏的工作簿窗口

範圍和像元組:

調整像元大小: 以英寸,磅,厘米或像素為單位設置行高或列寬
合併相同的單元格: 合併具有相同數據/值的列中的相鄰單元格
取消合併單元: 取消合併單元格並填寫值
翻轉水平範圍: 翻轉(反向)列或行的數據順序
翻轉垂直範圍: 翻轉(反向)列或行的數據順序
轉置台尺寸: 將二維/交叉表轉換為列表
轉換範圍: 將單個列或行轉置(轉換)為範圍
交換範圍: 交換行,列或範圍
隨機排序範圍: 隨機排序或選擇單元格,行和列
比較單元格: 如果它們相等或不同,則輕鬆比較兩個單元格範圍
選擇相同和不同的單元格: 比較兩個範圍以選擇重複值或唯一值
防止重複: 防止列中重複輸入
防止輸入: 輕鬆防止在單元格中鍵入特殊字符或某些字符
僅允許在一系列單元格中輸入特定字符
複製範圍: 複製多個選擇或範圍
在文本和數字之間轉換: 轉換/強制將文本轉換為數字或將數字轉換為文本
在羅馬和數字之間轉換: 在羅馬數字和數字之間轉換
將公式轉換為文本: 快速將單元格公式轉換為文本字符串
將文本轉換為公式: 快速將文本字符串轉換為公式
轉換為日期: 識別並轉換日期格式
轉換時間: 將時間轉換為秒/分鐘/小時
貨幣轉換: 轉換貨幣(USD轉換為EURO / USD轉換為GBP)
單位換算: 轉換測量單位
數制轉換: 在不使用公式的情況下在不同數字系統之間轉換
拼出數字: 將數字轉換或拼寫為英文單詞
更改值的符號: 更改數字的符號(修正尾隨的負號/將所有負值更改為正數)
高級合併行: 根據相同的值快速合併行
將數字轉換為序數: 快速將數字轉換為序數
到實際: 將公式替換為計算值/單元格中的結果
回合(無公式): 不帶公式的捨入單元值
合併(行和列): 合併(合併)多列或多行

編輯組:

超級查找:
僅在註釋中查找特定的文本字符串
僅在單元格值中查找特定的文本字符串
僅在公式中查找特定的文本字符串
根據條件查找包含日期類型值的單元格
根據條件查找數字
僅在超鏈接中搜索特定的文本值
查找具有特定單元格格式的所有單元格
模糊查詢: 從單元格值列表中查找並替換類似的記錄
選擇範圍助手: 選擇,取消選擇和反轉多個範圍
選擇間隔行和列: 選擇間隔(其他)行或列
選擇合併的單元格: 查找並選擇合併的單元格
選擇最後一個單元格: 選擇使用範圍的最後一個單元格或最後一行或最後一列的數據的最後一個單元格
選擇具有最大值或最小值的單元格: 選擇最大或最小(最小或最大)值單元格
選擇具有錯誤值的單元格: 選擇具有錯誤值的單元格
選擇特定的單元格: 選擇特定的單元格,行和列
選擇具有以下格式的單元格: 根據格式選擇單元格
選擇解鎖的單元格: 快速選擇所有未鎖定的單元格
選擇空白單元格: 輕鬆選擇非空白或非空單元格
選擇重複和唯一單元格: 查找範圍內的重複或唯一單元格/行
插入標題行: 將標題行插入範圍
插入空白行和列: 每隔一行插入空白行或列
插入日期: 使用日期格式插入日期
批量插入複選框: 一次快速插入多個複選框
批量插入選項按鈕: 一次快速插入多個選項按鈕
插入水印: 快速插入和刪除水印
自動文本: 輕鬆創建和插入自動文本輸入
插入序列號: 創建並插入唯一的序列號
查找丟失的序列號: 快速按順序查找並填寫缺失的數字
填寫自定義列表: 創建自定義列表並用它們填充單元格
列出所有組合: 快速生成/列出某些列表的所有可能組合
插入項目符號或編號: 在Excel中的多個單元格中快速插入項目符號或編號
插入隨機數據: 使用隨機數生成器生成數字和密碼
填寫空白單元格: 用大於或等於0的值填充空白單元格
刪除空白行: 從底部/範圍中刪除或刪除所有空白行
刪除行和列: 刪除空白或隱藏的行(列)
刪除工具: 刪除所有圖表,文本框和嵌入式OLE對象
刪除Web控件: 刪除所有HTML對象,例如復選框
批量刪除複選框: 刪除/刪除多個複選框
批量刪除選項按鈕: 批量刪除選項按鈕
刪除所有宏: 刪除工作表或工作簿中的所有宏
批量刪除所有宏: 批量刪除或刪除工作簿中的所有宏
刪除空間: 刪除文本之前/之後的空格或刪除文本中的多餘空格
變更案例: 將文字大小寫改為大寫,適當
化學式中的下標編號: 正確下標化學方程式中的所有數字
按位置刪除: 從文本字符串的開頭/結尾刪除或刪除字符
反向文字順序: 反向文本字符串或單詞順序
替換重音字符: 用常規字符替換多個重音字符
提取文字: 快速從單元格中提取某些文本
提取電子郵件地址: 從文本字符串中提取電子郵件地址
添加文字: 在一系列單元格中添加相同的文本
拆分名稱: 拆分名字,中間名和姓氏
分裂細胞: 通過空格或其他定界符快速拆分單元格內容
刪除字符: 從單元格中刪除數字,字母,不可打印或字母數字字符
交替的行/列底紋: 每隔一列/每列加陰影
上標/下標(格式): 將文本格式設置為上標或下標
套用日期格式: 將日期格式應用於日期範圍
複製單元格格式: 將一個單元格格式從一個單元格複製到其他單元格
清除所有單元格格式: 完全清除範圍單元格的所有格式
轉換超鏈接: 從超鏈接中提取URL鏈接或將純文本鏈接轉換為超鏈接
查找並斷開斷開的鏈接: 查找和斷開斷開的鏈接(外部引用)
刪除超鏈接: 刪除範圍,工作表和工作簿的所有超鏈接
Kutools計算器: 從單元中獲取值進行操作並將結果粘貼到單元中
操作工具: 將數學運算應用於沒有公式的範圍
更改評論形狀: 更改評論框的形狀
單元格註釋工具: 修改多個單元格註釋
創建評論列表: 快速提取所有評論並將其列出到新工作表或工作簿中
格式註釋: 根據評論快速格式化所有評論
查找/替換評論文本: 快速查找和替換評論中的文本
在註釋中刪除/添加用戶名: 在評論中快速更改/刪除/添加作者姓名
轉換評論和單元格: 在單元格內容和註釋之間快速轉換
自動調整評論: 自動調整評論框的大小以適合內容

公式組:

   功能:

按單元格顏色計數: 使用功能通過填充或字體顏色對單元格進行計數/求和
計數字符: 計算字符串中字符的出現
提取號碼: 使用函數從混合文本字符串中提取數字
反向文字: 具有功能的單元格中的字符輕鬆顛倒順序
以粗體顯示的總和: 快速匯總僅粗體值/數字
按粗體字體計數: 輕鬆計算範圍內僅粗體單元格的數量
簡明: 輕鬆僅對可見單元格,行或列進行求和/計數/平均

   公式:

加上小時/分鐘/秒: 輕鬆地將小時/分鐘/秒添加到日期時間
加上年/月/日/週: 加上年/月/日/週
根據生日計算年齡: 按出生日期計算年齡
單元格中的總數: 對一個單元格中的所有數字/數字求和
絕對值總和: 輕鬆將範圍內的絕對值求和
在列表中查找值: 快速查找值並返回表中的其他單元格
計算兩個日期之間的周末: 快速計算兩個日期之間的周末/工作日/星期幾
查找第n個出現的字符: 輕鬆找到文本字符串中第n個出現的字符的位置
計算範圍內的單詞: 快速計算字數
找到最常見的值: 快速計算字數
從日期中刪除時間: 永久性地從日期時間格式中快速刪除時間

確切的公式副本: 複製精確的公式而無需更改單元格引用
轉換參考: 將單元格引用轉換為相對/絕對引用
替換範圍名稱: 用單元格引用替換公式中的名稱
隱藏/取消隱藏範圍名稱: 輕鬆隱藏或取消隱藏命名範圍
錯誤條件嚮導: 用零,空白單元格或自定義文本替換公式錯誤消息
動態參考工作表: 快速填充來自多個工作表的單元格引用
跟踪先例和相關項: 快速追踪所有從屬或先例

工作簿和表格組:

工作簿工具

拆分工作簿: 將工作簿中的每個工作表/工作表拆分或保存為一個單獨的Excel文件
文件格式轉換器: 將多個XLSX文件轉換為XLS或PDF文件
插入工作簿信息: 將文件名或路徑插入單元格/頁眉或頁腳
打開包含文件夾: 打開活動工作簿的當前目錄/文件夾
複製完整路徑: 複製並插入活動工作簿的文件名和路徑
下次自動打開那些工作簿: Excel啟動時自動打開指定的工作簿
合併工作表:
1.將多個工作表/工作簿的範圍合併為一個工作表
2.將工作簿中所有相同名稱的工作表合併/合併到一個工作表中
3.將工作表或工作簿合併/合併為一個工作簿
4.將多個工作表中的數據匯總併計算到一個工作表中

工作表工具

同步工作表: 在所有工作表中同步選擇相同的單元格
排序表: 按字母順序排序或排列工作表/工作表
凍結窗格多個工作表: 凍結多個工作表中的窗格
取消凍結多個工作表的窗格: 取消凍結多個工作表上的窗格
重命名多個工作表: 重命名多個工作表
創建工作表名稱列表: 在活動工作簿中創建圖紙索引
複製多個工作表: 複製或插入多個工作表
創建序列工作表: 創建具有自定義工作表名稱的新工作簿
萬年曆: 在Excel中插入每月或每年的日曆
分割資料: 將數據分成多張紙
刪除空白工作表: 一鍵刪除所有空白工作表
刪除所有隱藏的工作表: 一鍵刪除所有隱藏的工作表
刪除所有不活動的工作表: 從工作簿中刪除除當前/活動中的工作表以外的所有工作表
合併工作表: 將多個工作表或工作簿合併到一個工作簿中
表合併: 通過匹配兩個工作表/工作簿中的列來更新或合併表
將範圍導出到文件: 將範圍導出或保存為CSV,HTML和工作簿
將範圍導出為圖形: 將範圍導出為圖像文件
導出圖形: 將圖表圖形(圖片或形狀)保存和導出為JPEG圖像文件
在光標處插入文件: 在光標位置插入CSV,Excel,Text或PRN文件的內容
文件名列表: 獲取並在文件夾或目錄中創建文件名列表
根據單元格內容創建文件夾: 根據單元格值創建文件夾
打印多個工作簿嚮導: 從目錄中打印多個工作簿
打印多項選擇嚮導: 將多個範圍/選擇打印到一頁
以相反的順序打印頁面: 輕鬆按相反順序打印頁面
在每一行插入分頁符: 在Excel工作表中每隔x行快速插入分頁符
為每頁添加邊框: 快速在每個頁面周圍添加和打印邊框
複製頁面設置: 將頁面設置設置從一個工作表複製並應用到其他工作表
分頁小計: 在每個打印頁面上插入和打印小計
打印每個工作表的第一頁: 快速打印每個工作表的首頁
導入圖片: 將多張圖片插入單元格並整齊地排列
匹配導入圖片: 根據像元值將圖片導入像元
打印多列: 將列表打印成多列以適合每個打印頁面
打印當前頁面: 打印活動單元的當前打印頁面

安全組:

加密單元: 加密和解密選定的單元格值或內容
解密單元: 加密和解密選定的單元格值或內容
保護工作表: 一次保護多個工作表/工作表
取消保護工作表: 一次取消保護多個工作表/工作表
創建郵件列表: 在Excel中輕鬆創建郵件列表
發電子郵件: 根據Excel中的郵件列表發送電子郵件

郵件組:

創建郵件列表: 在Excel表中快速創建收件人列表
發電子郵件: 批量發送個性化電子郵件給多個收件人

過濾器和統計組:

按顏色計數: 根據單元格背景或陰影顏色計算單元格值
分頁小計: 在每個打印頁面上插入和打印小計
高級排序: 輕鬆按姓氏/月份/頻率/文本長度對數據進行排序
超級過濾器: 根據具有多個條件的單元格值過濾數據
過濾器粗體: 按粗體字符過濾所有單元格
過濾斜體: 按斜體過濾所有單元格
過濾刪除線: 刪除線過濾單元
過濾器評論: 用評論過濾所有單元格
篩選器公式: 篩選所有包含公式的單元格
合併過濾器: 過濾合併的單元格
特殊過濾器:
按大寫/小寫過濾單元格
按文本長度過濾單元格
按工作日/週末/星期幾過濾單元格
按字體顏色過濾單元格
通過背景顏色過濾單元格
粘貼到可見範圍內: 複製數據並粘貼到僅可見的單元格/過濾列表中
選擇鎖: 輕鬆配置要鎖定或解鎖的單元
選擇解鎖: 輕鬆配置要鎖定或解鎖的單元
突出顯示解鎖: 快速突出顯示/為所有未鎖定的單元格上色
公式隱藏: 快速隱藏或取消隱藏公式
公式取消隱藏: 快速隱藏或取消隱藏公式
突出顯示隱藏: 使用隱藏的公式快速突出顯示單元格
突出顯示公式: 快速突出顯示所有公式單元格
突出顯示名稱: 快速突出顯示所有命名範圍
顯示標題: 快速隱藏和顯示列標題和行標題
顯示公式: 輕鬆顯示或顯示所有單元格公式
Say something here...
symbols left.
You are guest
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.
    pratap singh · 3 years ago
    Please help to convert the 22.1.2018 to 22-jan-2018
  • To post as a guest, your comment is unpublished.
    qiuhongkun · 3 years ago
    Please don't post any comments after this article. We will not answer it. Please use the forum
    https://www.extendoffice.com/forum/kutools-for-excel.html or contact us with email.
  • To post as a guest, your comment is unpublished.
    blueoaks · 3 years ago
    I am trying out your Excel plugin. To test, I deliberately copied data in 2 cells from 1 range and pasted them exactly into another range on a sheet in the same workbook, then used your 'compare cells' tool and it does not find a match. Repeated test many times. Not sure if its working for others, but definitely not for me. Will not be purchasing. Excel 2010 on Windows 10 PC.
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello,
      Once again, please don't post any comments after this article. We will not answer it. Please use the forum or contact us with email.
      BTW, it work, please take a look at https://www.extendoffice.com/product/kutools-for-excel/excel-compare-ranges,-rows-and-columns.html
  • To post as a guest, your comment is unpublished.
    pdn.update@gmail.com · 3 years ago
    Hello
    when I downloaded Kutools for excel I saw that it can be usable for 45 days trial But when I installed it a window with license and purchase appeared please give me the answer I want to try some issues and buy the license later.

    Thanks
  • To post as a guest, your comment is unpublished.
    Jeffrey Stitt · 3 years ago
    I am trying out your software in excel and using the To Actual button.

    i don't know if there is a limit to the amount of cells it can change at one time but i was trying it out on 13755 cells and i get most of them converted but about 1200 to 1500 of them convert to #Ref.

    Let me know what you think.
  • To post as a guest, your comment is unpublished.
    sureshkumar · 3 years ago
    how to use excel files with this software
  • To post as a guest, your comment is unpublished.
    Nigel Attwood · 3 years ago
    I am using the reading layout and cannot edit comments in this mode, I can delete them and create them just not edit which is a pain having to rewrite the whole comment. It is a large spreadsheet W columns and 5800 rows so far with the W column holding extensive comments on each record.
  • To post as a guest, your comment is unpublished.
    Ekta · 3 years ago
    In Excel, I have business names list in one sheet and its outwit export contact data(sheet2)(address, Page title,business url,Source url...) but it does not contain business name. So, I want to add business name column to its businessurl in sheet2. I have large no of records in excel sheet.

    For ex:
    In sheet1: In sheet2:
    abc www.wh.com
    xyz www.xy.com
    White House www.abc.com

    1) how I will get business urls name to its adjecent column.
    2) how can I check business name from its url.
  • To post as a guest, your comment is unpublished.
    Guest · 3 years ago
    How to Activate License to the KU Tool
  • To post as a guest, your comment is unpublished.
    sanket dayama · 3 years ago
    Can anyone guide me how to buy this?

    https://www.extendoffice.com/order/kutools-for-excel.html
  • To post as a guest, your comment is unpublished.
    George · 3 years ago
    Hi. installed free version to test and evaluate before purchasing. Problem is KUTOOLS don't show on my ribbon, no idea why. After installation I was prompted to start Excel, which I did, then, closed it and now KUTOOLS doesn't show. Any idea why?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello,
      Please don't post such issue after this article.
      Please contact us via jaychivo@extendoffice.com with the detailed information.
      Please go to check your Excel add-ins manager. Can you see the Kutools for Excel in your Excel add-ins manager?
      Please try to enable both Kutools for Excel add-ins in your Excel add-ins manager.
      Thanks in advance.
  • To post as a guest, your comment is unpublished.
    Esther · 3 years ago
    I've been receiving a circular reference message every time I open an excel workbook regardless if it is blank or has data on it. How do I make this go away?
  • To post as a guest, your comment is unpublished.
    Andrew · 3 years ago
    How do I do a weighted random selection in an excel list? For example, I am running a competition where you get more chances to win for every $5 you save.
  • To post as a guest, your comment is unpublished.
    Erin · 3 years ago
    Good Morning: I have purchased a license for Kutools for all MS products after successfully using the free version for excel. I loved the addin; however, since purchase NONE of the plugins work- in fact, if I attempt to use any function of the add-in my program, anyone that I'm using, crashes. This was a considerable investment and yet I have less access than I did when I was using a free version for excel.
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello,
      Please don't post such topic here. If you want to get the support quickly, please contact us via jaychivo@extendoffice.com or post the topic in the forum section.
  • To post as a guest, your comment is unpublished.
    zaidoon · 3 years ago
    Hi, I have multi Excel file with data like

    YES
    YES
    YES
    YES
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO

    can I change like 50% of NO to YES using VBA? How? thanks
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello,
      Please use the forum for help.
      • To post as a guest, your comment is unpublished.
        Jay · 3 years ago
        I ordered it with PayPal how do I get the installation information?
  • To post as a guest, your comment is unpublished.
    vml · 3 years ago
    hi

    can i transfer the purchased kutools from my office computer to personal
  • To post as a guest, your comment is unpublished.
    Ryan · 3 years ago
    I have emailed twice to receive my registration information but have not received anything can you please assist me?
  • To post as a guest, your comment is unpublished.
    Deepak Kumar · 3 years ago
    Hi can i get freeware version of Kutool (may be limited options) for long term?
    • To post as a guest, your comment is unpublished.
      Excelfans · 3 years ago
      Sorry, we don't have such version.
  • To post as a guest, your comment is unpublished.
    wtw1326@gmail.com · 3 years ago
    Can my license name and code be emailed to me?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello,
      Please try to contact us via jaychivo@extendoffice.com with your order information.
  • To post as a guest, your comment is unpublished.
    yorm · 3 years ago
    my free trial has expired and i am trying to purchase but i am being told my details cannot be be verified, i need help
  • To post as a guest, your comment is unpublished.
    Simon W · 3 years ago
    I am looking for previous versions of Kutools for excel but all links lead to V16.5. My licence expired in July. Please assist...
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello,
      You can install the old version from https://www.extendoffice.com/downloads/History-Kutools-for-Excel/16.00/KutoolsforExcelSetup.exe
      You can contact us with your order information via jaychivo@extendoffice.com.
  • To post as a guest, your comment is unpublished.
    carlo.vaiani@gmail.com · 3 years ago
    I have a problem with Work Area utility.
    When I use it at work with two displays attached to my laptop, the pop up panel with the 4 profile buttons shows up correctly
    Instead, when I use the same at home on the same laptop without additional screen, the pop up does not show up correctly (see attachment).
    I already tried changing scaling and resolution settings, but nothing changed.
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello All,
      Please try to use the forum to post your issue or feedback https://www.extendoffice.com/forum/kutools-for-excel.html
      Or please send an email to jaychivo@extendoffice.com.
      Please don't post your issue after this article.
      1. Please make sure you have installed the latest version.
      2. Please tell me the version informaiton of your Office and computer system.
      Thanks in advance.
  • To post as a guest, your comment is unpublished.
    MDodin · 3 years ago
    Hi,
    I just purchased the Kutools for excel. How do I activate it ?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      You can go to register the software in the Setting Center or go to register as shown in the attached screenshot.
  • To post as a guest, your comment is unpublished.
    Jotham Wadongo · 3 years ago
    Hi I am Jotham. I have purchased a single license user software but when I try to update it refuses to work. What would be the issue?
  • To post as a guest, your comment is unpublished.
    Joe · 3 years ago
    Will this product work on Excel 2016 64bit Office 2016?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Yes, this software is compatible with the Microsoft Office 2007 / 2010 / 2013 / 2016 / Office 365, 32 bit or 64 bit of all series. (ok)
      Please go to have a 60-day free trial from https://www.extendoffice.com/downloads/KutoolsforExcelSetup.exe.
  • To post as a guest, your comment is unpublished.
    Winnie · 3 years ago
    Hi, I am trying the trial version of Kutools to insert multiple pictures matching with their names. I followed every step described in the website, but the image still comes out from the image sequences instead of matched names image. Any idea what goes wrong?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Please try to contact me via jaychivo@extendoffice.com.
      Please try to show how to replicate your operation.
      Thanks in advance.
  • To post as a guest, your comment is unpublished.
    Lauren · 3 years ago
    I emailed as I ordered this and my computer got messed up and when I went to reload it I couldnt
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello,

      Please try to contact me with your order informaiton via jaychivo@extendoffice.com.

      Please be more specific about your issue.
      Thanks in advance.
  • To post as a guest, your comment is unpublished.
    Ashley · 4 years ago
    When I try to combine worksheets it either doesn't combine in the file when I open it or says that I have exceeded the size (in which case, I do not have that much data)
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Please try to create some sample data in a new workbook and try it again.
      If the problem persists with the sample workbook, pleas send the workbook to us via jaychivo@extendoffice.com.
      Please be more specific about your operations.
  • To post as a guest, your comment is unpublished.
    Melissa · 4 years ago
    HI,
    I downloaded the trial version to see if we should purchase. I used the advanced combine rows but after my data refreshes, they go back to uncombined. Is there a way to make them stay combined (or recombine)? Others will be using this workbook and they don't have the add-in.
    Thanks
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Please try to create some sample data in a new workbook and try it again.
      If the problem persists with the sample workbook, pleas send the workbook to us via jaychivo@extendoffice.com.
      Please be more specific about your operations.
  • To post as a guest, your comment is unpublished.
    Kanokwan · 4 years ago
    Hi, I was sent email to Jay Chivo but he not reply my email for more than 20 hours.
    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.
    • To post as a guest, your comment is unpublished.
      Andrew · 4 years ago
      I too am having the exact same issue? is there a fix for this as yet?
      • To post as a guest, your comment is unpublished.
        jaychivo · 4 years ago
        Please try to contact me with your order information via jaychivo@extendoffice.com. We will help you solve it immediately.
    • To post as a guest, your comment is unpublished.
      ehtesham · 4 years ago
      I am having the same problem too. I am using Excel 2013... :( Did you get any fix for this?
      • To post as a guest, your comment is unpublished.
        jaychivo · 4 years ago
        Please try to contact me with your order information via jaychivo@extendoffice.com. We will help you solve it immediately.
  • To post as a guest, your comment is unpublished.
    Tracy Colegrove · 4 years ago
    Hi,

    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
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="Tracy Colegrove"]Hi,

      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[/quote]

      Can you get it done? If no, please try to contact us with the detailed information via jaychivo@extendoffice.com
  • To post as a guest, your comment is unpublished.
    steve smith · 4 years ago
    Hi,
    I love this product. Do you have a portable version that i could use at work?
    Thank You,
    Steve :-)
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="steve smith"]Hi,
      I love this product. Do you have a portable version that i could use at work?
      Thank You,
      Steve :-)[/quote]
      Sorry, we don't have a portable version. :)
  • To post as a guest, your comment is unpublished.
    Garima · 4 years ago
    Hi,

    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 ?
  • To post as a guest, your comment is unpublished.
    Andrew · 4 years ago
    Hello, I accidentally moved the Kutools folders when I was trying to clean up my documents on the computer and now whenever I open excel I get the error message that reads "Access violation at address 07ED2750 in module 'PANEFO~1.DLL', Read of address 000000000" and when excel opens, the words in the navigation pane are not in English. How do I resolve?
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="Andrew"]Hello, I accidentally moved the Kutools folders when I was trying to clean up my documents on the computer and now whenever I open excel I get the error message that reads "Access violation at address 07ED2750 in module 'PANEFO~1.DLL', Read of address 000000000" and when excel opens, the words in the navigation pane are not in English. How do I resolve?[/quote]

      Please try to reinstall the software. If the problem persists after installation, please contact me via jaychivo@extendoffice.com.
  • To post as a guest, your comment is unpublished.
    tom · 4 years ago
    Hi Admin

    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.
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="tom"]Hi Admin

      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.[/quote]

      Please contact us via jaychivo@extendoffice.com
  • To post as a guest, your comment is unpublished.
    Leasha Riggs · 4 years ago
    Hello
    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
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="Leasha Riggs"]Hello
      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[/quote]

      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@extendoffice.com.

      Please attach the sample workbook in your email.
  • To post as a guest, your comment is unpublished.
    Sean Tarantino · 4 years ago
    Fantastic plugin!
    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!
  • To post as a guest, your comment is unpublished.
    Ajaz · 4 years ago
    Dear, i have values in a range of cell, say fromA1: A100. In another cell C1 i have value 200. Now i will start adding A1 with A2 if the result value is less than C1 i will again add A1 to A3 if the sum is less than C1 i will again add A1:A4 and so on untill the sum is more or equal to C1. How can i do that
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="Ajaz"]Dear, i have values in a range of cell, say fromA1: A100. In another cell C1 i have value 200. Now i will start adding A1 with A2 if the result value is less than C1 i will again add A1 to A3 if the sum is less than C1 i will again add A1:A4 and so on untill the sum is more or equal to C1. How can i do that[/quote]
      Please try to use this formula: =IF(SUM(INDIRECT("B1"))>=$C$1,"",A2)
  • To post as a guest, your comment is unpublished.
    Ram · 4 years ago
    I just wish to find sum of best of two questions using a single formula in total column
  • To post as a guest, your comment is unpublished.
    Jenny · 4 years ago
    Since I purchased this software it never worked for me, every time I try to do something with kutools it always frozen my excel, it is horrible and I can not get any support from the kutools team. Very disappointing!
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="Jenny"]Since I purchased this software it never worked for me, every time I try to do something with kutools it always frozen my excel, it is horrible and I can not get any support from the kutools team. Very disappointing![/quote]
      Please try to contact us with your order informaiton. You can contact me via jaychivo@extendoffice.com. :-)
      We will solve it for you.
  • To post as a guest, your comment is unpublished.
    marco · 4 years ago
    I had problem to register the product (Kutools for excel) but after having solved this issue I can't use the tools becuase every time I' trying to use a Kutools task the Excel closed.
    Please help me
    Thanks

    Marco
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="marco"]I had problem to register the product (Kutools for excel) but after having solved this issue I can't use the tools becuase every time I' trying to use a Kutools task the Excel closed.
      Please help me
      Thanks

      Marco[/quote]
      Please try to contact us with your order information via jaychivo@extendoffice.com.

      We will solve it for you. :-)
  • To post as a guest, your comment is unpublished.
    I N · 4 years ago
    Hello, I am using the file list function and finding that Kutools can only import 32,767 lines of data. Why is this the case and is there a way to generate the file list with more than 32,767 rows?

    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
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="I N"]Hello, I am using the file list function and finding that Kutools can only import 32,767 lines of data. Why is this the case and is there a way to generate the file list with more than 32,767 rows?

      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[/quote]

      Please try to contact us via jaychivo@extendoffice.com with detailed information about the issue.
  • To post as a guest, your comment is unpublished.
    Jodi Smith · 4 years ago
    I need my registration code and I submitted the form and have not received the email Can you help?
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="Jodi Smith"]I need my registration code and I submitted the form and have not received the email Can you help?[/quote]
      Please contact us via jaychivo@extendoffice.com with your order information.
  • To post as a guest, your comment is unpublished.
    Nikosjc · 4 years ago
    Hi, I am using the "match import pictures" and works fine if I have unique names/path in the cells and unique photos. But I would like to import a photo more than one time if there is the same name/path in the path column. Is this possible? Thanks!
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="Nikosjc"]Hi, I am using the "match import pictures" and works fine if I have unique names/path in the cells and unique photos. But I would like to import a photo more than one time if there is the same name/path in the path column. Is this possible? Thanks![/quote]
      Hello, you should try: https://www.extendoffice.com/product/kutools-for-excel/excel-insert-multiple-pictures.html
      • To post as a guest, your comment is unpublished.
        Nikosjc · 4 years ago
        [quote name="admin_jay"][quote name="Nikosjc"]Hi, I am using the "match import pictures" and works fine if I have unique names/path in the cells and unique photos. But I would like to import a photo more than one time if there is the same name/path in the path column. Is this possible? Thanks![/quote]
        Hello, you should try: https://www.extendoffice.com/product/kutools-for-excel/excel-insert-multiple-pictures.html[/quote]

        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
  • To post as a guest, your comment is unpublished.
    Ken · 4 years ago
    Do you have a version of the range swap that only swaps the contents of the cells and not the formatting?
    • To post as a guest, your comment is unpublished.
      Herman · 4 years ago
      I do not understand your question, I use version 7.5.
    • To post as a guest, your comment is unpublished.
      Herman · 4 years ago
      Hi Ken,

      I do not understand your question, I use version 7.5 of Kutools.

      Regards
      Herman
  • To post as a guest, your comment is unpublished.
    Herman · 4 years ago
    I use a Mac machine and have installed Microsoft Office 2007 on it, running under Crossover virtual machine. I have also installed Kutool on the virtual machine, but how do I get excel to work with Kutools?
  • To post as a guest, your comment is unpublished.
    Mark Grosart · 4 years ago
    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
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="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[/quote]

      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.
  • To post as a guest, your comment is unpublished.
    Sayb Sourchi · 4 years ago
    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?
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="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?[/quote]
      Please try to contact me via jaychivo@extendoffice.com with your order information. We will fix it for you.
  • To post as a guest, your comment is unpublished.
    AS · 4 years ago
    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?
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="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?[/quote]
      Please contact me via jaychivo@extendoffice.com with your order information. We will resend you the license information.
  • To post as a guest, your comment is unpublished.
    Sam · 4 years ago
    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!
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="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![/quote]
      This is very special issue. We will try to fix it in upcoming versions. It only happens under certain circumstance. :sad: