Kutools for Excel: Powerful Excel Toolbox

Navigation: Navigate workbooks, sheets, columns, and named ranges, and easily insert AutoText entries—all from one panel.

Grid Focus (Reading Layout): Automatically highlight the entire row or column of the active cell to improve readability.

AI Aide: Revolutionize how you interact with Excel, offering an unprecedented level of support and automation.

Design View:

• Lock Cells: Easily lock selected cells when protecting the worksheet.
• Unlock Cells: Easily unlock selected cells when protecting the worksheet.
• Highlight unlocked: Instantly highlight all unlocked cells in the sheet.
• Hide Formulas: Quickly hide formulas in protected worksheets.
• Unhide Formulas: Instantly unhide formulas in protected worksheets.
• Highlight Hidden: Highlight cells containing hidden formulas with one click.
• Highlight Formulas: Highlight all cells with formulas in the worksheet.
• Highlight Names: Highlight all named ranges in the current worksheet.
• Monitor Precedents / Dependents: Auto-display all precedents and dependents of the selected range.
• Settings; Open the settings center of the Design Tools.
• Close Design: Exit the Design tab with one click.

Date Picker: Quickly enable date picker (drop down calendar) for date cells in Excel.

Big Formula Bar: View and edit long cell contents more easily with an expanded formula bar.

View:

• Show Classic Menu on Quick Access Toolbar: Restore the classic Excel menu style in Excel 2007 and later versions.
• Snap (Backup Current Workbook): Instantly take snapshots of your workbook and restore them when needed.
• Advanced Data Form: Create structured, user-friendly data entry forms in seconds.
• Toggle Hidden Columns Visibility: Instantly show or hide all hidden columns.
• Toggle Hidden Worksheets Visibility: Quickly toggle all hidden sheets to be visible or invisible in Excel.
• Work Area: Maximize or reduce the visible working area by toggling Ribbon, Formula Bar, and Status Bar.
• Always Show Comment: Automatically display cell comments when the cell is selected.
• Set Scroll Area: Restrict scrolling by hiding all unselected rows and columns.
• Unhide All Ranges: Unhide all hidden rows and columns at once.
• Hide Unselected sheets: Hide all worksheets except those currently selected.
• Unhide All Hidden Sheets: Show all hidden worksheets with one click.
• Hide Inactive Windows: Hide all inactive workbook windows to focus on the current one.
• Unhide All Hidden Windows: Reveal all hidden workbook windows instantly.
• Hide/Unhide Workbooks and Sheets: Quickly manage visibility of workbooks and worksheets with ease.
• View Options: Quickly toggle various Excel interface elements like gridlines, scrollbars, and sheet tabs.

Range:

• Flip Horizontal Range: Reverse the data order of multiple columns horizontally.
• Flip Vertical Range: Reverse the data order of multiple rows vertically.
• Transpose Table Dimensions: Convert a cross table to a list easily, or vise versa.
• Transform Range: Transpose a single row or column to a range, or vice versa.
• Swap Ranges: Swap cells, rows, columns, or ranges easily.
• Sort / Select Range Randomly: Randomly sort or select cells, rows, or columns.
• Paste to Visible: Paste data only into visible cells or filtered lists.
• Set Scroll Area: Restrict scrolling by hiding all unselected rows and columns.
• Unhide all Ranges: Unhide all hidden rows and columns at once.

Find Duplicates: Select, hide, identify or highlight duplicates excluding their first appearances with just a few clicks.

Copy Ranges: Copy multiple non-contiguous ranges easily.

Compare Cells: Compare two ranges and highlight same or differences.

Prevent Typing:

• Prevent Duplicate: Prevent duplicate entries in a column.
• Prevent Typing:
  1. Easily prevent special or certain characters from being typed in cells
  2. Only allow specific characters to be entered in a range of cells
• Validate Email Address: Ensure entries are valid email addresses.
• Validate IP Address: Allow only valid IP addresses.
• Validate Phone Number: Validate phone number formats in cells.
• Clear Data Validation Restrictions: Remove all data validation rules in bulk.

Drop-down List:

