Navigation Pane – List Sheets, Workbooks, Columns and Names in Excel

It's not easy for you to navigate sheet tabs in Excel if you are dealing a workbook with too many worksheets. You will always spend more time in repetitive scrolling and clicking if you need to switch from one sheet to another. The Navigation Pane in Kutools for Excel will bring in almost 10 times faster than using the tab scrolling buttons. Even if there are dozens of worksheets between those two sheets you want to switch, you only need to click the mouse once to navigate them. Demo

See what Excel Navigation Pane can help:

• List all open workbooks: you can quickly click to navigate between all open workbooks;
• List all worksheets: almost 10 times faster to navigate between sheet tabs;
• List all columns (in active worksheet): you can quickly click on the column and go to the specific column in the active worksheet;
• List all names (in active workbook): click on the name and you will be navigated to the exact position of the name;
• Toggle Button: toggle all of the hidden sheets/columns to be visible and invisible;
• Refresh Button: refresh all the information of the navigation pane;
• Font Size Buttons: change the font size of worksheet names, workbook names, column titles and name titles;
• Scroll bar: makes it fluent to scroll the list from up to down; just as the way you do in browsing the web pages;
• When you switch multiple sheets by using the sheet tab of Excel, you can also stay at the specific position of that sheet in the Navigation Pane;
• Easily jump from one sheet (workbook, column or name range) to another by clicking the corresponding item in the pane;
• The more worksheets (columns) you work with, the faster the process can be when using Navigation pane.

Click Kutools >> Navigation.

See Navigation Pane feature demo (video 1)

This is only one feature of Kutools for Excel

It includes more than 120 functions and tools for Excel 2013, 2010, 2007 and Office 365.