FINAN 4020 Shortcut Key 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 - when inside a cell this will start a new line in that cell
Alt Enter
Format using hot keys
Alt H 0
Increase decimal using hot keys
Alt H 0
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 percentage using hot keys
Alt H P
Decrease indent using hot keys
Alt H S
Paste 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 key
Displays the quick analysis options for your data when you have cells that contain that data selected
Crtl Q
Copy the value from the cell above the active cell into the cell or formula bar
Ctrl '
Hide columns
Ctrl 0
Open format dialog
Ctrl 1
Hide rows
Ctrl 9
Enter the current date
Ctrl ;
Select all
Ctrl A
Move to next section of text
Ctrl Arrow key
Bold highlighted section
Ctrl B
Copy
Ctrl C
Fill down command to copy the contents and format of 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 & replace
Ctrl H
Move to beginning of line of text (or region)
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, from left-to-right
Ctrl PgDn
Switches between worksheet tabs, from right-to-left
Ctrl PgUp
Save
Ctrl S
Apply comma format
Ctrl Shift !
Applies the currency format with two 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 beginning of line of text (or cell a1)
Ctrl Shift Home
Applies the general number format
Ctrl Shift ~
Select entire column
Ctrl Space
Create table
Ctrl T
Move between open excel files
Ctrl Tab
Underline highlighted selection
Ctrl U
Paste
Ctrl V
Cut
Ctrl X
Redo last action (can be used multiple times)
Ctrl Y
Undo last action (can be used multiple times)
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 (in formula)
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 extended selection
F8
Calculate the workbook
F9
Selecting cells
Shift Arrows
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