• Quickly Create a Drop-Down List: Create a standard drop-down list quickly.
• Colored Drop-down List: Add conditional formatting colors to drop-down items.
• Picture Drop-down List: Create drop-down lists with pictures.
• Multi-select Drop-down List: Allow multiple selections from a drop-down list.
• Drop-down List with Check Boxes: Create drop-down lists with checkboxes.
• Make Drop-down List Searchable, Auto-popup: Create autocomplete or searchable drop-downs.
• Advanced Drop-down List Manager: Remove advanced drop-down lists added by Kutools.
• Dynamic Drop-down List: Easily create multiple levels (2-level or 3-5 level) drop-Down list in Excel.
• Update Dynamic Drop-down List: Update dynamic drop-down list items.
• Expand Dynamic Drop-down list Range: Extend dependent drop-down ranges.

Content:

• Convert between Text and Number: Switch cell format between text and number.
• Convert Formula to Text: Turn formulas into plain text.
• Convert Text to Formula: Convert text strings into executable formulas.
• Convert to Date: Convert recognized text to date format.
• Convert Time: Convert time values to seconds, minutes, or hours.
• Currency Conversion: Convert between different currencies.
• Unit Conversion: Convert units like length, weight, temperature, etc.
• Number Systems Conversion: Convert between binary, decimal, and hex systems.
• Number to Words: Convert numbers to English words.
• Convert between Roman and Number: Switch between Roman numerals and numbers.
• Change Sign of Values: Quickly change sign of numbers in Excel.
• Convert Number to Ordinal: Change numbers to ordinal format (e.g., 1st, 2nd).
• Make up a Number: Find number combinations that sum to a target value.

To Actual; Replace formulas with their result values.

Round (Without Formula): Round numbers directly without using a formula.

Merge & Split:

• Combine Rows, Columns or Cells without Losing Data: Quickly combine (merge) multiple columns or rows without losing data.
• Split Data to Rows: Easily split delimited text into different rows by a certain separator.
• Split Cells: Split text in cells by delimiter into rows or columns.
• Split Names: Separate full names into first, middle, and last.
• Merge Same Cells: Quickly merge adjacent cells in columns with same data/value in Excel.
• Unmerge Cell & Fill Value: Unmerge and fill each cell with the original value.
• Advanced Combine Rows: Combine duplicate rows and summarize values.

Charts:

• Data Distribution Charts
  1. Bubble Chart: Quickly create a bubble chart to visualize data distribution.
  2. Normal Distribution / Bell Curve Chart: Easily generate a bell curve to represent normal distribution.
  3. Dumbbell Plot Chart: Create a dumbbell chart to compare two sets of values point by point.
  4. Dynamic Pie Of Pie Chart: Build a dynamic Pie of Pie chart to better display grouped data.
  5. Scrollable Line Chart: Create a line chart with a scroll bar to dynamically explore data trends.
• Point in Time Charts
  1. Gantt Chart: Quickly create a Gantt chart to visualize project timelines.
  2. Timeline Chart: Generate a milestone or timeline chart to track chronological events.
• Progress Charts
  1. Speedometer Chart: Easily create a 180° or 270° speedometer chart to show progress against a goal.
  2. Bullet Chart: Build vertical or horizontal bullet charts to compare performance metrics.
  3. Thermometer Chart: Create a thermometer chart to display progress as a percentage.
  4. Target and Actual Chart: Visualize target vs. actual values with a clear comparison chart.
  5. Progress Bar Chart: Display project completion as a percentage with a progress bar.
  6. Progress Ring Chart: Show percentage completion inside a doughnut-style progress chart.
  7. Percentage Ball Chart: Represent completion rate with a colored percentage ball chart.
  8. Project Status Spectrum Chart: Use a spectrum chart to compare multiple project progress levels.
  9. Project Status Bead Chart: Display the status of multiple projects simultaneously with a bead chart.
  10. Battery Chart: Create a battery-style chart to visually indicate completion status.
  11. Alternative Progress Bar Chart: Design an alternative-style progress bar chart with a few clicks.
