Search

Are you in Control? Quick List of shortcuts using the CTRL key in Excel

Here are a short list of CTRL shortcuts you can use in Excel to speed up your navigation.
 
 
CTRL A = SELECT ALL RANGE OR TABLE
CTRL C = COPY
CTRL X = CUT
CTRL V = PASTE
CTRL O = OPEN
CTRL W = CLOSE

CTRL HOME = GOES TO CELL A1 (HOME)
CTRL END = GOES TO END (LAST EDITED ROW AND COLUMN of WORKSHEET)

CTRL Z = UNDO LAST
CTRL Y = REDO LAST
CTRL S = SAVE

CTRL T = CREATES TABLE FROM RANGE

CTRL : = INSERT TIME (NOW)
CTRL ; = INSERT DATE (TODAY)

CTRL SPACEBAR = SELECT ENTIRE COLUMN
SHIFT SPACEBAR = SELECT ENTIRE ROW

CTRL PAGEUP = GOES TO PREVIOUS WORKSHEET
CTRL PAGEDOWN = GOES TO NEXT WORKSHEET
 
 
Do you have one which is not listed? post it below in the comment section :)
[photo]

$75p/h

Yves S.

Advanced Excel (incl vba), Access, and Outlook for business executives

200+ hours
if (isMyPost) { }