How to Edit a Cell in Excel (4 Easy Methods)

Editing a cell is one of the most fundamental tasks in Excel. Indeed, we need to edit a cell to correct or update any inaccurate information every now and then. This article provides you with 4 quick and convenient guides on how to edit a cell in Excel.

4 Methods to Edit a Cell in Excel 

Excel offers numerous methods to edit a cell, here are 4 such methods. So let’s explore them one by one.

Throughout this article, we’ll use the dataset (in B4:D14 cells) below. The dataset depicts the names of the Sales Reps, the Product they sold, and lastly the Sales amount.

Dataset 1

1. Double Click to Edit a Cell 

The first method is the most popular way to edit a cell simply by double-clicking it. To edit a cell using the first method, you may follow the below steps.


  • Firstly, select any cell. For example, I have chosen the D9 cell and double-clicked it.
  • Now, a cursor appears and blinks on this cell. This indicates that you can edit this cell.

How to Edit a Cell in Excel Using Double Click

  • Next, press ENTER to confirm the change and move on to the next cell.

How to Edit a Cell in Excel Using Double Click

Read More: How to Edit Cell with Single Click in Excel

2. Edit the Active Cell Utilizing Keyboard Shortcuts

Now, I know what you’re thinking. Are there any shortcut keys? Lucky you! There are shortcut keys for both Windows and Mac users. And our next method describes just that.


  • To start, choose a cell. We’ve shown the D14 cell as an example.
  • Secondly, instead of double-clicking on the cell, press the F2 key if you’re a Windows user. And the cursor pops up just like before. For Mac users, the keyboard shortcut is ^ U.

How to Edit a Cell in Excel Using Keyboard Shortcut

  • Now, you can change the value of the cell.
  • Lastly, press ENTER to keep the change.

How to Edit a Cell in Excel Using Keyboard Shortcut

Read More: How to Edit Cell in Excel with Keyboard 

3. Using the Formula Bar

So, editing inside a cell can become tricky, especially with long pieces of text or functions. You need not worry since Excel’s Formula Bar is the answer. Let’s see it in action.


  • Similar to the prior methods, first select a cell. In this case, I have shown the D8 cell.
  • Secondly, start typing in the box located just above the spreadsheet, as shown in the picture below.

How to Edit a Cell in Excel Using Formula Bar

  • Finally, after completing your typing, click the green checkmark on the left to commit to the change.

Using Formula Bar

Read More: How to Edit a Cell in Excel without Double Clicking 

4. Edit a Cell with VBA Code

You might be wondering, is there a way to automate this task? Then VBA has you covered. Just follow along.

Step 01: Open the VBA Editor

  • To begin, go to the Developer tab and then to Visual Basic.

Using VBA Code

Step 02: Insert the VBA Code

  • Secondly, double-click on the sheet where you want to insert the VBA code.

Using VBA Code

  • For your ease of reference, you can copy the code from here and paste it into the window as shown below.

How to Edit a Cell in Excel Using VBA Code

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
'This code helps you to edit cell' 
SendKeys "{F2}" 
End Sub

Step 03: Run the Code

  • Thirdly, navigate to Run and click it, or you can use the keyboard shortcut F5 to run.

How to Edit a Cell in Excel Using VBA Code

  • Finally, return to your worksheet. Selecting any cell will enter into editing mode.

How to Edit a Cell in Excel Using VBA Code

Read More: How to Edit Macros in Excel

Issues When You Can’t Edit Cell

Have you ever faced a situation where you cannot edit any of the cells and you are not sure how to fix it? Well, you’ve come to the right place. There are numerous ways you can enable editing on your worksheet, and they are described below.

1. When Worksheet Is in Read Only Mode

  • When you download a file from the internet, Excel by default opens the spreadsheet in Read-Only mode, which restricts any editing. To edit the file, simply press the Enable Editing icon.

How to Edit a Cell in When Read Only Mode is Activated

  • Once pressed, you can edit any cell in the worksheet.

When Read Only Mode is Activated

Read More: How to Enable Editing in Excel Protected View

2. If Excel Spreadsheet Is Locked

A second reason for not being able to edit your worksheet could be the fact that it is locked. If a worksheet is locked, then trying to edit it prompts the following message.

When Worksheet is Locked


  • First, navigate to the Review tab and click Unprotect Sheet.

When Worksheet is Locked

  • Next, type in the password and press OK.

How to Edit a Cell in When Worksheet is Locked

  • Eventually, this should re-enable the editing option.

How to Edit a Cell in When Worksheet is Locked

Read More: How to Unlock Excel Sheet for Editing

3. Whenever Editing Is Disabled for the Worksheet

Sometimes you may be restrained from directly editing the worksheet because it has been disabled. You re-enable the editing option by following these steps.


  • Firstly, navigate to the File tab located at the top left corner.

When Editing is Disabled

  • Secondly, click the Options tab to open a new window.

When Editing is Disabled

  • Thirdly, press the Advanced tab and check the Allow editing directly in the cells box. Confirm the change by clicking OK.

How to Edit a Cell in When Editing is Disabled

Read More: Cannot Edit Excel File in Protected View 

Download Practice Workbook


To summarize, this article describes the process of editing a cell in Excel. Make sure to download the practice files and do it yourself. Please inform us in the comment section if you have any queries. We, the Exceldemy team, are happy to answer your queries.

Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF