Fix Excel Mobile App Not Displaying Headings and Headers
Question details
The user is unable to see headings in the mobile spreadsheet application, even though the setting is enabled and they are visible in print preview.
- Product
- Excel Mobile
- Device & OS
- not provided
- Scenario
- Viewing and editing a spreadsheet on a mobile device where page headers or row headings are expected to be visible.
- Observed behavior
- The headings or headers do not display in the normal mobile editing view, but they appear correctly when accessing the print preview mode.
Determine whether you are looking for page headers and footers (which print at the top/bottom of pages) or grid row and column headings (e.g., A, B, C and 1, 2, 3), as mobile apps handle them differently.
Use Print Preview or Switch to a Desktop Application
Page headers and footers are generally not supported in the standard editing view of mobile spreadsheet applications and require a desktop app for full editing.
Mobile spreadsheet applications are highly optimized for smaller screens. Because of this space constraint, page headers and footers will not display in the normal editing view, even if your document contains them. They are only rendered when generating a print layout.
If you need to actively edit or view headers and footers alongside your spreadsheet data, you will need to open the document on a desktop computer.
Open your document in the mobile app and navigate to the Print or Print Preview screen to confirm your headers and footers are intact.
Transfer or sync the spreadsheet to a computer and open it using a full desktop spreadsheet application (like WPS Spreadsheets or desktop Excel) to access the Page Layout view.
Switch to WPS Office for a Seamless Cross-Platform Experience
Since mobile spreadsheet apps have inherent limitations with displaying page headers and footers, WPS Office provides a lightweight, free alternative. Use its robust desktop application for detailed header editing, and rely on its capable mobile app for accurate on-the-go print previews.
- 1. Download and Install WPS Office: Get WPS Office on your desktop or mobile device from the official website or your device's app store.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Excel file.
- 3. Manage Headers and Footers: On desktop, navigate to the 'Insert' tab and click 'Header and Footer' to easily edit them in a full-featured view.

Frequently Asked Questions
Why do my row and column headings disappear on my mobile spreadsheet app?
You may have accidentally disabled the setting. Go to the View menu or settings panel within your mobile app and ensure the 'Headings' option is toggled on to restore the A, B, C and 1, 2, 3 grid labels.
Can I edit headers and footers directly within the mobile app view?
No, standard mobile spreadsheet apps generally do not support editing or displaying page headers and footers in the normal view due to screen space limitations. You must use a desktop application to edit them.
How do I know if my headers will print correctly from my phone?
Use the Print Preview feature within your mobile app. Even though headers are hidden during editing, if they appear correctly in the print preview screen, they will be included on the final printed page or PDF.




