Always hitting F1 when I mean to hit F2

[xenou]

F2 is a useful key (puts a cell in edit mode). But I sometimes hit F1 by mistake and Excel help pops up.

So a little fix I find helpful is this one:

[COLOR="Navy"]Private[/COLOR] [COLOR="Navy"]Sub[/COLOR] Workbook_Open()
[COLOR="SeaGreen"]'//I'm always hitting F1 when I want F2[/COLOR]
    Application.OnKey "{F1}", ""
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Just put this in the open event of a workbook that will start up each session (like Personal.xls in your xlStart folder, or an addin that you always use).

Keep Excelling,
ξ

 

[wigi]

LOL

It's known that some people who tend to use Excel heavily, seriously heavily and are only keyboard oriented instead of using the mouse,
take out the F1 key completely... It's a waste of precious time.

 

[xenou]

I taught myself a new keyboard shortcut every week when I was first learning Excel. I think most tasks I perform frequently I keyboard, including a half dozen or so custom keyboard shortuts. Then I add a lot of quick access shortcuts, customize my right click menu, and the ribbon stays minimized 99% of the time.