• Difference Comparison Charts
  1. Step Chart: Quickly create a step chart to show data changes at intervals.
  2. Column Chart with Percentage Changed: Easily create a column chart displaying percentage change between values.
  3. Slope Chart: Create a slope chart to visually compare data changes between two points.
  4. Threshold Value Chart: Create a segmented y-axis chart to compare data against a threshold.
  5. Difference Arrow Chart: Generate a bar chart with arrows indicating percentage differences.
  6. Matrix Bubble Chart: Easily create a matrix bubble chart to compare multiple data dimensions.
  7. Bar with Bubble Chart: Create a hybrid chart combining bars and bubbles for dual insights.
  8. Difference Comparison Chart: Quickly generate a year-over-year comparison bar chart.
  9. Difference Area Chart: Create an area chart to highlight differences between two data sets.
  10. Progress Pie Chart: Display multiple progress pie charts side by side for easy comparison.
  11. Radial Bar Chart: Create a radial bar chart to visualize data in a circular layout.
  12. Alternative Rose Chart: Generate an alternative rose chart for data presentation.
  13. Nightingale Chart: Easily create a Nightingale rose chart to compare category-based values.
  14. Bidirectional Histogram Chart: Compare two data sets along a horizontal axis using a bidirectional histogram.
  15. Multiple Series Line Chart: Plot multiple data series in one line chart for comparison.
  16. Smooth Area Chart: Create an area chart with smoothed lines for clearer trends.
  17. Horizontal Waterfall Chart: Build a horizontal or mini waterfall chart to show incremental changes.
  18. Interval Lable Bar Chart: Create a bar chart with category labels placed above bars to save space.
  19. Stacked Difference Chart: Visualize value changes using stacked bar/column charts with direction arrows.
  20. Dynamic Column Chart: Generate a dynamic column chart that displays one series at a time via a dropdown.
  21. Dynamic Ranking Bar Chart: Create a scrollable bar chart to show the top N values in descending order.
  22. Truncate the Y-axis Chart: Build a truncated Y-axis chart to balance very large and small values visually.
• Category Comparison Charts
  1. Color Grouping Chart: Create a chart that colors bars or columns based on their value ranges.
  2. Dot Chart: Display the frequency of data points in a dataset using a dot plot chart.
  3. Variable Width Column Chart: Create a column chart with varying widths and heights to represent two dimensions of data.
  4. Marimekko Chart: Visualize multiple qualitative variables using a mosaic-style Marimekko chart.
  5. Lollipop Chart: Display values with slim lines and circular markers to make data visually engaging.
  6. Multi Series Area Chart: Create an area chart that compares multiple data series at once.
  7. Proportion Stacked Chart: Build a stacked chart with squares showing the proportion of each value in a series.
  8. BiDirection Bar Chart: Create a bidirectional bar chart to compare two series side by side.
  9. Stacked Chart with Percentage: Create a stacked chart that displays the percentage composition of each series.
  10. Multi Series Histogram Chart: Generate a histogram or bar chart with multiple data series.
  11. Multi Layer Column Chart: Build a layered column chart to show multiple series in a stacked format.
  12. Forecast Chart: Create a forecast chart to visualize predicted trends over time.
  13. Threshold Value Area Chart: Create an area chart segmented by threshold values for better comparison.
  14. Rectangular Pie Chart: Quickly build a rectangular version of a pie chart to visualize proportions.
  15. Half Pie Chart: Create a semi-circular pie chart to highlight part-to-whole relationships.
  16. Price Tag Chart: Display price labels as tags to enhance product or cost comparison.
  17. Check Box Line Chart: Make an interactive line chart with checkboxes to toggle series visibility.
  18. Alternative Stacked Column Chart: Create a variation of the stacked column chart to display data series as sections of a single bar.
  19. Dynamic Polyline Chart: Build a scrollable polyline chart that highlights a selected data point in a dataset.
• Chart Tools
  1. Color Chart by Value: Automatically color chart elements based on cell values.
  2. Add Line to Chart: Insert a horizontal or vertical average line into a chart with one click.
  3. Copy Format to Other Charts: Apply the formatting of one chart to others across the workbook in bulk.
  4. Set Absolute Position of Chart: Define the exact position of a chart within the worksheet.
  5. Add Sum Labels to Chart: Add total value labels to a stacked chart with a single click.
  6. Add Cumulative Sum to Chart: Display an accumulated total line in a clustered column chart.
  7. Move X-axis to Negative/Zero/Bottom: Reposition the X-axis label to zero, negative, or bottom with one click.
  8. Add Trend Lines to Multiple Series: Insert trend lines for multiple series in a scatter chart.
  9. Change Chart Color According to Cell Color: Sync chart element colors with their source cell colors.
  10. Add Poly Line: Insert a polyline with an arrow into a chart to indicate trends or relationships.
  11. Detach Chart: Break the chart's link to source data while preserving its appearance.

Find:

