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.
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.