Navigation Pane: 5 panes:

• Workbook & Sheet pane
• AutoText pane
• Name Manager pane
• Column List pane
• Advanced Find and Replace pane

Reading Layout: Highlight the entire row or column of the active cell

Bigger Formula Bar: Enhance the formula bar and display the active cell's contents in a window

Snap (Backup Current Workbook): Take snapshots of the current workbook for easy restoration

Data Form: Easily view, edit, or delete data entries.

View Options: Quickly toggle any of the following settings:

• Gridlines
• Horizontal scrollbar
• Vertical scrollbar
• Row and column headers
• Page breaks
• Formula view
• Sheet tabs
• Status bar
• Formula bar
• Full-screen display,
• Comment visibility
• Object visibility

Show / Hide: A collection of tools that allow you to quickly show or hide specific items:

• Show Classic Menu On Quick Access Toolbar
• Columns
• Worksheets
• Work Area
• Always Show Comment
• Set Scroll Area
• Unhide All Ranges
• Hide Unselected Sheets
• Unhide All Hidden Sheets
• Hide Inactive Windows
• Unhide All Hidden Windows
• Hide/Unhide Workbooks And Sheets

Range: A collection of utilities to allow you to quickly process operations in cell ranges:

• Flip Horizontal Range
• Flip Vertical Range
• Transpose Table Dimensions
• Transform Range
• Swap Ranges
• Sort / Select Range Randomly
• Paste To Visible
• Set Scroll Area
• Unhide All Ranges

Copy Ranges: Copy multiple selected ranges at once

Compare Cells: Quickly:

• Compare 2 columns; and
• Highlight duplicate cells or differences

Prevent Typing

• Prevent Duplicate: Prevent entering duplicate data in a single column
• Prevent Typing:
  • Prevent certain characters from being typed; or
  • Allow (only) certain characters to be typed
• Validate Email Address
• Validate IP Address
• Validate Phone Number
• Clear Data Validation Restrictions

Drop-Down List

• Dynamic Drop-Down List
• Colored Drop-Down List
• Picture Drop-Down List
• Multi-Select Drop-Down List
• Drop-Down List with Check Boxes
• Searchable Drop-Down List
• Create Simple Drop-Down List
• Update Dynamic Drop-Down List
• Expand Dynamic Drop-Down List Range

Content

• Convert to Date
• Convert Time
• Number to Words
• Convert Between Roman and Number
• Change Sign of Values
• Convert Number to Ordinal
• Data Association
• Make Up a Number
• Date Picker

Conversion

• Currency Conversion
• Unit Conversion
• Number Systems Conversion
• Convert Between Text and Number
• Convert Between Roman and Number
• Convert Formula to Text
• Convert Text to Formula

To Actual: Convert the real value or formula in selected cells into the displaying values

Round (Without Formula): Batch round numbers in selected range to the given decimal places without formula

Merge & Split

• Combine Rows, Columns, or Cells Without Losing Data
• Split Cells
• Split Names
• Merge Same Cells
• Unmerge Cells & Fill Value
• Advanced Combine Rows

Charts

• Data Distribution Charts
  • Bubble Chart
  • Normal Distribution / Bell Curve Chart
  • Dumbbell Plot Chart
  • Dynamic Pie Of Pie Chart
  • Scrollable Line Chart
• Point in Time Charts
  • Gantt Chart
  • Timeline Chart
• Progress Charts
  • Speedometer
  • Bullet Chart
  • Thermometer Chart
  • Target and Actual Chart
  • Progress Bar Chart
  • Progress Ring Chart
  • Percentage Ball Chart
  • Project Status Spectrum Chart
  • Project Status Bead Chart
  • Battery Chart
  • Alternative Progress Bar Chart
