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.

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.