提示:其它语言是由 Google 机器翻译的。 你可以访问 English 版本。
登录
x
or
x
x
马上登记
x

or

Kutools for Excel:功能强大的Excel工具箱

Kutools for Excel 是一个功能强大的Excel工具箱,使您无需在Excel中执行耗时的操作。 该工具箱具有超过300功能,适用于Excel 2019,2016,2013,2010,2007和Office 365。

最新更新: Kutools for Excel 20.00
日期:七月16,2019
我们欢迎所有问题,反馈和错误报告。 我们通常需要以下信息: 联系我们
  • 对问题的简要描述以及如何复制(如适用)。
  • 您的操作系统(Windows 10,8,Windows 7等)以及Microsoft Office的版本信息。
  • 说明问题的截图 - 如何截图? http://www.take-a-screenshot.org

订阅更新通讯:


Kutools for Excel功能教程:


您可以通过在以下搜索框中输入功能名称来快速访问功能教程。 例如,如果你想知道如何使用 阅读版式视图,你只需要输入 阅读 搜索框中的关键字。

查看组:

Track Snap(备份当前工作簿): 暂时备份当前工作簿
导航窗格: 列出所有工作表,工作簿,列和名称
高级查找和替换: 轻松找到并替换多个工作表和工作簿
工作区域大小: 快速更改工作区域大小
阅读版式视图: 轻松阅读/查看大量的行和列
显示列: 将所有隐藏的列切换为可见或不可见
显示表格: 将所有隐藏的工作表切换为可见或不可见
隐藏/取消隐藏工作簿和表格: 隐藏或取消隐藏工作簿和工作表
查看选项: 切换工作簿和工作表设置
设置滚动区域: 设置滚动区域(一次隐藏未选定的列和行)
隐藏未选中的图纸: 隐藏所有不活动(或未选定的)工作表
隐藏不活动的Windows: 隐藏其他工作簿(所有不活动的窗口)
取消隐藏所有范围: 取消隐藏所有行和列
取消隐藏所有工作表: 显示所有隐藏的工作表
取消隐藏所有窗口: 取消隐藏所有隐藏的工作簿窗口

范围和细胞组:

调整单元格大小: 以英寸,磅,厘米或像素为单位设置行高或列宽
合并相同的单元格: 合并具有相同数据/值的列中的相邻单元格
Unmerge手机: 取消合并单元格并填写值
翻转水平范围: 翻转(反向)列或行的数据顺序
翻转垂直范围: 翻转(反向)列或行的数据顺序
转置表尺寸: 将2维/交叉表转换为列表
变换范围: 将单个列或行转置(转换)为范围
交换范围: 交换行,列或范围
排序范围随机: 随机排序或选择单元格,行和列
比较单元格: 轻松比较两个单元格的范围,如果他们是相同或不同的
选择相同和不同的单元格: 比较两个范围来选择重复或唯一的值
防止重复: 防止列中出现重复条目
防止键入: 轻松防止在单元格中输入特定或某些字符
只允许在单元格范围内输入特定的字符
复制范围: 复制多个选择或范围
文本和数字之间的转换: 转换/强制文本到数字或数字到文本
罗马和数字之间的转换: 罗马数字和数字之间的转换
将公式转换为文本: 快速将单元格公式转换为文本字符串
将文本转换为公式: 将文本字符串快速转换为公式
转换为日期: 识别并转换日期格式
转换时间: 转换时间为秒/分钟/小时
货币转换: 货币兑换(美元兑欧元/美元兑英镑)
单位换算: 转换度量单位
数字系统的转换: 在不使用公式的情况下转换不同的数字系
拼出数字: 将一个数字转换或拼写成英文单词
更改值的符号: 改变数字的符号(修复尾随负号/将所有负值更改为正数)
先进的组合行: 根据相同的值快速组合行
将数字转换为序数: 将数字快速转换为序数字
到实际: 用单元格中的计算值/结果替换公式
回合(不含公式): 没有公式的圆形单元值
合并(行和列): 组合(合并)多个列或行

编辑组:

