STRG + 8 Excel 97: Spalte ausblenden, Excel 2003: Standard-Symbolleiste ein-/ausblenden STRG + 6 Wechseln dem Ein-/Ausblenden von Objekten und dem Anzeigen von Platzhaltern STRG + 5 Formatierung "Text durchgestrichen" STRG + 0 ( Null ) Excel97: Ein-/Ausblenden der Standard-Symbolleiste, Excel 2003: Spalte ausblenden STRG + § (Paragraph) Datumsformat "01.Jan 00" zuweisen STRG + < Zelleninhalt von darüber liegender Zelle kopieren STRG + + ( Pluszeichen ) leere Zelle einfügen STRG + _ ( Underscore ) Gesamtrahmen zuweisen STRG + ( Semikolon ) Kopieren des Wertes aus der Zelle darüber STRG + : ( Doppelpunkt ) aktuelle Uhrzeit einfügen STRG + * markieren des aktuellen Bereichs STRG + & Zahlenformat "Standard" zuweisen STRG + % Zahlenformat "Prozent ohne Dezimalstellen" zuweisen STRG + $ Zahlenformat "Währung + 2 Nachkommastellen" zuweisen STRG + # Wechseln der Anzeige zwischen Zellwerten und Zellformeln STRG + " Zahlenformat "Wissenschaft mit 2 Nachkommastellen" zuweisen STRG + ! Zahlenformat "Zahl mit Tausendertrennzeichen, 2 Dezimalstellen + Vorzeichen" zuweisen 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. MrExcel ® is a registered trademark of Tickling Keys, Inc.Īll contents © 1998 - 2022 MrExcel Publishing | All rights reserved.Few weeks back I have invited all of you to share your excel keyboard shortcuts in a open thread. View our Privacy Policy, Cookies Policy, and Terms of Use.Įxcel ® is a registered trademark of the Microsoft Corporation. You can earn a commission for sales leads that you send to us by joining our Any affiliate commissions that weĮarn when you click a link to Amazon or other sites is reinvested in keeping Web site are provided "as is" and we do not guarantee that they can be used in all The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. This article is an excerpt from Power Excel With MrExcel In some cases, you can use the arrow key to move to the next cell, then press F4 to apply the same formatting as the previous command. Use the shortcut keys to perform the first command, and then use F4 to repeat the command. When you are not editing a formula, F4 will repeat the last command. Strategy: Most people know F4 as the shortcut to toggle dollar signs within a reference while you are editing a formula. Even with keyboard shortcut keys, it is several keystrokes over and over. Problem: I have to do a certain command 20 times in a row.
#List of excel shortcut keys download#
KeyboardShortcuts.xlsm is in download files for this book. After adjusting column widths, you will have a worksheet of the shortcuts. This Excel help article lists all Excel keyboard shortcuts. Scroll to the bottom and choose Open in Browser. The resulting article lists all of the keyboard shortcuts. Search Excel help for “Keyboard Shortcuts”. Strategy: There are many lists floating around the Internet, but the easiest source is right in Excel help. Problem: Is there a complete list of keyboard shortcuts?