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
我们欢迎所有问题,反馈和错误报告。 我们通常需要以下信息: 联系我们
  • 有关问题及其复制方式的简要说明(如果适用)。
  • 您的操作系统(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启动时自动打开指定的工作簿
合并工作表:


将多个工作表/范围从工作簿合并到一个工作表中
将跨工作簿的所有同名工作表合并/合并到一个工作表中
将工作表或工作簿合并/合并为一个工作簿
将多个工作表中的数据汇总并计算到一个工作表中

工作表工具

同步工作表: 在所有工作表中同步选择相同的单元格
排序表: 按字母顺序排列或排列工作表/工作表
冻结窗格多个工作表: 冻结多个工作表中的窗格
取消冻结多个工作表的窗格: 取消冻结多个工作表上的窗格
重命名多个工作表: 重命名多个工作表
创建工作表名称列表: 在活动工作簿中创建图纸索引
复制多个工作表: 复制或插入多个工作表
创建序列工作表: 创建具有自定义工作表名称的新工作簿
万年历: 在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.
    Joshtill1868 · 8 days ago
    im looking for a formula that will compare 2 working dates minus holidays if the days are not 30 then return the first day of the next month. example if 10/4/2021 and 11/04/2021 are less then 30 days then 12/01/2021
  • To post as a guest, your comment is unpublished.
    r4deak · 17 days ago
    setting sheets so always 100% and open on cell A1??
  • To post as a guest, your comment is unpublished.
    3l3phant · 1 months ago
    Can the Excel tool be used to format a cell color as well as lock and unlock a cell based on the value in another cell?
  • To post as a guest, your comment is unpublished.
    janick1980. · 1 months ago
    Good evening,

    Just a question , I would like to buy a license for excel. But I am asking myself the following question:
    I now have an older computer where I would like to start with KUtools. But what happens to the license if I buy another computer?

  • To post as a guest, your comment is unpublished.
    gn.umapathy@gmail.com · 3 months ago
    I have the license for the previous versions but the free upgrade support should have expired already.

    The link in Excel Kutools to upgrade the license is dead (as shown in attachment). And I cannot find information about upgrade an expired upgrade plan. Please advise the upgrade method and pricing accordingly.
  • To post as a guest, your comment is unpublished.
    Deborah M · 3 months ago

    Hi- how can I import individual PowerPoint slide images into excel cells without copy/pasting each one?
  • To post as a guest, your comment is unpublished.
    Binish · 3 months ago
    Can I download for  MAC. 
  • To post as a guest, your comment is unpublished.
    skesel · 3 months ago
    Have a spreadsheet with Week Number in column A, Weekdays (Sun through Sat) in column B and a number in column C.  I need to create a charte the shows each days number grouped by week.  Each column in the group is a different color by day of week. See attached snip of data and chart sample.
    • To post as a guest, your comment is unpublished.
      Zarathrustra · 3 months ago
      Thanks for responding skesel, but I fear I didn't explain my problem clearly enough as your suggestion does not address my problem where I already have the complex listing.

      I wish to de-concatenate (or desegregate) an existing cell's content, so where I have a cell with:
      E:\By Years\1968\ 19680000 06 UK_ Mnchstr_UMIST_RegTalbotsBath_6788.jpg, 
      I wish to have that mapped into 4 separate: cells
      E
      By Years
      1968
      19680000 06 UK_ Mnchstr_UMIST_RegTalbotsBath_6788.jpg,
  • To post as a guest, your comment is unpublished.
    Susan Kesel · 3 months ago
    I need to create a bar chart with 8 weeks of data and charting by day of week (ie columns grouped by day of week with each column within the group representing a day.
  • To post as a guest, your comment is unpublished.
    Bruce · 4 months ago
    I keep getting the following error:  Access Violation at address 000000000278DCDD in module 'PaneforKutools64.dll.

    what should I do?
  • To post as a guest, your comment is unpublished.
    guy champ · 5 months ago
    trying to make marrimekko chart for phd thesis. i really want to switch axis to make legends more readable, but either chart does not display ( no error,just nothing happpens) or the transpose axis function is not available.any help appreciated..
  • To post as a guest, your comment is unpublished.
    sers000 · 5 months ago
    Initially I could use "Drop-Down List with Check Boxes " prior to the 30 days trial expiry. After the trial expiry, the list no longer shows up when i click on the cell, i assumed it was because of the trial expiry so I purchased the license. Unfortunately, I am still having the same issue. Any help would be appreciated.
  • To post as a guest, your comment is unpublished.
    Ihab Yaseen · 5 months ago
    Initially I could use "Drop-Down List with Check Boxes " prior to the 30 days trial expiry. After the trial expiry, the list no longer shows up when i click on the cell, i assumed it was because of the trial expiry so I purchased the license. Unfortunately, I am still having the same issue. Any help would be appreciated.
  • To post as a guest, your comment is unpublished.
    John · 5 months ago
    The Kutools tabs aren't showing up in my task bar and I can't seem to get them added.  What am I doing wrong?
  • To post as a guest, your comment is unpublished.
    Nathan · 5 months ago
    I want to find/replace text within "Comments" not "Notes" and cannot find where to do it. Websites point to a "More" button on the Ribbon in the Editing Tab, but I have no such choice.

  • To post as a guest, your comment is unpublished.
    Ping · 7 months ago
    Sometime I can't insert picture from path, I wonder why?
  • To post as a guest, your comment is unpublished.
    Zarathrustra · 7 months ago
    How can I take a numerica+text string in a cell and split it up, for example: E:\By Years\1968\19680000_06_UK_Mnchstr_UMIST_RegTalbotsBath_6768.jpg
    so that I have: E:\By Years\1968\ 19680000 06 UK_ Mnchstr_UMIST_RegTalbotsBath_6788.jpg
    all into four separate cells?
  • To post as a guest, your comment is unpublished.
    Jerry Mairani · 8 months ago
    I have a large file, I have had to disable Kutools to work with it. Very slow, have I disabled all other add-ins. Over a 1500 tabs
  • To post as a guest, your comment is unpublished.
    Robert · 9 months ago
    when i use count by color the color method box is greyed out, any ideas?

  • To post as a guest, your comment is unpublished.
    MMMe · 10 months ago
    I want to know how to uninstall Kutools, I cant find out the way to take it off.
  • To post as a guest, your comment is unpublished.
    MKme · 10 months ago
    Hi I have 2 columns , location and color..
    I need to count all unique cominations from Location and color for example:

    For Location R2 .. I need a formula that brings me "2" as the answer .. Since there are R2BLUE(+duplicate)+ R2GREEN,
    What can i do?
    =COUNTIFS(a15:a21,"r2",a15:a21,"<>0") This formula is counting the duplicate so brings me a "3"
    =SUM(IF(B15:B21<>"",1/COUNTIF(B15:B21,B15:B21))) .. This Formula gives me the unique values from column B (5) , but I dont know how to limit to location R2.

    PLEASE HELP!!!

    LOC COLOR
    R2 R2BLUE
    A1 A1BLUE
    A1 A1BROWN
    R2 R2BLUE
    R2 R2GREEN
    A1 A1PINK
    A1 A1PINK
  • To post as a guest, your comment is unpublished.
    John · 11 months ago
    I am looking to split addresses to multiple cells on the same row. I am looking to move data from one cell and split it if it begins with S or N. I want to move the S or N to the previous cell. If the cell has data that does not begin with N or S I want it left alone.

    1. S RALEIGH AVE
    2. ATLANTIC AVE
    3. S NORTH CAROLINA 906
    4. N NEW HAMPSHIRE AVE
    5. MADISON AVE

    Then I also need to move the Ave, street, alley to another cell on the same row as well.

    I have over 18000 rows of data I need to do this for. Is it possible?
  • To post as a guest, your comment is unpublished.
    Gourav · 1 years 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.
      gavcol · 6 months ago
      I've had the same issue. The split workbook function should not be changing data like this.
      Is it due to the limitation of only exporting to macintosh csv ?
      There should be the standard csv file type available
  • To post as a guest, your comment is unpublished.
    David Lynch 1 · 1 years 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 · 1 years 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 · 1 years 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 · 1 years 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.
    Craig de Jager · 1 years 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 · 1 years ago
    can i convert number in indian rupees format in words

  • To post as a guest, your comment is unpublished.
    theo · 1 years 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 · 1 years 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 · 1 years ago
      Yes, you can.
  • To post as a guest, your comment is unpublished.
    Mike · 1 years 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 · 1 years 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.
    · 1 years ago
    Hi, is any translation in Arabic language?
    thanks.
  • To post as a guest, your comment is unpublished.
    Moeen · 1 years 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 · 1 years 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 · 1 years 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 · 1 years 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 · 1 years 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 · 1 years 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 · 1 years ago
    can it work on ipads?
  • To post as a guest, your comment is unpublished.
    cy · 1 years 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 · 1 years ago
    pdf to excel
  • To post as a guest, your comment is unpublished.
    sowmissk · 1 years ago
    how to clear cell compare rules or modify the rules
  • To post as a guest, your comment is unpublished.
    sowmissk · 1 years 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 · 1 years 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 · 1 years 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 · 1 years 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 · 1 years 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 · 1 years 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 · 1 years ago
    how do i put kutools on my excell I downloaded it
    • To post as a guest, your comment is unpublished.
      Heather · 1 years 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 · 1 years 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?