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

Get FREE Advanced Excel Exercises with Solutions!

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.


Cell Contents Are Not Visible But They Show in Formula Bar in Excel: 5 Possible Solutions

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 the 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

Read More: [Fixed] Excel Formula Bar Not Showing Cell Contents


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 in 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

Read More: How to Reduce the Size of Formula Bar in Excel


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

Read More: [Fixed!] Excel Formula Bar Not Showing Text


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

If these 5 steps do 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 will show in the Formula Bar. Recovering the corrupted 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


Download Practice Workbook


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. Thanks for reading. Keep excelling!


Related Articles


<< Go Back to Excel Formula Bar | Excel Parts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo