# Shared Flashcard Set

## Details

Excel Shortcuts
Excel Shortcuts
243
11/11/2015

Term
 Shortcut key
Definition
 Action
Term
 Ctrl+A
Definition
 Select All
Term
 Ctrl+B
Definition
 Bold
Term
 Ctrl+C
Definition
 Copy
Term
 Ctrl+D
Definition
 Fill Down
Term
 Ctrl+F
Definition
 Find
Term
 Ctrl+G
Definition
 Goto
Term
 Ctrl+H
Definition
 Replace
Term
 Ctrl+I
Definition
 Italic
Term
 Ctrl+K
Definition
Term
 Ctrl+N
Definition
 New Workbook
Term
 Ctrl+O
Definition
 Open
Term
 Ctrl+P
Definition
 Print
Term
 Ctrl+R
Definition
 Fill Right
Term
 Ctrl+S
Definition
 Save
Term
 Ctrl+U
Definition
 Underline
Term
 Ctrl+V
Definition
 Paste
Term
 Ctrl W
Definition
 Close
Term
 Ctrl+X
Definition
 Cut
Term
 Ctrl+Y
Definition
 Repeat
Term
 Ctrl+Z
Definition
 Undo
Term
 F1
Definition
 Help
Term
 F2
Definition
 Edit
Term
 F3
Definition
 Paste Name
Term
 F4
Definition
 Repeat last action
Term
 F4
Definition
 While typing a formula, switch between absolute/relative refs
Term
 F5
Definition
 Goto
Term
 F6
Definition
 Next Pane
Term
 F7
Definition
 Spell check
Term
 F8
Definition
 Extend mode
Term
 F9
Definition
 Recalculate all workbooks
Term
 F10
Definition
Term
 F11
Definition
 New Chart
Term
 F12
Definition
 Save As
Term
 Ctrl+:
Definition
 Insert Current Time
Term
 Ctrl+;
Definition
 Insert Current Date
Term
 Ctrl+"
Definition
 Copy Value from Cell Above
Term
 Ctrl+’
Definition
 Copy Formula from Cell Above
Term
 Shift
Definition
Term
 Shift+F1
Definition
 What’s This?
Term
 Shift+F2
Definition
 Edit cell comment
Term
 Shift+F3
Definition
 Paste function into formula
Term
 Shift+F4
Definition
 Find Next
Term
 Shift+F5
Definition
 Find
Term
 Shift+F6
Definition
 Previous Pane
Term
 Shift+F8
Definition
Term
 Shift+F9
Definition
 Calculate active worksheet
Term
 Ctrl+Alt+F9
Definition
 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Term
 Ctrl+Alt+Shift+F9
Definition
 Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Term
 Shift+F10
Definition
Term
 Shift+F11
Definition
 New worksheet
Term
 Shift+F12
Definition
 Save
Term
 Ctrl+F3
Definition
 Define name
Term
 Ctrl+F4
Definition
 Close
Term
 Ctrl+F5
Definition
 XL, Restore window size
Term
 Ctrl+F6
Definition
 Next workbook window
Term
 Shift+Ctrl+F6
Definition
 Previous workbook window
Term
 Ctrl+F7
Definition
 Move window
Term
 Ctrl+F8
Definition
 Resize window
Term
 Ctrl+F9
Definition
 Minimize workbook
Term
 Ctrl+F10
Definition
 Maximize or restore window
Term
 Ctrl+F11
Definition
 Inset 4.0 Macro sheet
Term
 Ctrl+F12
Definition
 File Open
Term
 Alt+F1
Definition
 Insert Chart
Term
 Alt+F2
Definition
 Save As
Term
 Alt+F4
Definition
 Exit
Term
 Alt+F8
Definition
 Macro dialog box
Term
 Alt+F11
Definition
 Visual Basic Editor
Term
 Ctrl+Shift+F3
Definition
 Create name by using names of row and column labels
Term
 Ctrl+Shift+F6
Definition
 Previous Window
Term
 Ctrl+Shift+F12
Definition
 Print
Term
 Alt+Shift+F1
Definition
 New worksheet
Term
 Alt+Shift+F2
Definition
 Save
Term
 Alt+=
Definition
 AutoSum
