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.

How to generate a list of hyperlinks in Excel It’s not unusual for a complex workbook to include a list of hyperlinks to each sheet in the workbook.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.