Karteikarten
Excel Shortcuts
Karten in diesem Stapel (80)
- 1Ctrl + Shift + &applies the outline border to the selected cells
- 2Ctrl + Shift_removes the outline border from the selected cells
- 3Ctrl + Shift + ~applies the general number format
- 4Ctrl + Shift + $applies the currency format with two decimal places (negative numbers in parentheses)
- 5Ctrl + Shift + %applies the percentage formal with no decimal places
- 6Ctrl + Shift + ^applies the scientific number format with two decimal places
- 7Ctrl + Shift + #applies the date format with the day, month, and year
- 8Ctrl + Shift + @applies the time format with the hour and minute, and AM or PM
- 9Ctrl + Shift + !applies the number format with two decimal places, thousands separator, and minus sign for negative values
- 10Ctrl + Shift + *selects the current region around the active cell ( the data area enclosed by blank rows and columns)
In a PivotTable it selects the entire PivotTable report - 11Ctrl + Shift + :enters the current time
- 12Ctrl + Shift + "copies the values from the cell above the active cell into the formula bar
- 13Ctrl + Shift + Plus(+)displays the Insert dialog box to insert blank cells
- 14Ctrl + Shift + Minus(-)displays the Delete dialog box to delete the selected cells
- 15Ctrl + ;enters the current date
- 16Ctrl + `alternates between displaying cell values and displaying formulas in the worksheet
- 17Ctrl + 'copies a formula from the cell above the active cell into the cell or the formula bar
- 18Ctrl + 1displays the Formal Cells dialog box
- 19Ctrl + 2applies or removes bold formatting
- 20Ctrl + 3applies or removes italic formatting
- 21Ctrl + 4applies or removes underlining
- 22Ctrl + 5applies or removes strikethrough
- 23Ctrl + 6alternates between hiding and displaying objects
- 24Ctrl + 8displays or hides the outline symbols
- 25Ctrl + 9hides the selected rows
- 26Ctrl + 0hides the selected columns
- 27Ctrl + Duses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
- 28Ctrl + Einvoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column
- 29Ctrl + Shift + Fopens the Format Cells dialog box with the Font tab selected
- 30Ctrl + Gdisplays the Go To dialog box
- 31Ctrl + Hdisplays the Find and Replace dialog box with the Replace tab selected
- 32Ctrl + Kdisplays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks
- 33Ctrl + Ldisplays the Create Table dialog box
- 34Ctrl + Odisplays the Open dialog box to open or find a file
- 35Ctrl + Shift + Popens the format cells dialog box with the Font tab selected
- 36Ctrl + Pdisplays the Print tab in Microsoft Office Backstage view
- 37Ctrl + Qdisplays the quick analysis options for your data when you have cells that contain that data selected
- 38Ctrl + Ruses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right
- 39Ctrl + Tdisplays the Create Table dialog box
- 40Ctrl + Shift+ Uswitches between the expanding and collapsing of the formula bar
- 41Ctrl + Alt + Vdisplays the Paste Special dialog box
- 42Ctrl + Wcloses the selected workbook window
- 43Ctrl + Xcuts the selected cells
- 44Ctrl + Yrepeats the last command or action, if possible
- 45F1displays the Excel Help task pane
- 46Ctrl + F1displays or hides the Ribbon
- 47Alt + F1creates an embedded chart of the data in the current range
- 48Alt + Shift + F1inserts a new worksheet
- 49F2edits the active cell and positions the insertion point at the end of the cell contents, also move the insertion point into the Formula Bar when editing in a cell is turned off
- 50Shift + F2adds or edits a cell comment
- 51Ctrl + F2displays the print preview area on the Print tab in the Backstage view
- 52F3displays the Paste Name dialog box.
- 53Shift + F3displays the Insert Function dialog box
- 54F4repeats the last command or action is possible
- 55Ctrl + F4closes the selected workbook window
- 56Alt + F4closes Excel
- 57F5displays the Go To dialog box
- 58Ctrl + F5restores the window size of the selected workbook
- 59F6switches between the worksheet, Ribbon, task pane, and Zoom controls
- 60Shift + F6switches between the worksheet, Zoom controls, task pane, and Ribbon
- 61Ctrl + F6switches to the next workbook window when more than one workbook window is open
- 62F7displays the Spelling dialog box to check spelling in the active sheet or selected range
- 63Ctrl + F7performs the Move command on the workbook window when it is not maximized, use the arrow keys to move the window and when finished press Enter, or Esc to cancel
- 64F8turns extend mode on or off. In the extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection
- 65Shift + F8enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys
- 66Ctrl + F8performs the Size command when a workbook is not maximized
- 67Alt + F8displays the Macro dialog box to create, run, edit, or delete a macro
- 68F9calculates all worksheets in all open windows
- 69Shift + F9calculates the active worksheet
- 70Ctrl + Alt + F9calculates all worksheets in all open workbooks, regardless of whether they have changes since the last calculation
- 71Ctrl + F9minimizes a workbook window to an icon
- 72F10turns key tips on or off
- 73Shift + F10displays the shortcut menu for a selected item
- 74Alt + Shift + F10displays the menu or message for an Error Checking button
- 75Ctrl + F10maximizes or restores the selected workbook window
- 76F11creates a chart of the data in the current range in a separate Chart area
- 77Shift + F11inserts a new worksheet
- 78Alt + F11opens the Microsoft Visual Basic for Applications Editor, in which you can create macro by using Visual Basic for Applications
- 79F12displays the Save As dialog box
- 80—
Informationen
- Beschreibung
- Excel shortcuts
- Erstellt von
- Amethyst Maxson · Sep 2018
- Aktualisiert
- 28 Sep 2018
- Aufrufe
- 23
- Tags
- Bewertung