Print the First Column on Every Page in Excel 2010

We have shown you print the first row on every page in Excel, but what if you wanted a column instead? Let say you have a table and you have a header column, instead of a row, that you want to print out on each page. Don’t worry we will show you how to do this in Excel 2010.

We will be using Excel 2010 for this but this works for Office 2010 or Office 2007.

How to Print First column in Every Page in Excel 2010

Just like our row tutorial you will need to go back to Page Layout and click on the Print Titles, so open up Excel and navigate to the menu.

Excel 2010

The Page Setup window will open, and you should be on the Sheet tab, if not go to it. Find the Print titles section and click the red arrow next to the Columns to repeat at left to the right of the text box.

Excel 2010

Then select the column you want to repeat and click the red arrow when you are done.

Excel 2010

Click OK on the Page Setup window, and you are ready to print. Take a look at my print preview:

Excel 2010

Every page has the first column on it on my Excel spreadsheet.

That is it, you might also want to check out some of our other Excel how to articles or go and post any questions you have in our forum.

This Excel how to applies to Office 2010 and Office 2007.

Follow me

Ryan Dozier

Just your typical neighborhood geek that loves computers and finding awesome free stuff.
Follow me