By : Vikas |
| 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 |
|
By : Vikas |
Moving to the Last (or First) Cell in a Range
Using keyboard shortcuts
To move to the last (or first) cell in a range:
• Vertically from top to bottom, press Ctrl+Down Arrow.
• Vertically from bottom to top, press Ctrl+Up Arrow.
• Horizontally from left to right, press Ctrl+Right Arrow.
• Horizontally from right to left, press Ctrl+Left Arrow.
|
