Table of Contents
Key Points To Consider Using Formula Bar
- You can hide or unhide the formula bar.
- You can change its height , but you can’t change its position.
What is the Excel Formula Bar?
Excel Formula Bar is a thin bar below ribbon that displays the selected cell’s content and displays the cell address of the selected cell on the left side. Alternatively, you can enter a value into the cell from the formula bar. It has three buttons (Enter, Cancel, and Insert Function).
- Name Box
- Horizontal Expand
- Input bar
- Vertical Expand
How to Show Formula Bar (or Hide it)
The formula bar is active by default but if it is hidden, you can activate it by going directly from the view tab.
- Firstly, go to the view tab, and from the show group and tick mark formula bar.
- Apart from this, you can also activate it from the Excel options.
- Go to the Excel options ➜ Advanced ➜ Display ➜ Show formula bar.
Same steps can be used if you want to hide it.
How to Expand Formula Bar
If by default, the formula bar is thin, then you can expand it and make it a little wide. When you move your cursor on the bottom of the formula bar, it converts into a vertical double-ended arrow, and then you can pull it down to expand it.
Also, there is a shortcut key (Control + Shift + U) that you can use to expand the formula bar vertically. You can also use drop-down icon from the right side.
And if you want to change its width you can do it by hovering your cursor on three dots between the name box and formula bar and then stretch it to the right or left.
How to Enter Data from the Formula Bar
You can enter data into a cell using the formula bar and for this, you need to select the cell and click on input bar in formula bar.
And once you are done with the value that you want to enter; you can click on enter button that is on the left side of the formula bar.
There is also a button to cancel the data entry or else you can press the escape key.
How to Enter Function using Formula Bar
There is an insert function button on the formula bar, and when you click on this button, there comes a dialogue box from where you can find and insert the function.
Once you select function you want to insert, click OK, and it will show you a dialog box to define the function’s arguments.
How to use Use Name Box
On the right side of the formula bar, you have a name box that shows the cell address for the selected cell. But you can also use this name box to navigate. You are a specific cell or a range. When you click on the name box, it allows you to edit it, and you can enter a cell address, and once you do that and hit enter, it will navigate you to that cell.
In the same way, you can also enter a range’s address to select it.
How To Edit Shapes From Formula Bar
If you want to connect a shape with a cell, you can do that by editing it from the formula bar.
- Select the shape that you have in the worksheet.
- Click on the formula bar to edit it.
- Enter “=” and select the cell that you want to connect with the shape.
- In the end, click, OK.