How do I get the formula bar back in Excel?
Unhide formula bar via Excel Options
- Click File (or the Office button in earlier Excel versions).
- Go to Options.
- Click Advanced in the left pane.
- Scroll down to the Display section and select the Show Formula bar option.
Why is Excel not showing formula bar?
If the formula bar is missing in the Excel spreadsheet, click on View tab, then find the group Show and select the Formula Bar option. The formula bar appears and you can see all the functions and formulas in cells.
How do you show the formulas on Excel?
Show Formulas
- To display all formulas, in all cells, press CTRL + ` (you can find this key above the tab key).
- Press ↓ twice.
- Note: as you can see, Excel highlights all cells that are referenced by a formula. To hide all formulas, press CTRL + ` again.
- Note: to hide all formulas, click Show Formulas again.
Where do I find the formula bar in Excel?
We can display or hide the Formula Bar under View tab in Excel Ribbon with Formula Bar option in the Show group. If you want to show the Formula Bar, check the Formula Bar option; if you want to hide the Formula Bar, uncheck it.
How to enable or disable the formula bar in Excel?
1 Click on the View menu. 2 Tick or untick the rectangle box given to enable or disable the formula bar. 3 According to your selection, the visibility will be set.
Why is the formula bar missing in Excel?
Excel formula bar missing – how to show and hide formula bar in Excel. Formula bar is very helpful for reviewing and editing formulas in your worksheets. If the formula bar is missing in your Excel, most likely it’s because you’ve accidentally turned off the Formula Bar option on the ribbon.
Is there way to unhide formula bar in Excel?
Show formula bar in Excel 2016, Excel 2013 and Excel 2010. In the modern versions of Excel, you can unhide formula bar by going to the View tab > Show group and selecting the Formula Bar option.