At first, you will have to open the spreadsheet with Microsoft Excel. In case you want to insert the header and footer before making a spreadsheet, create a black spreadsheet by opening the Excel.

In Excel’s custom headers and footers box, the ampersand character (&) is used as a marker to indicate that a special formatting code follows.