Formatting Issues

Fix Excel Cells That Look Blank but Show Data in the Formula Bar

Natalie TaylorNatalie Taylor Nov 20, 2026 868 views

Question details

The user needs to make worksheet values visible in Excel cells when the values still appear in the formula bar.

Fix Excel Cells That Look Blank but Show Data 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.
Before you start

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.

Solution 1Recommended

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.

1
Reset the zoom

Use the zoom control at the bottom-right of the Excel window, or select View > Zoom, and set the worksheet to 100%.

2
Select affected rows

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.

3
Autofit row height

Go to Home > Format > AutoFit Row Height, then check whether the cell contents are visible.

4
Try another zoom level

If the cells still look blank, use the bottom-right zoom control to test a nearby zoom level and see whether the text reappears.

Adjust Excel Zoom and Autofit the Affected Rows
Free Microsoft Office alternative

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.

Open and review worksheet values in WPS SpreadsheetsCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet controls for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.