Kutools for Excel

Kutools for Excel is a handy Excel add-in with more than 300 advanced features to simplify various kinds of complicated tasks into a few clicks in Microsoft Excel. For example, Excel users can easily combine worksheets with several clicks, merge cells without losing data, paste to only visible cells, and so on. Undoubtedly, this powerful and user-friendly add-in will save Excel users a mass of working time and greatly improve working efficiency.

See How Kutools For Excel Save Your Time In Excel 2019 / 2016 / 2013 / 2010 / 2007 / Office 365

• 110,000+ Excel users’ choice. Full feature free trial 60-day, no credit card required!
• Combine multiple worksheet or workbooks into one workbook
• Count and sum cells based on background/font color
• Split cell contents into multiple rows/columns by space/comma/delimiter
• Batch Remove leading spaces in cells

Navigation Pane does not only list all the workbooks, worksheets, columns, and names in a built-in pane for you, but it also augments Excel with a fascinating feature that lets you easily take a glance at all the workbooks, worksheets, and switch between all of them. And what's more? You can quickly select and go to the specific column and name in your workbooks. You can drag and drop the Navigation Pane to any position in your working area, and it can be activated to hide or show with one click.

Kutools for Excel can take a snapshot of the current workbook with one click at any time, and click on the snapshot item will restore the workbook to the snapshot. Please note that this utility will only keep the snapshot available before closing the workbook, if the workbook has been closed, all snapshots of the workbook will be cleaned.

Features and Highlights

• List all open workbooks within a pane
• List all worksheet names of a workbook within a pane
• List all columns and titles of a worksheet within a pane
• Minimize the ribbon with one click
• Minimize the ribbon, hide the status bar, formula bar, and ribbon with one click
• Show or hide the horizontal scrollbar
• Show or hide page breaks
• Easily set or limit a scrolling area in an active worksheet
• Interactively hide or unhide multiple workbooks and worksheets at one time
• Select a cell or multiple cells randomly
• Insert a unique sequence number
• Convert values store as number into a text
• Swap two columns or two same size ranges
• Insert a specific number of blank rows at a specified interval

Note: 30 days trial version. Requires MS Excel.