Formatting Issues

How to Hide Zero Values in Excel Mobile App

Olivia MillerOlivia Miller Oct 26, 2026 871 views

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.

How to Hide Zero Values in Excel Mobile App Without Removing Them
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the target cells

Tap and drag to highlight the cells or the specific range that contains the zero values you want to hide.

2
Access the formatting tools

Tap the Edit icon to open the main menu, then navigate to the Home tab.

3
Adjust the font color

Expand the Font group options and change the font color to white (or whichever color exactly matches your spreadsheet's background).

Change Cell Font Color to Match the Background
Calculation Integrity: Because the zeroes are only hidden visually, any SUM or AVERAGE formulas referencing these cells will continue to function normally.
Free Microsoft Office alternative

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. 1. Download and Install: Get WPS Office for free from the Google Play Store or Apple App Store.
  2. 2. Open Your Files: WPS natively opens your existing spreadsheets without requiring any file conversions.
  3. 3. Edit Without Limits: Take advantage of comprehensive mobile tools to format, calculate, and present your data perfectly.
100% compatible with Microsoft Excel (.xlsx, .xls) formatsRich mobile spreadsheet editing and advanced formatting toolsCompletely free, lightweight, and fast on Android and iOS devicesFamiliar interface ensures a seamless transition with zero learning curve
QA img-9

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.