• Difference Comparison Charts
  • Step Chart
  • Column Chart with Percentage Changed
  • Slope Chart
  • Threshold Value Chart
  • Difference Arrow Chart
  • Matrix Bubble Chart
  • Bar with Bubble Chart
  • Difference Comparison Chart
  • Difference Area Chart
  • Progress Pie Chart
  • Radial Bar Chart
  • Alternative Rose Chart
  • Nightingale Chart
  • Bidirectional Histogram Chart
  • Multiple Series Line Chart
  • Smooth Area Chart
  • Horizontal Waterfall Chart
  • Interval Label Bar Chart
  • Stacked Difference Chart
  • Dynamic Column Chart
  • Dynamic Ranking Bar Chart
• Category Comparison Charts
  • Color Grouping Chart
  • Dot Chart
  • Variable Width Column Chart
  • Marimekko Chart
  • Lollipop Chart
  • Multi Series Area Chart
  • Proportion Stacked Chart
  • BiDirection Bar Chart
  • Stacked Chart with Percentage
  • Multi Series Histogram Chart
  • Multi Layer Column Chart
  • Forecast Chart
  • Threshold Value Area Chart
  • Rectangular Pie Chart
  • Half Pie Chart
  • Price Tag Chart
  • Check Box Line Chart
  • Alternative Stacked Column Chart
• Chart Tools
  • Color Chart by Value
  • Add Line to Chart
  • Copy Format to Other Charts
  • Set Absolute Position of Chart
  • Add Sum Labels to Chart
  • Add Cumulative Sum to Chart
  • Move X-axis to Negative/Zero/Bottom
  • Add Trend Lines to Multiple Series
  • Change Chart Color According to Cell Color
  • Add Poly Line
  • Detach Chart

Find

• Super Find
  • Find specific text strings only in the comments
  • Find specific text strings only in the formulas
  • Search specific text values only in hyperlinks
  • Find specific text string only in cell value
  • Find cells which contain date type values based on criteria
  • Find numbers based on criteria
  • Find all cells with specific cell formatting
• Fuzzy Lookup
• Find & Replace in Multiple Workbooks

Select

• Select Range Helper
• Select Range Randomly
• Select Interval Rows & Columns
• Select Merged Cells
• Select Last Cell
• Select Cells With Max Or Min Value
• Select Cells With Error Value
• Select Unlocked Cells
• Select Nonblank Cells
• Select Specific Cells
• Select Cells With Format
• Select Duplicate & Unique Cells
• Select Same & Different Cells

Insert

• Insert Titles Rows
• Insert Blank Rows & Columns
• Duplicate Rows / Rows Based On Cell Value
• Insert Random Data
• Insert Sequence Number
• Find Missing Sequence Number
• Fill Custom Lists
• List All Combinations
• Insert Barcode
• Insert QR Code
• Insert Bullet
• Insert Numbering
• Insert Date
• Fill Blank Cells
• Batch Insert Check Boxes
• Batch Insert Option Buttons
• Insert Watermark
• Insert Pictures From Path (URL)
• Auto Text

Delete

• Delete Blank Rows
• Delete Hidden (Visible) Rows & Columns
• Delete Watermark
• Delete Illustrations & Objects
• Delete Web Controls
• Batch Delete Check Boxes
• Batch Delete Option Buttons
• Remove All Macros
• Batch Remove All Macros

Text

• Add Text
• Extract Text
• Extract Email Address
• Remove Spaces
• Remove Leading Zeros
• Remove By Position
• Remove Characters
• Subscript Numbers In Chemical Formulas
• Change Case
• Reverse Text Order
• Replace Accented Characters
• Mark Keyword

Format

• Alternate Row / Column Shading
• Distinguish Differences
• Superscript / Subscript (Formatting)
• Apply Date Formatting
• Copy Cell Formatting
• Clear Characters Formatting
• Adjust Cell Size

Link

• Convert Hyperlinks
• Find And Break Broken Links
• Remove Hyperlinks Without Losing Formatting

Comment

• Change Comment Shape
• Create Comment List
• Format Comment
• Find / Replace Comment Text
• Remove / Add Username In Comment
• Convert Comment And Cell
• AutoFit Comment
• Reset Comment Position
• Always Show Comment

Operation: Perform common math operations in cells.

Calculator: Carry out more than 10 types of mathematical operations.

