How to type in or edit cell without double clicking it in Excel?
Usually, when editing a cell with content, you need to double click it to get into the editing mode at first. For editing a cell with long content that exceeds the cell size, you need to get into the editing mode, and then find the accurate position to make the change. This tutorial introduces three methods, which can help to edit cell easily in Excel.
Method B: Type in or edit cell with VBA code
Method C: Edit a long content cell easily with an awesome feature
Type in or edit cell with pressing the F2 key
You can press the F2 key to get into the editing mode of a cell without double clicking it.
It is easy to operate, you just need to select the cell you want to edit and press the F2 key, and the cursor will be located at the end of the cell value, then you can edit the cell immediately.
Note: You need to press the F2 key repeatedly for editing all cells in a list.
View and edit a long content cell easily in Excel:
The Enhanced Edit Bar utility of Kutools for Excel can help you easily view and edit a long content cell without double clicking the cell or enlarging the Formula Bar.
Download and try it now! (30-day free trail)
Type in or edit cell with VBA code
If pressing F2 key is also time-consuming for you, you can try the following VBA method.
1. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.
2. In the Microsoft Visual Basic for Applications window, please double click the sheet name (cells you need to edit locating in this worksheet) in the left bar to open the code window. Then copy and paste the below VBA code into the window.
VBA code: type in or edit cell without double clicking it
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Update by Extendoffice 20190809
SendKeys "{F2}"
End Sub
3. Press Alt + Q keys simultaneously to close the Microsoft Visual Basic for Applications window.
From now on, when selecting a cell or pressing the Enter key to move to the next cell in this worksheet, it will get into the editing mode automatically.
Edit a long content cell easily with an awesome feature
Here we introduce the Enhanced Edit Bar feature of Kutools for Excel. With this feature, you can edit a cell with long content easily without double clicking the cell.
1. Enable this feature by clicking Kutools > Show & Hide > Enhanced Edit Bar.
From now on, when selecting a cell, a window will pop up to display the whole content of it.
Directly editing the content in the window will simultaneously take effect to the cell.
Tip: Click Kutools > Enhanced Edit Bar to turn off the feature.
If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite ā Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license ā set up in minutes (MSI-ready)
- Works better together ā streamlined productivity across Office apps
- 30-day full-featured trial ā no registration, no credit card
- Best value ā save vs buying individual add-in