Flashcards
Excel shortcuts - 1
Cards in this deck (24)
- 1Apply outline border around selected cellAlt + H, B
- 2Select an entire column in a worksheetCtrl + Spacebar
- 3Select an entire row in a worksheetShift + Spacebar
- 4Hide rowsCtrl + 9
- 5Unhide rowsCtrl + Shift + 9
- 6Hide columnsCtrl + O
- 7Unhide columnsCtrl + Shift + O
- 8Repeat the last command or action, if possibleCtrl + Y
- 9Apply currency format with two decimal placesCtrl + Shift + $
- 10Apply percentage format with no decimal placesCtrl + Shift + %
- 11Apply date format with day, month, yearCtrl + Shift + #
- 12Apply time format with hour, minutes, and A.M. or P.M. indicationCtrl + Shift + @
- 13Open hyperlink windowCtrl + K
- 14Go to the Home tabAlt + H
- 15Go to Insert tabAlt + N
- 16Center align cell contentsAlt + H, A, then C
- 17Insert blank cells with the Insert dialog boxCtrl + Shift + Plus (+)
- 18Switch between displaying cell values or formulas in the worksheetCtrl + grave accent (`)
- 19Select the current region if the worksheet contains data. Press a second time to select the current region and its summary rows. Press a third time to select the entire worksheetCtrl + A
- 20Paste content by using the Paste Special dialog boxCtrl + Alt + V
- 21Apply an outline border to the selected cellsCtrl + Shift + ampersand (&)
- 22Remove the outline border from the selected cellsCtrl + Shift + underline (_)
- 23Use the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the rightCtrl + R
- 24Check spelling in the active worksheet or selected rangeF7
Information
- Description
- Keyboard shortcuts Flashcards on Excel shortcuts - 1, created by David Smith on 17/09/2016.
- Created by
- David Smith
- Views
- 0
- Rating