[Solved]: Excel Cell Contents Not Visible but Show in Formula Bar

Looking for a solution to “Excel cell contents not visible but show in Formula Bar”? Then this is the right article for you. We will discuss the top 5 reasons along with solutions to the issue. Moreover, we will discuss 3 more alternative solutions to this problem at the end of this article.


Download Practice Workbook


5 Suitable Solutions for the Issue Regarding Excel Cell Contents That Are Not Visible but They Show in Formula Bar

To demonstrate our solutions, we have taken a dataset with 3 columns: “Name”, “Weight (lbs)”, and “Weight (kg)”. Basically, this dataset shows the weight information for 6 employees. Sometimes, the cell contents may not be visible inside the cell. However, if we click on it, we can see it on the Formula Bar.

  • The top reasons for this issue are:
    • First, the font color is the same as the background color.
    • Next, the cell format is set to three semicolons, which hide the cell contents.
    • Then, the row height is set too small.
    • The Text Wrap feature is turned on.
    • Finally, the text alignment is indented.
  • Moreover, less common reasons are:
    • Firstly, the font is unavailable.
    • Secondly, the RAM issue.
    • Lastly, corrupted Excel file.

Excel Cell Contents Not Visible but Show in Formula Bar


1. Changing Font Color

If the font color is the same as the color of the Excel cell background, then the cell contents will not be visible but will show in the Formula bar. In our dataset, we can see that cell D6 is not visible in the cell but in the Formula Bar, it is shown. Next, we will change the font color in this section to solve this problem.

Excel Cell Contents Not Visible but Show in Formula Bar 2

Steps:

  • Now, all font colors are set to White in our case.
  • So, we select the cell range D5:D10.
  • Then, from the Home tab → Font Color → select Automatic. This will change the font color to Black.

Excel Cell Contents Not Visible but Show in Formula Bar 3

  • After that, we can see the cell contents in Excel.

Excel Cell Contents Not Visible but Show in Formula Bar 4


2. Modifying Cell Format

When there is a Custom Cell Format set, we may not be able to see the Excel cell contents. To check if there is any custom cell formatting set and fix our issue, follow these steps.

Steps:

  • At first, select the cell range D5:D10.
  • Next, press CTRL+1.

Excel Cell Contents Not Visible but Show in Formula Bar 5

  • So, this will bring up the Format Cells dialog box.
  • Then, we can see that there are three semicolons. This Custom Format is causing the issue.

Excel Cell Contents Not Visible but Show in Formula Bar 6

  • Then, select Number from the Category section.
  • Lastly, press OK.

Excel Cell Contents Not Visible but Show in Formula Bar 7

  • Thus, we have solved the issue.

Excel Cell Contents Not Visible but Show in Formula Bar 8


3. Adjusting Row Height

If the row height is smaller, then the cell contents will not be visible in Excel. To fix this, we need to adjust the row heights.

Excel Cell Contents Not Visible but Show in Formula Bar 9

Steps:

  • To begin with, select row 5 and right-click on it to bring up the Context Menu.
  • Then, select Row Height.

Excel Cell Contents Not Visible but Show in Formula Bar 10

  • So, the Row Height box will pop up.
  • Then, set Row Height to 47.5 and press OK.

Excel Cell Contents Not Visible but Show in Formula Bar 11

  • After that, it will make the cell value from B5 visible.

Excel Cell Contents Not Visible but Show in Formula Bar 12

  • Again, there is another cell that needs to be resized.
  • We can double-click between rows 8 and 9 to AutoFit row 8.

Excel Cell Contents Not Visible but Show in Formula Bar 13

  • Thus, this third solution works for our issue and this is what the final image should look like.

Excel Cell Contents Not Visible but Show in Formula Bar 14


4. Turning Off Wrap Text Feature

Now we have the same dataset from method 3. We can turn off the Text Wrap feature to solve the issue of “Excel cell contents not visible but show in Formula Bar”.

Steps:

  • Firstly, select the cell range B5:B10.
  • Secondly, from the Home tab → deselect Wrap Text.

Text Wrap Feature

  • So, the cell contents will be visible once again.

Text Wrap 2


5. Changing Text Alignment

When the text alignments are indented, then the cell contents will not be visible in Excel. However, the Formula Bar will show the value. If this is the case for us, we need to change the text alignment in the Format Cells window.

Indent 1

Steps:

  • First, select cell B6 and press CTRL+1 to bring up the Format Cells window.
  • Then, from the Alignment tab, we can see that the Indent is 30.

Indent 2

  • Afterward, set the Indent to 0 and press OK.

Indent 3

  • Lastly, repeat this for cell B8 and the final output will be similar to this.

Indent Output


Other Solutions for Excel Cell Contents Not Visible but Show in Formula Bar

If these 5 steps did not solve the issue for you, then you can try these 3 additional solutions.

  • RAM Issue: When there is a RAM issue, the Excel file may not show the cell contents. Closing and reopening the Excel file should fix the problem.
  • Font Not Available: If you download the file and the used fonts are not available on your computer, then you will not be able to see the cell contents. To fix this, install that font or change the font.
  • Corrupt Excel File: If there is a problem in your Excel file then the cell contents will not be visible but show in Formula Bar. Repairing the Excel file is a solution when this happens. There are also various online tools available for this.

Practice Section

We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.

Practice Dataset


Conclusion

We have shown you the top 5 reasons with solutions to the issue of “Excel cell contents not visible but show in Formula Bar”. If you face any problems regarding these methods or have any feedback for me, feel free to comment below. Moreover, you can visit our site ExcelDemy for more Excel-related articles. Thanks for reading, keep excelling!

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I am passionate about all things related to data and MS Excel is my favorite application. I want to make people's life easier by writing easy-to-follow and in-depth guides here at Exceldemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo