| |
SHORTCUT KEYS IN EXCEL
|
|
1
|
QUICK SUM- ALT + =
|
|
2
|
TODAY DATE - CTRL + ;
(semi column कहते है)
|
3/26/2019
|
3
|
TODAY TIME - CTRL +
SHIFT + ;
|
12:43 PM
|
4
|
SAVE AS AS - F12
|
|
5
|
FOR PASTE - CTRL + D
|
|
6
|
SELECTING ROW - SHIFT
+ SPACEBAR
|
|
7
|
INSERT ROW - SHIFT +
SPACEBAR THAN CTRL + (+)
|
|
8
|
DELETE ROW - SHIFT +
SPACEBAR THAN CTRL +(-)
|
|
9
|
SELECTING COLUMN -
CTRL + SPACEBAR
|
|
10
|
INSERT COLUMN - CTRL
+ SPACEBAR THAN CTRL + (+)
|
|
11
|
DELETE COLUMN - CTRL
+ SPACEBAR THAN CTRL + (-)
|
|
12
|
QUICK PRINT - CTRL + P
|
|
13
|
FOR EDIT CELL - F2
|
|
14
|
FOR START NEW LINE IN
SAME CELL - ALT + ENTER
|
|
15
|
FOR GO TO NEXT SHEET
- CTRL + PAGE DOWN
|
|
16
|
FOR GO TO PREVIOUS
SHEET - CTRL + PAGE UP
|
|
17
|
FOR CHART - F11
|
|
18
|
| FREEZE MULTIPLE ROW AND COLUMN - ALT - W- F-
F |
|
|
19
|
FOR FILTER - CTRL +
SHIFT + L
|
|
20
|
DATA SELECTION - CTRL
+ SHIFT +
|
|
|
|
|
hii good
ReplyDelete