How to Repeat a Column on the Left Side of Every Printed Page in Excel 2010

No matter what you use Microsoft Excel for, there’s a strong possibility that you will need to print something from it at some point. This is often a tricky proposition, however, as the default spreadsheet settings in Excel typically won’t result in a great printed document. This is especially true for multi-page documents. One way that you can simplify these printed spreadsheets, however, is by configuring the spreadsheet to print a specific column on every page. For spreadsheets that are oriented with headings in the first column, this is a very important function. It will make the rest of your pages easier to read because your readers will be able to see which row heading is applying to the columns that they are seeing on each successive page.


How to Repeat Columns in Excel 2010

This is a similar process to one we have previously written about printing a row on every page in Excel 2010. The main difference being that printing a column on every page is ideal when your spreadsheet extends far to the right, while printing a row on every page is better suited for spreadsheets that extend far down.


Step 1: Open the spreadsheet in Excel 2010.


Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab in excel 2010



Step 3: Click the Print Titles button in the Page Setup section of the ribbon at the top of the window.

how to print a column on every page in excel 2010



Step 4: Click inside the Columns to repeat at left field.

click inside the columns to print at left field



Step 5: Click the number at the top of the column that you want to repeat on each page. For example, in the image below, I am selecting column A.

click the column you want to print on every page



Step 6: This will populate the Columns to repeat at left field, so you can click the OK button at the bottom of the window.

click the OK button after the field is populated



You can now go ahead and finish setting up your spreadsheet as needed, then the spreadsheet will print out with your selected column repeated on each page.

If you do a lot of printing from multiple printers, then a wireless laser printer can be very helpful. Brother makes a wireless laser printer that is very affordable and has great reviews. Learn more here.

You can also learn how to adjust your print settings to fit all of your columns on one page in Excel 2010. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.