超级查找:
仅在注释中查找特定的文本字符串
仅在单元格值中查找特定文本字符串
仅在公式中查找特定的文本字符串
根据条件查找包含日期类型值的单元格
根据标准查找数字
仅在超链接中搜索特定文本值
查找具有特定单元格格式的所有单元
模糊查找: 从单元格值列表中查找并替换类似记录
选择范围助手: 选择,取消选择和反转多个范围
选择间隔行和列: 选择间隔(每隔一个)行或列
选择合并单元格: 查找并选择合并的单元格
选择最后单元格: 选择最后一行或最后一列的最后一个单元格
选择具有最大值或最小值的单元格: 选择最大或最小(最小或最大)值单元格
选择具有错误值的单元格: 选择具有错误值的单元格
选择特定单元格: 选择特定的单元格,行和列
选择带格式的单元格: 根据格式选择单元格
选择解锁的单元格: 快速选择所有未锁定的单元格
选择Unblank Cells: 轻松选择非空白或非空单元格
选择重复和独特单元格: 在一个范围内查找重复或唯一的单元格/行
插入标题行数: 将标题行插入一个范围
插入空白行和列: 每隔一行/列插入空行或列
插入日期: 用日期格式插入日期
批量插入复选框: 一次快速插入多个复选框
批量插入选项按钮: 一次快速插入多个选项按钮
插入水印: 快速插入和删除水印
自动文本: 轻松创建并插入自动文本输入
插入序列号: 创建并插入唯一的序列号
找到缺少的序号: 快速找到并填写缺少的数字顺序
填写自定义列表: 创建自定义列表并使用它们填充单元格
列出所有组合: 快速生成/列出某些列表的所有可能的组合
插入项目符号或编号: 在Excel中的多个单元格中快速插入项目符号或编号
插入随机数据: 使用随机数生成器来生成数字和密码
填充空白单元格: 用上面的值或0填充空白单元格
删除空白行: 删除或删除底部/范围内的所有空白行
删除行和列: 删除空行或隐藏行(列)
删除工具: 删除所有图表,文本框和嵌入的OLE对象
删除网页控件: 删除所有html对象,如复选框
批量删除复选框: 删除/删除多个复选框
批量删除选项按钮: 批量删除选项按钮
删除所有宏: 删除工作表或工作簿中的所有宏
批量删除所有宏: 批量删除或删除工作簿中的所有宏
删除空格: 删除文本之前/之后的空格或从文本中删除多余的空格
变更案例: 将文本的大小写更改为全部大写,低一些
化学式中的下标数字: 在化学方程中正确标注所有数字
按位置移除: 从文本字符串的开头/结尾删除或删除字符
反向文本顺序: 反转文本字符串或单词顺序
替换重音字符: 用正则字符替换多个重音字符
提取文本: 从单元格中快速提取某些文本
提取电子邮件地址: 从文本字符串中提取电子邮件地址
添加文字: 在一系列单元格中添加相同的文本
拆分名称: 拆分第一,中间和最后一个名字
拆分单元格: 通过空格或其他分隔符快速拆分单元格内容
删除字符: 从单元格中删除数字,字母,不可打印或字母数字字符
备用行/列着色: 遮挡隔行/列
上标/下标(格式): 将文本格式设置为上标或下标
应用日期格式: 将日期格式应用于日期范围
复制单元格格式: 将单元格从一个单元格复制到其他单元格
清除所有单元格式: 完全清除范围单元格的所有格式
转换超链接: 从超链接中提取链接或将纯文本链接转换为超链接
查找和打破断开的链接: 查找并打破断开的链接(外部引用)
删除超链接: 删除范围,工作表和工作簿的所有超链接
Kutools计算器: 从单元获取操作值并将结果粘贴到单元格中
操作工具: 将数学运算应用于没有公式的范围
更改注释形状: 改变评论框的形状
单元格注释工具: 修改多个单元格注释
创建注释列表: 快速提取并列出所有评论到新的工作表或工作簿
格式说明: 根据评论快速格式化所有评论
查找/替换评论文字: 快速找到并替换评论中的文字
在评论中删除/添加用户名称: 在注释中快速更改/删除/添加作者姓名
转换注释和单元格: 快速转换单元格内容和注释
AutoFit评论: 自动调整评论框以适应内容

配方组:

功能:

按细胞颜色计数: 使用函数来按填充或字体颜色对单元格进行计数/求和
Char Char: 计算字符串中字符的出现次数
提取数字: 使用函数从混合文本字符串中提取数字
反向文本: 用功能轻松颠倒单元格中的字符顺序
按字体加粗加粗: 快速总结粗体值/数字
按字体粗体计算: 轻松计算一个范围内只有粗体单元格的数量
SUMVISIBLE: 只能简单地求和/计算/平均可见的单元格,行或列

公式:

