5 Simple Ways to Remove Page Numbers in Excel

Excel, a powerhouse in the realm of data management and analysis, offers a multitude of features to its users. One common customization that users often seek is the removal of page numbers. Whether for presentation purposes or simply to streamline a document, knowing how to remove or hide page numbers can be quite handy. Here are five straightforward methods to help you remove page numbers in Excel, enhancing the clarity and professionalism of your spreadsheets.

Method 1: Using Page Layout View

To start with, let’s explore a simple method for removing page numbers through the Page Layout view:

• Open your Excel workbook.
• Switch to the ‘View’ tab on the ribbon.
• Select ‘Page Layout’ from the workbook views section to enter Page Layout View.
• In this view, go to the ‘Header & Footer’ group under the ‘Page Layout’ tab.
• If your document has a footer, click on the footer section. If there’s no footer but a header with page numbers, click on the header.
• Delete the page number code from the header or footer by selecting it and pressing ‘Delete’ on your keyboard.

🔍 Note: This method allows you to directly edit page numbers in the layout, making it a visual and immediate solution.

Method 2: Via Page Setup

For those looking for a more controlled approach:

• Navigate to the ‘Page Layout’ tab in the ribbon.
• Click on the ‘Page Setup’ dialog box launcher (small arrow in the bottom right corner).
• In the Page Setup window, go to the ‘Header/Footer’ tab.
• Choose ‘Custom Header’ or ‘Custom Footer’ where the page number might be located.
• Remove any page number codes by deleting them, then click ‘OK’.

These steps not only remove page numbers but also allow you to customize headers or footers further if needed.

Method 3: Hide Headers and Footers

If you prefer not to delete page numbers but simply hide them:

• Go to the ‘Page Layout’ tab.
• Click on ‘Print Titles’ in the ‘Page Setup’ group.
• In the dialog box, select the ‘Sheet’ tab.
• Check the box for ‘Different first page’ or uncheck the boxes for ‘Rows to repeat at top’ and ‘Columns to repeat at left’.
• Remove any entries in the ‘Header’ or ‘Footer’ fields that contain page numbers.
• Confirm by clicking ‘OK’.

📝 Note: This approach is perfect if you want to keep the page numbers for some purposes but not display them when printing or showing the sheet.

Method 4: Use VBA Macro

For users comfortable with VBA or needing to perform this task frequently:

• Press ‘Alt’ + ‘F11’ to open the VBA editor.
• Insert a new module by right-clicking on any workbook in the Project Explorer, selecting ‘Insert’, and then ‘Module’.
• Paste the following code into the module:

Sub RemovePageNumbers()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Worksheets
        ws.PageSetup.CenterFooter = ""
        ws.PageSetup.RightFooter = ""
        ws.PageSetup.LeftFooter = ""
        ws.PageSetup.CenterHeader = ""
        ws.PageSetup.RightHeader = ""
        ws.PageSetup.LeftHeader = ""
    Next ws
End Sub

• Close the VBA editor and run the macro by pressing 'Alt' + 'F8', selecting 'RemovePageNumbers', and clicking 'Run'.

Using VBA provides a fast, repeatable method to remove page numbers from all sheets or specified sheets.

Method 5: Custom Page Layout

If you’re designing a report or any Excel output:

• Access the ‘Page Layout’ tab.
• Click on ‘Page Setup’ and go to the ‘Header/Footer’ tab.
• Choose or create a custom header/footer layout.
• Ensure that no page number fields are included in your custom layout.

This method is particularly useful when tailoring the look and feel of your document for presentations or publications, ensuring that all visual elements, including page numbers, are under your control.

In summary, these five methods provide a variety of ways to manage and remove page numbers in Excel, catering to different levels of user expertise and document requirements. From simple GUI adjustments to more advanced VBA scripting, users have a range of options to streamline their Excel documents effectively. Remember, each method serves a different purpose; choose the one that best suits your needs, whether for a one-time adjustment or as part of your regular Excel workflow.

Can I remove page numbers from only certain sheets?

+

Yes, you can adjust page numbers for specific sheets using the Page Layout or Page Setup method, or target particular sheets in VBA.

Will removing page numbers affect my document’s layout?

+

Removing page numbers does not impact the layout of your spreadsheet itself but does change how your document appears when printed or viewed in page layout mode.

How can I undo the removal of page numbers?

+

If you’ve deleted the page numbers, you’d need to add them back manually through the header or footer settings. If you’ve hidden them, simply undo the changes made in the Page Setup dialog.