[Fixed!] Excel Formula Bar Not Showing Text (3 Quick Solutions)

In this article, we will provide 3 solutions to the ‘Excel formula bar not showing text’ problem. Generally, when you click a cell in your excel worksheet, the formula bar shows the text that the cell contains. But, sometimes, the formula bar does not display any text. Today, we will demonstrate three solutions that you can use when the excel formula bar is not showing text.


Download Practice Book

Download the practice book here.


What Is the Purpose of a Formula Bar?

Excel formula bar is used to enter a formula in a cell. It also displays the content of the cell. If a cell contains any formula, then it will display the formula. But, if a cell contains any text, it will display the text.


3 Solutions to Formula Bar Not Showing Text in Excel

1. Use Review Tab When Formula Bar Not Showing Text in Excel

In the first solution, we will use the Review tab when the excel formula bar is not showing text. This problem can arise when the cells are locked and hidden. The sheets that contain locked and hidden cells are usually protected. To explain the solution, we will use a dataset that contains information about the Department of some employees.

Use Review Tab When Formula Bar Is Not Showing Text in Excel

In our dataset, the formula bar does not show any text if we select any cell of the Department column. Here, we have selected  Cell C7.

Use Review Tab When Formula Bar Is Not Showing Text in Excel

Let’s follow the steps to fix the problem.

STEPS:

  • In the first place, go to the Review tab and select Unprotect Sheet.

Use Review Tab When Formula Bar Is Not Showing Text in Excel

  • After selecting Unprotected Sheet, it will change to Protect Sheet.

Use Review Tab When Formula Bar Is Not Showing Text in Excel

  • After that, select Cell C7.
  • Finally, you will see the formula bar is showing text.

Use Review Tab When Formula Bar Is Not Showing Text in Excel

  • Sometimes, your excel sheet can be protected with a password.
  • In that case, if you click Unprotect Sheet, it will ask for the password.
  • Then, you need to enter the password to unprotect the sheet.

Use Review Tab When Formula Bar Is Not Showing Text in Excel

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


2. Expand the Excel Formula Bar When It Is Not Showing Text

If your cell is not protected, then there can be another reason for this problem. In this case, the formula bar will show only a part of the text or can display nothing. This can happen if we use a line break in the cell. To explain the solution, we will use a dataset that contains the full name of some sellers. But the formula bar is showing only the first name.

Expand the Excel Formula Bar When It is Not Showing Text

Let’s observe the steps below to solve the problem.

STEPS:

  • To display the full name, search for the drop-down icon on the right side of the formula bar.

Expand the Excel Formula Bar When It is Not Showing Text

  • After that, select the drop-down icon.
  • The formula bar will expand.
  • Finally, you will see results like the picture below.

Expand the Excel Formula Bar When It is Not Showing Text

NOTE: You can also expand the formula bar by dragging or pressing Ctrl + Shift + U keys from the keyboard.

Read More: How to Reduce the Size of Formula Bar in Excel (3 Methods)


3. Fix Formula Bar Not Showing Text with ‘Find & Select’ Option

We can use the ‘Find & Select’ option to fix the ‘Excel formula bar not showing text’ problem. We can use this solution if the problem occurs because of the line break. Here, we will use the ‘Find & Select’ option to remove the line breaks so that the formula bar displays the whole text. Again, we will use the previous dataset.

Fix Formula Bar Is Not Showing Text with ‘Find & Select’ Option

Let’s pay attention to the steps below to learn the solution.

STEPS:

  • Firstly, go to the Home tab and select the ‘Find & Select’ option. A drop-down menu will appear.

Fix Formula Bar Is Not Showing Text with ‘Find & Select’ Option

  • Secondly, select Replace from the drop-down menu.

  • After selecting Replace, the Find and Replace window will appear.
  • You can press the Ctrl + H key to get the Find and Replace window.

  • Now, the most important thing, press Ctrl + J in the Find what field.
  • You will not see anything in the Find what field, but it will enter some special character.
  • After that, select the Replace with field and press the Space key.
  • Then, click Replace All.

  • After clicking Replace All, you will see a message like below.
  • Click OK to proceed.

  • Finally, the line breaks will be removed from the sheet and you will see results like below.

Read More: [Fixed!] Formula Bar Is Not Showing in Excel (4 Solutions)


Things to Remember

There are certain things we need to remember when we are trying to fix the ‘Excel formula bar not showing text’ problem.

  • Sometimes, in Method-3, the solution may not work. In that case, you need to close the excel file and re-open it.
  • You need to first understand the reason behind the problem and then, apply the methods.

Conclusion

We demonstrated 3 easy ways to solve the ‘Excel Formula Bar Not Showing Text’ problem. I hope these solutions will help you to perform your tasks perfectly. Furthermore, we have also added the practice book at the beginning of the article. Download it to practice more. Last of all, if you have any queries or suggestions, feel free to ask in the comment section.


Related Articles

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer as well as an electrical and electronics engineer. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo