How to Make a Header Row in Excel 2011

Organization is a very important component in Microsoft Excel, but the majority of it is focused upon how your spreadsheets appear on the screen.

If you are worried about keeping a printed spreadsheet organized, then you need to take some additional steps so that it is simpler to read.

One helpful way to do this is by repeating your top, or “header” row at the top of each page. This allows your readers to know what data belongs in which column, and will help to eliminate confusion.

You can perform a similar action in the Windows version of Excel. This Excel repeat rows at top tutorial will show you how.

How to Repeat the Top Row on Every Page in Excel 2011

This tutorial is going to focus on repeating the top row on every page, but you can also use these steps to repeat any row that you want.

Step 1: Open the spreadsheet in Excel 2011 on which you want to have the top row printed on every page.

Step 2: Click the Layout tab.

click the layout tab

Step 3: Click the Repeat Titles button in the Print section of the ribbon.

how to repeat rows at the top of every page in excel 2011

Step 4: Click the row number at the left side of the window that contains the headers that you want to repeat at the top of each page. In the image below, for example, I am going to repeat row 1.

select the row to repeat

Step 5: Click the OK button at the bottom of the window to save your settings. Now the row that you just selected will print at the top of each page.

You can buy magazine subscriptions from Amazon now, and they are priced very low. View their selection here.

We have previously written about how to print gridlines in Excel 2011. Click here to learn how.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy