There are thousands of cells in an Excel sheet. Every time we need to edit those cells because there is data, values, formulas and so on in a cell and we need to edit them from time to time for our requirements. We can easily edit those cells by knowing how to edit cells in Excel with a keyboard. In this article, we shall discuss the methods of **how to edit a cell** in Excel with the keyboard.

**Table of Contents**hide

## Download Practice Workbook

## 4 Methods to Edit Cell in Excel with Keyboard

We can edit a cell in Excel by using a keyboard with the usage of different keys. To understand the keyboard shortcuts usage, we have prepared a dataset of the **Distance of Main Distribution Boards(MDB)** from the **Substation **of a company. The dataset is like this.

Weâ€™ll now see different usage of keyboard shortcuts based on this dataset.

**1. Using F2 Key to Edit Cell in ExcelÂ **

To edit a cell we first need to select the cell like this.

- Secondly, we can enter the edit mode by pressing the
**F2**key like this.

Here, we need to convert the value from **inch **to **millimeter**. But the value here is converted from **meter** to **mile**.

- As we have selected the cell, now we need to place the cursor with one click on the right side of
**m**which is the**meter**.

- After that, we need to erase
**m**by pressing**Backspace**and need to write**in**which means**inch**.

- Then, we should move to the right side of
**mi**by pressing the right arrow key (**>**) and follow the same step to erase**mi**and put**mm.**

- Finally, we should press
**ENTER**. By doing this, the value is converted from**inch**to**mm**. - And using the
**Fill Handle**, we can convert all of the values from**D7**to**D12**.

**Read More: ****How to Edit a Cell in Excel without Double Clicking (3 Easy Ways)**

**2. Using Different Combinations of CTRL, SHIFT, and Arrows to Edit Cell with Keyboard**

We can edit inside a cell by using different combinations of** CTRL**, **SHIFT,** and **Arrows**. We can use **SHIFT+Arrows**, **CTRL+Arrows**,** CTRL+SHIFT+Arrows** for different purposes to edit inside a cell.

__Select One Character Right or Left__

Firstly, we can use the **SHIFT** and **Arrows** keys when we need to select a character inside a cell. We can do this following the below steps.

- In the picture below, if we need to select one character right of the
**B6**cell, we first need to put the cursor on the left of**MDB-One**with one click.

- Secondly, we need to press
**SHIFT**, hold it, and press**Right Arrow(>)**i.e.Â**SHIFT+Right Arrow (>)**.

- Now we can edit the selected character by putting anything here.
- Similarly, for selecting one character left, we need to press
**SHIFT + Left Arrow (<)**in the same way.

__Move One Word Right or Left__

We can use the **CTRL** and Arrows combination when we need to move a one-word character inside a cell. We can do this following the below steps.

- In the picture below, if we need to select one word right of the
**B6**cell, we first need to put the cursor on the left of**One**in the**MDB-One**words with one click.

- Secondly, we need to press
**CTRL**, hold it, and press**Right Arrow (>)**e.**CTRL+ Right Arrow (>)**.

- We can see that the cursor has moved to the right 1 word and placed it on the right side of
- Similarly, for moving one word left, we need to press
**CTRL + Left Arrow (<)**in the same way.

__Selecting One Word Right or Left__

- In the picture below, if we need to select one word right of the
**B6**cell, we first need to put the cursor on the left of**MDB-One**with one click.

- Then, we need to press
**CTRL**, hold it, press**SHIFT**, hold it and press**Right Arrow (>)**e.**CTRL + SHIFT + Right Arrow (>)**.

- Now we can edit the selected word by putting anything here.
- Similarly, for selecting one character left, we need to press
**CTRL + SHIFT + Left Arrow (<)**in the same way.

**Read More: ****How to Edit Header in Excel (6 Easy Methods)**

**Similar Readings**

**[Fix:] Edit Links in Excel Not Working****How to Edit Hyperlink in Excel (5 Quick & Easy Ways)****Edit a Pivot Table in Excel (5 Methods)****How to Edit Defined Names in Excel (Step-by-Step Guideline)****Edit Named Range in Excel**

**3. Editing a Cell Using Formula Bar with Keyboard **

If we want to edit a cell directly using **Formula Bar** we need to undo allowing editing directly in cells.

- For this first, we need to press
**ALT + F**to open the**File Menu.**Then we should press**T**. - As a result, a page will come like this.

- Then we need to select the
**Advanced.**

- After that, we need to undo the Allow
**Editing Directly in Cells.**

- As a result of this, if we want to edit a cell we need to just click on the cell, we need to just press
**F2**and Â We will see that the cursor is now directly in the**Formula Bar**. That means we can edit directly from**Formula Bar.**

**Read More: ****How to Edit Cell with Single Click in Excel (3 Easy Methods)**

**4. Applying Escape Button to Cancel Entry **

If we want to cancel the entry of a cell we just need to press the **Esc** key.

- Here we have first selected the cell which we want to edit. And have pressed
**F2**to go into edit mode.

- And now we donâ€™t want any new entries in the cell. For this, we have pressed the
**Esc**The cell has returned to its initial state, which means the new entry is canceled.

**Read More: ****How to Edit Footer in Excel (3 Quick Methods)**

## Things to Remember

Probably, you might have faced the following issues.

- The Excel file is in Read-Only mode.
- The Excel worksheet is locked.
- Editing in a cell is disabled in Excel.

These are the issues for which you canâ€™t edit a cell in Excel. So, make sure that you have fixed these issues before editing a cell with the keyboard.

## Conclusion

When we want to edit a cell, it becomes easier if we use keyboard shortcuts. By using keyboard shortcuts our editing tasks need less time and attention.

## Related Articles

**Edit a Macro Button in Excel (5 Easy Methods)****How to See History of Edit in Excel (With Easy Steps)****Enable Editing in Excel Protected View (5 Methods)****How to Edit Drop Down List in Excel Macro (4 Easy Methods)****Edit Chart Data in Excel (5 Suitable Examples)****How to Unlock Excel Sheet for Editing (With Quick Steps)****Cannot Edit Excel File in Protected View (3 Reasons with Solutions)**