Shared Flashcard Set

Details

Excel Shortcuts
Excel Shortcuts
243
Business
Post-Graduate
11/11/2015

Additional Business Flashcards

 


 

Cards

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
Insert Hyperlink
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
Activate Menubar
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
Hold down shift for additional functions in Excel’s menu
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
Add to selection
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
Display shortcut menu
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
Activate the menu
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
Insert Hyperlink
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
Activate Menubar
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
Hold down shift for additional functions in Excel's menu
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
Add to selection
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
Display shortcut menu
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
Activate the menu
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!