Report

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

Ask a question Ben - Last answered on Apr 25, 2017 at 10:38 PM by 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!

See more 
Helpful
+0
plus moins
Double click the cell......
BenFromSingapore 2Posts Monday April 24, 2017Registration date April 24, 2017 Last seen - Apr 24, 2017 at 06:46 AM
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
Reply
TrowaD 2197Posts Sunday September 12, 2010Registration date ModeratorStatus May 23, 2017 Last seen - Apr 24, 2017 at 12:10 PM
Never used F2 or double click to input data, just start typing ......
Reply
Leave a comment
Helpful
+0
plus moins
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
Leave a comment
Helpful
+0
plus moins
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
Leave a comment
Helpful
+0
plus moins
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
Leave a comment
Helpful
+0
plus moins
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
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!