Term
 Ctrl+`
Definition
 Toggle Value/Formula display
Term
 Ctrl+Shift+A
Definition
 Insert argument names into formula
Term
 Alt+Down arrow
Definition
 Display AutoComplete list
Term
 Alt+’
Definition
 Format Style dialog box
Term
 Ctrl+Shift+~
Definition
 General format
Term
 Ctrl+Shift+!
Definition
 Comma format
Term
 Ctrl+Shift+@
Definition
 Time format
Term
 Ctrl+Shift+#
Definition
 Date format
Term
 Ctrl+Shift+\$
Definition
 Currency format
Term
 Ctrl+Shift+%
Definition
 Percent format
Term
 Ctrl+Shift+^
Definition
 Exponential format
Term
 Ctrl+Shift+&
Definition
 Place outline border around selected cells
Term
 Ctrl+Shift+_
Definition
 Remove outline border
Term
 Ctrl+Shift+*
Definition
 Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report.
Term
 Ctrl++
Definition
 Insert
Term
 Ctrl+-
Definition
 Delete
Term
 Ctrl+1
Definition
 Format cells dialog box
Term
 Ctrl+2
Definition
 Bold
Term
 Ctrl+3
Definition
 Italic
Term
 Ctrl+4
Definition
 Underline
Term
 Ctrl+5
Definition
 Strikethrough
Term
 Ctrl+6
Definition
 Show/Hide objects
Term
 Ctrl+7
Definition
 Show/Hide Standard toolbar
Term
 Ctrl+8
Definition
 Toggle Outline symbols
Term
 Ctrl+9
Definition
 Hide rows
Term
 Ctrl+0
Definition
 Hide columns
Term
 Ctrl+Shift+(
Definition
 Unhide rows
Term
 Ctrl+Shift+)
Definition
 Unhide columns
Term
 Alt or F10
Definition
Term
 Ctrl+Tab
Definition
 In toolbar: next toolbar
Term
 Shift+Ctrl+Tab
Definition
 In toolbar: previous toolbar
Term
 Tab
Definition
 Next tool
Term
 Shift+Tab
Definition
 Previous tool
Term
 Enter
Definition
 Do the command
Term
 Alt+Enter
Definition
 Start a new line in the same cell.
Term
 Ctrl+Enter
Definition
 Fill the selected cell range with the current entry.
Term
 Shift+Ctrl+F
Definition
 Font Drop Down List
Term
 Shift+Ctrl+F+F
Definition
 Font tab of Format Cell Dialog box
Term
 Shift+Ctrl+P
Definition
 Point size Drop Down List
Term
 Ctrl+Spacebar
Definition
 Select the entire column
Term
 Shift+Spacebar
Definition
 Select the entire row
Term
 CTRL+/
Definition
 Select the array containing the active cell.
Term
 CTRL+SHIFT+O
Definition
 Select all cells that contain comments.
Term
 CTRL+\
Definition
 In a selected row, select the cells that don’t match the formula or static value in the active cell.
Term
 CTRL+SHIFT+|
Definition
 In a selected column, select the cells that don’t match the formula or static value in the active cell.
Term
 CTRL+[
Definition
 Select all cells directly referenced by formulas in the selection.
Term
 CTRL+SHIFT+{
Definition
 Select all cells directly or indirectly referenced by formulas in the selection.
Term
 CTRL+]
Definition
 Select cells that contain formulas that directly reference the active cell.
Term
 CTRL+SHIFT+}
Definition
 Select cells that contain formulas that directly or indirectly reference the active cell.
Term
 ALT+;
Definition
 Select the visible cells in the current selection.
Term
 SHIFT+BACKSPACE
Definition
 With multiple cells selected, select only the active cell.
Term
 CTRL+SHIFT+SPACEBAR
Definition
 Selects the entire worksheet.
Term
 Ctrl+Alt+L
Definition
 Reapply the filter and sort on the current range so that changes you've made are included
Term
 Ctrl+Alt+V
Definition
 Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
Term
 Shortcut key
Definition
 Action
Term
 Ctrl+A
Definition
 Select All
Term
 Ctrl+B
Definition
 Bold
Term
 Ctrl+C
Definition
 Copy
Term
 Ctrl+D
Definition
 Fill Down
Term
 Ctrl+F
Definition
 Find
Term
 Ctrl+G
Definition
 Goto
Term
 Ctrl+H
Definition
 Replace
Term
 Ctrl+I
Definition
 Italic
Term
 Ctrl+K
Definition
Term
 Ctrl+N
Definition
 New Workbook
Term
 Ctrl+O
Definition
 Open
Term
 Ctrl+P
Definition
 Print
Term
 Ctrl+R
Definition
 Fill Right
Term
 Ctrl+S
Definition
 Save
Term
 Ctrl+U
Definition
 Underline
Term
 Ctrl+V
Definition
 Paste
Term
 Ctrl W
Definition
 Close
Term
 Ctrl+X
Definition
 Cut
Term
 Ctrl+Y
Definition
 Repeat
Term
 Ctrl+Z
Definition
 Undo
Term
 F1
Definition
 Help
Term
 F2
Definition
 Edit
Term
 F3
Definition
 Paste Name
Term
 F4
Definition
 Repeat last action
Term
 F4
Definition
 While typing a formula, switch between absolute/relative refs
Term
 F5
Definition
 Goto
Term
 F6
Definition
 Next Pane
Term
 F7
Definition
 Spell check
Term
 F8
Definition
 Extend mode
Term
 F9
Definition
 Recalculate all workbooks
Term
 F10
Definition
Term
 F11
Definition
 New Chart
Term
 F12
Definition
 Save As
Term
 Ctrl+:
Definition
 Insert Current Time
Term
 Ctrl+;
Definition
 Insert Current Date
Term
 Ctrl+"
Definition
 Copy Value from Cell Above
Term
 Ctrl+'
Definition
 Copy Formula from Cell Above
Term
 Shift
Definition
Term
 Shift+F1
Definition
 What's This?
Term
 Shift+F2
Definition
 Edit cell comment
Term
 Shift+F3
Definition
 Paste function into formula
Term
 Shift+F4
Definition
 Find Next
Term
 Shift+F5
Definition
 Find
Term
 Shift+F6
Definition
 Previous Pane
Term
 Shift+F8
Definition
Term
 Shift+F9
Definition
 Calculate active worksheet
Term
 Ctrl+Alt+F9
Definition
 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Term
 Ctrl+Alt+Shift+F9
Definition
 Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Term
 Shift+F10
Definition
Term
 Shift+F11
Definition
 New worksheet
Term
 Shift+F12
Definition
 Save
Term
 Ctrl+F3
Definition
 Define name
Term
 Ctrl+F4
Definition
 Close
Term
 Ctrl+F5
Definition
 XL, Restore window size
Term
 Ctrl+F6
Definition
 Next workbook window
Term
 Shift+Ctrl+F6
Definition
 Previous workbook window
Term
 Ctrl+F7
Definition
 Move window
Term
 Ctrl+F8
Definition
 Resize window
Term
 Ctrl+F9
Definition
 Minimize workbook
Term
 Ctrl+F10
Definition
 Maximize or restore window
Term
 Ctrl+F11
Definition
 Inset 4.0 Macro sheet
Term
 Ctrl+F12
Definition
 File Open
Term
 Alt+F1
Definition
 Insert Chart
Term
 Alt+F2
Definition
 Save As
Term
 Alt+F4
Definition
 Exit
Term
 Alt+F8
Definition
 Macro dialog box
Term
 Alt+F11
Definition
 Visual Basic Editor
Term
 Ctrl+Shift+F3
Definition
 Create name by using names of row and column labels
Term
 Ctrl+Shift+F6
Definition
 Previous Window
Term
 Ctrl+Shift+F12
Definition
 Print
Term
 Alt+Shift+F1
Definition
 New worksheet
Term
 Alt+Shift+F2
Definition
 Save
Term
 Alt+=
Definition
 AutoSum
Term
 Ctrl+`
