Flashcards
Excel shortcuts - 2
Cards in this deck (23)
- 1Sum data quicklyHighlight the data plus one empty cell, then Alt + =
- 2Insert current timeCtrl + Shift + ;
- 3Insert current dateCtrl + ;
- 4New line inside cellAlt + Enter
- 5Show/hide formulasCtrl + `
- 6Moves to the next sheetCtrl+PgDn
- 7Moves to the fi rst cell in the worksheetCtrl+Home
- 8If the active cell is within a multicell range, selects the block of data surrounding the active cell.Ctrl+*
- 9Prompts for a range or range name to select.Ctrl+G
- 10Moves the cell pointer up to the preceding cell in the selection.Shift+Enter
- 11Sets or removes strikethroughCtrl+5
- 12Selects direct precedent cellsCtrl+[
- 13Selects directly dependent cellsCtrl+]
- 14Equivalent to Home ? Editing ? Fill ? DownCtrl+D
- 15Equivalent to Insert ? Tables ? TableCtrl+T
- 16Pastes a name into a formulaF3
- 17Repeats the last actionF4
- 18Equivalent to View ? Macros ? Macros, or Developer ? Code ? MacrosAlt+F8
- 19Creates a chart in a chart sheetF11
- 20Inserts an Excel 4.0 macro sheetCtrl+F11
- 21Equivalent to Developer ? Code ? Visual BasicAlt+F11
- 22Moves to the last nonempty cell of the worksheetCtrl+End
- 23Name tableAlt, J, T, A
Information
- Description
- Keyboard shortcuts Flashcards on Excel shortcuts - 2, created by David Smith on 29/10/2016.
- Created by
- David Smith
- Views
- 0
- Rating