• Super Find
  1. Find in comments: Find specific text strings only within comments across selection, sheet, or workbook.
  2. Find in formulas: Search for specific text within formulas in the selected range, sheet, or entire workbook.
  3. Find in hyperlinks: Locate text values only within hyperlinks in the selection, sheet, or workbook.
  4. Find in cell values: Search text in cell values based on length, case, or substring criteria.
  5. Find by date criteria:Locate cells containing date values that match specific criteria in your selection or workbook.
  6. Find by number criteria: Search for numbers within a defined range, such as greater than or between values.
  7. Find by cell formatting: Find all cells matching specific formatting like bold, italic, strikethrough, or color.
• Fuzzy Lookup: Search and replace similar text records within a list using fuzzy matching.
• Find & Replace in Workbooks: Perform batch find and replace across multiple worksheets and workbooks.
• Find Duplicates: Detect, highlight, hide, or select duplicate values while keeping the first occurrence.

Select:

• Select Range Helper: Easily select, deselect, or reverse selections in the current workbook.
• Select Range Randomly: Randomly select cells, rows, or columns from a given range.
• Select Interval Rows & Columns: Select every Nth row or column within a large dataset.
• Select Merged Cells: Instantly select all merged cells in a selected range.
• Select Last Cell: Select the last used cell, or the last cell with data in a row or column.
• Select Cells with Max or Min Value: Select the cell with the maximum or minimum value in a range.
• Select Cells with Error Value: Select all cells with formula errors like #DIV/0!, #N/A, etc.
• Select Unlocked Cells: One click to select all unlocked cells in the specified range.
• Select Nonblank Cells: One click to select all non-empty cells from a selected range.
• Select Specific Cells: Select cells or rows that meet custom criteria from a range.
• Select Cells with Format:Select all cells matching the format of a reference cell.
• Select Duplicate & Unique Cells: Select duplicate or unique values or entire rows in a range.
• Select Same & Different Cells: Compare two ranges and select cells that are the same or different.

Insert:

• Insert Titles Rows: Quickly insert title rows above each data block in a range.
• Insert Blank Rows & Columns: Alternately insert blank rows or columns at specified intervals.
• Duplicate Rows / Rows based on cell value: Easily duplicate rows based on a cell's numeric value.
• Insert Random Data: Insert random numbers, dates, or passwords into selected cells.
• Insert Sequence Number: Generate and insert sequential numbers into a range.
• Find Missing Sequence Number: Identify and insert missing numbers in a sequence.
• Fill Custom Lists: Easily fill cells with custom list items vertically or horizontally.
• List All Combinations: Quickly generate all possible combinations from selected lists.
• Insert Barcode: Easily insert multiple barcodes based on cell values.
• Insert QR Code: Insert multiple QR codes based on cell values.
• Insert Bullet: Add bullet points to the beginning of selected cells.
• Insert Numbering: Add bullets or numbered lists to multiple cells.
• Insert Date: Insert formatted dates by selecting from a date picker.
• Fill Blank Cells: Fill blank cells with the value above or with zero.
• Batch Insert Check Boxes: Insert checkboxes into multiple cells at once.
• Batch Insert Option Buttons: Insert option buttons into specified cells or ranges.
• Insert Watermark: Easily insert text or image watermarks into the worksheet.
• Insert Pictures from Path(URL): Easily import images from file paths or URLs into cells.
• Resource Library: Save and reuse text, charts, formulas, and ranges with one click.
• Add Rows: This right-click feature allows you to quickly insert a specified number of rows above or below the selection.
• Add Below: This right-click feature enables you to directly insert an equivalent number of rows below the selected row(s).
• Add Columns: This right-click feature allows you to quickly insert a specified number of columns to the left or right of the selection.
• Add to Right: This right-click feature enables you to directly insert an equivalent number of columns to the right of the selected column(s).

Delete:

• Delete Blank Rows:Quickly delete blank rows from selected range, worksheet, or entire workbook.
• Delete Hidden (Visible) Rows & Columns: Delete all hidden or visible rows and columns in Excel.
• Delete Watermark: Remove watermarks inserted by Kutools' Insert Watermark feature.
• Delete Illustrations & Objects: Delete all charts, text boxes, and embedded objects in one click.
• Delete Web Controls: Easily remove all HTML-based controls like checkboxes from the worksheet.
• Batch Delete Check Boxes: Delete multiple checkboxes from selected cells at once.
• Batch Delete Option Buttons: Delete all option buttons within a specific range instantly.
• Remove All Macros: Quickly remove VBA modules, UserForms, dialog sheets, and XLM macros from the workbook.
• Batch Remove All Macros: Easily remove all macros from multiple workbooks simultaneously.

