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.
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
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 > 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.
Let’s play a game today! Open your excel sheet and I will ask you to do some tasks, If you do it, you’ll get a point else I’ll get one. OK ready with your excel ? 😛
1.) Type your first name in any cell
I guess this was ridiculously simple. Ok you got me here, here is the score!
- Me- 0
- You -1
2.) In the same cell type your last name after your first name. Hey Hey Hey.. but
- You cannot retype the first name (you have to start writing after your first name)
- You cannot use the mouse at all and remember the track pad on your laptop is also a mouse 😛
How about now Rocky? Were you able to do it? If you were, then here is a point for you
- Me- 0
- You – 2
3. Take the sum of the 2 left over numbers** on the sheet, hey but
** just like this
- You cannot type (or edit) the cell addresses or the formula
- You cannot refer to the cell address with the mouse, you have to use the keyboard arrow keys
- And you cannot rewrite the whole formula, you just have to add the rest of the formula in the end
So if you were able to do it, I must say you are a James bond at keeping an eye on details. You win and I lose!
- Me – 0
- You – 3
But, here is my point !
There are 5 types of cell modes that largely go unnoticed and a few causing minor irritation while writing formulas!
1. Ready Mode –
The standard mode any cell in on the sheet, essentially means that excel is now ready to accept your data. Take a notice whenever you build some heavy duty formula and it takes a while to execute, the ready mode disappears
2. Edit Mode
Ok so if you want to edit the contents of the cell, you press F2 key to go to the edit mode and then edit it
3. Enter Mode
When you start writing in the cell without pressing F2, excel overwrites the contents and starts entering the data or the formula in the Enter Mode
EDIT Mode v/s ENTER Mode – Often the source of problem
- You would not be able to link the cells (with keyboard) in a formula in the EDIT Mode. The EDIT Mode is meant to just edit the contents of the cell
- While in Enter Mode you can link cells (with keyboard) and also add fresh data but you would not be able to Edit the contents (with keyboard again) of the cell
- You can toggle between the Enter and Edit mode with the F2 Key, now I find that pretty cool !!
4. Point Mode
While entering a formula in the Enter Mode, when you take the ‘moving dots’ selection to any other cell, the mode changes to POINT Mode
5. Copy and Paste Mode
When you select any cell or a set of cells and use the copy command, the mode changes to “Select destination and press ENTER or choose to PASTE” – I call it the copy and paste mode 😎