There is nothing worse than those the little annoying problems that pop up just when we have an important job to do. Probably one of the worst of them is the missing formula bar. When it is gone, we can not see or write any formulas.
Most often we have no idea how it happened, but fortunately, it can be quickly restored. There are two ways doing it. Let's start.
From Ribbon (quicker)
-
Go to View ribbon and click Formula bar checkbox.
On smaller screens, in View ribbon you have to click Show first.
From Excel options
-
On the ribbon click File tab
Click to enlarge -
On the left bottom, click Options
Click to enlarge -
In Excel Options go to Advanced options. There in Display section is a Show formula bar checkbox. Check it to show the bar.
Click to enlarge
Excellent. Many thanks.
The best and easy solution I have ever had.
God Bless you all.