Text:

• Add Text: Insert the same text or characters into multiple selected cells at once.
• Extract Text: Easily extract text by location or specified rule from selected cells.
• Extract Email Address: Extract email addresses from text strings in selected cells.
• Remove Spaces: Remove leading, trailing, extra, or all spaces from selected cells.
• Remove Leading Zeros: One click to instantly remove leading zeros from selected cells.
• Remove by Position: Remove characters from the start, end, or a specific position in text.
• Remove Characters:Remove specific types of characters (e.g., digits, letters, non-alphabetic) from text.
• Subscript numbers in Chemical Formulas: Convert numbers in chemical formulas to subscript in bulk.
• Change Case: Convert text to upper, lower, proper, or sentence case easily.
• Reverse Text Order: Quickly reverse word or character order in selected cells.
• Replace Accented Characters: Easily replace all kinds of accented characters with regular characters in the entire workbook.
• Mark Keyword: Highlight keywords within or across cells in the selected range.

Format:

• Alternate Row / Column Shading: Shade or color every N row or column for better readability.
• Distinguish Differences: Highlight value changes by inserting page breaks, blanks, borders, or fill color.
• Superscript / Subscript (Formatting): Format selected text as superscript or subscript in cells.
• Apply Date Formatting: Change date formats of selected cells quickly.
• Copy Cell Formatting: Copy and apply cell formatting from one cell to others.
• Clear Characters Formatting: Remove all formatting from selected cells with one click.
• Adjust Cell Size: Set row height and column width using specific units (inches, cm, pixels, etc.).

Link:

• Convert Hyperlinks: Convert plain text to hyperlinks or extract URLs from existing hyperlinks.
• Find and Break Broken Links: Detect and remove broken or external references in Excel.
• Remove Hyperlinks Without Losing Formatting: Delete hyperlinks while keeping cell formatting intact.

More:

Calculator: Use a built-in calculator to compute and insert results directly into cells.

Operation: Apply math operations (add, subtract, multiply, divide) to cells in bulk.

• Change Comment Shape: Change one or all comment box shapes in the worksheet at once.
• Create Comment List: Extract and list all comments to a new worksheet or workbook.
• Format Comment: Apply consistent formatting to all comments based on a selected comment.
• Find / Replace Comment Text: Find and replace specific words in cell comments across sheets.
• Remove / Add User Name in Comment: Modify, add, or remove the author name in comments.
• Convert Comment and Cell: Swap content between comments and cell values easily.
• AutoFit Comment: Automatically resize comment boxes to fit their content.
• Reset Comment Position: Restore all comment boxes to their original positions with one click.
• Always Show Comment: Always display the comment when a cell is selected.

Kutools Functions:

• Date & Time: Convert time to seconds, minutes, or hours using built-in functions.
• Statistical & Math
  1. Average Visible cells: Calculate the average of visible cells only in a range.
  2. Count Visible Cells: Count visible cells, rows, or columns in a filtered range.
  3. Sum Visible Cells: Sum only visible values in filtered cells, rows, or columns.
  4. Count by cell color: Count the number of cells filled with a specific background color.
  5. Count by font color: Count the number of cells with a specific font color.
  6. Count by font bold: Count only the bold-formatted cells in a selected range.
  7. Count characters: Count the number of times a character appears in a string.
  8. Count shades: Count the total number of colored cells in a range.
  9. Sum by cell color: Sum values of cells based on background color.
  10. Sum by font color: Sum values of cells with a specific font color.
  11. Sum by font bold: Sum all bold-formatted values in a range.
• Text
  1. Extract Numbers: Extract only numbers from mixed text strings.
  2. Reverse Text: Reverse the order of characters in a cell using a function.

Formula Helper:

• Date & Time
  1. Add years to date: Add a specific number of years from a date.
  2. Add months to date: Add a specific number of months to a date.
  3. Add days to date; Add a specific number of days to a date.
  4. Add hours to date: Add a specific number of hours to a datetime value in Excel.
  5. Add minutes to date: Add a specific number of minutes to a datetime value in Excel.
  6. Add seconds to date: Add a specific number of seconds to a datetime value in Excel.
  7. Add weeks to date: Add a specific number of weeks to a date
  8. Remove time from date: Remove the time portion and keep only the date in Excel.
  9. Count days, hours and minutes between dates: Calculate the difference between two datetime values in days, hours, and minutes.
  10. Convert number (of days) to year month day: Convert total days into a format showing years, months, and days.
  11. Convert number (of seconds) to hh:mm:ss time format: Convert a number of seconds into time format hh:mm:ss.
  12. Convert date to ordinal date: Convert standard dates into ordinal date format (e.g., 2025-01-01 to 1st January, 2025).
  13. Convert date to quarter: Convert a date to its corresponding quarter and year.
