Ctrl+Z |
Undo |
Ctrl+C |
Copy, Paste & Multiple Paste Cut |
Ctrl+F, |
Find, |
Ctrl+P, Ctrl+F4 Alt+F4 |
Print, |
Ctrl+Arrow |
Move to edge of region |
Ctrl+* |
Select |
Ctrl+A |
Select all cells |
Ctrl+Home |
Select A1,
|
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 |
Move to
the next 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, |
Define name, Paste name |
Ctrl+Spacebar
|
Select columns, Select rows |
Ctrl+1, |
Format |
Ctrl+; |
Current |
Welcome to VBA Tips & Tricks. All VBA related information will be posted on this blog. Of late, VBA has been disregarded by many software professionals for .Net, c# and other technologies. This blog will also post articles related to them too Happy reading
Friday, November 9, 2012
Shortcut keys
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment