Create your own keyboard shortcuts

Create your own keyboard shortcuts

Are you a heavy user of Excel who likes to press F2 to edit a cell, but somehow, your fingers usually fall on the F1 key? Well, you're not alone. And you goolge for answers when you really need Excel support, instead of pressing F1 for help? If you fall into this scenario, you'll find the Excel F1 key most annoying. Especially because it can not be disabled.

There is a solution, however. Using a software to create custom defined keyboard shortcuts, like AutoHotKey, it is a matter of defining a new shortcut attached to the F1 key.

;--------------------------
; F1 Disable help key in Excel
;---------------------------
#IfWinActive ahk_exe EXCEL.EXE
{
              F1::
              return
}
#IfWinActive

Now, make sure this AutoHotKey script starts automatically when you log in to Windows (e.g. by running a batch file on start up) and you'll get real help by not having the Excel Help.

By the way, having already AutoHotKey running, why not loading a library with all your nice keyboard shortcuts? Here is an example of a few more that you might find useful.

;--------------------------
; CTRL+< Text–only paste from clipboard
;--------------------------
^<::    
	str_temp  := ClipBoard
	ClipBoard := str_temp . ""
	Send ^v 
	return


;--------------------------
; CTRL+q Send ALT-F4, except in Outlook (keep behavior)
;--------------------------
#IfWinActive ahk_exe OUTLOOK.EXE
{
	$^q::
	Send ^q
    return
}
#IfWinActive
^q::
Send !{F4}
return


;--------------------------
; CTRL+SPACE Set/unset window always on top
;--------------------------
^SPACE::  Winset, Alwaysontop, , A
return

Have fun!

要查看或添加评论,请登录

Jorge Lopes的更多文章

  • 2 trends for 2024

    2 trends for 2024

    Not an exhaustive list - just my 2 cents on two major trends for 2024. In the realm of tech evolution, 2023 kickstarted…

    2 条评论
  • Giants fall when their feet break - Google is in red alert

    Giants fall when their feet break - Google is in red alert

    Accordingly to the New York Times, Google is in red alert because of the success of ChatGPT. I guess that it is not the…

    3 条评论
  • Playing around with ChatGPT

    Playing around with ChatGPT

    Like many others, I've been playing around with ChatGPT, mainly to check its capacity to "understand" complex written…

    4 条评论
  • Windows: my new Linux OS

    Windows: my new Linux OS

    Unsurprisingly, this article is now outdated. WSL got improved, both in Windows 10 and 11.

  • Let's welcome CTRL+ALT+DEL to the automotive world

    Let's welcome CTRL+ALT+DEL to the automotive world

    ID.3, the new Volkswagen electric vehicle that will go on sale next year, has "massive" software problems, which is a…

    1 条评论
  • Voice Search, the audible revolution

    Voice Search, the audible revolution

    Digital assistants and devices such as Alexa, Siri, Google Home, and Amazon Echo are not what we would call privacy…

  • Net neutrality: giving a name to something didn't need to be named

    Net neutrality: giving a name to something didn't need to be named

    For decades no one needed a name for it. It was simply existing until someone though of ending it.

  • Functional / Microservices in Real-Time Financials

    Functional / Microservices in Real-Time Financials

    Here is a presentation of how Nubank, a Brazilian startup that offers a credit card completely managed by a mobile…

  • Gatwick drone incident, 2nd July 2017

    Gatwick drone incident, 2nd July 2017

    NATS, the UK leading provider of air traffic control services, documented an incident with a drone on Sunday, 2nd July.…

  • Master presenters

    Master presenters

    While watching a conference with Elon Musk as speaker, about his new BFR, which is "just" a centre piece in his plans…

社区洞察

其他会员也浏览了