F keys
Ctrl+ shortcuts
Arrow Key
Other Shortcuts
Alt Shortcuts
100
It displays the Excel Help task pane
What is F1
100
It utilizes the undo command
What is Ctrl+Z
100
It moves one cell up, down, left, or right in a worksheet
What are the arrow keys
100
Cancels an entry in the cell or Formula Bar
What is ESC
100
Displays the Key Tips (new shortcuts) on the ribbon
What is Alt
200
It calculates all the worksheets in all open workbooks
What is F9
200
It reverses the effects of the undo command
What is Ctrl+V
200
It moves to the edge of the current data region in a worksheet.
What is Ctrl+arrow key
200
Moves one screen down in a worksheet
What is page down
200
displays the Macro dialog box to create, run, edit, or delete a macro
What is Alt+F8
300
It closes Excel
What is ALT+F4
300
It displays the Create Table dialog box
What is Ctrl+T
300
It extends the selection of cells by one cell
What is Shift+arrow key
300
Moves one screen up in a worksheet
What is page up
300
closes Excel
What is Alt+F4
400
It insert a new worksheet
What is SHIFT+F11
400
It selects the entire worksheet
What is Ctrl+A
400
It selects the tab to the left or right when the ribbon is selected
What is the left or right arrow key
400
Moves one cell to the right in a worksheet
What is Tabs
400
creates an embedded chart of the data in the current range
What is Alt+F1
500
It displays the menu or message for an Error Checking button
What is ALT+SHIFT+F10
500
It applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values
What is Ctrl+Shift+!
500
It selects the next or previous command when a menu or submenu is open. When a ribbon tab is selected, these keys navigate up or down the tab group
What is the up or down arrow key
500
Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments
What is Delete
500
inserts a new worksheet
What is Alt+Shift+F1
M
e
n
u