Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, also called description rows. They allow readers to follow your pages and understand content easier, because the descriptors are fixed as readers scroll through the spreadsheet. You can easily add both fixed rows and headers to your spreadsheet with the tools available in Excel.
Adding a Header
- Go to the "Insert" tab on the Excel toolbar, and then click the Header & Footer button in the Text group to start the process of adding a header. Excel changes the document view to a Page Layout view. Click on the top of your document where it says Click to Add Header, and then type the header for your document. Use the tools in the Design and Home tabs on your ribbon to customize the look and feel of your header.
Freezing Your Titles
- Create the column titles you want to use in the first row of your spreadsheet. You can either freeze the entire top row or specific cells as your descriptors. Select the cells you want to use, click the View tab, select Freeze Panes, and then choose a freeze option -- Freeze Panes fixes selected cells to the top of each row as you scroll, while Freeze Top Row keeps the entire top row visible as you scroll. The top-row option can be useful if you have not yet decided on the label for your column.