Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code. With both methods, users ...

If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.