添加小时/分钟/秒的日期: 轻松地将小时/分钟/秒添加到日期时间
添加年/月/日/周至今: 添加年/月/日/周至今
根据生日来计算年龄: 按出生日期计算年龄
总数在一个单元格中: 总和一个单元格中的所有数字/数字
总和绝对值: 轻松求和一个范围内的绝对值
在列表中查找值: 快速查找一个值并从表中返回一个不同的单元格
在两个日期之间的周末计数: 快速计算两个日期之间的周末/周日/特定日期的数量
查找第n个字符的出现: 在文本字符串中轻松找到第n个字符的位置
计数范围内的单词: 快速统计单词的数量
找到最常见的价值: 快速统计单词的数量
从日期中删除时间: 从日期时间格式中永久快速删除时间

确切的公式拷贝: 复制确切的公式而不更改单元格引用
转换参考: 将单元格引用转换为相对/绝对引用
替换范围名称: 将公式中的名称替换为单元格引用
隐藏/取消隐藏范围名称: 轻松隐藏或取消隐藏命名范围
错误条件向导: 将公式错误消息替换为零,空白单元格或自定义文本
动态参考工作表: 快速从多个工作表中填充单元格引用
追踪先例和依附: 快速追踪所有家属或先例

工作簿和表格组:

工作簿工具

分割工作簿: 将工作簿中的每张工作表分别保存为一个单独的Excel文件
文件格式转换器: 将多个XLSX文件转换为XLS或PDF文件
插入工作簿信息: 将文件名或路径插入单元格/页眉或页脚
打开包含文件夹: 打开活动工作簿的当前目录/文件夹
复制完整路径: 复制并插入活动工作簿文件名称和路径
自动打开这些工作簿下一次: Excel启动时自动打开指定的工作簿
合并工作表:
1。 将工作簿中的多个工作表/范围组合到一个工作表中
2。 将所有工作簿中具有相同名称的工作表合并/合并到一个工作表中
3。 将工作表或工作簿合并/合并到一个工作簿中
4。 总结和计算来自多个工作表的数据到一个工作表中

工作表工具

同步工作表: 在所有工作表中同步选择相同的单元格
排序表: 按字母顺序排列或排列表格/工作表
冻结窗格多个工作表: 冻结多个工作表中的窗格
解冻窗格多个工作表: 在多个工作表上解冻窗格
重命名多个工作表: 重命名多个工作表
创建图表名称列表: 创建活动工作簿中工作表的索引
复制多个工作表: 复制或插入多个工作表
创建序列工作表: 用自定义工作表名称创建一个新的工作簿
万年历: 在Excel中插入每月或每年的日历
拆分数据: 将数据拆分成多个工作表
删除空白工作表: 一键删除所有空白工作表
删除所有隐藏的表格: 一键删除所有隐藏的工作表
删除所有不活动的表格: 从工作簿中删除当前/活动页面以外的所有页面
合并工作簿: 将多个工作表或工作簿合并到一个工作簿中
表格合并: 通过匹配来自两个工作表/工作簿的列来更新或合并表
导出范围到文件: 将范围导出或保存为CSV,HTML和工作簿
导出范围如图所示: 将范围导出为图像文件
导出图形: 保存并导出图表图形(图片或形状)作为JPEG图像文件
在光标处插入文件: 在光标位置插入CSV,Excel,Text或PRN文件的内容
文件列表: 获取并创建文件夹或目录中的文件名列表
基于单元格内容创建文件夹: 根据单元格值创建文件夹
打印多个工作簿向导: 从目录打印多个工作簿
打印多个选择向导: 打印多个范围/选择到一个页面
按相反顺序打印页面: 以相反的顺序轻松打印页面
插入分页符每行: 在Excel工作表中快速插入分页符x行
为每个页面添加边框: 在每个页面周围快速添加和打印边框
复制页面设置: 将页面设置从一个工作表复制并应用到其他人
寻呼小计: 在每个打印页面上插入和打印小计
打印每个工作表的第一页: 快速打印每个工作表的第一页
导入图片: 插入多个图片到单元格中,整齐排列
匹配导入图片: 根据单元格值将图片导入到单元格中
打印多列: 将列表打印到多列以适合每个打印页面
打印当前页面: 打印活动单元格的当前打印页面

安全组:

加密单元格: 加密和解密选定的单元格值或内容
解密单元格: 加密和解密选定的单元格值或内容
保护工作表: 一次保护多张工作表
取消保护工作表: 一次解除多个工作表/工作表的保护
创建邮件列表: 在Excel中轻松创建邮件列表
发电子邮件: 基于邮件列表在Excel中发送电子邮件

过滤和统计组:

