Cheat-Sheet-Leitfaden
Excel Shortcuts, die du zuerst lernen solltest
Diese Seite sammelt 29 durchsuchbare Tastenkombinationen fuer Excel in 5 Kategorien. Beginne mit den wichtigsten Kategorien und drucke das Cheat Sheet, wenn du es griffbereit haben moechtest.
- Wechsle die OS-Tabs fuer Windows-, macOS- oder Linux-Shortcuts.
- Mit / springst du direkt zur Suche.
- Nutze den Vergleichsmodus beim Wechsel zwischen Systemen.
- Drucke oder speichere die Seite als kompaktes PDF-Cheat-Sheet.
Workbook & Files
5 shortcuts
Create new workbook
Ctrl+N
WinCtrl+N
Mac⌘N
Linux—
Open workbook
Ctrl+O
WinCtrl+O
Mac⌘O
Linux—
Save workbook
Ctrl+S
WinCtrl+S
Mac⌘S
Linux—
Drucken workbook
Ctrl+P
WinCtrl+P
Mac⌘P
Linux—
Schliessen workbook
Ctrl+W
WinCtrl+W
Mac⌘W
Linux—
Navigation
7 shortcuts
Move one cell up
↑
Win↑
Mac↑
Linux—
Move one cell down
↓
Win↓
Mac↓
Linux—
Move to edge of data region
Ctrl+Arrow
WinCtrl+Arrow
Mac⌘Arrow
Linux—
Go to cell A1
Ctrl+Home
WinCtrl+Home
MacFn+Ctrl+←
Linux—
Go to last used cell
Ctrl+End
WinCtrl+End
MacFn+Ctrl+→
Linux—
Next worksheet
Ctrl+PageDown
WinCtrl+PageDown
MacFn+Ctrl+↓
Linux—
Previous worksheet
Ctrl+PageUp
WinCtrl+PageUp
MacFn+Ctrl+↑
Linux—
Bearbeitung
7 shortcuts
Bearbeiten active cell
F2
WinF2
MacCtrl+U
Linux—
Fill down
Ctrl+D
WinCtrl+D
Mac⌘D
Linux—
Fill right
Ctrl+R
WinCtrl+R
Mac⌘R
Linux—
Insert current date
Ctrl+;
WinCtrl+;
MacCtrl+;
Linux—
Insert current time
Ctrl+Shift+;
WinCtrl+Shift+;
Mac⌘;
Linux—
Rueckgaengig
Ctrl+Z
WinCtrl+Z
Mac⌘Z
Linux—
Wiederholen
Ctrl+Y
WinCtrl+Y
Mac⌘Y
Linux—
Formeln
5 shortcuts
Start formula
=
Win=
Mac=
Linux—
AutoSum
Alt+=
WinAlt+=
Mac⌘⇧T
Linux—
Show formulas
Ctrl+`
WinCtrl+`
MacCtrl+`
Linux—
Calculate worksheets
F9
WinF9
MacF9
Linux—
Insert function
Shift+F3
WinShift+F3
MacShift+F3
Linux—
Formatierung
5 shortcuts
Fett
Ctrl+B
WinCtrl+B
Mac⌘B
Linux—
Kursiv
Ctrl+I
WinCtrl+I
Mac⌘I
Linux—
Unterstreichen
Ctrl+U
WinCtrl+U
Mac⌘U
Linux—
Format cells dialog
Ctrl+1
WinCtrl+1
Mac⌘1
Linux—
Apply percent format
Ctrl+Shift+%
WinCtrl+Shift+%
Mac⌃⇧%
Linux—
Haeufige Fragen
What is the fastest way to find Excel shortcuts on this page?
Use the search box or press /, then type an action such as create new workbook.
Can I print this Excel shortcut cheat sheet?
Yes. Use the Print / PDF button or your browser print command to save a compact cheat sheet.
Does this page include Windows and Mac shortcuts for Excel?
Yes. Use the OS tabs to switch between Windows and macOS shortcuts. For example, Create new workbook is Ctrl+N on Windows and ⌘N on macOS where available.
Advertisement