Excel Keyboard Shortcuts
Print
Shortcut key Aktion Menü - äquivalentes Kommando
Version
Ctrl+A Selekt alles keines
alle
Ctrl+B Bold Format, Cells, Font, Font Style, Bold
alle
Ctrl+C Copy Edit, Copy
alle
Ctrl+D Fill Down Edit, Fill, Down
alle
Ctrl+F Find Edit, Find
alle
Ctrl+G Goto Edit, Goto
alle
Ctrl+H Replace Edit, Replace
alle
Ctrl+I Italic Format, Cells, Font, Font Style, Italic
alle
Ctrl+K Insert Hyperlink Insert, Hyperlink
Excel 97/2000
Ctrl+N New Workbook File, New
alle
Ctrl+O Open File, Open
alle
Ctrl+P Print File, Print
alle
Ctrl+R Fill Right Edit, Fill Right
alle
Ctrl+S Save File, Save
alle
Ctrl+U Underline Format, Cells, Font, Underline, Single
alle
Ctrl+V Paste Edit, Paste
alle
Ctrl W Close File, Close
Excel 97/2000
Ctrl+X Cut Edit, Cut
alle
Ctrl+Y Repeat Edit, Repeat
alle
Ctrl+Z Undo Edit, Undo
alle
F1 Help Help, Contents and Index
alle
F2 Edit keines
alle
F3 Paste Name Insert, Name, Paste
alle
F4 Repeat last action Edit, Repeat. Works while not in Edit mode.
alle
F4 While typing a formula, switch between absolute/relative refs keines
alle
F5 Goto Edit, Goto
alle
F6 Next Pane keines
alle
F7 Spell check Tools, Spelling
alle
F8 Extend mode keines
alle
F9 Recalculate alle workbooks Tools, Options, Calculation, Calc,Now
alle
F10 Activate Menubar N/A
alle
F11 New Chart Insert, Chart
alle
F12 Save As File, Save As
alle
Ctrl+: Insert Current Time keines
alle
Ctrl+; Insert Current Date keines
alle
Ctrl+" Copy Value from Cell Above Edit, Paste Special, Value
alle
Ctrl+’ Copy Fromula from Cell Above Edit, Copy
alle
Shift gedrückt halten für zusätzliche Menüs keines
Excel 97/2000
Shift+F1 What’s This? Help, What’s This?
alle
Shift+F2 Edit cell comment Insert, Edit Comments
alle
Shift+F3 Paste function into formula Insert, Function
alle
Shift+F4 Find Next Edit, Find, Find Next
alle
Shift+F5 Find Edit, Find, Find Next
alle
Shift+F6 Previous Pane keines
alle
Shift+F8 Add to selection keines
alle
Shift+F9 Calculate active worksheet Calc Sheet
alle
Shift+F10 Display shortcut menu keines
alle
Shift+F11 New worksheet Insert, Worksheet
alle
Shift+F12 Save File, Save
alle
Ctrl+F3 Define name Insert, Names, Define
alle
Ctrl+F4 Close File, Close
alle
Ctrl+F5 XL, Restore window size Restore
alle
Ctrl+F6 Next workbook window Window, ...
alle
Shift+Ctrl+F6 Previous workbook window Window, ...
alle
Ctrl+F7 Move window XL, Move
alle
Ctrl+F8 Resize window XL, Size
alle
Ctrl+F9 Minimize workbook XL, Minimize
alle
Ctrl+F10 Maximize or restore window XL, Maximize
alle
Ctrl+F11 Inset 4.0 Macro sheet keines in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro
alle
Ctrl+F12 File Open File, Open
alle
Alt+F1 Insert Chart Insert, Chart...
alle
Alt+F2 Save As File, Save As
alle
Alt+F4 Exit File, Exit
alle
Alt+F8 Macro dialog box Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions
Excel 97/2000
Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor
Excel 97/2000
Ctrl+Shift+F3 Create name by using names of row and column labels Insert, Name, Create
alle
Ctrl+Shift+F6 Previous Window Window, ...
alle
Ctrl+Shift+F12 Print File, Print
alle
Alt+Shift+F1 New worksheet Insert, Worksheet
alle
Alt+Shift+F2 Save File, Save
alle
Alt+= AutoSum No direct equivalent
alle
Ctrl+` Toggle Value/Formula display Tools, Options, View, Formulas
alle
Ctrl+Shift+A Insert argument names into formula No direct equivalent
alle
Alt+Down arrow Display AutoComplete list keines
Excel 95
Alt+’ Format Style dialog box Format, Style
alle
Ctrl+Shift+~ General format Format, Cells, Number, Category, General
alle
Ctrl+Shift+! Comma format Format, Cells, Number, Category, Number
alle
Ctrl+Shift+@ Time format Format, Cells, Number, Category, Time
alle
Ctrl+Shift+# Date format Format, Cells, Number, Category, Date
alle
Ctrl+Shift+$ Currency format Format, Cells, Number, Category, Currency
alle
Ctrl+Shift+% Percent format Format, Cells, Number, Category, Percentage
alle
Ctrl+Shift+^ Exponential format Format, Cells, Number, Category,
alle
Ctrl+Shift+& Place outline border around selected cells Format, Cells, Border
alle
Ctrl+Shift+_ Remove outline border Format, Cells, Border
alle
Ctrl+Shift+* Select current region Edit, Goto, Special, Current Region
alle
Ctrl++ Insert Insert, (Rows, Columns, or Cells) Depends on selection
alle
Ctrl+- Delete Delete, (Rows, Columns, or Cells) Depends on selection
alle
Ctrl+1 Format cells dialog box Format, Cells
alle
Ctrl+2 Bold Format, Cells, Font, Font Style, Bold
alle
Ctrl+3 Italic Format, Cells, Font, Font Style, Italic
alle
Ctrl+4 Underline Format, Cells, Font, Font Style, Underline
alle
Ctrl+5 Strikethrough Format, Cells, Font, Effects, Strikethrough
alle
Ctrl+6 Show/Hide objects Tools, Options, View, Objects, Show alle/Hide
alle
Ctrl+7 Show/Hide Standard toolbar View, Toolbars, Stardard
alle
Ctrl+8 Toggle Outline symbols keines
alle
Ctrl+9 Hide rows Format, Row, Hide
alle
Ctrl+0 Hide columns Format, Column, Hide
alle
Ctrl+Shift+( Unhide rows Format, Row, Unhide
alle
Ctrl+Shift+) Unhide columns Format, Column, Unhide
alle
Alt or F10 Activate the menu keines
alle
Ctrl+Tab In toolbar: next toolbar keines
Excel 97/2000
Shift+Ctrl+Tab In toolbar: previous toolbar keines
Excel 97/2000
Ctrl+Tab In a workbook: activate next workbook keines
Excel 97/2000
Shift+Ctrl+Tab In a workbook: activate previous workbook keines
Excel 97/2000
Tab Next tool keines
Excel 97/2000
Shift+Tab Previous tool keines
Excel 97/2000
Enter Do the command keines
Excel 97/2000
Shift+Ctrl+F Font Drop Down List Format, Cells, Font
alle
Shift+Ctrl+F+F Font tab of Format Cell Dialog box Format, Cells, Font
Before 97/2000
Shift+Ctrl+P Point size Drop Down List Format, Cells, Font
alle

Zurück