Formula Bar in Excel

Generic filters

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
  • Buttons
  • 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.

  1. Firstly, go to the view tab, and from the show group and tick mark formula bar.
  2. Apart from this, you can also activate it from the Excel options.
  3. 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.

  1. Select the shape that you have in the worksheet.
  2. Click on the formula bar to edit it.
  3. Enter “=” and select the cell that you want to connect with the shape.
  4. In the end, click, OK.

Free Excel Templates


Shift Planner with Tracker

Shift Planner with Tracker for Excel is a powerful spreadsheet …

Download Now
billing-invoice template

Billing Invoice Template

The new billing invoice template provides a very simple and …

Download Now

Training Attendance Sheet

Whether you’re organizing any training program for an athletic event. …

Download Now

Multiplication Chart 1-100

Trying to help my son learning multiplication, I tried to …

Download Now

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.