Adding a header (or footer) to an Excel sheet is a simple task using Excel’s Page Layout view. Adding the same header to several or even all of the sheets in the workbook could mean a lot of ...

Create a second sheet and name it Dropdown (strictly speaking, it isn’t necessary to name this new sheet). Select a cell — I selected B2. Click the Data tab.