Open an Excel Worksheet and click "Insert." Click the "Text" button followed by "Header & Footer." Excel switches to layout view and displays three empty header columns at the top of the worksheet.

If none of them meets your needs, click on either Custom Header or Custom Footer , which brings up this screen: . By placing your cursor in any of the boxes ( Left section, Center section, Right ...

Excel spreadsheets are designed to help you organize and present your data. ... You can also use the top row of cells to create a custom header, which explains the content in each column, ...