按颜色计数: 根据单元格背景或阴影颜色计算单元格值
寻呼小计: 在每个打印页面上插入和打印小计
高级排序: 按姓氏/月份/频率/文本长度轻松排序数据
超级过滤器: 使用多个条件过滤基于单元值的数据
粗体过滤器: 用粗体字符过滤所有单元格
过滤斜体: 用斜体过滤所有单元格
过滤删除线: 用删除线过滤单元格
过滤评论: 使用评论过滤所有单元格
过滤公式: 过滤包含公式的所有单元格
过滤器合并: 过滤合并的单元格
特殊过滤器:
按大写/小写筛选单元格
按文本长度过滤单元格
按周工作日/周末/特定日过滤单元格
按字体颜色过滤单元格
通过背景颜色过滤单元格
粘贴到可见范围内: 复制数据并粘贴到可见单元格/过滤列表中
选择锁定: 轻松配置要锁定或解锁的单元格
选择解锁: 轻松配置要锁定或解锁的单元格
突出显示解锁: 快速突出显示/上色所有未锁定的单元格
公式隐藏: 快速隐藏或取消隐藏公式
公式取消隐藏: 快速隐藏或取消隐藏公式
突出显示隐藏: 用隐藏的公式快速突出显示单元格
突出显示公式: 快速突出显示所有配方单元
突出显示名称 快速突出显示所有命名的范围
显示标题: 快速隐藏并显示列和行标题
显示公式: 轻松显示或显示所有单元格公式
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.
    Damodar · 1 years ago
    Is there an issue of using the Right Mouse Button with Kutools Add-in in Office 365
  • To post as a guest, your comment is unpublished.
    Nadin · 1 years ago
    Please advise how to add-in the Kutools in excel. I add in the add-ins, however, it does not appear. Please help.
  • To post as a guest, your comment is unpublished.
    Martin Dijk · 1 years ago
    I just got Kutools Yesterday and saved me a lot of time using "Dynamically refer to worksheets...". I also need to do exact to opposite. So:
    - value cell B3 of sheet 1 should go to cell D4 of sheet 2;
    - Value cell B4 of sheet 1 should go to cell D4 of sheet 3
    - value cell B5 of sheet 1 should go to cell D4 of sheet 4
    etc.

    Does Kutools facilitate this and if so feature should I use or is VBA the only option?


  • To post as a guest, your comment is unpublished.
    paula hegarty · 1 years ago
    add 0 to beginning of numbers in a column. I have exported a csv file of over 3000 names and numbers and had to format the column so as the number shows correctly by changing the decimal place to 0 but this has removed all the 0 off the beginning of the numbers. How can i get the 0's back
  • To post as a guest, your comment is unpublished.
    Gopal · 1 years ago
    Please help to convert the 22.1.2018 to 22-jan-2018
  • To post as a guest, your comment is unpublished.
    Jay Chivo · 1 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.
    Joe · 1 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.
    pdn update · 1 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 · 1 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 · 1 years ago
    how to use excel files with this software
  • To post as a guest, your comment is unpublished.
    Nigel Attwood · 1 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 · 1 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 · 1 years ago
    How to Activate License to the KU Tool
  • To post as a guest, your comment is unpublished.
    sanket dayama · 1 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 · 1 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.
      Jay Chivo · 1 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 · 1 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 · 1 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 · 2 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.
      Jay Chivo · 2 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 · 2 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.
      Jay Chivo · 2 years ago
      Hello,
      Please use the forum for help.
      • To post as a guest, your comment is unpublished.
        Jay · 1 years ago
        I ordered it with PayPal how do I get the installation information?
  • To post as a guest, your comment is unpublished.
    vml · 2 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 · 2 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 · 2 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.
    Tommy Tyler · 2 years ago
    Can my license name and code be emailed to me?
    • To post as a guest, your comment is unpublished.
      Jay Chivo · 2 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 · 2 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 · 2 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.
    Carlo Vaiani · 2 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.
      Jay Chivo · 2 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 · 2 years ago
    Hi,
    I just purchased the Kutools for excel. How do I activate it ?
    • To post as a guest, your comment is unpublished.
      Jay Chivo · 2 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 · 2 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 · 2 years ago
    Will this product work on Excel 2016 64bit Office 2016?
  • To post as a guest, your comment is unpublished.
    Winnie · 2 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.
      Jay Chivo · 2 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 · 2 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.
      Jay Chivo · 2 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 · 2 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.
      Jay Chivo · 2 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 · 2 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.
      Jay Chivo · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 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 · 2 years ago
      I do not understand your question, I use version 7.5.
    • To post as a guest, your comment is unpublished.
      Herman · 2 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 · 2 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?