Validate Email Address: Quickly validate email addresses in a column or a range of cells in Excel.Only allow specific characters to be entered in a range of cells.Easily prevent special or certain characters from being typed in cells.Prevent Duplicate: Quickly prevent duplicate entries in a column in Excel.Unhide all Ranges: Quickly unhide all rows and columns in ExcelĬopy Ranges: Easily copy multiple selections in ExcelĬompare Cells: Easily compare two ranges of cells if they are equal or different in Excel.Paste to Visible: Quickly copy data and paste into only visible cells / filtered list in Excel.Sort / Select Range Randomly: Quickly sort or select cells, rows and columns randomly in Excel.Swap Ranges: Easily wwap cells, rows, columns or ranges in Excel.Transform Range: Transpose (convert) a single column or row to ranges or vise versa in Excel.

Transpose Table Dimensions: Quickly convert 2-dimensional/cross table to list in Excel.Flip Vertical Range: Quickly reverse date order of multiple rows vertically with flip vertical range.Flip Horizontal Range: Quickly reverse data order of multiple columns horizontally with flip horizontal range.Hide/Unhide Workbooks and Sheets: Quickly hide or unhide workbooks and sheets (worksheets) in Excel.Unhide All Hidden Windows: Unhide all hidden workbook windows with one click in Excel.Hide Inactive Windows: Quickly hide other workbooks (all inactive windows) in Excel.Unhide All Hidden Sheets: Quickly show all hidden worksheets with one click in Excel.Hide Unselected sheets: Quickly hide all inactive (all not-selected) worksheets in Excel.Unhide All Ranges: Quickly unhide all rows and columns in Excel.Set Scroll Area: Quickly set scroll area (hide unselected columns and rows at once) in Excel.Always Show Comment: always show comment when a cell is selected in excel.Work Area: Change Working Area Size: Show Or Hide Ribbon, Formula Bar, And Status Bar In Excel.Worksheets: Quickly toggle all hidden sheets to be visible or invisible in Excel.Columns: Quickly toggle all hidden columns to be visible or invisible in Excel.Show Classic Menu on Quick Access Toolbar: Display classic menu in Excel 2007 or later versions.View Options: Quickly toggle workbook and worksheet settings in Excel Snap (Backup Current Workbook): Take snapshots of the current workbook for restoring the workbook easilyĭata Form: Quickly create a data entry form in Excel Reading Layout: Automatically highlight the entire row or column of the active cellīigger Formula Bar: Show full contents of cell and enhance editing in Excel Navigation Pane: List sheets, workbooks, columns, names And insert auto text in Excel

Kutools for excel tutorial