Definition
 Toggle Value/Formula display
Term
 Ctrl+Shift+A
Definition
 Insert argument names into formula
Term
 Alt+Down arrow
Definition
 Display AutoComplete list
Term
 Alt+'
Definition
 Format Style dialog box
Term
 Ctrl+Shift+~
Definition
 General format
Term
 Ctrl+Shift+!
Definition
 Comma format
Term
 Ctrl+Shift+@
Definition
 Time format
Term
 Ctrl+Shift+#
Definition
 Date format
Term
 Ctrl+Shift+\$
Definition
 Currency format
Term
 Ctrl+Shift+%
Definition
 Percent format
Term
 Ctrl+Shift+^
Definition
 Exponential format
Term
 Ctrl+Shift+&
Definition
 Place outline border around selected cells
Term
 Ctrl+Shift+_
Definition
 Remove outline border
Term
 Ctrl+Shift+*
Definition
 Select current region
Term
 Ctrl++
Definition
 Insert
Term
 Ctrl+-
Definition
 Delete
Term
 Ctrl+1
Definition
 Format cells dialog box
Term
 Ctrl+2
Definition
 Bold
Term
 Ctrl+3
Definition
 Italic
Term
 Ctrl+4
Definition
 Underline
Term
 Ctrl+5
Definition
 Strikethrough
Term
 Ctrl+6
Definition
 Show/Hide objects
Term
 Ctrl+7
Definition
 Show/Hide Standard toolbar
Term
 Ctrl+8
Definition
 Toggle Outline symbols
Term
 Ctrl+9
Definition
 Hide rows
Term
 Ctrl+0
Definition
 Hide columns
Term
 Ctrl+Shift+(
Definition
 Unhide rows
Term
 Ctrl+Shift+)
Definition
 Unhide columns
Term
 Alt or F10
Definition
Term
 Ctrl+Tab
Definition
 In toolbar: next toolbar
Term
 Shift+Ctrl+Tab
Definition
 In toolbar: previous toolbar
Term
 Ctrl+Tab
Definition
 In a workbook: activate next workbook
Term
 Shift+Ctrl+Tab
Definition
 In a workbook: activate previous workbook
Term
 Tab
Definition
 Next tool
Term
 Shift+Tab
Definition
 Previous tool
Term
 Enter
Definition
 Do the command
Term
 Alt+Enter
Definition
 Start a new line in the same cell.
Term
 Ctrl+Enter
Definition
 Fill the selected cell range with the current entry.
Term
 Shift+Ctrl+F
Definition
 Font Drop Down List
Term
 Shift+Ctrl+F+F
Definition
 Font tab of Format Cell Dialog box
Term
 Shift+Ctrl+P
Definition
 Point size Drop Down List
Supporting users have an ad free experience!