MICROSOFT EXCEL
SHORTCUT KEYS
WORKSHEET NAVIGATION
PG PG Move one screen CTRL HOME Move to the beginning
up / down of a worksheet
ALT PG ALT PG Move one screen to CTRL END Move to the last cell
the left / right that has content in it
CTRL PG CTRL PG Move one worksheet CTRL Move to the word to the
tab to the left / right left while in a cell
Move one worksheet tab CTRL Move to the word to the
to the left / right right while in a cell
TAB Move to the next cell CTRL G F5 Move to the word to the
to the right right while in a cell
SHIFT TAB Move to the cell to F6 Switch between the worksheet, the
the left Ribbon, the task pane and Zoom controls
HOME Move to the beginning CTRL F6 If more than one worksheet is
of a row open, switch to the next one
RIBBON NAVIGATION
ALT Display Ribbon ALT P Go to the Page Layout
shortcuts tab
ALT F Go to the File tab ALT M Go to the Formulas tab
ALT H Go to the Home tab ALT A Go to the Data tab
ALT N Go to the Insert tab ALT R Go to the Review tab
MICROSOFT EXCEL
SHORTCUT KEYS
RIBBON NAVIGATION (CONT.)
ALT W Go to the View ALT JT Go to the Table Tools / Design tab
tab when cursor is on a table
ALT Q Put cursor in the Tell ALT JP Go to the Picture Tools / Format
Me box tab when cursor is on an image
ALT JC Go to the Chart Tools / Design tab ALT JI Go to the Draw tab
when cursor is on a chart (if available)
ALT JA Go to the Chart Tools / Format tab ALT B Go to the Power Pivot tab
when cursor is on a chart (if available)