How to Print with Row and Column Headings in Excel 2010

Printed Excel spreadsheets always suffer from the fact that they can be difficult to follow. This is especially true of multi-page spreadsheets that are missing row or column titles or headings to help identify specific cells.

One way that you can resolve this problem is to change the printing settings for the spreadsheet so that the row and column headings are printed on every page. This is a simple adjustment to make using our short guide below.

Print Row and Column Headings on Every Page in Excel 2010

Following the steps below will only change this setting for the spreadsheet that is currently being edited. You will need to follow these steps again if you want to print the row and column headings on a different spreadsheet.

The row and column headings that this method will print are the numbers and letters at the top and left of the spreadsheet. After you have followed the steps below, you can click the Print Preview button to see how the spreadsheet will look when it is printed.

Step 1: Open your spreadsheet in Excel 2010.

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

click the page layout tab

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

click the page setup button

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

click the sheet tab

Step 5: Check the box to the left of Row and column headings in the Print section of the window, then click the OK button at the bottom of the window to confirm the changes.

how to print row and column headings in excel 2010

Find out how to print with row and column headings in Excel 2010 and provide your readers with an easy way to locate and identify individual cells.

Is there a column that you would like to print at the left side of every page of your spreadsheet? This article can show you how.

Join Our Free Newsletter

Featured guides and deals

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