Kutools Functions

• Date & Time
• Statistical & Math
  • Average Visible cells
  • Count Visible Cells
  • Sum Visible Cells
  • Count by cell color
  • Count by font color
  • Count by font bold
  • Count characters
  • Count shades
  • Sum by cell color
  • Sum by font color
  • Sum by font bold
• Text
  • Extract Numbers
  • Reverse Text

Formula Helper

• Date & Time
  • Add years to date
  • Add months to date
  • Add days to date
  • Add hours to date
  • Add minutes to date
  • Add seconds to date
  • Add weeks to date
  • Remove time from date
  • Count days, hours, and minutes between dates
  • Convert number (of days) to year month day
  • Convert number (of seconds) to hh:mm:ss time format
  • Convert date to ordinal date
  • Convert date to quarter
• Statistical
  • Count the number of a word
  • Count total words
  • Number of non-working days between two dates
  • Number of working days between two dates
  • Count the number of the day of the week
  • Count cells equal to A, B, or C
  • Count cells which equal to A and B
  • Count unique values
  • Count cells with unique values (include the first duplicate value)
  • Count the number of values separated by comma
  • Sum based on the same text
• Text
  • Extract the nth word in cell
  • Extract cells with unique values
  • Extract cells with unique values (include the first duplicate value)
  • Extract strings between specified text
  • Cell contains specific text then return value
  • Abbreviated name or word
  • Connected value by specific character (string)
• Lookup & Reference
  • Look for a value in list
  • Find where the character appears Nth in a string
  • Find the value that appears most often
  • Index and match on multiple columns
  • Find the largest number less than
• Math & Trig
  • Sum absolute values
  • Sum numbers in a cell
  • Calculate age based on birthday
  • SUMPRODUCT with criteria
  • Calculate days in year
  • Calculate days in month
• Date & Time Helper
  • Add specified number of years, months, weeks, days, or hours, minutes, seconds to a date or time
  • Subtract specified number of years, months, weeks, days, or hours, minutes, seconds from a date or time
  • Calculate difference between two dates / times
  • Calculate age based on a given date

Exact (Formula) Copy: Easily copy formulas without adjusting relative cell references.

Super Lookup:

• LOOKUP Across Multiple Sheets
• LOOKUP And Sum
• LOOKUP From Right To Left
• LOOKUP From Bottom To Top
• LOOKUP Between Two Values
• Replace 0 Or #N/A With Blank Or A Specified Value

Name Tools

• Convert Name To Reference Range
• Hide / Unhide Range Name

More

• Error Condition Wizard
• Dynamically Refer To Worksheets
• Convert Refers (References)
• Monitor Precedents / Dependents Of Ranges

Workbook

• Split Workbook
• File Format Converter
• Insert Workbook Information
• Open Containing Folder
• Copy Full Path
• Hide Inactive Windows
• Unhide All Hidden Windows
• Hide/Unhide Workbooks And Sheets
• Auto Open Those Workbooks Next Time

Worksheets

• Compare Worksheets
• Synchronize Worksheets
• Sort Sheets
• Freeze Panes Multiple Worksheets
• Unfreeze Panes Multiple Worksheets
• Rename Worksheets
• Create List Of Sheet Names
• Copy Worksheets
• Create Sequence Worksheets
• Perpetual Calendar
• Split Data
• Hide Unselected Sheets
• Unhide All Hidden Sheets
• Hide/Unhide Workbooks And Sheets
• Delete Blank Worksheets
• Delete All Hidden Sheets
• Delete All Inactive Sheets

Combine (Worksheets)

• Quickly combine multiple worksheets / ranges from workbooks into one worksheet
• Quickly merge / combine all worksheets of the same name across workbooks into one worksheet
• Quickly merge / combine worksheets or workbooks into one workbook
• Quickly summarize / calculate data from multiple worksheets into one worksheet.

Table Merge: Update or merge two tables by a given matching column from two worksheets or workbooks.

Split Data: Split data in a range into multiple worksheets based on specific columns or fixed rows.

Format Converter

