Formatting Issues

How to Fix Excel Footer Text Not Showing or Editable

Rana Garcia Sep 27, 2026 873 views

Question details

The user needs to add text to a spreadsheet footer but finds the footer text field completely uneditable and unresponsive.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Customizing the page setup for a spreadsheet by adding footer information prior to printing or exporting.
Observed behavior: The user is able to successfully add a header, but the 'Add footer' control does not respond to clicks. Additionally, some Page Setup options for the footer may appear grayed out or disabled.

Before you start

Ensure your worksheet is set to Page Layout view (View > Page Layout), as headers and footers are only visible and directly clickable in this specific viewing mode.

Solution 1Recommended

Reduce the Worksheet Zoom Level

Zooming out is a proven workaround when the footer field becomes unresponsive due to an Excel display rendering glitch.

In some versions of Excel, viewing the spreadsheet at 100% or higher magnification in Page Layout view can cause the bounding box of the footer to become unclickable. Lowering the zoom level forces the screen to redraw, which restores access to the text field.

Switch to Page Layout view

Navigate to the 'View' tab on the top Excel ribbon and click on 'Page Layout' if you are currently in Normal view.

Scroll down to the footer

Scroll to the very bottom of your current worksheet page where the 'Add footer' placeholder text is displayed.

Zoom out the worksheet

Use the zoom slider located at the bottom-right corner of the Excel window to reduce the magnification (for example, slide it down to 75% or 50%).

Enter your footer text

Click directly into the footer area again. The field should now activate and display a blinking cursor, allowing you to type your desired footer text.

Return to Normal Zoom: Once you have successfully typed in your footer text and clicked outside the footer area to apply it, you can safely return your zoom level back to 100%.

Seamless Spreadsheet Editing

Easily Add Headers and Footers with WPS Spreadsheet

Avoid display glitches when preparing your documents for print. WPS Spreadsheet offers a smooth and reliable Page Layout view, allowing you to effortlessly add, edit, and format headers and footers without dealing with unresponsiveness.

1. Open your file in WPS: Launch WPS Office and open your spreadsheet document.
2. Access the Header and Footer tool: Go to the 'Insert' tab on the top ribbon and click on the 'Header and Footer' icon.
3. Navigate to the footer: The view will automatically switch. Scroll down or click the 'Go to Footer' button on the ribbon to access the bottom section.
4. Enter and format text: Click directly into the left, center, or right footer section and type your text, or use the ribbon buttons to insert dynamic elements like page numbers.

Free to use with a familiar, highly intuitive interfaceFully compatible with Microsoft Excel (.xlsx and .xls) formatsStable Page Layout view immune to zooming glitchesRich built-in presets for inserting page numbers, dates, and file paths

Frequently Asked Questions

Why are the Page Setup options for headers and footers disabled in Excel?

This usually happens if you are currently actively editing a cell (your cursor is blinking inside a spreadsheet cell). Press 'Enter' or 'Esc' on your keyboard to exit cell editing mode, and the Page Setup and footer options will become clickable again.

Why can't I see my footer in Normal view?

Headers and footers are strictly designed for printed pages. They will only display when you are in the Page Layout view or when you are looking at the Print Preview screen. They remain hidden in the default Normal working view.

Can I add different footers for the first page?

Yes. When you click into the footer area, the 'Header & Footer' design tab will appear on the ribbon. Check the box labeled 'Different First Page' to specify a unique footer that will only apply to page one of your printed worksheet.

How do I automatically insert page numbers in the Excel footer?

Click into the footer area to activate the Header & Footer tools on the ribbon. Click on the 'Page Number' button, which will insert the code &[Page] into the text box. This code will automatically translate into the correct sequential page numbers when the document is printed.

Document & File Issues