switches between worksheet tabs, from left to right
What is ctrl+PgDn
100
switches the worksheet to page layout view.
What is Alt,W,P
100
Shift+F2
What shortcut adds or edits a cell comment
100
calculates all worksheets in all open workbooks, regardless of whether they have changed since last calculation
What is Ctrl+Alt+F9
200
this key allows a user to repeat simple actions
What is the f4 key
200
applies the outline border to the selected cells
What is Ctrl+Shift+&
200
displays the key tips on the ribbon
What is Alt
200
displays the insert function dialog box
What is shift+F3
200
Ctrl+Alt+Shift+F9
What shortcut rechecks dependent formulas, and then calculates all cells in open workbooks, including cells not marked as needing to be calculated.
300
It displays the paste name dialog box
What is the F3 key?
300
Removes outline border of selected cells
What is Ctrl+Shift_
300
switches worksheet to normal view.
What is Alt,W,L
300
Shift+F6
What shortcut switches between the worksheet, zoom controls, task pane , and ribbon.
300
displays the menu or message for an error checking button.
What is Alt+Shift+F10
400
Edits the active cell and positions point at the end of the cell contents, also moves the insertion point into the Formula Bar when editing in a cell is turned off.
What is the F2 key?
400
Applies general number format
What is Ctrl+Shift+~
400
Alt,W,I
What shortcut switches the worksheet to page break preview view
400
enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
What is Shift+F8
400
Ctrl+Arrow Key
What shortcut moves to the edge of current data region in a worksheet
500
displays the Go To dialog box.
What is the F5 key?
500
Applies the date format with the day, month, year
What is Ctrl+Shift+#
500
Alt+F11
What shortcut opens the Microsoft visual basic for application editor in which you can create a macro by using Visual basic for applications.
500
Shift+F9
What shortcut calculates the active worksheet.
500
Shift+Arrow Key
What shortcut extends the selection of cells by one cell