How to Add Page Numbers in Excel - Practical Guide

Learn how to add page numbers to your Excel spreadsheets for professional printing. This tutorial covers inserting page numbers in headers and footers, customizing their format and position, and ensuring they appear correctly across multiple printed pages. Page numbers are essential for document organization and reader navigation.

Why This Matters

Page numbers help readers navigate multi-page documents and are required for professional reports, compliance documents, and formal presentations. They ensure printed materials appear organized and complete.

Prerequisites

•Excel spreadsheet with data ready to print
•Understanding of basic printing concepts

Step-by-Step Instructions

Access Page Setup Options

Click Insert > Header & Footer to open the Print Layout view where you can edit headers and footers.

Position Your Cursor in Footer Area

Click on the Center Footer section (or Left/Right Footer) where you want page numbers to appear in the header/footer editing area.

Insert Page Number Code

Click Insert > Page Number (#) button in the Header & Footer Tools ribbon to automatically insert the page number code.

Add Custom Text (Optional)

Type additional text like 'Page ' before or 'of &[Pages]' after the page number code for context (e.g., 'Page 1 of 5').

Exit Edit Mode and Print Preview

Click outside the header/footer area or press Escape, then go to File > Print to verify page numbers appear correctly on all pages.

Alternative Methods

Using Page Setup Dialog

Go to File > Print > Print Setup (or Page Setup) and access header/footer options from the dialog box instead of Insert ribbon.

Adding Page Numbers in Headers

Use the Left Header or Right Header sections instead of Footer to place page numbers at the top of each printed page.

Tips & Tricks

✓Use 'Page # of &[Pages]' format to show total pages automatically—very helpful for professional documents.
✓Preview your document before printing to ensure page numbers don't overlap with your data or other content.
✓Different sections of a workbook can have different page number formats using different sheet headers/footers.

Pro Tips

★Use &[Date] and &[Time] codes in the same footer to add timestamp alongside page numbers for version control.
★Right-align page numbers using Tab stops in the footer to keep them away from data in print layout.
★Create a custom footer with company branding like '© 2024 Company Name - Page #' for professional documents.

Troubleshooting

Page numbers are cut off or outside the printable area

Adjust your page margins (File > Page Setup > Margins) to ensure the header/footer area fits within your printer's margins. Increase top/bottom margins if needed.

Page numbers don't match actual printed pages

Check your print settings for page breaks and scaling. Go to File > Print > Settings and verify 'Fit to' or 'Scale' options aren't splitting pages unexpectedly.

Header/Footer editing area is grayed out

Exit Normal view and switch to Page Layout view via View > Page Layout, which enables header/footer editing.

Frequently Asked Questions

Can I start page numbering from a number other than 1?

Yes. Go to File > Print > Settings > Advanced (or Page Setup dialog) and look for 'Page number' or 'Start page number' option. Enter your desired starting number, though this is primarily for printing, not affecting the document itself.

How do I remove page numbers from the first page only?

Enable 'Different first page' option in Page Setup (File > Page Setup > Header/Footer tab), then leave the first page header/footer empty while adding page numbers to subsequent pages.

Can page numbers appear on different positions for odd and even pages?

Yes, use the 'Different odd and even' option in Page Setup to create separate headers/footers for odd and even pages, then position page numbers differently on each.

Do page numbers update automatically when I add or delete rows?

Page numbers are recalculated based on page breaks when you print or preview, so they always reflect the current pagination of your document.

What does &[Pages] code do?

The &[Pages] code automatically displays the total number of pages in your document, useful for formats like 'Page 1 of 10'.