|
Excel
Keyboard Shortcuts
|
  |
| 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 | 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 | 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
|