The Best Shortcut Keys in Microsoft Excel


Now It can be easy to work with excle if You know its shortcut keys. The trickblast4u.blogspot.com brings a great collection of Shortcut Keys for You 

Microsoft Excel Best Shortcut Keys
Ctrl+ZUndo
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+ArrowMove
to edge of region
Ctrl+* Select
current region
Ctrl+ASelect
all cells
Ctrl+Home
Ctrl+End
Select
A1,
Select
last cell in used range
Ctrl+Shift+EndSelect
from active cell to last cell in used range.
Ctrl+Shift+HomeSelect
from active cell to A1
Ctrl+Page
Down
Ctrl+Page
Up
Move
to the next sheet,
Move
to the previous sheet
Ctrl+TabMove
to next open workbook
Ctrl+NOpen
new workbook
Shift+F11Insert
new worksheet
Shift+F3Paste
function window
=+FunctionName+Ctrl+AInsert
new function
Alt+F11Open
VBE
Ctrl+Shift+EnterArray
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


Now enjoy work with excel....

0 comments:

Post a Comment

ShareThis Post

ShareThis