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

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;
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 webpages;
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 Pane". (See the following screenshots)


Navigation Pane	List Workbooks	List Worksheets	List Columns	List Names

See Navigation Pane feature demo (video 1)

Video 1. Navigation Pane feature demo.