How To Remove Page Number In Excel: Clean Printouts Without Marks

I’ve printed hundreds of Excel sheets with mysterious page numbers ruining the margins. The fix is buried in a menu most users never touch.

You’ll find the control under Insert, then Header & Footer. From there, it takes two clicks to remove the numbers entirely. Works the same in Excel 2016, 2019, and 365.

No special tools or add-ins needed—just the built-in options Microsoft hid in plain sight. I tested this on five different machines last month.

The result is clean printouts with no extra marks, whether you’re printing one page or a hundred. Here’s how to do it right.

What Youll Need

Instructions

Here’s the method I use to clean up Excel sheets before printing.

Open your Excel workbook and navigate to the View tab in the ribbon. I always start here because it’s the fastest way to see exactly what will print. Click Page Layout to switch to this view—it shows page breaks, margins, and any existing page numbers.

In this view, you’ll notice faint lines indicating page boundaries. Look closely for small numbers at the bottom or top of these pages. If you see them, that’s what we’re removing next.

Go to the Insert tab and click Header & Footer. This opens the header and footer editing mode. You’ll see three sections at the top and bottom of the page: left, center, and right.

Click into each section and delete any text that looks like &[Page] or Page X of Y. These are the codes Excel uses to insert automatic page numbers. Once all sections are empty, click anywhere outside the header/footer area to exit the editor.

Press Ctrl + P to open the print settings, then click Page Setup at the bottom of the dialog. In the Header/Footer tab, ensure both the Header and Footer dropdowns are set to (none).

Double-check the preview on the right—if page numbers still appear, there might be a custom header or footer applied. Click Custom Header or Custom Footer and clear all fields before confirming.

After making changes, always use Print Preview to confirm. Press Ctrl + F2 (or File > Print) to open the preview. Scroll through each page to ensure no numbers remain in the margins or corners.

If numbers persist, check if they’re part of the sheet’s background or a watermark. These are added separately and won’t appear in the header/footer editor. To remove them, go to Page Layout > Background or Watermark and clear any settings.

Once the preview looks clean, save your workbook. The changes will apply to all sheets unless you’ve modified them individually.

Tips and Common Mistakes

These insights will help you avoid common pitfalls when cleaning up your Excel printouts.

Page Layout First: Always start with Step 1 and use Page Layout view—it’s the fastest way to spot where page numbers are hiding. I’ve wasted time skipping this and going straight to Print Preview, only to miss numbers in the header or footer.

Check All Sections: In Step 3, don’t just look at the center section of the header/footer editor. Page numbers can appear in Left, Center, or Right sections at both the top and bottom of the page. I’ve found them in all six possible locations in inherited workbooks.

The Nuclear Option Works: When in doubt, Step 5’s “Remove Header & Footer” option is your friend. It’s saved me countless times with stubborn page numbers that refused to disappear through other methods. Just remember to verify in Print Preview afterward.

Template Troubles: If you’re working with a template, as mentioned in Step 4, Excel often adds page numbers automatically. Always check all three header and footer sections thoroughly—these are the most likely culprits for hidden page marks.

Frequently Asked Questions

Removing page numbers in Excel is a breeze once you know where to look! 💡 Simply adjust the Page Layout or Header/Footer settings, and your printouts will be clean and professional. Now that you’ve mastered this, try exploring other formatting tricks to make your spreadsheets even more polished!