Formula Bar in Excel

Search
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.

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.

Deselect Cells in Excel

How To Deselect Cells in Excel

Table of Contents How to Deselect Cells in Excel After adding the deselecting cells feature in Excel, this  becomes so  …

Select Non-Contiguous Cells in Excel

Learn how to Select Non-Contiguous Cells in Excel

Table of Contents Select cell without using Ctrl Key By following these simple steps we can do it. At first, …

Format Painter in Excel

How to use Format Painter in Excel

Table of Contents Where’s the Format Painter Button? It’s there on your Home Tab. If you look at the clipboard …

Apply Strikethrough in Excel [Shortcut + Command]

How to apply Strikethrough in Excel [Shortcut + Command]

Table of Contents Shortcut Key to Apply Strikethrough to a Cell Let’s say you’re in hurry and don’t want to …

Formula Bar in Excel

Formula Bar in Excel

Table of Contents Key Points To Consider Using Formula Bar You can hide or unhide the formula bar. You can …

Convert Date into Day

Convert Date into Day Sub date2day() Dim tempCell As Range Selection.Value = Selection.Value For Each tempCell In Selection If IsDate(tempCell) …

Basic VBA Macro Codes in Excel

Custom Header & Footer

Sub CustomHeader() Dim myText As String myText = InputBox(“Enter your text here”, “Enter Text”) With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader …

Get Macro Code

Add Header and Footer Date

Sub DateInHeader() With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader = “&D” .RightHeader = “” .LeftFooter = “” .CenterFooter = “” .RightFooter …

Get Macro Code

Open Calculator

Sub OpenCalculator() Application.ActivateMicrosoftApp Index:=0 End Sub In Windows, there is a specific calculator and by using this macro code you …

Get Macro Code

Unmerge Cells

Sub UnmergeCells() Selection.UnMerge End Sub Unmerge Cells code simply uses the unmerge options which you have on the HOME‌ tab. …

Get Macro Code

Remove Text Wrap

Sub RemoveTextWrap() Range(“A1”).WrapText = False End Sub This code will help you to remove text wrap from the entire worksheet …

Get Macro Code

Auto Fit Rows

Sub AutoFitRows() Cells.Select Cells.EntireRow.AutoFit End Sub You can use this code to auto-fit all the rows in a worksheet. When …

Get Macro Code

Auto Fit Columns

Sub AutoFitColumns() Cells.Select Cells.EntireColumn.AutoFit End Sub Use above Excel macro code to auto fit rows in all your sheet at …

Get Macro Code

Insert Multiple Columns

Sub InsertMultipleColumns() Dim i As Integer Dim j As Integer ActiveCell.EntireColumn.Select On Error GoTo Last i = InputBox(“Enter number of …

Get Macro Code

Insert Multiple Rows

Sub InsertMultipleRows() Dim i As Integer Dim j As Integer ActiveCell.EntireRow.Select On Error GoTo Last i = InputBox(“Enter number of …

Get Macro Code