SHIFT + Rücktaste Reduzierung der Markierung auf die aktuelle Zelle SHIFT + POS1 Erweitern der Markierung bis zum Zeilenanfang SHIFT + Pfeiltaste Erweitern der Markierung um eine Zelle SHIFT + Leertaste gesamte Zeile markieren SHIFT + BildAuf Erweitern der Markierung um eine Bildschirmseite nach oben SHIFT + BildAb Erweitern der Markierung um eine Bildschirmseite nach unten SHIFT + F9 Aktives Tabellenblatt berechnen SHIFT + F6 Wechseln zum vorherigen Ausschnitt SHIFT + F3 Einfügen einer Funktion in eine Formel Here are some short-cuts - sorry, but only in germanĪLT + (Pfeil nach unten) Anzeige der AutoEingabe - ListeĪLT + EINGABE Zeilenumbruch innerhalb einer Zelle You may want to remember a few to boost your productivity. These are very useful and extremely time saving ones. Note: I have *ed some of the most important shortcuts. Here is the complete list of excel keyboard shortcuts. Without you I couldn’t have learned these shortcuts.
Special thanks to all the commenters on the original post. Here is the complete list of Excel Keyboard Shortcuts. During the weekend, I spent sometime to collect all these beautiful shortcuts and arranged them neatly so that you can easily learn them. There were so many wonderful keyboard shortcuts and tricks buried in the comments section of that post. More than 50 people commented on that post and shared a hundred excel keyboard shortcuts with us. Then I disable the active window title detection with the empty #IfWinActive at the end.Īlso, once the #IfWinActive is hit, I know exactly which window will receive the keys I'm sending, so I don't have to do anything special beyond a simple "Send " in response to each real key-press that is to be replaced.Few weeks back I have invited all of you to share your excel keyboard shortcuts in a open thread. The "#IfWinActive" ensures these particular key-press replacements only apply when the active window's title ends with the string " - Outlook" (the end is marked by the dollar sign, which works because I've enabled Regular Expression based string matching mode above). The script looks like so: SetTitleMatchMode RegEx Or whenever I press I want to go to the search box (d'oh!) but Outlook expects a for that so I have the script send it a. So for example whenever I have an e-mail selected and press I want it to be marked as read, therefore I have the AutoHotkey script replace that with a. My solution is to use AutoHotkey to "translate" my desired key combinations into the existing shortcuts that Outlook 2016 (or Excel 2016 or what have you) expects for those actions. To me all above answers are unsatisfactory because they limit what combinations I can use as custom shortcuts or what actions I can target, or they require way too much work for something that should be simple. With VBA you can actually create longer combos like Ctrl-Shft-N (one of my favorites). You only have the choice of Ctrl and one key, I believe. With #3 it's still the same as it was in earlier versions, just go into the Macro dialog and change the shortcut in Options. still exist behind the scenes in Excel 20 and can be accessed via code). The only way I know to do this now would be to change the toolbar name in VBA (the old toolbars, File, Edit, etc. For example you could change the name of the Edit menu from &Edit to &Zdit and the shortcut sequence in #2 above would be changed to Alt-Z-S-V. You use to be able to do #2 in Excel by going into Tools > Customize and then changing the location of the ampersand.
Of course you can write a macro in Excel that changes the Bold property and then assign a keyboard shortcut to it, but that really falls under #3 above. I don't think Excel has ever allowed you to do this. With # 1 I think only Word allows you to change these, e.g., you can change the shortcut for Bold from Ctrl-B to something else. There are 3 different kinds of keyboard shortcuts I know of:
0 kommentar(er)
