How to Remove Page Numbers in Excel 2010

Page numbers are a helpful way to keep printed documents organized, especially if the document is something like a spreadsheet. Excel spreadsheets, especially multi-page ones, can all look very similar, and an out of order spreadsheet can be difficult to re-organize without page numbers.

But there are times where page numbers can be distracting or disruptive, so you may choose to remove them from your file. But if you did not add the page numbers to the spreadsheet yourself, you may be having difficulty determining how you can remove them. So continue reading our guide below to learn how you can remove page numbers from your Excel 2010 spreadsheet.


Getting Rid of Excel 2010 Page Numbers

This tutorial is going to completely remove all of the page numbers from your Excel 2010 spreadsheet. If you decide later that you want to have page numbers, you can read this article to learn how to add them.


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



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

click the page setup button



Step 4: Click the Header/Footer tab at the top of the window.

click the header/footer tab



Step 5: Click the drop-down menu under Header, then select the None option at the top of the list. Repeat this for the drop-down menu under Footer as well. Your window should them look like the image below. Click the OK button when you are done.

how to remove page numbers in excel 2010



If you open the Print menu in Excel, your page numbers should no longer be visible.

Do you struggle trying to adjust your Excel spreadsheets so that they print better? Learn how to fit all of your columns on one page to save time manually adjusting column widths. newsletter

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