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.

How to add a header in Excel. Here’s how you can add a header in Excel in only a few clicks. Step. 1 . Go to Insert . First, you need to go to the Insert tab. This is just next to the Home tab. Step.