How to Edit Cell with Single Click in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

When we need to change something in a cell, we usually have to edit it. Therefore, it would be hassle-free if we could edit a cell with just one click on the cell. If you are in search of such a thing, certainly this article would be beneficial to you. Here, we will take you through 3 easy and convenient methods on how to edit a cell with a single click in Excel.


Excel Single Click to Edit Cell: 3 Methods

In Excel, you can edit individual cells one at a time. If you single-click on a cell, the existing value will be overwritten at the time of typing. You might have faced this thing. So, normally we use double-clicking on a cell to do in-cell editing. But we can do this kind of work by clicking one time on that cell.

We’ve got a dataset of Attendance Lists of random students’ of a class. The cells in the 2nd column containing their Name have different types of typing errors.

How to Edit Cell with Single Click in Excel

So, we’ve to edit those cells. Here, we’ll show a handful of different methods of editing cells with a single click in Excel. So let’s go through them one by one.


1. Clicking on Formula Bar after Selecting Cell

You can edit cells in Excel using the Formula Bar. For performing this method, you should go through the procedures below.

Steps:

  • At the very beginning, click on the preferred cell that you want to edit. Then place your cursor on the Formula Bar and click the left button of the mouse once. You can see a blinking straight line appearing on the formula bar just at the end of your previous input for that cell.

How to Edit Cell with Single Click Using Formula Bar in Excel

  • Now you can move this blinking line with the help of your mouse or press the arrow keys on your keyboard and edit the data as per your requirement. After finishing the edit, press ENTER which will take the selection pane to the next cell down.

How to Edit Cell with Single Click Using Formula Bar in Excel

  • Correspondingly, edit the other cells down in a similar way.

How to Edit Cell with Single Click in Excel


2. Using Keyboard Shortcut to Edit Cells with a Single Click in Excel

Another way of editing a cell with a single click is to use a keyboard shortcut. Pay attention to the process stated below.

Steps:

  • In the beginning, place your cursor on the cell to be edited and single-click on the cell. This action makes the cell selected. Then, press the F2 key and you will see the blinking straight line just at the end of your previous input in that cell. This means you can edit anything inside this cell.

How to Edit Cell with Single Click Using Keyboard Shortcut in Excel

The difference with the previous method is that here the blinking line appears in the cell, not in the Formula Bar.

Note: On Mac, use Ctrl + U to do the same task.

Read More: How to Edit Cell in Excel with Keyboard


3. Applying VBA Code

A distinct method of doing the same task is to apply the VBA code. The process is as follows.

Steps:

  • Click on the Sheet name and select View Code.

How to Edit Cell with Single Click Applying VBA Code in Excel

  • From the ribbon, click on the Insert tab and select Module.

How to Edit Cell with Single Click Applying VBA Code in Excel

  • Right away, a window appears on the right. Now, copy the following code and paste it into the window.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
     SendKeys "{F2}"
End Sub How to Edit Cell with Single Click Applying VBA Code in Excel

Worksheet_SelectionChange(ByVal Target As Range) is an event. From the name, we can easily understand that this event is triggered when we change the selection. In other words, if you move your cursor from Cell C5 to another cell, the code in this subroutine will run. Sendkeys “{F2}” means after every change of selection, the system will automatically press the F2 key once.

  • Lastly, select Run from the top ribbon. Then close the window and return to your VBA worksheet. With just a single click on a cell, you can see that the cell becomes editable immediately.

How to Edit Cell with Single Click Applying VBA Code in Excel


Why You Cannot Edit Cell in Excel

Usually, when we download an Excel file, it opens in PROTECTED VIEW. Therefore, you won’t be able to edit any of the cells in Excel. Because the Excel has been saved as read-only. To solve this problem, press the Enable Editing button on the right top of the Excel worksheet.

How to Edit Cell with Single Click in Excel

After that, you will be able to edit any cell in this workbook.


Editing in Formula Bar Directly

In our 2nd method, we selected our cell first and then pressed the F2 button to edit the cell. Then a blinking straight line appeared in the cell. But we can change this phenomenon manually just by changing some options. We can make the blinking line appear in the formula bar directly after pressing the F2 key. Please follow us to do this.

Steps:

  • Go to the File tab from the ribbon.

Editing in Formula Bar Directly

  • From the File tab, select Options.

Exploring File tab

  • Instantly, a window named Excel Options opens. Now select Advanced > clear the Allow editing directly in cells check box > click OK.

Using Excel Options to Edit Cells

  • At this point, if you select any cell and press the F2 key, you will see the blinking line directly inside the Formula Bar, not in the cell.

Editing in formula bar Directly


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice yourself.


Conclusion

Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section.


Related Article


<< Go Back to Edit Cell | Excel Cells | Learn Excel



<< Go Back to Edit Cell | Excel Cells | Learn Excel


<< Go Back to Edit Cell | Excel Cells | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shahriar Abrar Rafid
Shahriar Abrar Rafid

Shahriar Abrar Rafid, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked with the ExcelDemy project for more than 1 year. He has written over 100+ articles for ExcelDemy. He is a professional visual content developer adept at crafting scripts, meticulously editing Excel files, and delivering insightful video tutorials for YouTube channels. His work and learning interests vary from Microsoft Office Suites and Excel to Data Analysis, VBA, and Video recording and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo