The Best Shortcut Keys in Microsoft Excel

Vinod Jain (Practising Chartered Accountant at Durg since 1983)   (1546 Points)

26 January 2009  
Ctrl+Z Undo
Ctrl+C

Enter,
Ctrl+V
Ctrl+X		 Copy,

Paste,
Multiple Paste,
Cut
Ctrl+F,
Ctrl+H		 Find,
Find&Replace
Ctrl+P,
Ctrl+S, Ctrl+F4, Alt+F4		 Print,
Save, Close,
Close
Excel
Ctrl+Arrow Move
to edge of region
Ctrl+* Select
current region
Ctrl+A Select
all cells
Ctrl+Home
Ctrl+End		 Select
A1,
Select
last cell in used range
Ctrl+Shift+End Select
from active cell to last cell in used range.
Ctrl+Shift+Home Select
from active cell to A1
Ctrl+Page
Down
Ctrl+Page
Up		 Move
to the next sheet,
Move
to the previous sheet
Ctrl+Tab Move
to next open workbook
Ctrl+N Open
new workbook
Shift+F11 Insert
new worksheet
Shift+F3 Paste
function window
=+FunctionName+Ctrl+A Insert
new function
Alt+F11 Open
VBE
Ctrl+Shift+Enter Array
formula
Ctrl+F3,
F3		 Define
name, Paste name
Ctrl+Spacebar
Shift+Spacebar		 Select
columns, Select rows
Ctrl+1,
Ctrl+B, Ctrl+U		 Format
cells, Bold, Underline
Ctrl+;
, Ctrl+shift+:		 Current
date, Current time