How to Print the First Column on Every Page in Excel 2013

Does your spreadsheet have a column of labels that help to identify the information in the rest of the spreadsheet? This is a common way to organize data in Excel, as it allows viewers of the document to easily identify the information contained within a cell.

But a printed spreadsheet can be very different than one that you view on your computer screen, and your audience may have difficulty keeping data straight on anything printed after page 1. A helpful way to resolve this problem is to print the header column at the left side of every page. This can help to reduce confusion, and ensure that the intended information is being conveyed to your audience.


Print a Column on the Left of Every Page in Excel 2013

The steps in this tutorial will allow you to select a column that prints at the left side of every page that you print from Excel 2013. Note that columns have letters, and rows have numbers. If you instead want to print a row at the top of every page, then you can read this article.


Step 1: Open your spreadsheet in Excel 2013.


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

click the page layout tab



Step 3: Click the Page Setup button at the bottom-right corner of the Page Setup section of the navigational ribbon.

click the page setup button



Step 4: Click the Sheet tab at the top of the window.

click the sheet tab



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

click inside the columns to repeat at left field



Step 5: Click the letter at the top of the spreadsheet for the column that you want to repeat at the left side of every page.

click the column to repeat



Step 6: Confirm that the value in the Columns to repeat at left field is correct, then click the OK button at the bottom of the window. You can then proceed to print your spreadsheet with your new settings.

click the ok button



Do you only want to print some of the cells in your spreadsheet? Find out more about printing a selection in Excel 2013 and learn about one of the ways that you can modify the way you print your spreadsheets.

Join Our Free Newsletter

Featured guides and deals

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

Newest Guides