Shortcut Quiz #2
Show Hotkeys
Alt
Select visible cells
Alt ;
Auto sum- Sum all the cells above
Alt =
Group using hot keys
Alt A G G
Sort in ascending order using hot keys
Alt A S A
Sort in descending order using hot keys
Alt A S D
Open sort dialog box using hot keys
Alt A S S
Filter a table or range using hot keys
Alt A T
Ungroup using hot keys
Alt A U U
Open a combo box or filter list
Alt Down
Wrap Text
Alt Enter
Increase decimal using hot keys
Alt H 0
Decrease indent using hot keys
Alt H 5
Indent using hot keys
Alt H 6
Decrease decimal using hot keys
Alt H 9
Apply all borders using hot keys
Alt H B A
Remove the outline border from the selected cells using hot keys
Alt H B N
Apply a bottom border using hot keys
Alt H B O
Apply a top border using hot keys
Alt H B P
Apply outline border to the selected cells using hot keys
Alt H B S
Top and double bottom border using hot keys
Alt H B U
Delete cells using hot keys
Alt H D
Clear all using hot keys
Alt H E A
Insert cells using hot keys
Alt H I
Format accounting using hot keys
Alt H K
Conditional formatting using hot keys
Alt H L
Format using hot keys
Alt H O
Format percentage using hot keys
Alt H P
Past values using hot keys
Alt H V V
Name a cell using hot keys
Alt M M D
Open name dialog box using hot keys
Alt M N
Insert pivot table using hot keys
Alt N V
Insert new worksheet
Alt Shift F1
Cycle backward through open applications
Alt Shift Tab
Cycle forward through open applications
Alt Tab
Freeze and unfreeze panes using hot keys
Alt W F F
Move to next cell
Arrow keys
Copy the value from the cell above the active cell into the cell or the formula bar
Ctrl '
Hide columns
Ctrl 0
Open format dialog
Ctrl 1
Hide rows
Ctrl 9
Enter Current Date
Ctrl ;
Select All
Ctrl A
Move to next section of text
Ctrl ArrowKey
Bold Highlighted Section
Ctrl B
Copy
Ctrl C
Fill down command to copy the contents and format the topmost cell of a selected range into the cells below
Ctrl D
Move to the end of line of text (or region)
Ctrl End
Enter the same data or formula into all cells selected
Ctrl Enter
Find
Ctrl F
Minimize / maximize currently selected window
Ctrl F10
Print Preview
Ctrl F2
Minimize current window
Ctrl F9
Find and replace
Ctrl H
Move to beginning of line of text (or last nonblank row/column)
Ctrl Home
Italic highlighted selection
Ctrl I
New workbook
Ctrl N
Bring up the print dialog box to begin printing
Ctrl P
Switches between worksheet tabs, left to right
Ctrl PageDown
Switches between worksheet tabs, from right to left
Ctrl PageUp
Displays the quick analysis option for your data when you have cells that contain that data selected
Ctrl Q
Save
Ctrl S
Select entire column
Ctrl SPACE
Apply comma format
Ctrl Shift !
Applies the currency format with 2 decimal places (negative numbers in parentheses)
Ctrl Shift $
Applies the percentage format with no decimal places
Ctrl Shift %
Unhide rows
Ctrl Shift (
Unhide Columns
Ctrl Shift )
Enter the current time
Ctrl Shift ;
Selecting a range
Ctrl Shift Arrows
Select to end of line of text (or region)
Ctrl Shift End
Select to begging of line of text (or cell a1)
Ctrl Shift Home
Applies the general number format
Ctrl Shift ~
Create Table
Ctrl T
Move between open excel files
Ctrl Tab
Underline highlighted section
Ctrl U
Past
Ctrl V
Cut
Ctrl X
Redo last action
Ctrl Y
Undo last action
Ctrl Z
Alternate between displaying cell values and displaying formulas in the worksheet
Ctrl ~
Delete Cell content
Del
Help
F1
Create chart
F11
Save as
F12
Edit the selected cell
F2
Show names
F3
Cycle through absolute and relative
F4
Display the go to dialog box
F5
Switch between the ribbon and task pane
F6
Spell check selected text and/ or document
F7
Toggle extend selection
F8
Calculate the workbook
F9
Selecting cells
Shift ArrowKeys
Open context menu
Shift F10
Insert a new worksheet
Shift F11
Adds or edit a cell comment
Shift F2
Open the excel formula window
Shift F3
Calculate the worksheet
Shift F9
Select entire row
Shift Space