• Convert multiple XLSX files to XLS files in Excel
• Convert multiple XLS files to XLSX files in Excel
• Convert multiple Excel workbooks to PDF files

Split Workbook: Split each worksheet of the active workbook as an individual:

• Workbook;
• TXT file;
• CSV file; or
• PDF file.

Worksheet Design: Toggle the Design Tools added by Kutools for Excel.

Printing

• Print Multiple Workbooks Wizard
• Print Multiple Selections Wizard
• Print First Page Of Each Worksheet
• Print Pages In Reverse Order
• Print Current Page
• Print Specified Pages
• Print Circle Invalid Data
• Print Charts Only
• Copy Page Setup
• Paging Subtotals
• Insert Page Break Every Row
• Add Border To Each Page

Split To Columns: Quickly print columns in multiple segments to fit on one printed page in Excel.

Import / Export

• Export Range To File
• Export Range As Graphic
• Export Graphics
• Import Pictures
• Match Import Pictures
• Insert File At Cursor
• Filename List
• Create Folders Based On Cell Contents

Password Manager: Add and manage passwords, which are used to open password-protected workbooks.

Encrypt Cells: Encrypt selected cells.

Decrypt Cells: Decrypt the cells which have been encrypted with Encrypt Cells of Kutools for Excel.

Protect Worksheet: Quickly protect multiple worksheets with the same password in the current workbook.

Unprotect Worksheet: Unprotect (in bulk) multiple worksheets protected by the same password.

Encrypt Workbooks: Protect multiple workbooks with the same password at the same time.

Decrypt Workbooks: Unprotect (in bulk) multiple workbooks protected by the same password.

Create Mailing List: Quickly create a list of recipients in an Excel table.

Send Emails: Send personalized emails to multiple recipients in bulk.

Sort

• Advanced Sort
• Sort Range Randomly

Super Filter: Quickly filter the whole worksheet by combining multiple conditions.

Special Filter

• Filter Bold
• Filter Italic
• Filter Strikethrough
• Filter Comment
• Filter Formula
• Filter Merged
• Special Filter:
  • Filter Cells By Uppercase / Lowercase
  • Filter Cells By Text Length
  • Filter Cells By Workday/Weekend/Specific Day Of The Week
  • Filter All Cells By Bold Characters
  • Filter All Cells By Italics
  • Filter Cells With Strikethrough
  • Filter All Cells With Comments
  • Filter All Cells Which Contain A Formula
  • Filter Merged Cells
  • Filter Cells By The Font Color
  • Filter Cells By The Background Color

Count By Color: Calculate cells by background color or font color.

Paging Subtotals: Insert a row into each printed page for analyzing and calculating each column.

Pivot Table: A collection of tools for Pivot Tables.

Re-Run Last Utility: Quickly apply the utility of Kutools for Excel you have just launched before with one click.

Search: List features related to the keywords entered in the search box.

Feedback: Submit errors that you encounter when running Kutools for Excel.

Help:

• Languages
• Toolbar Mode
• Setting Center
• Register
• Check For Updates
• Configure Synchronization
• Get Help
• About

Lock Cells: One click to set the formatting of current selection as lock.

Unlock Cells: One click to set the formatting of current selection as unlock.

Highlight Unlocked: One click to highlight all cells formatting as unlocking in the whole workbook.

Hide Formulas: One click to hide the formulas in cells of selection.

Unhide Formulas: One click to show all hidden formulas in the selection.

Highlight Hidden: One click to highlight all cells whose formulas are formatting as hidden in the whole workbook.

Highlight Formulas: One click to highlight all cells containing formulas in the whole workbook.

Highlight Names: One click to highlight all named ranges in the whole workbook.

Monitor Precedents / Dependents

• Monitor Precedents of Ranges
• Monitor Dependents of Ranges
• Monitor Precedents and Dependents

Settings

• Enable the protect options to automatically protect and unprotect worksheets
• Specify the highlight colors for unlocked ranges, formulas hidden ranges, formulas cells, and named ranges.

Close Design: Exit the Design tab