M.S Excel shourtcut
Øla-
|
'kh"kZd (Excel es)
|
'kksVZ dh
|
|
1
|
le; ns[kuk ¼Excel
es½
|
Ctrl+shift+ ; nckus ls
|
|
2
|
Rkjh[k ns[kuk ¼Excel
es½
|
Ctrl+; nckus ls
|
|
3
|
Row lysDV djuk ¼tgka
dlZj½
|
Shift+space nckus ls
|
|
4
|
Column lysDV djuk
¼tgka dlZj½ ¼Excel es½
|
Ctrl+space nckus ls
|
|
5
|
Minimize djuk ¼Excel es½
|
Ctrl+f9 nckus ls
|
|
6
|
Maximize djuk ¼Excel
es½
|
Ctrl+f10 nckus ls
|
|
7
|
Restore djuk ¼Excel es½
|
Ctrl+F5 nckus ls
|
|
7
|
Find and Replace
¼Excel½
|
Shift+F5 nckus ls
|
|
8
|
QkbZy ds vUr es tkuk ¼Excel½
|
Ctrl+fups dk ,jks key
|
|
9
|
QkbZy ds Home es tkuk¼Excel½
|
Ctrl+ +Åij ,jks key
|
|
10
|
eSVj ds fcp dV yxkuk (Excel)
|
Ctrl+5 flEcksy key
|
|
11
|
Print preview ns[kuk
|
Ctrl+F2 nckus ls
|
|
12
|
Strikethrough(Excel es)
|
ctrl+5 flEcksy key nckus ls
|
|
13
|
Excel es Chart cukus ds fy,
|
F11 dks nckus ls
xzkQ 'kks djsxkA
|
|
14
|
Fist cell ls Last cell es tkus ds fy,
|
ctrl+ ,jks key nckus lsA
|
|
15
|
word es Time fudkyuk
|
Alt+shift+T nckus ls
|
|
16
|
word es rkjh[k ykuk
|
Alt+shift+D nckus
ls
|
|
17
|
Date o Time ,d lkFk ykuk
|
=Now() Enter nckus ls
|
|
18
|
Bookmark pkVZ ykus ds fy,
|
ctrl+F5 nckus ls
|
|
19
|
screen dh copy djuk
|
ctrl+Alt+print screen dh nckus
|
|
20
|
all screen dh copydjuk
|
print screen dh nckus ls
|
|
21
|
Excel es Rowo column
ns[kus
|
ctrl+shift+Lis'k ;k ,jks dh nckus lsA
|
|
22
|
word es Bookmark pkVZ ykukA
|
ctrl+shift+F5 nckus lsA
|
|
23
|
Excel es find & Replace ds fy,
|
shift+F5 nckus lsA
|
|
23
|
m.s word es find & Replace ds fy,
|
F5 nckus lsA
|
|
24
|
Duble print Box ykuk
|
ctrl+p,nckus ds ckn Alt+p
|
|
25
|
Duble print Box ykuk
|
Alt nckdj F→w→v nck;saA
|
|
26
|
,d&,d ist es
uhps tkus ds fy,
|
ctrl nckdj j[kuk page down
|
|
27
|
,d&,d ist es
Åij tkus ds fy,
|
ctrl nckdj j[kuk page up
|
|
28
|
Table es Row dks Åij-fups ys tkuk
|
Alt+sfift nckdj j[kuk o ,jks key ls Åij fups ys tk ldrs gSaA
|
|
29
|
word es okD; dks lysDV dj] Åij-fups ys tkukA
|
Alt+sfift nckdj j[kuk o fups dk ,jks key ls lysDV] ,jks key ls Åij &fups ys tk ldrs gSaA
|
|
30
|
word es ,d ykbZy dks lysDV djukA
|
shift+down ,jks key nckus lsA
|
|
31
|
word es ,d&,d dks lysDV djukA
|
shift+Right ,jks key nckus lsA
|
|
32
|
Excel es Auto sum(tksM+uk)
|
lysDV djuk o Alt+= nckus lsA
|
|
33
|
Excel es Filter yxkukA
|
ctrl+shift+L nckus lsA
|
|
34
|
Research djuk
|
Alt+Dyhd djuk
|
|
35
|
Excel es New comment
|
shift+F12 nckus lsA
|
|
36
|
Excel es tgka dlZj gSa fiNs dk
Hkkx lysDV djuk
|
ctrl+shift+Home ;k End nckus lsA
|
|
37
|
work sheet dks lysDV djukA
|
ctrl+shift+Lisl nckus lsA
|
|
38
|
Excel es ubZ worksheet insert djuk
|
shift+F11 nckus lsA
|
|
39
|
Excel es Fill(tks³uk) Down
|
ctrl+D nckus lsA
|
|
40
|
Excel es Fill(tks³uk) Right
|
ctrl+R nckus
ls
A
|
|
41
|
Excel es Table
(insert) insert djuk
|
ctrl+T nckus lsA
|
|
42
|
start ds ehuw vksiu djukA
|
ctrl+Esc nckusa lsA
|
|
43
|
insert
Tab key vksiu djuk
|
ctrl+ +key nckus lsA
|
|
44
|
,d sheet
ls nwljh sheet es eSVj ykus ds fy;sA
|
[kkyh 'khV = VkbZi dj] tks eSVj ykuk
gks] nwljh sheet es tkdj eSVj dks lysDV djus
ls, lq= =sheet1!
|
|
45
|
Auto sum
¼tks³us½ dk 'kksVZdV rjhdk
|
Alt+>
key ds lkFk = key nck;saA
|
|
46
|
End of
Document
|
ctrl+End key nck;s
|
|
47
|
End of
Line ¼ykbZu ds vUr esa tkuk½
|
End key nck;saA
|
|
48
|
dlZj ds jkbZV dk cell dks
Edit
djuk
|
Shift+End
key nck;saA
|
|
49
|
Excel dh
worksheet esa cell dks
,fMV djuk
|
F2 key dks
¼ftl lsy dks ,fMV djuk gSa ml lsy esa dlZj ls fDyd djs] ckn F2 key nck;sa½
|
|
50
|
Excel esa Save
As dk 'kksVZdV
|
Alt+F2
key dks nck;saA
|
No comments:
Post a Comment