Fix Excel Cells That Look Blank but Show Data in the Formula Bar
Question details
The user needs to make worksheet values visible in Excel cells when the values still appear in the formula bar.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Viewing a worksheet where cell contents may be affected by zoom, row height, or font rendering.
- Observed behavior
- Cells appear empty even though their values are visible in the formula bar.
Select an affected cell and check whether its value appears in the formula bar. Note the worksheet zoom level and the cell's font before changing them.
Adjust Excel Zoom and Autofit the Affected Rows
Use these display checks when values appear in the formula bar but not in the worksheet grid.
Use the zoom control at the bottom-right of the Excel window, or select View > Zoom, and set the worksheet to 100%.
Click the row numbers beside the affected cells, or select the entire worksheet using the button at the intersection of the row and column headings.
Go to Home > Format > AutoFit Row Height, then check whether the cell contents are visible.
If the cells still look blank, use the bottom-right zoom control to test a nearby zoom level and see whether the text reappears.

Test a Different Font in the Affected Excel Cells
Use this test if changing the zoom or row height does not restore the display, especially when the cells use Arial Narrow.
Share a Sanitized Workbook for Further Diagnosis
Use this option if zoom, row height, and font tests do not explain the behavior.
View and Edit Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format support makes it easy to move existing files into WPS, though it does not repair Excel's display settings.

Frequently Asked Questions
Why does the formula bar show data when an Excel cell looks blank?
The value may still be stored in the cell while a display issue hides it. Check the worksheet zoom, row height, and font, particularly if the cell uses Arial Narrow.
How do I reset the worksheet zoom in Excel?
Use the zoom control at the bottom-right of the Excel window or select View > Zoom and choose 100%.
How can I make a row tall enough to show its contents?
Select the affected row numbers, then choose Home > Format > AutoFit Row Height.
Will changing the font delete my cell values?
No. Selecting affected cells and choosing another font from the Home tab changes their appearance, not the stored values.
What should I share if the display issue continues?
Create a sample workbook without confidential data, upload it to OneDrive, and use Share to copy a link for the person investigating the issue.




