Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.


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 the full feature 30-day free trail of Kutools for Excel now!


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.


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.

Before applying the below operation, please go to download and install Kutools for Excel firstly.

1. Enable this feature by clicking Kutools > 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.


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

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!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Andy · 1 years ago
    Great. Any way to set it up in VGA so that I can select a column or large column of data and just run it? - entering and exiting the cells until complete? Random request but I've been sent a data source and excel isn't detecting the dates in the cells until you have been in and out of the cell. I am a newbie, so any help is appreciated.
  • To post as a guest, your comment is unpublished.
    Genaro · 1 years ago
    This is very helpful! Is there a way to apply the sendkeys F2 to only 1 cell in the worksheet? I don't need every cell that I click to go into edit mode, I only need one to do it.
  • To post as a guest, your comment is unpublished.
    Rene · 1 years ago
    2 thumbs up