Excel Hack

Excel formula bar shortcut

Many of you may use the formula bar when creating or editing formulas in Excel. You can also use the shortcut keys to operate the formula bar. We will show you how to use shortcut keys to jump the cursor to the formula bar in Windows and Mac, and how to make the formula bar wider. Try using this method when you are creating or editing long formulas.

Formula bar shortcut

Jump the cursor to the formula bar

Windows
F2

Mac
control + U

Make the formula bar wider

Windows
Ctrl+ Shift + U

Mac
control + shift + U

Jump the cursor to the formula bar

To move the cursor from the selected cell to the formula bar by shortcut key, you must first set Excel's options to disallow direct editing of cells.

Total Time: 1 minute

Open the file and press the access key

Open a file

Open the file that you want to set up so that the cursor moves from the selected cell to the formula bar, and press Alt + F + T.

Set to not type directly into cells

Configure the options

The Excel Options dialog box will appear. Use (Down Arrow key) to select Advanced. Use Tab to select Allow editing directly in cells and use Space to remove the check mark. Press Enter.

The cursor has moved to the formula bar

Use the shortcut key to make the cursor jump to the formula bar

Go back to the file and select the cell that contains the formula or a blank cell. Press F2 to jump the cursor to the formula bar.

Move the cursor to the formula bar on Mac

Even on a Mac, to move the cursor from the selected cell to the formula bar using shortcut keys, you must first set the preferences to prevent direct editing of the cell.

Open a file

Open the file that you want to set up so that the cursor moves from the selected cell to the formula bar, and press command + , (comma).

Select Edit

The Excel Preferences dialog box will appear.

Click on Edit to select it.

Configure the options

The Edit dialog box will appear.

Remove the check mark from Edit directly in cells.

Use the shortcut key to make the cursor jump to the formula bar

Go back to the file and select the cell that contains the formula or a blank cell.

Press control + U to jump the cursor to the formula bar.

Use the shortcut keys to make the formula bar wider

Use shortcut keys

Select the formula bar.

You can also select a cell with a formula or a blank cell.

The formula bar gets wider

Press Ctrl + Shift + U to make the formula bar wider.

Use shortcut keys

Press Ctrl + Shift + U again to narrow the formula bar.