• Statistical:
  1. Count the number of a word: Count how many times a specific word appears in a range.
  2. Count total words: Count the total number of words in a cell or range.
  3. Number of non-working days between two dates: Count weekends between two given dates.
  4. Number of working days between two dates: Count weekdays (Mon–Fri) between two dates.
  5. Count the number of the day of the week: Count the number of a specific day of the week between two date (including the two dates)
  6. Count cells equal to A, B, or C: Count cells that match multiple OR conditions.
  7. Count cells which equal to A and B: Count cells that match multiple AND conditions.
  8. Count unique values: Count unique values in a column or range.
  9. Count cells with unique values (include the first duplicate value): Count distinct values including the first instance of duplicates.
  10. Count the number of values separated by comma: Count the number of values separated by commas within a single cell.
  11. Sum based on the same text: Only sum numeric values with the same text right after them.
• Text
  1. Extract the nth word in cell: Easily extract the nth word from a text string in Excel.
  2. Extract cells with unique values: Quickly extract unique values from a column.
  3. Extract cells with unique values (include the first duplicate value): Extract unique values including the first instance of duplicates.
  4. Extract strings between specified text: Extract substrings between two defined markers in a text.
  5. Cell contains specific text then return value: Return a value if a specific keyword is found in the cell.
  6. Abbreviated name or word: Convert full names or phrases into abbreviations.
  7. Connected value by specific character (string): Join values with a specified delimiter in Excel.
• Lookup & Reference
  1. Look for a value in list: Look up a value and return a related result from a list or table.
  2. Find where the character appears Nth in a string: Locate the position of the Nth instance of a character in a string.
  3. Find most common value: Return the value that appears most often in a list.
  4. Index and match on multiple columns: Return a value based on matches across multiple columns.
  5. Find the largest number less than: Return the largest value that is smaller than a given number.
• Math & Trig
  1. Sum absolute values: Sum values in a range using their absolute values only.
  2. Sum numbers in a cell: Add all individual digits or numbers within a single cell.
  3. Calculate age based on birthday: Calculate the age from a given date of birth.
  4. SUMPRODUCT with criteria: Use SUMPRODUCT to sum with custom filtering conditions.
  5. Calculate days in year: Count the total days in the year from a specific date.
  6. Calculate days in month: Count the number of days in the month of a given date.
• Date & Time Helper: Perform date and time operations like add, subtract, and age calculation in Excel.

Exact (Formula) Copy: Copy Exact Formula: Copy formulas without altering cell references.

Super Lookup:

• Look for a value in list: Easily look up a specific value and return its corresponding data from another column
• LOOKUP Across Multiple Sheets: Search across multiple worksheets and return matching values.
• Multi-condition Lookup: Return results based on multiple matching criteria.
• LOOKUP and Sum: Retrieve and sum the first or all matching values.
• One-to-many Lookup (returns multiple results): Return multiple matching values and apply operations like join, sum, or average.
• LOOKUP from Right to Left: Search values in right columns and return results from the left.
• LOOKUP from Bottom to Top: Return results from the first match starting at the bottom.
• LOOKUP between Two Values: Return a value that falls between two given numbers.
• Replace 0 Or #N/A With Blank Or A Specified Value: Substitute error or zero results with blank or custom text.

Name Tools:

• Convert Name to Reference Range: Replace defined names with actual cell references in formulas.
• Hide / Unhide Range Name: Show or conceal named ranges in Excel.

More:

• Error Condition Wizard: Replace formula errors with blank, zero, or custom text.
• Dynamically Refer to Worksheets: Fill cell references from multiple worksheets.
• Convert Refers (References): Switch between relative and absolute references.
• Monitor Precedents / Dependents of Ranges: Instantly view all precedents or dependents of a selected range.

Workbook:

