As you move from sheet to sheet, you’ll see that they all have the same header. This technique works with footers too. Headers and footers are visible only in Page Layout view and in Print Preview.

Adjusting print settings, margins and sheet options are all ways to avoid issues when printing an Excel spreadsheet. Learn how in this guide.

They produce their invoices on Excel and would like their name to appear as a header on each sheet. Although the name can be entered in a cell on each sheet, I can't get Excel to make it a page header ...