Edit Cell Shortcut

This tutorial will take you step-by-step through everything you need to know to use the Edit Cell Shortcut in Excel.

If you are using Excel keyboard shortcuts to save your time, this article is yours. Editing cell is a basic operation in Excel. Today, we will discover and show you the best methods to edit cells using keyboard shortcuts.

Basics of Editing Cells in Excel

Why do you need to edit cells in Excel? In practice, if you are editing cells, you can change or fix a formula or function and modify a text or number value in a cell. Sometimes, you want to trace the formula. In addition, editing cell is useful to find errors in your expression.

In the example, you have the data set below:

edit cell shortcut data example

Because you want to calculate the profit for each month, you use a simple formula to get the profit in cell F3.

To edit the formula in cell F3, you need to select the cell first.

The next two examples will show you how to do that!

Edit cell using the Formula Bar

Take a closer look at the picture below:

Edit cell using the Formula Bar

The Formula Bar shows the formula if the selected cell contains a function.

Click on the Formula Bar.

Click on the Formula Bar.

You are in cell editing mode if

  • A blinking cursor appears.
  • The formula name does not appear in the selected cell.

As we mentioned above, using this method, you can edit any cells or formulas on the Formula Bar in Excel.

Double click on the cell

Using the formula bar to edit a cell is great, but you can choose another way to do that.

Select the cell before editing and double-click on it. Now, you are in the cell edit mode, and the blinking cursor appears.

double clicking on cell edit

Use the Edit Cell Shortcut Key

How to use the Edit cell shortcut in Excel?

Press F2 on Windows and use Ctrl + U on Mac Excel.

By pressing these shortcut keys, you can quickly enter into cell editing mode.

Windows Shortcut

F2

Mac Shortcut

Ctrl U

In the example, you want to edit cell F4. First, select the cell, then press the F2 shortcut key.

excel edit cell shortcut F2

Using a shortcut is a faster way than using the formula bar. In this case, Excel shows a blinking cursor in the editable cell.

Troubleshooting when the Edit cell Shortcut is not working

In the example, you want to modify the cell content using the edit cell shortcut and pressing F2. Nothing happens!

Instead of entering the Editing cell mode, the cursor jumps to another cell. What’s the problem, and how to fix it?

This guide will help you in case of the editing mode does not work in Excel. Follow these steps to enable the cell edit mode.

1. Go to the File Tab, and click Options

Go to the File Tab and click Options

2. On the left pane, select “Advanced.” Now locate the Editing Options Group.

On the left pane  select Advanced

3. Make sure that the ‘Allow editing directly in cells’ checkbox is enabled.

Make sure that the Allow editing directly in cells checkbox is enabled.

From now on, the edit cell shortcut will work again by pressing F2. If you want to learn more about why your shortcut not works, check the article. Stay tuned.

Additional resources:

Istvan Vozar

Istvan is the co-founder of Excelkid. He writes blog posts and helps people to reach the top in Excel.