• Split Workbook: Easily split each sheet into a separate Excel, TXT, CSV, or PDF file.
• Format Converter: Batch convert XLSX files to XLS or PDF from local or OneDrive.
• Insert Workbook Information: Insert the workbook information such as file name or path into cells, headers, or footers.
• Open Containing Folder: Open the folder where the active workbook is stored.
• Copy Full Path: Copy the full file path of the active workbook to clipboard.
• Hide Inactive Windows: Hide all inactive workbooks with one click.
• Unhide All Hidden Windows: Instantly unhide all hidden workbook windows.
• Hide/Unhide Workbooks and Sheets: Manage workbook and worksheet visibility easily.
• Auto Open Those Workbooks Next Time: Auto-open previously used workbooks when Excel launches.

Worksheet:

• Compare Worksheets: Compare sheets and highlight differences cell by cell.
• Link Sheets: Click a cell to automatically filter data based on values from another workbook.
• Sync Worksheets: Sync cell selections across all worksheets.
• Sort Sheets: Alphabetically sort worksheets in the workbook.
• Freeze Panes Multiple Worksheets: Freeze panes in all sheets at once.
• Unfreeze Panes Multiple Worksheets: Remove freeze panes from all sheets in one go.
• Rename Worksheets: Batch rename sheets in the workbook.
• Create List of Sheet Names: List all sheet names with hyperlinks for quick navigation.
• Copy Worksheets: Duplicate multiple worksheets simultaneously.
• Create Sequence Worksheets: Create a new workbook with named sequential sheets.
• Perpetual Calendar: Add a full monthly or yearly calendar to your workbook.
• Split Data: Split data into sheets by column value or row count.
• Hide Unselected sheets: Hide all inactive sheets in the current workbook.
• Unhide All Hidden Sheets: Unhide all hidden sheets in one click.
• Hide/Unhide Workbooks and Sheets: Manage workbook and worksheet visibility easily.
• Delete Blank Worksheets: Remove all blank or empty sheets, including hidden ones.
• Delete All Hidden Sheets: Instantly delete all hidden worksheets.
• Delete All Inactive Sheets: Delete all sheets except the currently active one.

Sync Worksheets: Sync cell selections across all worksheets.

Rename Worksheets: Batch rename sheets in the workbook.

Copy Worksheets: Duplicate multiple worksheets simultaneously.

Combine (Worksheets): Merge multiple sheets/workbooks or CSV files into one workbook.

• Combine multiple worksheets/ranges into one sheet.
• Merge same-named sheets from different workbooks.
• Combine all sheets from different files into one workbook.
• Consolidate and summarize data from multiple sheets into one.

Table Merge: Merge or update tables by matching key columns.

Split Data: Split data into sheets by column value or row count.

Format Converter: Batch convert XLSX files to XLS or PDF from local or OneDrive.

Split Workbook: Easily split each sheet into a separate Excel, TXT, CSV, or PDF file.

Design View:

• Lock Cells: Easily lock selected cells when protecting the worksheet.
• Unlock Cells: Easily unlock selected cells when protecting the worksheet.
• Highlight unlocked: Instantly highlight all unlocked cells in the sheet.
• Hide Formulas: Quickly hide formulas in protected worksheets.
• Unhide Formulas: Instantly unhide formulas in protected worksheets.
• Highlight Hidden: Highlight cells containing hidden formulas with one click.
• Highlight Formulas: Highlight all cells with formulas in the worksheet.
• Highlight Names: Highlight all named ranges in the current worksheet.
• Monitor Precedents / Dependents: Auto-display all precedents and dependents of the selected range.
• Settings; Open the settings center of the Design Tools.
• Close Design: Exit the Design tab with one click.

Printing:

• Print Multiple Workbooks Wizard: Batch print multiple workbooks and text files from one or more directories.
• Print Multiple Selections Wizard: Print multiple selected ranges on the same page.
• Print First Page of Each Worksheet: Print only the first page of every sheet in the current workbook with one click.
• Print Pages in Reverse Order: Reverse print order and print from the last page to the first.
• Print Current Page: Print only the page containing the active cell.
• Print Specified Pages: Print specific page ranges, or only odd/even pages in a worksheet.
• Print Circle Invalid Data: Print all circled invalid data in the selection or sheet.
• Print Charts Only: Print all or each chart in the workbook separately or on one page.
• Copy Page Setup: Copy the current sheet's page setup to other sheets in the workbook.
• Paging Subtotals: Insert and print subtotals on each printed page.
• Insert Page Break Every Row: Automatically insert page breaks after every x rows.
• Add Border to Each Page: Add printable borders to every page for better visual separation.

