Shortcut to edit a cell without using F2 keySolved/Closed

Question

Hello, 

I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard.
Normally to edit a cell, I would select the cell and hit F2, but the Logitech Bluetooth keyboard reserves F1-F3 for pairing different devices to the one keyboard (sounds neat!).
Anybody know of a shortcut to edit a cell that does not involve the F2 key?
thanks so much for any help!

System Configuration: Windows / Internet Explorer 11.0

kieferschild · Answer

Double click the cell......

BenFromSingapore · Answer

Thanks TrowaD, that is indeed an option.
But probably this is a better option for inputting data into a cell, rather than for editing data already contained in a cell.
Appreciate your taking time to share! Have a great day

TrowaD · Answer

Didn't think of that.

A workaround could be to use a macro code and assign a shortcut to it. 

Sub RunMe()
Dim oValue, nValue As String
oValue = ActiveCell.Value
nValue = InputBox("Altering cell value", , oValue)
ActiveCell.Value = nValue
End Sub 

After putting the code in a standard module, hit Alt+F8 to open the macro window and then click on the option button to assign a shortcut key to it.

Best regards,
Trowa

x · Answer

Not sure if this is your keyboard but perhaps this will enable them so that they can be used properly.

http://support.logitech.com/en_in/article/35064?product=a0qi00000069ufcAAA

BenFromSingapore · Answer

Wow - that's a really sophisticated solution and I will give it a go! Looks like the answer that I need.
Thanks so much - to you TrowaD, to kierefschild, and to others in the community.
best,
Ben

Shortcut to edit a cell without using F2 key

5 responses

Similar discussions

Subscribe To Our Newsletter!