How to Display Cell Values in the New Excel Format in WPS Office
Question details
The user needs to restore or verify cell value visibility in the updated Excel interface and identify which display or formatting settings may hide values.

- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- A user opened a workbook in the updated Excel interface and noticed that some cell values are not visible or appear changed.
- Observed behavior
- Cells look blank or show unexpected results even though the underlying data or formula is present.
Open the affected workbook and make a copy of the worksheet before changing display or formatting settings. Check that the file is a supported Excel format such as .xlsx so WPS Office Spreadsheet can open and display it correctly.
Restore Cell Values in WPS Office Spreadsheet
Use this method when you want a reliable WPS Office workflow to check formatting, view options, and hidden rows or columns that can hide cell values.
WPS Office Spreadsheet preserves Excel formatting and formulas while giving you direct access to display settings. If the value exists in the formula bar, the issue is usually a visible-format setting rather than missing data.
Launch WPS Office, click Spreadsheet, then open the affected Excel workbook from the file location or Recent files.
Highlight the cells where values are not visible, or press Ctrl+A to select the entire worksheet.
Right-click the selection and choose Format Cells. On the Number tab, set the category to General or the intended format, and on the Font tab set Color to Automatic.
Go to the View tab and clear or deselect Show Formulas so calculated results appear instead of formula text.
Select the row or column headers around the missing area, right-click, and choose Unhide to restore hidden values.

Check View Settings and Clear Formats in Microsoft Excel
Use this method if you need to stay in Microsoft Excel and verify whether the updated interface enabled a view or formatting option that hides cell values.
Display Excel Cell Values in WPS Office Spreadsheet
Open the new Excel file in WPS Office Spreadsheet, verify cell formatting and view options, and restore value visibility without losing workbook data or structure.
- 1. Open WPS Office Spreadsheet: Launch WPS Office and click Spreadsheet, then open the affected workbook from your folder or Recent files.
- 2. Select the cells with missing values: Highlight the affected range, or press Ctrl+A to select the whole worksheet.
- 3. Check cell formatting: Right-click the selection, choose Format Cells, and confirm that the number category and font color are not hiding the values.
- 4. Turn off Show Formulas: Go to the View tab and deselect Show Formulas so calculated values display instead of formula text.
- 5. Unhide hidden rows and columns: Right-click the surrounding row or column headers and choose Unhide to restore any hidden values.

Frequently Asked Questions
Why is my Excel cell blank when the formula bar shows a value?
This is usually caused by a custom number format, white font color, or formulas being displayed instead of results. In WPS Office Spreadsheet, select the cell, open Format Cells, set the number format to General, and set the font color to Automatic.
How do I turn off Show Formulas in the updated Excel interface?
In Microsoft Excel, go to the Formulas tab and click Show Formulas. In WPS Office Spreadsheet, go to the View tab and deselect Show Formulas.
Can WPS Office open the new Excel .xlsx format without losing cell values?
Yes. WPS Office Spreadsheet supports .xlsx files and preserves cell values, formulas, and most formatting when opening and saving Excel workbooks.
Why are entire rows or columns missing values after opening a workbook?
Rows or columns may be hidden or filtered. Select the headers around the missing area, right-click, and choose Unhide, or go to the Data tab and clear filters.
Does changing a cell number format delete the existing value?
No. Changing number format, font color, or view settings only changes how a value is displayed. The underlying cell value is not deleted.




