Flashcards
Excel shortcuts
Cards in this deck (14)
- 1Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).Ctrl+Shift+*
- 2In a PivotTable, it selects the entire PivotTable reportCtrl+Shift+*
- 3Enters the current time.Ctrl+Shift+:
- 4Enters the current dateCtrl+;
- 5Alternates between displaying cell values and displaying formulas in the worksheet.Ctrl+`
- 6Selects the entire worksheetCtrl+A
- 7Copies the selected cells.Ctrl+C
- 8Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.Ctrl+D
- 9selects all cells that contain comments.Ctrl+Shift+O
- 10Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.Ctrl+R
- 11switches between expanding and collapsing of the formula barCtrl+U
- 12Cuts the selected cells.Ctrl+X
- 13Repeats the last command or action, if possible.Ctrl+Y
- 14Uses the Undo command to reverse the last command or to delete the last entry that you typed.Ctrl+Z
Information
- Description
- Flashcards on Excel shortcuts, created by neil.hardy on 16/05/2015.
- Created by
- neil.hardy
- Views
- 0
- Rating