Microsoft excel keyboard shortcuts
9 excel short cut keys.pdf.pdf
Page – 1
Excel short cut keys
1 Home tab alt h. 2 insert tab alt n. 3 page layout tab alt p.
4 formula tab alt m. 5 data tab alt d. 6 review tab altr. 7 view tab alt w.
1 Home tab Alt h.
1 paste Control V or alt hv. 2 Cut Control X or alt hx.
3 copy Control C or alt hc
4 format painter Control Shift Cor alt hfp.
5 font alt hff. 6 font colour alt hfc.
7 Bold Control B or alt h 1.
8 italic Control I or alt h 2
9 under line Control U or alt h 3. 10 increase font size alt hfg.
11 decrease font size alt h k.
12 shadings alt h sh.
13 top alignment alt hat. 14 middle alignment alt h am 15 bottom alignment alth ab. 16 orientation alt hfa.
17 left alignment alt hal. 18 center alignment alt hac.
19 right alignment alt har. 20 decrease in dent alt h 5 CTRL alt SHIFT tab.
21 increase indent alth 6 CTRL alt SHIFT tab. 22 wrap text alt hw.
23 merge across alt hma. 24 merge Cells alt h mm. 25 unmerge Cells alth mu. 26 format cell alignment alth fa
. 27 number format alth n. 28 accounting number format alth Anm. 29 percent style alt hp. 30 comma style alt h k. 31 increase decimal alt ho. 32 decrease decimal alt h 9. 33 conditional formatting alt hl.
34 format as table altht. 35 Cell styles su. 36 insert Cells alt hl.
37 select Cells alt hd. 38 format altho. 39 Auto sum alth u alt.
45Page – 2
40 fill alt hfl. 41 clear alt he. 42 sort and filter alt hs. 43 find and select alt hfd.
insert tab altn 1 pivot table table alt nvt. 2 tables control t alt nt. 3 picture alt np. 4 clip art alt nf.
5 shapes alt nsh. 6 smart art alt n m. 7 column alt n c. 8 line alt nn. 9 pie alt ne.
10 bar alt nb. 11 area alt na. 12 scatter alt nt. 13 other charts alt no. 14 all chart types alt nk.
15 hyper link alt ni CTRL k. 16 text box alt nx. 17 header and footer alt nn. 18 wordart alt nw.
19 signature line alt nga. 20 object alt nj. 21 symbol alt nu.
3 page layout tab Alt p. 1 Themes alt pth. 2 colours alt ptc. 3 fonts alt ptf. 4 effects alt pte. 5 margins alt p m. 6 orientation alt po. 7 size alt psg. 8 print area alt pr. 9 breaks alt pb.
10 background alt pg. 11 print titles alt pl. 12 page setup
alt psp. 13 width alt pw. 14 height alt
ph, 15 scale: alt ps. 16 page setup submenu alt h sp. 17 view alt pypg. 18 print check alt pyp g. 19 view check alt pyph. 20 print check alt pyph. 21 sheet options alt pso. 22 bring to front
. 23 send to back. 24 selection pane alt pap. 25 align drop down alt p Aa. 26 group drop down alt pag – 27 rotate table alt pll.
4 formula tab Alt m. 1 insert function Shift f3 Alt mf. 2 autosum alt = 3 recently used alt mr. 4 financial alt ml. 5 logical alt ml. 6 text alt mt. 7 date and time alt me. 8 math and trig alt me. 9 more functions alt mq. 10 name manager alt m n CTRL F3. 11 define name alt m m d. 12 use in formula alt ms. 13 create from selection CTRL F3 alt mc.
14 trace precedents alt md. 15 remove arrows show formulas alt m alt mh CTRL +
16 ERROR CHECKING evaluate formula alt mv. 17 watch window alt mw.
18 calculation options alt mx. 19 calculate nowf9 alt md. 20 calculate sheet Shift f9 alt mj.
5 data tab alt A.
1 from access alt Afa. 2 from web alt AW. 3 From text alt Aft. 4 From other sources alt Afo.
46Page – 3
5 Existing connection alt Ax. 6 Refresh all CTRL alt f5. 7 connections alt A 0. 8 properties alt a p
9 edit links alt A sort a to z alt a a. 10 Sort ZA alt ad. 11 Sort alt as.
12 Filter alt CTRL Shift I alt a t. 13 Clear alt a c. 14 apply alta y CTRL Shift I. 15 advanced alt A q. 16 text to column alt Ae. 17 remove duplicates alt Am.
18 data validations alt Avv. 19 consolidate alt An. 20 what A financial alt A w. 21 group alt ag.
22 Ungroup Shift a alt left. 23 Subtotal alt Ab. 24 Show detail alt Aj. 25 Hide details alt An.
26 Group and outline settings alt AI.
6 Review tab altr.
1 Spellings check
f7 altrs. 2 research alt rr. 3 thesaurus altre. 4 translate alt rl.
5 new comments altre. 6 delete alt rd. 7 previous altrv. 8 next altrn.
9 show / hide comments altrh. 10 protect sheet alt rps. 11 protect workbook altrpw.
12 share workbook altrw. 13 protect and share workbook altro.
14 allow user to did arranges altru. 15 track changes altrg.
Z view tab alt w.
1 normal alt w1. 2 page layout alt wp. 3 page break preview alt w 1. 4 custom views alt wc.
5 full screen
alt we. 6 ruler alt wr. 7 gridlines alt wvg. 8 message bar alt w d.
9 formula bar alt wvf. 10 headings alt wvh. 11 zoom alt we. 12 100 % zoom alt wj.
13 zoom to selection alt wg. 14 new window alt w n. 15 arrange all alt wa.
16 freeze panes alt wf 17 split alt ws. 18 hide alt wh. 19 unhide alt wu. 20 view side by side alt w b. 21 synchronous scrolling alt wvs. 22 reset window position alt wt.
23 save work space alt wk. 24 switch to windows alt ww. 25 view macros alt f8.
F47