ZKutools Anywhere for Excel Feature List
AuthorXiaoyang•Last modified
ZKutools Anywhere for Excel combines AI-powered features with practical Kutools tools to simplify everyday Excel work. It helps you generate formulas, create tables, sort and filter data, extract information, and clean text more efficiently in Excel.
Tip ZKutools Anywhere for Excel works with Microsoft Excel for the web (Excel Online), Excel for Windows, Excel for Mac, and Excel for iPad.
After installation, you can access these features from the ZKUTOOLS tab in Excel.
| 👁️ View Features | |
| Navigator | Displays all worksheets in the current workbook in a side pane, allowing you to quickly search for and switch to a specific sheet. |
| Columns | Easily manage and process worksheet columns with practical tools for common column-related tasks. |
| ✨ AI Features | |
|---|---|
| Assistant | Provides an AI-powered assistant inside Excel to help users understand data, generate content, create formulas, and perform common spreadsheet tasks more easily. |
| Generate Formula | Helps users generate Excel formulas from natural language descriptions, reducing the need to manually write complex formulas. |
| Quick Table | Quickly creates structured tables based on user requirements or extracts data from other files to generate organized tables, helping users prepare worksheets and summarize information more efficiently. |
| Conditional Format | Applies conditional formatting rules to highlight important values, trends, duplicates, exceptions, or cells that meet specific conditions. |
| Advanced Filter | Filters data using more flexible criteria, helping users quickly find matching records, extract specific rows, or narrow down large datasets. |
| Advanced Sort | Sorts data by one or multiple columns with advanced rules, including custom sorting orders and natural-language sorting instructions. |
| Smart Pivot | Helps users summarize and analyze data more easily by creating pivot-style reports or data summaries with less manual setup. |
| Data Validation | Creates or manages data validation rules to control input, build dropdown lists, and keep worksheet data accurate and consistent. |
| Text Processing | Provides tools for cleaning, editing, extracting, and transforming text values in selected cells without using complicated formulas. |
| Format | Helps users quickly adjust cell formats, improve worksheet appearance, and standardize the layout of selected ranges. |
| Extract Information | Extracts useful information such as names, addresses, emails, keywords, numbers, or custom data from text strings. |
| 📊 Workbook & Sheet | |
| Match Replace | Matches rows between two tables and updates selected values in Table A using data from Table B based on specified matching columns. |
| ✏️ Edit | |
|---|---|
| Text | |
| Change Case | Converts selected text to uppercase, lowercase, proper case, sentence case, or other case styles for cleaner and more consistent data. |
| Add Text | Adds specific text, characters, prefixes, suffixes, or separators to selected cells in bulk. |
| Remove Spaces | Removes extra spaces, leading spaces, trailing spaces, or all spaces from selected cells to clean imported or inconsistent text data. |
| Delete Characters | Deletes specific characters, symbols, numbers, letters, or unwanted text from selected cells quickly. |
| Remove by Position | Removes characters from the left, right, a specified position, or based on specified text markers, making it useful for cleaning structured text strings. |
| Reverse Text | Reverses the order of characters or text content in selected cells, useful for special text processing or data transformation tasks. |
| Replace Characters | Replaces specific characters, symbols, words, or text fragments with new content across selected cells. |
| Convert | |
| Calculation Tools | Performs common mathematical operations on selected cells without requiring users to create formulas manually. |
| Round Numbers | Rounds selected numbers normally, up, down, or using Banker’s Rounding with the specified number of decimal places. |
| Spell Out Numbers | Converts numeric values into written words for invoices, checks, reports, and other documents. |
| Change Sign | Changes positive numbers to negative, negative numbers to positive, or reverses the signs of all selected numbers. |
| Convert between Roman and Arabic Numerals | Converts Roman numerals to Arabic numbers or Arabic numbers to Roman numerals. |
| Recognize Dates | Identifies non-standard date values and converts them into valid Excel dates. |
| Currency Conversion | Converts selected amounts between currencies using an editable or updated exchange rate. |
| Other Tools | |
| Make Up a Number | Finds all combinations of numbers in a selected range that add up to a specified total. |