Formatting Issues

How to Display Cell Values in the New Excel Format in WPS Office

Ayan MasoodAyan Masood Nov 13, 2026 868 views

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.

How to Display Cell Values in the New Excel Format in WPS Office
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook in WPS Office Spreadsheet

Launch WPS Office, click Spreadsheet, then open the affected Excel workbook from the file location or Recent files.

2
Select the affected range

Highlight the cells where values are not visible, or press Ctrl+A to select the entire worksheet.

3
Check number format and font color

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.

4
Turn off formula view

Go to the View tab and clear or deselect Show Formulas so calculated results appear instead of formula text.

5
Unhide hidden rows or columns

Select the row or column headers around the missing area, right-click, and choose Unhide to restore hidden values.

Restore Cell Values in WPS Office Spreadsheet
Values should now appear correctly: After these changes, the cell values should display in WPS Office Spreadsheet unless the cells are filtered or protected.
WPS Office Spreadsheet

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. 1. Open WPS Office Spreadsheet: Launch WPS Office and click Spreadsheet, then open the affected workbook from your folder or Recent files.
  2. 2. Select the cells with missing values: Highlight the affected range, or press Ctrl+A to select the whole worksheet.
  3. 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. 4. Turn off Show Formulas: Go to the View tab and deselect Show Formulas so calculated values display instead of formula text.
  5. 5. Unhide hidden rows and columns: Right-click the surrounding row or column headers and choose Unhide to restore any hidden values.
Free to use for viewing and editing .xlsx workbooksPreserves Microsoft Excel cell values, formulas, and formattingFamiliar ribbon interface makes display settings easy to findQuickly switch between formula view and normal value displaySupports the new Excel .xlsx format for seamless migration
microsoft office alternative - wps office

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.