Navigation

Location on ribbon: Tab DVD Addin → Group View and Sheets

Command ID: btnNavigation

What it does

Opens the Navigation pane — a task pane docked to the left of the Excel window that lists the open workbooks and every sheet of the active one. From there you filter sheets by name, jump to a sheet, hide or show it, rename it and reorder the tabs, without hunting along the tab bar.

It is the answer to submission files with dozens of sheets — estimates, quantity take-offs by work package, folders of inspection records — where Excel's tab bar can no longer show the names.

How to use

1. Go to tab DVD Addin → group View and Sheets → Navigation, or press Ctrl+Shift+W.
2. The Navigation pane opens and docks on the left edge of the Excel window.
3. Type in the search box to filter the sheet list by name; the list narrows as you type.
4. Double-click a row to jump to that sheet.
5. Right-click a row for the context menu with sheet management actions (hide/show, rename, reorder).
6. Close the pane with the X in its corner when you are done.

Example

Hoso-Nghiemthu-BlockA.xlsx holds 63 sheets named NT-<floor>-<activity>: NT-T05-Cotthep, NT-T05-Copha, NT-T06-Betong and so on.

Instead of clicking the tab-scroll arrows dozens of times, press Ctrl+Shift+W, type T05 in the filter — the list narrows to the seven fifth-floor sheets — then double-click NT-T05-Cotthep to land straight on the record you need to sign.

Notes

• The Navigation pane is an Excel task pane: it belongs to the Excel window, so a newly opened Excel window needs the command run again.
• The Ctrl+Shift+W shortcut only works once the add-in has finished loading, after Excel has fully started.
• The pane takes up screen width; on a small laptop screen, close it when you need the full sheet width.
• Renaming, hiding and reordering from this pane act directly on the workbook and cannot be undone with Ctrl+Z.
• If the workbook structure is protected, Excel blocks the hide/show and reorder actions.

Related

• Sheet List — generate a permanent index sheet instead of browsing ad hoc.
• Hide Unselected — hide the sheets you are not working on.
• Unhide All — reveal everything before browsing.
• Reading Layout — read the table comfortably once you are on the right sheet.