Excel 2010 offers a variety of options that can be added to or removed from your printed worksheets. One of these options is the ability to include row and column headings when you print. These are the numbers at the left side and letters at the top which help to identify the location of a cell. While they can be helpful when viewing a spreadsheet on the screen, they are often undesirable on the printed page.
Printing row and column headings is an option that can be turned on or off for each individual Excel file, although the default setting is for them not to print. But if your file has been modified so that the headings are printing, then our short guide below will show you how to remove them from your spreadsheet.
Disable the Print Option for Row and Column Headings in an Excel 2010 Worksheet
The steps in this article were written specifically for Excel 2010, and the screenshots displayed are from that version of the program. These steps are similar in other versions of Excel as well. If you aren’t sure which version of Excel you are using, you can read this article.
Step 1: Open the spreadsheet in Excel 2010 that is printing with row and column headings.
Step 2: Click the Page Layout tab at the top of the window.
Step 3: Click the box to the left of Print, under the Headings portion in the Sheet Options section of the ribbon. This will remove the check mark from the box, as in the image below.
You can now click the File tab and click Print (or press Ctrl + P on your keyboard) to see that your spreadsheet will print without the row and column headings. If you print this spreadsheet a lot, then you should save the file after making this change so that the headings do not show up the next time you print it.
Are you having other print problems with Excel? Our simple guide to printing in Excel can offer solutions for some of the more common print issues that can arise with the program.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.