登入  \/ 
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 24.00
日期:18年2020月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.
    narendra · 1 years ago
    hi
    i am not able to use this formula in windows10

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

    kindly help on it
  • To post as a guest, your comment is unpublished.
    Robs · 1 years ago
    Hi, I would like to export a range of data as CSV file with KuTools. But I have errors with the export as I use commas in the currency in the cells.
    So my question is if there is a possibility that KuTools will export my data to csv semicolon delimited.
  • To post as a guest, your comment is unpublished.
    Mark Martin · 1 years ago
    Hello. I just downloaded the Kutools for Excel and giving it a test run. Within one workbook I placed two sheets and I would like to be able to highlight the differences from one sheet to the other. Is this possible??
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 1 years ago
      Yes, we have such feature. Please use this feature, and select the whole worksheet as a range.
      https://www.extendoffice.com/product/kutools-for-excel/excel-compare-ranges,-rows-and-columns.html
  • To post as a guest, your comment is unpublished.
    Kevin · 1 years ago
    Recently installed kutools trial, having real issues with the viewing area when on my laptop with multiple displays and more than one workbook open. Shifting focus causes the viewing area to resize and jump around, if the navigation pane is open everything disappears. Impossible to work with. I thought it might be a conflict with Ablebits, which I have the enterprise version installed, but after uninstalling that and restarting the issue persists. I am using the most recent version of Excel 2019 on windows via a 365 subscription. Hoping this can be fixed as the features seem to be genuinely useful, but only if I can see my workbooks.
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 1 years ago
      Hello,
      Please don't try to post your issue here. This is not the support area. Please try to contact us via email or the forum for the fast support. Thanks. :)
      Please try this version https://download.extendoffice.com/downloads/Kutools-for-Excel/beta/KutoolsforExcelSetup.exe
  • To post as a guest, your comment is unpublished.
    Nicky · 1 years ago
    I have a class list and template for student profiles and would like to quickly create individual student profiles from the template worksheet for each student on the class list worksheet. How am I able to do this?
  • To post as a guest, your comment is unpublished.
    vvieira1168@gmail.com · 1 years ago
    Is there a Portuguese language version (Brazilian)?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 1 years ago
      Hello,
      Sorry, we don't have this language yet. We will add it in the upcoming versions. :)
  • To post as a guest, your comment is unpublished.
    Vitor Vieira · 1 years ago
    Is there a Portuguese language version?
  • To post as a guest, your comment is unpublished.
    David Linton · 1 years ago
    does it work with office for mac?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 1 years ago
      Sorry, we don't have the mac version yet.
  • To post as a guest, your comment is unpublished.
    Jacob · 1 years ago
    Excel 2013 doesn't load the kutools for excel 16.5 or 18.0. i'm a license owner. Excel tells me "runtime error". What can I do for it?
  • To post as a guest, your comment is unpublished.
    Jason Gregg · 1 years ago
    version 18 keeps crashing excel, any ideas
  • To post as a guest, your comment is unpublished.
    fares · 1 years ago
    How do I make kutools handle conditional formatting?
  • To post as a guest, your comment is unpublished.
    Gudgeon · 1 years ago
    How can I make a heading blink in a single sheet of my work book?
  • To post as a guest, your comment is unpublished.
    ansar@pluraldesigns.com · 2 years ago
    can we make conditional formating by using kutools
  • To post as a guest, your comment is unpublished.
    brutality812@gmail.com · 2 years ago
    Kutools for Excel has the following issues with the Find and Replace bar on Excel 2016:

    When excel is minimized, hitting Ctrl + F in other applications with re-prioritize Excel somehow and it will open the Find dialog box there. It will do this without switching windows, and it will also disable the Ctrl + F functionality inside other applications until that dialog box is closed.


    Please offer a solution to this very irritating problem.


    Windows 10 x64 1803
  • To post as a guest, your comment is unpublished.
    Corey D · 2 years ago
    Kutools for Excel has the following issues with the Find and Replace bar on Excel 2016:

    When excel is minmized, hitting Ctrl + F in other applications with re-prioritize Excel somehow and it will open the Find dialog box there. It will do this without switching windows, and it will also disable the Ctrl + F functionality inside other applications until that dialog box is closed.


    Please offer a solution to this very irritating problem.


    Windows 10 x64 1803
  • To post as a guest, your comment is unpublished.
    Henry Kim · 2 years ago
    I bought this product, but I would like to check I am able to this product with many computers.
    Of course, I do have many computers, lab top and desk tops.
    Can I use this single license to many computers?
  • To post as a guest, your comment is unpublished.
    mysser13 · 2 years ago
    I installed the lastest version of Kutools for Excel. However, it made Excel work very slow and trouble always. I use Office 365 with lastest update.

    Plz give me solution. Thanks!
  • To post as a guest, your comment is unpublished.
    Dylan Muzzy · 2 years ago
    The computer had Kutools installed changed users and now it can't be activated. This is in a business environemnt.
  • To post as a guest, your comment is unpublished.
    · 2 years ago
    Is Kutools for Excel compatible with the 64 bit version of Office 365?
  • To post as a guest, your comment is unpublished.
    Guy Shuster · 2 years ago
    Please advise how to show and delete Hidden Chars

    Thanks.
  • To post as a guest, your comment is unpublished.
    Buddy · 2 years ago
    If I purchase Kutools and install it on my machine, then create a spreadsheet that uses a Kutools feature, and save the sheet. When another machine that does not have Kutools installed opens the spreadsheet will the feature, that I used when the sheet was saved, work on their machine. In other words after a feature is used is it embedded in the sheet and will then work anywhere the sheet is opened? Or, will I have to purchase a license for any machine that will be opening the sheet?
  • To post as a guest, your comment is unpublished.
    Steve Chalker · 2 years ago
    I am a personal user of excel (not business). I have 3 PC's 1 desktop 2 laptops, for speed reasons on my stock CFD transactions and calculations i use all 3 at various times, My question is can i purchase only one KuTools for the 3 PC's or do I need to purchase 3?
    • To post as a guest, your comment is unpublished.
      Excelfans · 2 years ago
      Hello,
      Please take a look at https://www.extendoffice.com/support/end-user-license-agreement.html
  • To post as a guest, your comment is unpublished.
    truongquyen@outlook.com · 2 years ago
    Hi! I use the convert function to convert Excel to PDF, is there anyway to convert the active sheet only? Right now, I have to convert all the worksheet.


    Tks,
    NTQ
  • To post as a guest, your comment is unpublished.
    mikejamescusick@gmail.com · 2 years ago
    I have a column of names, some with 1st and Last Name, and some with 1st, middle initial and last name. I need this column moved to 3 separate columns of 1st name, middle initial and last name. Can Kutools do this? Which function? thank you
  • To post as a guest, your comment is unpublished.
    prakashekhande@gmail.com · 2 years ago
    Hi


    Is there any tab or other software to reduce the excel file size?
  • To post as a guest, your comment is unpublished.
    Jeneen · 2 years ago
    I'm trying to combine worksheets of large amounts of data. I can't find the area where I need to enter in a Primary Key. Does anyone know how to get there? I thought I had to go to COMBINE and then it should be there, but it's not.
  • To post as a guest, your comment is unpublished.
    · 2 years ago
    I have a membership list with email addresses, I would like to send a flyer to the members using the excel list without typing out all the email addresses
  • To post as a guest, your comment is unpublished.
    Tarsis · 2 years ago
    Good morning, I want to know how to access crack Kutools For Excel ?
  • To post as a guest, your comment is unpublished.
    Thomas · 2 years ago
    Good morning! I have used the "list all combinations" function to generate a catalog number based on all options available for a certain product. Subsequently, each of the options has a specific dollar value. After generating all combinations, is there a formula to apply those values to the generated combinations to get a price?
  • To post as a guest, your comment is unpublished.
    frnaill · 2 years ago
    Can you select a range of worksheets or specific worksheets from the navigation pane?
  • To post as a guest, your comment is unpublished.
    jerome · 2 years ago
    Hello.
    Please is there a way to remove duplicates only if they are subsequent? And making it to count from 1 again once there is a break.
    I tried the select duplicates feature but it does not start to count again after a break. It recognizes if the value was counted before. Please help. Thanks
  • To post as a guest, your comment is unpublished.
    atieghi · 2 years ago
    Kutools do not start when excel starup
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 2 years ago
      Hello,
      Please go to check your Excel add-ins manager. Please go to download and install the software with the EXE installation package.
      BTW, Please don'r post such question here. We will not answer you quickly. Please contact us with the email.
  • To post as a guest, your comment is unpublished.
    Simon Greenwood · 2 years ago
    Every time I try to use the Kutools plugin for Excel, it crashes. Excel simply closes down. Is this a known issue? Is there a solution? Thanks. Si
  • To post as a guest, your comment is unpublished.
    Damodar · 2 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 · 2 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 · 2 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 · 2 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.
    pratap singh · 2 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.