Split to Columns: Split a list into multiple columns per page for compact printing.

Import / Export:

• Export Range to File: Save a selected range as CSV, HTML, PDF, or workbook file.
• Export Range as Graphic: Export a selected range as an image (JPG, PNG, or GIF).
• Export Graphics: Export all charts and objects as images in one go.
• Import Pictures: Bulk insert and neatly align multiple images into cells.
• Match Import Pictures: Insert pictures into cells based on matching cell values.
• Insert File at Cursor: Insert data from other sheets or text files at the cursor location.
• Filename List: List all files and folders from a specified directory into Excel.

Password Manager: Manage workbook passwords used for opening, merging, or converting Excel files.

Encrypt Cells: Encrypt selected cell values or contents in Excel.

Decrypt Cells: Decrypt previously encrypted cells with one click.

Protect Worksheet: Apply protection to multiple worksheets at once.

Unprotect Worksheet: Batch unprotect multiple worksheets simultaneously.

Encrypt Workbooks: Password-protect multiple workbooks in bulk.

Decrypt Workbooks: Remove password protection from multiple workbooks in bulk.

Create Mailing List: Generate a structured recipient list directly in Excel.

Send Emails: Send bulk personalized emails to multiple recipients with ease.

Sort:

• Advanced Sort: Easily sort data by last name, month, frequency, or text length.
• Sort Range Randomly: Randomly shuffle cells, rows, or columns in a selected range.

Super Filter: Easily create complex filters by combining multiple criteria across sheets.

Special Filter:

• Filter Bold: Filter cells with bold formatting.
• Filter Italic: Filter cells formatted in italics.
• Filter Strikethrough: Filter cells with strikethrough text in the active column.
• Filter Comment: Show only cells that contain comments.
• Filter Formula: Filter all cells containing formulas.
• Filter Merged: Filter merged cells in the current column.
• Special Filter:
  1. Uppercase/Lowercase Text: Filter cells by case.
  2. Text length equal to: Filter by character count in cells.
  3. Filter by Workdays/Weekend/Day of week: Filter cells based on date type.
  4. Font Bold: Filter cells with bold formatting.
  5. Font Italic: Filter cells formatted in italics.
  6. Font Strikethrough: Filter cells with strikethrough text in the active column.
  7. Comments: Filter all cells with comments.
  8. Formula: Filter all cells containing formulas.
  9. Merge Cells: Filter merged cells in the current column.
  10. Font Color: Filter cells by font color.
  11. Background Color: Filter cells by fill color.

Count by Color: Easily count cells by font or fill color.

Paging Subtotals: Add and print subtotal rows on each printed page.

Pivot Table:

• PivotTable Special Time Grouping: Group pivot data by fiscal year, half year, or week number effortlessly.

AI Aide: An AI-powered assistant that enhances how you work in Excel—supports custom formula generation, intelligent function matching, VBA creation, chart automation, data analysis, and more.

• Intelligent Execution of Operations: Automatically identify and perform relevant Excel tasks.
• Generate Custom Formula: Create formulas based on your natural language input.
• Invoke Kutools Functions: Recommend matching Kutools features based on your command.
• Data Analysis & Chart Creation: Generate insights and visualizations instantly.
• Create Custom Functions: Build reusable user-defined functions.
• Write VBA Code: Produce ready-to-run macros based on your instructions.
• Provide Operational Guidance: Get step-by-step instructions for Excel operations.
• Handle Other Tasks: Including text translation, function explanation, and more.

Re-run Last Utility: Instantly relaunch the last-used Kutools feature with one click.

Search: Find any Kutools feature by typing keywords in the search bar.

Feedback: Report bugs or submit suggestions directly to the development team.

Help:

• Languages: Change the interface language of Kutools for Excel.
• Toolbar mode: Switch between ribbon display styles for the Kutools tab.
• Setting Center:
  1. Disable or enable the Kutools add-in for Excel.
  2. Clear configurations and caches of this add-in.
  3. Set the language of the software.
  4. Check the user's registration information.
• Resister: Activate your license or proceed to purchase from the official site.
• Check for Updates: Download and install the latest version of Kutools.
• Configure Synchronization: Sync settings across devices using OneDrive.
• Get Help: Get help from our website https://www.extendoffice.com.
• About: View detailed information about your Kutools installation and license.