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. And what's more? You can quickly select and go to the specific column and name in your workbooks. 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. Split cell contents into multiple rows/columns by space/comma/delimiter.Count and sum cells based on background/font color.Combine multiple worksheet or workbooks into one workbook.Full feature free trial 60-day, no credit card required! See How Kutools For Excel Save Your Time In Excel 2019 / 2016 / 2013 / 2010 / 2007 / Office 365 Undoubtedly, this powerful and user-friendly add-in will save Excel users a mass of working time and greatly improve working efficiency. For example, Excel users can easily combine worksheets with several clicks, merge cells without losing data, paste to only visible cells, and so on. 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.
