Excel guides for workbooks with many sheets

Written while building Vertical Tabs, an add-in for exactly this problem. Everything here works in plain Excel for Windows, no add-in required.

• Too many sheets in Excel? 7 ways to navigate a large workbook

  The hidden sheet list, keyboard shortcuts, Go To, an index sheet, the Navigation pane and add-ins.

• How to list all sheet names in Excel

  A GET.WORKBOOK formula, Power Query with no macros, or a VBA macro that builds a linked index.

• How to find and unhide very hidden sheets in Excel

  The sheets Excel's Unhide dialog does not show, and one line that brings them all back.

• Excel keyboard shortcuts for working with sheets

  Switch, select, insert, rename, move, colour, hide and delete sheets without the mouse.