Total Pageviews

Sunday 17 May 2009

Microsoft Excel Shortcut Keys

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

No comments:

Post a Comment