MICROSOFT EXCEL
SHORTCUT KEYS
WORKING WITH DATA
SHIFT SPACEBAR Select a row CTRL C Copy cell’s contents to
the clipboard
CTRL SPACEBAR Select a column CTRL X Copy and delete cell’s
contents
CTRL A CTRL SHIFT SPACEBAR Select an entire CTRL V Paste from the
worksheet clipboard into a cell
SHIFT Extend selection CTRL ALT V Move to the word to the
by a single cell right while in a cell
Extend selection
SHIFT PG SHIFT PG down one screen ENTER Display the Paste
/ up one screen Special dialog box
SHIFT HOME Extend selection to SHIFT ENTER Finish entering data in a cell
the beginning of a row and move to the next cell down
CTRL SHIFT HOME Extend selection to the ESC Finish entering data in a cell and
beginning of the worksheet move to the next cell up
CTRL ; Insert the current CTRL END When in the formula bar, move
date the cursor to the end of the text
CTRL SHIFT ; Insert the current CTRL SHIFT END In the formula bar, select all text
time from the cursor to the end.
CTRL T CTRL L Display the Create ALT F8 Create, run, edit or
Table dialog box delete a macro