I found where several folks had this issue but no fixes and plenty of people did not know what the person complaining was talking about.

But if you are a novice in Microsoft Excel, you might want to learn the basics first, and one of the essentials is the Formula Bar.

You can use it to enter a new formula or copy an existing one.

If the formula bar is missing in your Excel, most likely its because youve accidentally turned off the Formula Bar option on the ribbon.

And you can do this by unchecking the Formula bar option in the Excel Options dialog, as demonstrated above, or on the ribbon ( View tab Show group).

To restore the default formula bar size, press this shortcut again.

In the next article, we are going to talk about more serious things such as evaluating and debugging Excel formulas.

I thank you for reading and hope to see you on our blog next week.

However I am having a problem with the formula bar because the font is boxy and almost too small to read.

Is there a way to modify the font in the formula bar Thank you very much for your assistance.

However, if you open an existing Excel workbook that was created and saved in normal size, only the font of the formula bar will change.

Maybe now I will be able to see when I duplicate the minus sign by mistake You are very helpful.

Even if i give normal view also that window for Workspace is not regained.

Once after a new blank workbook is created it will come but either the row numbers will disappear or the window will open with some grid lines.

It has something to do with Formula Bar and is INFURIATING because a simple spreadsheet CANNOT be writen.

It should filter hugh amount of data and it works, but I need to display in formula bar in final (filtered sheet) original text from source sheet instead of link sourceF22.

I tried to use F9 and it shows me text as I wanted, but when I made a change in source sheet, that change has not been transfered in to the filtered sheet, because F9 replace permanently link by text.

In the formula bar in some but not all of my excel files, the box that shows cell contents (and allows editing thereof) has disappeared.

How do I get the missing box to reappear on the formula bar How did I make it disappear.

Disappears after a few minutes of work.

Excel 2013. Tried the Control-Shift-U, it has an impact - the amount of white space increases or decreases - but theres no formula bar.

I save and close the file after enabling the Formula Bar, but upon reopening its always turned off again.

Any ideas.

Ended up the right most box had somehow become extended all the way to the right and off the screen.

To recover it you have to down size your excel and stretch it off the screen and slide the excel window to the right until you find the edge.

Excel For Mac Formula Bar Odd Format