## 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 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

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

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

The Excel Preferences dialog box will appear.

**Click** on **Edit** to select it.

The Edit dialog box will appear.

Remove the check mark from **Edit directly in cells**.

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

Select the formula bar.

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

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

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

### Comments

Please send us your comments on this article.