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

A printed Excel spreadsheet with more than one page can be difficult to read.

Important information that identifies cell contents and gives context for values might not be on every page, so the reader might be going back and forth between pages, which can waste time and lead to mistakes.

Our tutorial below will show you how to print the first column on every page in Excel 2013 so that important information is shown at the left side of every page.

How to Repeat an Excel Column on the Left of Every Printed Page

  1. Open the Excel file.
  2. Select the Page Layout tab.
  3. Click the Print Titles button.
  4. Click inside the Columns to repeat at left field.
  5. Choose the column letter to print on each page.
  6. Click OK.

Our guide continues below with additional information on how to print the first column on every page in Excel 2013, including pictures of these steps.

Does your spreadsheet have a column of labels that helps 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 one.

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.

How to Print the Same Column on Every Page in Microsoft Excel (Guide with Pictures)

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

Now that you know how to print the first column on every page in Excel 2013 you can make your printed spreadsheets a lot easier to read.

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