How to Hide Zero Values in Excel Mobile App
Question details
The user wants to visually hide cells that display a zero value in the mobile spreadsheet app while retaining the actual numeric zero for downstream calculations.

- Product
- Excel Mobile App
- Device & OS
- Android
- Scenario
- Formatting a spreadsheet on a mobile device where the native desktop display settings for hiding zeros are missing.
- Observed behavior
- The mobile app lacks the specific option to hide zero values. Attempting to use IF formulas to return blank strings converts the numeric value to text, which disrupts other formulas.
Keep in mind that mobile workarounds to hide values are primarily visual. The actual zeros will remain in the cells, ensuring that any dependent formulas calculate correctly.
Change Cell Font Color to Match the Background
Since the mobile app lacks a direct toggle to hide zero values, you can make the zeros invisible by changing their font color to match the cell's background color.
This visual trick is the most reliable workaround on mobile devices. It hides the zeroes from view but preserves the underlying numeric values so your calculations do not break.
Tap and drag to highlight the cells or the specific range that contains the zero values you want to hide.
Tap the Edit icon to open the main menu, then navigate to the Home tab.
Expand the Font group options and change the font color to white (or whichever color exactly matches your spreadsheet's background).

Configure Display Settings on the Desktop Version
You can apply the native 'hide zero values' setting on a desktop computer, which may carry over when viewing the file on your mobile app.
Experience Advanced Spreadsheet Formatting with WPS Office
Frustrated by missing features in your current mobile app? WPS Office is a free, lightweight, and incredibly powerful alternative that offers robust spreadsheet editing tools natively on mobile. Enjoy a familiar interface and seamless compatibility with all your existing Microsoft Office files.
- 1. Download and Install: Get WPS Office for free from the Google Play Store or Apple App Store.
- 2. Open Your Files: WPS natively opens your existing spreadsheets without requiring any file conversions.
- 3. Edit Without Limits: Take advantage of comprehensive mobile tools to format, calculate, and present your data perfectly.

Frequently Asked Questions
Why shouldn't I use an IF formula to return an empty string?
Using a formula like `=IF(A1=0, "", A1)` changes the cell's underlying value from a number to text (an empty string). If other mathematical formulas reference this cell, it will often cause a #VALUE! error because the software cannot perform math on text.
Is there a custom number format I can use instead?
Yes, if you configure it on the desktop version. You can use the custom number format `0;-0;;@` to hide zero values. When you apply this format and sync the file, the mobile app will generally respect the custom formatting rule and hide the zeroes.
Will Microsoft add this feature to the mobile app?
This setting is currently missing from the mobile application. Users are encouraged to visit the official feedback portal to upvote the feature request, which helps developers prioritize future updates.
Does changing the font color to white affect printing from mobile?
No. As long as you are printing on standard white paper and your background is white, the zeroes will remain invisible on the printed document, exactly as they appear on your screen.




