Shortcut to edit a cell without using F2 key [Solved/Closed]

Report
-
 BenFromSingapore -
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!

5 replies


Double click the cell......
Posts
2
Registration date
Monday April 24, 2017
Status
Member
Last seen
April 24, 2017

Thanks so much for this. It certainly works!
Do you know of an alternative, that uses the keyboard exclusively - not the mouse?
Thanks! And have a great day
Posts
2665
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 12, 2020
445
Never used F2 or double click to input data, just start typing ......
Posts
2
Registration date
Monday April 24, 2017
Status
Member
Last seen
April 24, 2017

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
Posts
2665
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 12, 2020
445
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
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

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