How to Put Cells in a Microsoft Excel Header

1. Open your Excel spreadsheet. Type the data in the uppermost cells of the spreadsheet. For example, type 'test' in cells A1 and D1.
2. Click the 'Page Layout' tab. Click on the square with the arrow on the 'Page Setup' panel to see additional options.
3. Click the 'Header/Footer' tab, and then select the header to use from the 'Header:' drop-down box, or press the 'Custom Header' button and type your preferred header.
4. Click the 'Margins' tab, and adjust how far the header will be from the top of the page. Press the up or down arrow buttons beside the 'Header' box.