[Fixed] Excel Formula Bar Not Showing Cell Contents

This article illustrates how to fix if the excel formula bar is not showing cell contents. Formula bar in excel allows us to enter or copy formulas. Using the formula bar in excel is more convenient in the case of large formulas. But sometimes the formula bar may not show the cell contents. If you are facing such a problem, then have a quick look through the article. The following picture highlights the purpose of this article.

[Fixed] Excel Formula Bar Not Showing Cell Contents


Download Practice Workbook

You can download the practice workbook from the download button below.


2 Ways to Fix Excel Formula Bar Not Showing Cell Contents

Here I will explain 2 possible solutions for the excel formula bar not showing cell contents. So, let’s start.


1. Fix Excel Formula Bar Not Showing Cell Contents with Format Cells

Imagine cell A1 in your dataset has some contents but the formula bar is not showing the contents.

  • This is probably because the worksheet or the workbook is protected with hidden cell contents. To fix the problem, you need to unprotect the sheet first. You can easily do that from the Review tab. You may need to enter a password though if the worksheet is protected with a password.

  • Then press CTRL+1 to open the Format Cells window. Uncheck Hidden from the Protection tab. Next click on the OK button as shown in the following picture.

Fix Excel Formula Bar Not Showing Cell Contents with Format Cells

  • After that, you will see that the cell contents are visible in the formula bar as shown below. Now the cell contents won’t be hidden from the formula bar anymore even if you protect the worksheet.

Read More: How to Hide Cell Contents in Excel Formula Bar (5 Methods)


2. Fix Excel Formula Bar Not Showing Cell Contents with Keyboard Shortcut

If your worksheet is not protected, then there might be a line break in the formula. It shifts the cell contents down making it invisible due to the narrow height of the formula bar.

  • To understand the problem, place your cursor at the beginning of the formula bar as shown below. Then press ALT+Enter. This will create a line break. Then press Enter again.

  • Now it seems that the cell contents are gone. Tough such is not the case in reality.

  • Press CTRL+SHIFT+U while cell A1 is selected. This will expand the formula bar making the cell contents visible again.

Fix Excel Formula Bar Not Showing Cell Contents with Keyboard Shortcut

  • You can also use the downward arrow at the upper-right corner of the formula bar to do that.

  • Alternatively, you can drag and expand the formula bar too.

Read More: [Fixed]: Formula Bar Shows Different Value Than Cell in Excel (3 Solutions)


How to Hide/Unhide the Formula Bar in Excel

If you need more room for your excel worksheet, you can hide the formula bar.

  • Now check Formula Bar to return to the original view.

  • You can also do that from the Excel Options window. Select File >> Options or press ALT+F+T. Then search for the Display options in the Advanced tab. Then, check or uncheck Show Formula Bar. After that, hit the OK button.

Hide/Unhide the Formula Bar in Excel


Things to Remember

  • If you are using two or more monitors, then you need to bring your spreadsheet to the primary monitor. This may fix your problem.
  • Try to hide the formula bar and then unhide it. See if it fixes the problem.
  • Sometimes restarting the workbook solves such a problem too.

Conclusion

Now you know how to fix it if the excel formula bar is not showing cell contents. Please let us know if this article has helped you to solve your problem. You can use the comment section below for further queries or suggestions too. Do visit our ExcelDemy blog to read more on excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo