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.
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.
Then select the column you want to repeat and click the red arrow when you are done.
Click OK on the Page Setup window, and you are ready to print. Take a look at my print preview:
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.
Comments are closed.