Question: how to make a formula bar in excel?
Answer: Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. ... 
At the left side of the dialog box click Advanced.
Scroll down until you see the Display options. ... 
Click on the Show Formula Bar check box. ... 
Click on OK.