Where is formula bar in excel. Full feature free trial 30 day no credit card required. To expand the formula bar horizontally move the mouse cursor to the area between the name box and the the formula bar until the cursor turns into a horizontal double ended arrowleft click and drag to adjust the horizontal size. If you have kutools for excel installed its work area utility can help you quickly hide status bar formula bar or ribbon easily in excel and also enables you to restore the default excel view immediately.
The formula bar has two parts. Click the kutools work area it will. How to hide formula bar in excel.
Things to remember about formula bar in excel. To expand the formula bar vertically move the mouse cursor to the bottom. Full feature free trial 30 day no credit card required.
The formula bar in excel sits directly above the worksheet area to the right of the name boxthe formula bar can be used to edit the content of any cell and can be expanded to show multiple lines for the same formula example shortcut for togglingfor an example of editing a long formula in an expanded formula bar watch this video. Better to use formula bar for editing an applied formula. Kutools for excels formulas hide utility can help you to hide formulas from formula bar with only several clicks.
Next click on excel options and move to the advanced tab. To maximize workspace in your worksheet we may want to hide. Since the formula bar is always pointing to the active cell while applying the formula you should ensure the active cell is correct.
At the left is the name box and to the right is the contents of the currently selected cell. Select the cells whose formulas you want to hide from formula bar. Kutools for excel includes more than 300 handy tools for excel.
This manipulation can also be performed via the view menu. The two pictures below are examples of what the formula bar looks like in microsoft excel. Alternatively referred to as a formula box the formula bar is a section in microsoft excel and other spreadsheet applications.
Scroll to the display section. Click advanced in the left pane. Display or hide the formula bar in excel open your spreadsheet and click on the file menu.
Kutools for excel includes more than 300 handy tools for excel. Scroll down to the display section and select the show formula bar option. It shows the contents of the current cell and allows you to create and view formulas.
Uncheck the box labeled show formula bar and click ok. An alternative way to restore a lost formula bar in excel is this. This will help you to manage the long formulas or data easily.
The formula bar can be expanded either vertically or horizontally depending on your needs.