Sheet List & Navigation

Manage sheets in large workbooks — left-side navigation panel, sheet manager with drag/drop, batch operations.

Sheet List dialog

DVD Addin → group View and Sheet → click Sheet List.

The dialog shows a table of all sheets with columns:

• No.
• Sheet name (click to jump).
• Visible (Visible / Hidden / VeryHidden).
• Tab color (color preview).
• Protected (whether the sheet has password protection).
• Used Range (e.g. A1:M50).
• Action (rename, delete, change color buttons).

Operations:

• Filter at the top — type to filter by name.
• Multi-select (Ctrl+click) — select multiple sheets for batch operation.
• Sort by any column.

Batch operations

With multi-select:

• Hide / Show / VeryHide — change visibility.
• Change tab color — same color across multiple tabs.
• Protect / Unprotect — toggle sheet protection (with shared password).
• Export to separate workbook — split into individual .xlsx files.
• Delete — bulk delete (with confirmation).

Navigation panel (sidebar)

DVD Addin → group View and Sheet → click Navigation.

Opens a docked panel on the left of Excel:

• All sheets list with icons.
• Tree view of named ranges / tables / charts in the current sheet.
• Realtime search box filter.
• Bookmark — flag a cell/range to jump back to later.

The panel is modeless — always visible while you work.

Reading Layout

DVD Addin → group View and Sheet → click Reading Layout.

A "document reading" mode:

• Hide ribbon, formula bar, gridlines, headers.
• Zoom 120% (default, configurable).
• Active cell highlighted prominently.
• Smooth-scroll keyboard shortcuts.

Click again to exit → return to normal view.

Use case: present numerical tables to clients / management / meetings.

Highlight row + column

DVD Addin → group View and Sheet → click Highlight Row+Col.

Toggle cross-hair highlight for the active cell:

• The entire row + column of the current cell gets a light background.
• When you switch cells → highlight follows.
• Click toggle again to disable.

TIP

Highlight uses internal Conditional Formatting — does NOT affect actual cell formatting. CF is not saved when the workbook is saved.

Difference between the 3 commands

Feature	Sheet List	Navigation	Reading Layout
Display	Modal dialog	Docked panel	Fullscreen mode
Purpose	Batch manage	Quick jump	Read/present
Filter/Sort	✓	✓	✗
Multi-select	✓	✗	✗
Batch ops	✓	✗	✗
Realtime update	✗	✓	✗

License gating

All 3 commands are free (no license required).

Related

• Preferences → View — configure Reading Layout default zoom.