Automate repetitive tasks like merging sheets, splitting cells, or batch-converting files.
Append prefixes, suffixes, or specific characters to hundreds of cells at once. Go to Kutools > Text > Add Text , type your string, and specify its position (e.g., Before first character). Advanced Formulas and Calculations
: Microsoft Office 365, Excel 2021, 2019, 2016, 2013, and 2010 (both 32-bit and 64-bit). Disk Space : Minimum 150 MB of free hard drive space. Installation Steps
Features like "Encrypt Cells" allow you to mask data or protect specific ranges with a password [15]. Kutools for Word : Focuses on document organization [13]. kutools user guide pdf new
Navigate to Kutools > Formula Helper > Formula Helper . Common Use Cases: Calculate age based on a birthdate. Count the number of specific words or characters in a cell. Sum values based on criteria across multiple worksheets.
Formatting all visuals in a 100-page document is tedious. Go to Kutools > Paragraphs (or Tables / Shapes ) and use the selection tools to select all tables, equations, or images across the document instantly for bulk formatting. Content Conversion and Text Tools
Reset font styles, weights, and colors to your default template without losing the raw text. Part 4: What's New in the Latest Version Advanced Formulas and Calculations : Microsoft Office 365,
Open Excel or Word. You will see a new tab labeled and Kutools Plus on the ribbon interface. 3. Core Features of Kutools for Excel
This isn’t just a rehash of the old help file. The latest PDF guide has been completely restructured for clarity and speed. Here is what you will find inside:
Go to the dropdown menu at the bottom, select Disabled Items , and click Go . Kutools for Word : Focuses on document organization [13]
Go to Kutools Plus > Combine . Follow the wizard to merge multiple sheets from different files into one master sheet, automatically aligning matching column headers.
(Reminder: I can also generate the full draft content ready to paste into a PDF authoring tool.)
Easily split workbooks, merge multiple sheets, and convert file formats (XLS to PDF) [4, 11].
The iteration of the guide (version 30+) is significantly different from legacy PDFs from 2019. You will find:
Create complex filtering criteria involving multiple conditions and logical arguments (AND / OR) that standard Excel filters cannot handle.