Excel Gajerun hanyoyi

Hanyoyin Hanya Kullun Excel na Excel zuwa Kayan Kasuwanci da Hanyoyi

Koyi duka game da maɓallan gajeren hanya, ciki har da haɗuwa don amfani da Excel zuwa cikakken ƙarfinsa.

01 daga 27

Saka Sabuwar Wurin Hanya a Excel

Wannan matsala na Excel ya nuna maka yadda za a sa sabon takardun aiki a cikin littafi mai amfani ta hanyar gajeren hanya. Saka Sabuwar Ayyukan Hanya Ta Amfani Amfani da Maɓalli Keycut Latsa ka riƙe ƙasa maɓallin SHIFT a kan keyboard. Latsa kuma saki maɓallin F11 akan keyboard. Za a saka sabuwar takardar aiki a cikin littafin aiki na yanzu. Don ƙara ƙarin ɗawainiya na ci gaba da danna kuma saki maɓallin F11 yayin riƙe da maɓallin SHIFT. Kara "

02 na 27

Rubuta Rubutun akan Lissafi Biyu a Excel

Sanya rubutu a cikin tantanin halitta Idan kana son rubutu ya bayyana a kan layi da yawa a cikin tantanin halitta, zaka iya tsara tantanin salula don rubutu ya ƙunshi ta atomatik, ko kuma za ka iya shigar da shinge na layi. Me kake so ka yi? Sauya rubutun ta atomatik Shigar da layin layi Tsalle rubutu ta atomatik A cikin takardun aiki, zaɓi sel da kake son tsarawa. A Gidan shafin, a cikin Ƙungiyar Alƙawari, danna Maɓallin Rubutun Maɓallin rubutu. Bayanin Bayanan Rubutun Excel na Excel Bayanan bayanai a cikin tantanin halitta yana kunna don dace da nuni a shafi. Lokacin da ka canza fadin shafi, rikodin bayanai ya daidaita ta atomatik. Idan duk rubutun da aka nannata ba a bayyane ba, yana iya zama saboda an saita jere a wani tsawo ko kuma cewa rubutu yana cikin kewayon kwayoyin da aka haɗu. Don yin duk rubutun da aka nannata, yi da wadannan don daidaita daidaitattun layi: Zaɓi tantanin halitta ko iyakar abin da kake so ka daidaita daidaitattun tsawo. A cikin shafin shafin, a cikin sassan Cells, danna Tsarin. Takaddun rubutun Excel A ƙarƙashin Sashin Cell, yi ɗayan waɗannan masu zuwa: Don daidaita daidaitattun layin, danna Haɗin Hanya na AutoFit. Don ƙayyadadden tsawo, danna Girman Haɗin, sa'an nan kuma rubuta jeri na tsawo wanda kake so a cikin akwatin akwatin hawan. Tukwici Zaka kuma iya ja kasa iyakar jere zuwa zuwa tsawo wanda ya nuna duk rubutun nannade. Top of Page Jagora na Page Shigar da zangon layi Zaka iya fara sabon layi na rubutu a kowane ƙayyadadden ƙira a cikin tantanin halitta. Danna sau biyu dan tantanin da kake son shigar da layin layi. Gajerun hanyar faifan maɓalli Za ka iya zaɓar tantanin halitta, sannan ka danna F2. A cikin salula, danna wurin da kake son karya layin, sannan latsa ALT + ENTER.

Siffar rubutun Excel ta ƙunshi fasalin fasali wanda yake ba ka damar sarrafa tsarin rubutun da kuma rubutun a cikin maƙunsarka .

Sanya rubutu zai ba ka damar sanya rubutu a kan layi da yawa a cikin kwayar tantanin halitta maimakon ka rubuta rubutun akan kwayoyin halitta a cikin takardun aiki .

Kalmar "fasaha" wannan alama ce ta kunshe da rubutu da maɓallin haɗi don kunshe rubutu shine:

Alt Shigar

Misali: Amfani da Hanyar gajere Keys don Rubuta Rubutu

Misali ta amfani da Excel ta kunsa rubutun rubutu:

1. A cikin tantanin halitta D1 rubuta rubutun: Haɗuwa a cikin watanni kuma latsa maɓallin shigarwa a kan keyboard.
2. Tun da rubutun ya yi tsayi da yawa ga tantanin halitta, ya kamata ya zubar da shi cikin tantanin halitta E1.
3. A cikin cell E1 rubuta rubutu: Kudin watanni kuma danna maɓallin shigarwa a kan keyboard.
4. Ta shigar da bayanai zuwa E1 lakabi a cikin cell D1 ya kamata a yanke a ƙarshen tantanin halitta D1. Bugu da ƙari, rubutu a E1 ya zubar da shi cikin tantanin halitta zuwa dama.
5. Don gyara matsala tare da waɗannan alamomi, ƙaddamar da sassan D1 da E1 a cikin takardun aiki.
6. Danna kan shafin shafin.
7. Danna maɓallin Rubutun Maɓallin Rubutun akan rubutun .
8. Alamar a cikin sel D1 da E1 ya kamata su zama cikakkun bayyane tare da rubutun da aka rushe a cikin layi biyu ba tare da yaduwa a cikin sel ba.

Siffar rubutun Excel ta ƙunshi fasalin fasali wanda yake ba ka damar sarrafa tsarin rubutun da kuma rubutun a cikin maƙunsarka. Maimakon shimfiɗa ginshiƙan ginshiƙai don yin dogon lokaci a bayyane, kunsa rubutu zai ba ka damar sanya rubutu a kan layi da yawa a cikin kwayar halitta daya. Tafiyar Excel ta Rubuta Rubuta Rubuta Don taimako tare da wannan misali, duba hoto a sama. A cikin salula G1 rubuta rubutun: Aiki na Watanni kuma danna maballin ENTER akan keyboard. Tunda Asusun Cikakken ya yi tsayi sosai ga tantaninsa, zai zubar da shi cikin tantanin halitta H1. A cikin salula H1 rubuta rubutu: Kudin watanni kuma latsa maɓallin kunnawa a kan keyboard. Da zarar an shigar da bayanai zuwa tantanin halitta H1, za a yanke lakabi na farko a watan Yuni. Don gyara matsalar, ja zaɓi Kwayoyin G1 da H1 a kan maƙallan rubutu don haskaka su. Danna kan shafin shafin. Danna maɓallin Rubutun Maɓallin Rubutun akan rubutun. Alamar a cikin kwayoyin G1 da H1 ya kamata yanzu duka su kasance cikakke tare da rubutun da aka rushe a cikin layi biyu ba tare da yaduwa a cikin sel ba.

Wannan koyaswar ta shafi yadda za a rubuta a kan layi da yawa a cikin ɗayan ɗigon ɗawainiya.

Kalmar "fasaha" wannan alama ce ta kunshe da rubutu da maɓallin haɗi don kunshe rubutu shine:

Alt Shigar

Misali: Amfani da Hanyar gajere Keys don Rubuta Rubutu

Don amfani da Excel ta ƙunshi rubutun rubutu ta amfani da keyboard kawai:

1. Danna kan tantanin halitta inda kake so a sanya rubutu
2. Rubuta layin farko na rubutu
3. Latsa ka riƙe ƙasa Alt maɓallin kewayawa
4. Latsa kuma saki maɓallin shigarwa a kan keyboard ba tare da sake da maɓallin Alt ba
5. Saki da maɓallin Alt
6. Matsayin shigarwa ya kamata ya motsa zuwa layin da ke ƙasa da rubutu da aka shigo
7. Rubuta layi na biyu na rubutu
8. Idan kuna son shiga fiye da layi biyu na rubutu, ci gaba da danna Alt Shigar a ƙarshen kowane layi
9. Lokacin da aka shigar da duk rubutun, danna maɓallin shigarwa akan keyboard ko danna tare da linzamin kwamfuta don matsawa zuwa wani cell

Kara "

03 na 27

Ƙara Ranar Kwanan Wata

Wannan koyaswar ta shafi yadda za a ƙara kwanan wata a cikin takardun aiki ta hanyar amfani da keyboard kawai.

Babban haɗin don ƙara kwanan wata shine:

Ctrl + ; (key-colon key)

Misali: Yin amfani da gajerar hanya don ƙarawa kwanan wata

Don ƙara kwanan wata zuwa aikin aiki ta amfani da keyboard kawai:

1. Danna kan tantanin halitta inda kake so kwanan wata zai je.
2. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
3. Latsa kuma saki maɓallin yanki-ma'aunin ( ; ) a kan keyboard ba tare da bar maɓallin Ctrl ba.
4. Saki da maɓallin Ctrl.
5. Dole ne a ƙara kwanan wata zuwa aikin aiki a cikin cell da aka zaɓa.

Lura: Wannan gajerar hanya ta hanya ba ta yin amfani da aikin yau da kullum don haka kwanan wata ba zai canza kowane lokaci an buɗe maɓallin aikin aiki ba ko aka sake rubutawa. Kara "

04 na 27

Bayanan Sumad a Mahimman Ƙari na Hanyar Hanya

Bayanan Sumad a Mahimman Ƙari na Hanyar Hanya

Wannan shafi yana rufe yadda za a shigar da SUM aiki na Excel da sauri don ƙara bayanai ta amfani da maɓallin gajeren hanya a kan keyboard.

Maɓallin haɗin haɗi don shigar da SUM aiki shine:

" Alt " + " = "

Misali: Shigar da SUM Function ta amfani da Hanyoyin Hoto

1. Shigar da bayanai masu zuwa cikin sel D1 zuwa D3 na takardar aiki na Excel: 5, 6, 7
2. Idan ya cancanta, danna kan cell D4 don sa shi tantanin halitta mai aiki
3. Latsa ka riƙe ƙasa Alt maɓallin kewayawa
4. Latsa kuma saki alamar daidai ( = ) a kan keyboard ba tare da bar maɓallin Alt ba
5. Saki da maɓallin Alt
6. Dole ne a shigar da SUM aiki a cikin cell D4 tare da kewayon D1: D3 mai haske a matsayin ƙwaƙwalwar aikin
7. Latsa maɓallin shigarwa akan keyboard don kammala aikin
8. Amsar 18 ya kamata ya bayyana a cell D4
9. Lokacin da ka danna kan tantanin D4 da cikakke aikin = SUM (D1: D3) ya bayyana a cikin maɓallin tsari a sama da aikin aiki.

Wannan gajeren hanya za a iya amfani dashi zuwa bayanan bayanai a cikin layuka da ginshiƙai.

Lura : An tsara SUM don a shiga a kasan wani shafi na bayanai ko kuma a gefen dama na jere na bayanan.

Idan aikin SUM ya shiga cikin wani wuri banda waɗannan biyu, iyakar sel da aka zaɓa a matsayin ƙwaƙwalwar aiki na iya zama ba daidai ba.

Don canja zaɓin da aka zaba, yi amfani da maɓallin linzamin kwamfuta don nuna hasken madaidaiciya kafin danna maɓallin Shigar don kammala aikin More »

05 na 27

Ƙara lokaci na yanzu

Wannan koyaswar ta shafi yadda za a ƙara halin yanzu a cikin takardun aiki ta amfani da keyboard kawai:

Babban haɗin don ƙara lokaci shine:

Ctrl + Shift + : (maballin key)

Misali: Yin amfani da gajerar hanya yana danna don ƙara lokaci na yanzu

Don ƙara lokaci na yanzu zuwa wata takardar aiki ta amfani da keyboard kawai:

1. Danna kan tantanin halitta inda kake so lokaci zuwa.
   
   
2. Latsa ka riƙe ƙasa da Ctrl da maɓallin Shift a kan keyboard.
   
   
3. Latsa kuma saki maɓallin mallaka ( :) a kan keyboard ba tare da saki Ctrl da Shift keys ba.
   
   
4. A halin yanzu za a kara da shi a cikin maƙallan rubutu.
   
   

Lura: Wannan gajerar hanya ta hanya ba ta yin amfani da aikin NOW don haka kwanan wata ba zai canza kowane lokacin da aka buɗe ko kuma a sake yin aiki ba.

Ƙarin Tutaki na Ƙunƙwasa Gaisuwa

• Ƙara kwanan wata na yanzu
• Zaɓi Ƙananan Yankuna a Excel
• ALT - TAB Sauyawa a Windows

Kara "

06 na 27

Shigar da Hyperlink

Shigar da Hyperlink a cikin Ƙarin Amfani da Ƙunƙwasa

Koyaswar da ke ciki : Shigar Hyperlinks da Alamomin shafi a Excel

Wannan hoton na Excel yana rufe yadda za a saka jigon hyperlink don zaɓin rubutu ta amfani da maɓallin gajeren hanya a Excel.

Maɓallin haɗin da za a iya amfani dasu don saka hyperlink shine:

Ctrl + k

Misali: Shigar da Hyperlink ta amfani da Hanyoyin Hanya

Domin taimako tare da waɗannan umarnin danna kan hoton da ke sama

1. A cikin takardar aiki na Excel danna kan salula A1 don sa shi tantanin halitta mai aiki
2. Rubuta kalma don aiki a matsayin rubutu na mahimmanci kamar Fassara da kuma danna maɓallin shigarwa akan keyboard
3. Danna kan salula A1 don sake mayar da shi tantanin halitta
4. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard
5. Latsa kuma saki harafin ( k ) a kan maballin don bude Siffar maganganun Hyperlink
6. A cikin Adireshin: layi a ƙasa na akwatin maganganu yana da cikakken adireshin kamar:
   http://spreadsheets.about.com
   
7. Danna Ok don kammala hyperlink kuma rufe akwatin maganganu
8. Rubutun mahimmanci a cell A1 ya kamata a yanzu ya zama launin launi a launi kuma ya nuna cewa yana dauke da hyperlink

Gwada Hyperlink

1. Sanya linzamin linzamin kwamfuta akan hyperlink a cell A1
2. Yawan maɓallin arrow ya canza zuwa alama ta hannun
3. Danna kan rubutun rubutun hyperlink
4. Ya kamata mahaɗin yanar gizo ya bude zuwa shafin da aka gano ta URL

Cire Hyperlink

1. Sanya linzamin linzamin kwamfuta akan hyperlink a cell A1
2. Yawan maɓallin arrow ya canza zuwa alama ta hannun
3. Dama dama a kan rubutattun rubutun hyperlink don buɗe Menu na sauke menu
4. Danna kan cire Hyperlink a cikin menu
5. Ya kamata a cire launi mai launi da layin layi daga rubutun da ke nuna cewa an cire hyperlink

Other Keyboard Gajerun hanyoyi

Aiwatar da Tattalin Kudin

Aiwatar da Italics Tsarin

Ƙara Borders a Excel

Kara "

07 of 27

Show Formulas

Maɓallin haɗin da za a iya amfani dashi don nuna dabarar ita ce: Ctrl + `(maɓallin ƙarar murya) A kan mafi yawan maɓallin keɓaɓɓeccen maɓalli, maɓallin ƙararrakin kabari yana kusa da maɓallin lamba 1 a saman hagu na kusurwar keyboard kuma yana kama da baya apostrophe. Nuna Formulas ta amfani da Hanyar gajeren hanya Misali Latsa ka riƙe maɓallin Ctrl a kan maɓallin Latsawa ka kuma saki maɓallin ƙarar maɓallin kabari (`) a kan keyboard ba tare da saki da maɓallin Ctrl Saki maɓallin Ctrl ba Game da nuna dabarar Nuna samfurori bazai canza layin rubutu ba, kawai hanyar da aka nuna. Yana sa sauƙin samun samfurori da ke da siffofi Yana ba ka damar karantawa ta hanyar dukkanin matakan don bincika kurakurai Lokacin da ka danna kan wani tsari, Excel ya tsara a cikin launi da aka yi amfani da su a cikin tsarin. Wannan yana taimaka maka ka gano bayanan da aka yi amfani dasu a cikin wani tsari. Fitar da takardun shaida tare da nuna nau'ukan da aka kunna. Yin haka, zai ba ka damar bincika ɗakunan rubutu don wuya a sami kurakurai. Kara "

08 na 27

Hanyar Hanyar Hanya ta Excel ta Excel - Share

Wannan koyarwar maɓallin hanya ta hanyar Excel ta nuna maka yadda za a "canza" canje-canjen da aka sanya zuwa ga takardar aikin Excel.

Koyarwar da suka shafi wannan: Tasirin Excel ta Musamman .

Note: Yana da mahimmanci ka tuna cewa lokacin da kake amfani da Undo, yana "cirewa" ayyukanka a daidai wannan tsari da ka yi amfani da su.

Maɓallin haɗin gajeren hanyar amfani da su don "gyara" canje-canje shine:

• Ctrl + " Z "

Misali na Yadda za a Sauya Canje-canje ta yin amfani da Hanyoyin Hoto

1. Rubuta wasu bayanai a cikin tantanin halitta , kamar A1 a cikin maƙallan rubutu kuma danna maɓallin Shigar da ke keyboard.
   
   
2. Latsa wannan tantanin halitta don sa shi tantanin halitta mai aiki .
   
   
3. Danna kan shafin yanar gizo na kintinkiri .
   
   
4. Yi amfani da wadannan zaɓuɓɓukan tsarawa zuwa bayananka:
   • canza launin launi,
   • fadada shafi,
   • layi,
   • canza nau'in rubutu zuwa Arial Black,
   • cibiyar daidaita batun
   
   
5. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
   
   
6. Latsa kuma saki harafin " Z " a kan keyboard.
   
   
7. Bayanai a cikin tantanin halitta ya kamata ya canza zuwa hagu na hagu kamar yadda canje-canje na ƙarshe (tsakiya ya daidaita) ya ƙare.
   
   
8. Latsa ka riƙe ƙasa maɓallin Ctrl a kan keyboard.
   
   
9. Latsa kuma saki harafin " Z " a kan keyboard sau biyu ba tare da sake maɓallin Ctrl ba .
   
   
10. Ba wai kawai za a cire bayanan layi ba amma sigar ɗin ba zata zama Arial Black ba.
    
    
11. Wannan yana faruwa ne saboda, kamar yadda aka ambata a sama, ƙaddamar da ɓangaren "ya ɓoye" ayyukanku a ainihin baya domin ku yi amfani da su.
    
    

Ƙarin Koyarwar Hanyoyin Hoto na Ƙungiyar Excel

• Ƙara lokaci na yanzu
• Zaɓi Ƙananan Yankuna a Excel
• ALT - TAB Saurin Sauyawa a cikin Windows

Kara "

09 na 27

Zaɓan Ƙananan Yankuna

Zaɓi Ƙananan Yankuna a Excel

Tutorial da suka shafi: Zaɓi Ƙananan Ƙunƙwasa ta Amfani da Keyboard da Mouse

Ta zaɓin ƙwayoyin sel a cikin Excel za ka iya share bayanai, aiwatar da tsarin kamar iyakoki ko shading, ko kuma amfani da wasu zaɓuɓɓuka zuwa manyan sassan aiki ɗaya a lokaci guda.

A wasu lokuta waɗannan kwayoyin ba su samuwa a cikin shinge mai mahimmanci. A cikin waɗannan yanayi akwai yiwuwa a zaɓar wadanda ba a kusa ba.

Ana iya yin wannan ta amfani da keyboard da linzamin kwamfuta tare ko kawai amfani da keyboard.

Amfani da Keyboard a Tsarin Dama

Don zaɓar sel ba kusa da kawai keyboard yana buƙatar ka yi amfani da keyboard a Tsarin Dama .

An kunna yanayin ƙaddamar ta latsa maballin F8 akan keyboard. Kuna rufe hanyar ƙarawa ta latsa maɓallin Shift da F8 a kan keyboard tare.

Zaɓi Ƙirƙwarar Ƙasƙwarar Ƙaƙasasshe a Excel Yin Amfani da Keyboard

1. Matsar da siginan siginar zuwa sel ta farko da kake son zaɓar.
2. Latsa kuma saki maɓalli F8 a kan maɓallin keyboard don fara Yanayin Ƙaddamar kuma don haskaka farkon tantanin halitta.
3. Idan ba tare da motsawar siginar ba, latsa ka saki maɓallin Shift + F8 a kan keyboard tare don rufe fitar da yanayin ƙara.
4. Yi amfani da maɓallin arrow a kan keyboard don motsa siginar salula zuwa cell da ke so ka haskaka.
5. Ya kamata a fara ɗaukar wayar farko.
6. Tare da siginar salula a kan tantanin da ke gaba da za a haskaka, sake maimaita matakai 2 da 3 a sama.
7. Ci gaba da ƙara ƙwayoyin zuwa zangon haske ta amfani da maɓallin F8 da Shift + F8 don farawa da dakatar da yanayin ƙaura.

Zaɓin Ƙunƙwasa da Ƙananan Tsuntsaye a cikin Ƙaftaran Amfani da Maɓalli

Bi matakan da ke ƙasa idan filin da kuke so don zaɓar ya ƙunshi cakuda kusa da mutum kamar yadda aka nuna a hoton da ke sama.

1. Matsar da siginan siginar zuwa sel na farko a cikin rukuni na sel da kake so ka haskaka.
2. Latsa kuma saki maɓalli F8 a kan maɓallin keyboard don fara Yanayin Ƙaura .
3. Yi amfani da makullin maɓallin keɓaɓɓiyar maɓallin keɓaɓɓiyar ƙirar don ƙara ƙaddamar da kewayawa don haɗawa da dukkan kwayoyin jikinsu.
4. Tare da dukkanin sel a cikin rukunin da aka zaɓa, latsa kuma saki maɓallin Shift + F8 a kan maɓallin keyboard tare don rufe na'urar ƙare.
5. Yi amfani da makullin maɓallin kewayawa a kan keyboard don motsa maɓallin siginan kwamfuta daga ƙungiyar da aka zaba daga cikin sel.
6. Ƙungiyar farko ta sel ya kamata a kasance da haske.
7. Idan akwai wasu rukunin rabawa wanda kuke so su haskaka, matsa zuwa tantanin farko a cikin rukuni kuma sake maimaita matakai 2 zuwa 4 a sama.
8. Idan akwai kwayoyin kowannen da kake son ƙarawa zuwa tashar haske, yi amfani da saitin farko na umarnin da ke sama don nunawa ƙwayoyin sel guda ɗaya.

Kara "

10 na 27

Zaɓi Siffofin da ba a Yamma ba a Excel da Keyboard da Mouse

Tutorial da suka shafi: Zaɓin ƙananan ƙwayoyin amfani Amfani da Keyboard

Ta zaɓin ƙwayoyin sel a cikin Excel za ka iya share bayanai, aiwatar da tsarin kamar iyakoki ko shading, ko kuma amfani da wasu zaɓuɓɓuka zuwa manyan sassan aiki ɗaya a lokaci guda.

Yayin da kake amfani da hanyar zabin ja tare da linzamin kwamfuta don nuna hanzari a fili wani ɓangaren da ke kusa da shi yana iya zama hanyar da ta fi dacewa ta zaɓin fiye da ɗaya cell, akwai lokuta lokacin da sel da kake so ka haskaka ba a haɗe da juna.

Lokacin da wannan ya auku, yana yiwuwa a zaɓar wadanda ba a kusa ba. Ko da yake za a iya yin amfani da ƙwayoyin da ba a kusa ba tare da keyboard , yana da sauƙi don yin amfani da keyboard da linzamin kwamfuta tare.

Zaɓin Ƙunƙun da ba a Yamma ba a Excel

Don taimako tare da wannan misali, duba hoton da ke sama.

1. Danna kan tantanin da farko da kake so ka zaɓa tare da maɓallin linzamin kwamfuta don yin sautin mai aiki .
   
   
2. Saki da maɓallin linzamin kwamfuta.
   
   
3. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
   
   
4. Danna kan sauran kwayoyin da kake son zaɓar su Ba tare da sake danna Ctrl ba .
   
   
5. Da zarar an zaɓi dukkan nau'ikan da ake so, saki maɓallin Ctrl .
   
   
6. Kada a danna ko'ina cikin zane maballin bayan da ka saki maɓallin Ctrl ko za ka share haskaka daga ɗakunan da aka zaba.
   
   
7. Idan ka saki maɓallin Ctrl nan da nan kuma kana so ka haskaka mafi yawan sel, kawai latsa ka riƙe maɓallin Ctrl har yanzu sannan ka danna kan ƙarin cell (s).
   
   

Ƙarin Tutaki na Ƙunƙwasa Gaisuwa

• Ƙara lokaci na yanzu
• Ƙara kwanan wata na yanzu
• ALT - TAB Saurin Sauyawa a cikin Windows

Kara "

11 of 27

ALT - TAB Sauyawa a Windows

Ba kawai hanyar hanya ta Excel ba, ALT - TAB Sauyawa shi ne hanya mai sauri don matsawa tsakanin duk takardun budewa a Windows (Maɓallin Win + Tab a cikin Windows vista).

Yin amfani da keyboard don kammala aikin a kwamfuta yana yawanci fiye da yin amfani da linzamin kwamfuta ko sauran na'ura mai nunawa, kuma ALT - TAB Sauyawa yana ɗaya daga cikin mafi amfani da waɗannan gajerun hanyoyin keyboard.

Amfani da ALT - TAB Sauyawa

1. Bude a kalla biyu fayiloli a Windows. Waɗannan na iya zama fayiloli guda biyu Excel ko Fayil ɗin Excel da fayil na Microsoft Word misali.
   
   
2. Latsa ka riƙe ƙasa Alt maɓallin kewayawa.
   
   
3. Latsa kuma saki maɓallin Tab a kan keyboard ba tare da barin maɓallin Alt ba .
   
   
4. ALT - TAB Saurin Gyarawa ya kamata ya bayyana a tsakiyar kwamfutarka.
   
   
5. Wannan taga ya kamata a ƙunshi wata alama ga kowane takardun da aka bude yanzu a kwamfutarka.
   
   
6. Shafin farko a gefen hagu zai kasance ga takardun yanzu - wanda aka gani akan allon.
   
   
7. Alamar ta biyu daga gefen hagu ya zama alama ta akwatin.
   
   
8. Da ke ƙasa da gumaka ya kamata sunan sunan da aka nuna ta akwatin.
   
   
9. Saki da maɓallin Alt da windows ya kunna ku zuwa takardun da aka nuna.
   
   
10. Don matsawa zuwa wasu takardun da aka nuna a cikin ALT - TAB Fast Switching window, ci gaba da riƙe Alt da Alt yayin da ta danna maɓallin Tab . Kowace matsa ya kamata a motsa akwatin da ya fi dacewa a hagu zuwa dama daga takardu ɗaya zuwa gaba.
    
    
11. Saki da Alt maɓalli lokacin da aka nuna rubutu mai so.
    
    
12. Da zarar ALT - TAB Fast Switching window ya buɗe, za ka iya juya jagorancin akwatin akwatin haske - motsa shi daga dama zuwa hagu - ta hanyar riƙe da maɓallin Shift da maɓallin Alt sannan sannan ta danna maɓallin Tab .

Other Keyboard Gajerun hanyoyi

• Ƙara lokaci na yanzu
• Ƙara kwanan wata na yanzu
• Ɓoye ginshiƙai a cikin Excel

Kara "

12 daga cikin 27

Excel ta tafi zuwa ga mutum

Koyaswar da ke ciki: Excel Name Box Navigation .

Za'a iya amfani da Go to alama a Excel don hanzarta hanzarta zuwa sassa daban-daban a cikin ɗakunan rubutu . Wannan labarin ya haɗa da misali na yadda za a yi amfani da fasalin Go To don matsawa zuwa nau'o'i daban-daban ta amfani da gajeren hanya na keyboard.

Kodayake ba dole ba ga takardun aiki waɗanda ke amfani da wasu ginshiƙai da layuka , don manyan fayilolin rubutu yana iya zama da amfani don samun hanyoyi masu sauƙi don tsalle daga wani yanki na takardar aikinka zuwa wani.

Domin kunna Go to alama ta amfani da keyboard, danna maballin F5

Misali ta amfani da Excel ta Go Don nunawa don Kewayawa:

1. Latsa maɓalli F5 a kan maɓallin kewayawa don ɗaga akwatin Go To akwatin.
2. Rubuta a cikin tantanin halitta game da maƙasudin da ake buƙata a Tsarin Lissafi na akwatin maganganu. A wannan yanayin: HQ567 .
3. Danna maɓallin OK ko latsa maballin ENTER akan keyboard.
4. Akwatin baki wanda ke kewaye da tantanin halitta ya kamata ya yi tsalle zuwa cell HQ567 yana sa shi sabon sabon aiki.
5. Don matsawa zuwa wani cell, sake maimaita matakai 1 zuwa 3.

Tutorials masu dangantaka

• Excel Name Akwatin Kewayawa
• Siffofin Cell a cikin Formulas
• Ƙara Hyperlinks da Alamomin shafi a Excel

Kara "

13 na 27

Excel cika saukar da umurnin

Idan kana buƙatar shigar da wannan bayanai - rubutu ko lambobi - a cikin wasu lambobin da ke kusa a cikin wani shafi , Dokar Ƙaddamarwa za ta iya yin hakan nan da nan ta hanyar amfani da keyboard kawai.

Wannan matsala na Excel ya nuna maka yadda za a yi amfani da umarnin Ƙaddamarwa a cikin ɗakunan Excel ta amfani da gajeren hanya na keyboard.

Babban haɗin da ya shafi Dokar Fill Down shine:

• Ctrl + D

Misali: Amfani da Cika Ƙasa tare da Maɓalli Keyboard

Don taimako tare da wannan misali, duba hoton da ke sama.

1. Rubuta lamba, kamar 395.54 cikin cell D1 a Excel.
   
   
2. Latsa ka riƙe ƙasa da Shift key a kan keyboard
3. Latsa ka riƙe ƙasa maɓallin Down Arrow a kan maballin don ƙaddamar da tantanin halitta daga sel D1 zuwa D7.
4. Saki biyu keys.
5. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
6. Latsa kuma saki maɓallin " D " a kan keyboard.
7. Sel din D2 zuwa D7 ya kamata a cika yanzu da bayanan data kamar tantanin halitta D1.

Other Keyboard Gajerun hanyoyi

• Excel Undo
• Ƙara kwanan wata na yanzu
• Tsarin ranar

Kara "

14 daga 27

Aiwatar da Italics Tsarin

Wannan hoton na Excel ya nuna maka yadda za a yi amfani da tsarin rubutun kalmomi ta amfani da maɓallan gajeren hanya a kan keyboard.

Akwai haɗin maɓalli guda biyu waɗanda za a iya amfani da su don ƙara ko cire tsarin rubutun kalmomi zuwa bayanai:

• Ctrl + " I " makullin
• Ctrl + " 3 " makullin

Misali: Amfani da Hanyar gajere Keɓa don Aiwatar Tsarin Tutsi

Domin taimako tare da wannan misali, duba hoton zuwa dama.

1. Rubuta wasu bayanai a cikin tantanin halitta , kamar E1 a cikin maƙallan rubutu kuma danna maɓallin shigarwa akan keyboard.
   
   
2. Latsa wannan tantanin halitta don sa shi tantanin halitta mai aiki .
   
   
3. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
   
   
4. Latsa kuma saki harafin " I " a kan keyboard.
   
   
5. Ya kamata a tsara fassarar siyarwar bayanai ga bayanai a cikin tantanin halitta.
   
   
6. Latsa kuma saki maɓallin Ctrl + na " I " don sake cire tsarin rubutun.
   
   

Other Keyboard Gajerun hanyoyi

• Ƙara lokaci na yanzu
• Zaɓi Ƙananan Yankuna a Excel
• ALT - TAB Saurin Sauyawa a cikin Windows

15 daga 27

Aiwatar da Tsarin Format

Wannan koyaswar ta shafi yadda za a yi amfani da tsarin tsarawa zuwa gabobin da aka zaɓa ta yin amfani kawai da keyboard:

Formats masu amfani da aka yi amfani da bayanan da aka zaɓa sune:

• wurare biyu
• wannan takaddama a matsayin dubban masu rabawa (,)
• Alamar m (-) don mummunan dabi'u

Maɓallin haɗin da za'a iya amfani dashi don amfani da tsarin jadawalin zuwa bayanai shine:

Ctrl + Shift + ! (maƙalari)

Misali: Yin amfani da gajerar hanya don ƙaddamar da ƙidayar fasali

An nuna wannan misali a cikin hoto a sama

1. Ƙara bayanai masu zuwa zuwa sassan A1 zuwa A4:
   4578.25102 45782.5102 457825.102 4578251.02
2. Sanya siffofin A1 zuwa A4 don zaɓar su
3. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard
4. Latsa kuma saki maɓallin maɓallin alamar mamaki ( ! ) A kan keyboard ba tare da bar Ctrl da Shift keys ba
5. Saki Ctrl da makullin Shift
6. Lambobi a cikin kwayoyin A1 zuwa A4 ya kamata a tsara su duka kawai don nuna kawai wurare guda biyu kawai kawai kodayake yawancin lambobi sun ƙunshi fiye da biyu
7. Kwayoyin ya kamata su sami maƙalar da aka ƙaddara a matsayin mai raba gardama dubban
8. Danna kan kowane daga cikin sel yana nuna lambar da ba a ƙidayar ba a cikin maɓallin tsari a sama da takardun aiki

Other Keyboard Gajerun hanyoyi

• Ƙara kwanan wata na yanzu
• Ƙara lokaci na yanzu
• ALT - TAB Saurin Sauyawa a cikin Windows

Kara "

16 na 27

Aiwatar da Tattalin Kudin

Wannan koyaswar ta shafi yadda za a yi amfani da jadawalin kuɗin da sauri don zaɓuɓɓuka da aka zaɓa ta amfani da keyboard kawai:

Maɓallin haɗin da za'a iya amfani dashi don amfani da tsarin jadawalin zuwa bayanai shine:

• Ctrl + Shift + 4

Misali: Yin amfani da gajerar hanya don ƙoƙarin Aiwatar da Kudin

Domin taimako tare da wannan misali, duba hoton zuwa dama.

1. Ƙara bayanai masu zuwa zuwa sassan A1 zuwa B2: 7.98, 5.67, 2.45, -3.92
   
   
2. Jawo zaɓi Kwayoyin A1 zuwa B2 don haskaka su.
   
   
3. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard.
   
   
4. Latsa kuma saki maɓallin lamba huɗu ( 4 ) a kan keyboard ba tare da yada Ctrl da Shift keys ba.
   
   
5. A cikin sassan A1, A2, da B1 da alamar dollar ( $ ) ya kamata a kara da su zuwa ga bayanai.
   
   
6. A cikin salula B2, saboda bayanan yana da lambar mummunan, ya kamata ya zama ja kuma kewaye da baka na baka banda samun alamar dollar ( $ ).
   
   

Other Keyboard Gajerun hanyoyi

• Ƙara kwanan wata na yanzu
• Ƙara lokaci na yanzu
• ALT - TAB Saurin Sauyawa a cikin Windows

Kara "

17 na 27

Aiwatar Kashi Gyara

Wannan hoton na Excel ya shafi yin amfani da Tsarin Halitta zuwa ɗakunan da aka zaɓa a cikin ɗakunan Excel ɗin ta amfani da maɓallin gajeren hanyoyi a kan keyboard.

Maɓallin haɗin da za'a iya amfani dashi don amfani da tsarin jadawalin zuwa bayanai shine:

• Ctrl + Shift + 5

Misali na Yadda za a Aiwatar da Kashi Tsarin ta amfani da Keɓaɓɓun Hoto

Don taimako tare da wannan misali, duba hoton da ke sama.

1. Ƙara bayanai masu zuwa zuwa sassan A1 zuwa B2: .98, -.34, 1.23, .03
   
   
2. Jawo zaɓi Kwayoyin A1 zuwa B2 don haskaka su.
   
   
3. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard.
   
   
4. Latsa kuma saki maɓallin lamba biyar ( 5 ) a kan keyboard ba tare da saki Ctrl da Shift keys ba.
   
   
5. A cikin sassan A1 zuwa B2 ya kamata a canza bayanai zuwa kashi tare da alamar kashi ( % ) da aka haɗa zuwa bayanan.

Ƙarin Tutaki na Ƙunƙwasa Gaisuwa

• Aiwatar da Tattalin Kudin
• Aiwatar da Italics Tsarin
• Ƙara Borders a Excel

Kara "

18 na 27

Zaži Duk Cells a cikin Bayanin Bayanin Excel

Wannan hoton na Excel yana rufe yadda za a zabi dukkan kwayoyin halitta a cikin tarin bayanai na Excel ta amfani da gajeren hanya na keyboard. Yin haka yana ba ka damar amfani da canje-canje irin su tsarawa, nassin shafi, da dai sauransu zuwa takarda aiki duk lokaci daya.

Abubuwan da ke da dangantaka: Samar da wani Data Data a Excel .

Lura: Domin taimako tare da wannan misali, duba hoton zuwa dama.

Misalin yadda za a zabi dukkanin salula a cikin bayanan Data

1. Bude takaddun aiki na Excel dauke da tebur bayanai ko ƙirƙirar tebur bayanai .
   
   
2. Danna kan kowane tantanin halitta a cikin tarin bayanai.
   
   
3. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
   
   
4. Latsa kuma saki harafin " A " a kan maɓallin keyboard ba tare da bari Ctrl ba .
   
   
5. Dukkanin da ke cikin lissafin bayanai ya kamata a haskaka.
   
   
6. Latsa kuma saki wasika " A " a karo na biyu.
   
   
7. Dole ne a zana hoton layin jigilar bayanai tare da layin bayanai.
   
   
8. Latsa kuma saki wasika " A " a karo na uku.
   
   
9. Dukkanin sassan aiki a cikin takardun aiki ya kamata a haskaka.

Other Keyboard Gajerun hanyoyi

• Zaɓi Ƙananan Yankuna a Excel
• Ƙara Borders a Excel
• Ɓoye ginshiƙai a cikin Excel

Kara "

19 na 27

Zaži Salon gaba ɗaya a cikin Ƙaƙwalwar Hanya ta Hanyar Hanya

Zaɓi Lissafi a cikin takarda

Wannan hoton na Excel yana nuna yadda za a zabi ko zazzage kowane jeri a cikin takardun aiki ta amfani da makullin gajeren maɓallin kewayawa a cikin Excel.

Maɓallin haɗin da ake amfani dashi don zaɓar jere shine:

SHIFT + SPACEBAR

Misali: Yin amfani da gajerar hanya don ƙaddamar da jigon Hanya Kayan aiki

1. Bude Ɗaukar Hanya na Excel - Babu buƙatar zama duk wani bayanan da aka ba shi
2. Danna kan tantanin halitta a cikin takardun aiki - kamar A9 - don sa shi tantanin halitta mai aiki
3. Latsa ka riƙe ƙasa maɓallin SHIFT akan keyboard
4. Latsa ka kuma saki maɓallin SPACEBAR a kan keyboard ba tare da yada maɓallin SHIFT ba
5. Saki da maɓallin SHIFT
6. Dukkanin jinsin da aka zaɓa ya kamata a haskaka - ciki har da maƙallin jigo

Kara "

20 na 27

Ajiye a Excel

Hanyoyin Ajiyayyen Hoto na Excel

Wannan shafin na Excel yana rufe yadda za a adana bayanai ta hanyar amfani da makullin gajeren maɓallin kewayawa a cikin Excel.

Maɓallin haɗin da za a iya amfani dasu don ajiye bayanai shine:

Ctrl + S

Misali: Yin amfani da gajerar hanya don ɗaukar takardun aiki

1. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard
2. Latsa kuma saki harafin ( S ) a kan keyboard ba tare da bar maɓallin Ctrl ba
3. Saki da maɓallin Ctrl

Ajiye lokaci na farko

Idan ka riga ka ajiye takardun aikin aiki kawai nuna cewa Excel yana adana fayil ɗinka zai iya canza maƙarƙircin linzamin ɗan gajeren lokaci a cikin gunkin hourglass sa'annan ya koma zuwa alamar fararen al'ada.

Tsawon lokaci madogarar madogara na madogara yana dogara da yawan adadin bayanai na Excel dole ne ya ajiye. Mafi yawan adadin bayanai don ajiyewa, da ya fi tsayi da alamar hourglass zai kasance bayyane.

Idan kana adana takardun aiki na farko da Ajiye As dialog box zai bude.

Lokacin da aka ajiye fayil a karo na farko guda biyu na bayanai dole ne a ƙayyade a Ajiye Kamar yadda akwatin maganganu:

• sunan fayil ɗin (har zuwa haruffa 255 ciki har da sarari)
• wurin (babban fayil) inda za a adana fayil ɗin

Ajiye Sau da yawa

Tun da amfani da maɓallin Ctrl + S makullin hanya ce mai sauƙi don ajiye bayanai yana da kyakkyawar ra'ayin adanawa akai-akai - akalla kowane minti biyar - don kauce wa asarar bayanai a yayin da wani hadarin kwamfuta ya faru. Kara "

21 na 27

Ɓoye da Bayyana ginshiƙai da Layuka a Excel

22 na 27

Tsarin ranar

Wannan hoton na Excel yana nuna maka yadda za a tsara kwanan wata (rana, wata, shekara) a cikin takardun Excel ta amfani da gajeren hanya na keyboard.

Tsarin ranar da ke amfani da Ƙamus ɗin Ƙamus

1. Ƙara kwanan wata da ake so zuwa tantanin halitta a cikin takarda na Excel.
   
   
2. Danna kan tantanin halitta don sa shi tantanin halitta mai aiki .
   
   
3. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard.
   
   
4. Latsa kuma saki maɓallin alamar lambar ( # ) a kan keyboard ba tare da yada Ctrl da Shift keys ba.
   
   
5. Kwanan wata a cikin tantanin halitta mai aiki zai tsara cikin kwanan wata, wata, shekara.
   
   

Other Keyboard Gajerun hanyoyi

• Ƙara kwanan wata na yanzu
• Ƙara lokaci na yanzu
• ALT - TAB Saurin Sauyawa a cikin Windows

Kara "

23 na 27

Tsarin lokaci na yanzu

Wannan hoton na Excel ya nuna maka yadda za a tsara yanayin yanzu (sa'a, minti, da AM / PM) a cikin wani furofayil na Excel ta amfani da gajeren hanya na keyboard.

Sanya lokaci na yanzu ta amfani da maɓallin Ƙunƙwasa

1. Yi amfani da aikin NOW don ƙara kwanan wata da lokaci zuwa cell D1.
   
   
2. Danna kan tantanin halitta D1 don sa shi tantanin halitta mai aiki .
   
   
3. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard.
   
   
4. Latsa kuma saki lambar biyu ( 2 ) a kan keyboard ba tare da saki Ctrl da Shift keys ba.
   
   
5. Ayyukan NOW a cikin tantanin halitta D1 za'a tsara don nuna halin yanzu a cikin sa'a, minti, da kuma AM / PM.
   
   

Other Keyboard Gajerun hanyoyi

• Excel Undo
• Ƙara kwanan wata na yanzu
• Tsarin ranar

Kara "

24 na 27

Canja tsakanin Tsama'i

A matsayin madadin yin amfani da linzamin kwamfuta, yana da sauƙi don amfani da gajeren hanya na keyboard don sauyawa tsakanin ɗigon ayyuka a cikin Excel.

Maballin da aka yi amfani da shi shine maɓallin CTRL tare da ko dai PGUP (shafi na sama) ko maɓallin PGDN (shafi na ƙasa)

Misali - Canja tsakanin Siffofin aiki a Excel

Don matsawa zuwa dama:

1. Latsa ka riƙe ƙasa maɓallin CTRL a kan keyboard.
2. Latsa kuma saki maɓallin PGDN (shafi na ƙasa) a kan keyboard.
3. Don matsar da wata takarda a hannun dama kuma latsa maɓallin PGDN a karo na biyu.

Don matsawa zuwa hagu:

1. Latsa ka riƙe ƙasa maɓallin CTRL a kan keyboard.
2. Latsa kuma saki PGUP (shafi na sama) a kan keyboard.
3. Don matsar da wani takarda zuwa hagu na hagu kuma saki maɓallin PGUP a karo na biyu.

Other Keyboard Gajerun hanyoyi

• Ɓoye ginshiƙai a cikin Excel
• Ɓoye Layuka a Excel
• Ƙara kwanan wata na yanzu

Lura: Don zaɓar ɗawainiya masu yawa ta amfani da keyboard, latsa: Ctrl + Shift + PgUp don zaɓar shafukan zuwa hagu Ctrl + Shift + PgDn don zaɓar shafukan zuwa dama Ƙari »

25 na 27

Shirya sigogi tare da maɓallin aikin F2

Ƙararren Ƙararrakin Ƙararrakin Excel

Maballin aikin F2 yana baka damar saurin bayanai na tantanin halitta ta sauri da sauƙi ta hanyar kunna hanyar gyaran hanyar Excel kuma sanya matsayi a cikin ƙarshen abun ciki na sirri mai aiki.

Misali: Yin Amfani da F2 Key don Shirya Abubuwan Cikin Cell

Wannan misali yana nuna yadda za a shirya wata maƙalli a Excel

1. Shigar da wadannan bayanan cikin sel 1 zuwa D3: 4, 5, 6
2. Danna kan tantanin halitta E1 don sa shi tantanin halitta mai aiki
3. Shigar da wannan maƙirarin zuwa cikin cell E1:
   = D1 + D2
4. Latsa maɓallin shigarwa a kan keyboard don kammala wannan tsari - amsar 9 ya kamata ya bayyana a cikin cell E1
5. Danna kan tantanin halitta E1 don sake mayar da shi tantanin halitta
6. Latsa maballin F2 akan keyboard
7. Excel ta shiga yanayin gyaran kuma an sanya maɓallin sakawa a ƙarshen wannan tsari
8. Gyara dabara ta ƙara + D3 zuwa ƙarshen shi
9. Latsa maɓallin shigarwa a kan keyboard don kammala wannan dabara kuma bar hanyar gyare-gyaren - sabon jimlar don tsari - 15 - ya kamata ya bayyana a cikin cell E1

Lura: Idan zaɓin zaɓi don ba da izinin gyarawa a cikin sel an kashe, danna maballin F2 zai sa Excel a yanayin gyare-gyaren, amma za a sanya maɓallin sakawa zuwa maɓallin tsari a sama da takardun aiki don gyara abubuwan ciki na cell. Kara "

26 na 27

Zaži Duk Cells a cikin Ɗaukar Hanya na Excel

27 na 27

Ƙara Borders

Wannan hoton na Excel yana rufe yadda za a ƙara iyaka zuwa ɗakunan da aka zaɓa a cikin furotin na Excel ta amfani da gajeren hanya na keyboard.

Koyarwar da ke ciki: Ƙara / Tsarin Borders a Excel .

Babban haɗin don ƙara lokaci shine:

Ctrl + Shift + 7

Misali na Yadda za a Ƙara Borders ta amfani da Maɓalli Keyboard Shortcut

Domin taimako tare da wannan misali, duba hoton zuwa dama.

1. Shigar da lambobi 1 zuwa 9 zuwa cikin sel D2 zuwa F4.
   
   
2. Jawo zaɓi Kwayoyin D2 zuwa F4 don haskaka su.
   
   
3. Latsa ka riƙe ƙasa da Ctrl da maɓallin Shift a kan keyboard.
   
   
4. Latsa kuma saki maɓallin lambar bakwai ( 7 ) a kan keyboard ba tare da bar Ctrl da Shift keys ba.
   
   
5. Sel ɗin D2 zuwa F4 ya kamata a kewaye da iyakar baki.
   
   

Other Keyboard Gajerun hanyoyi

• Ƙara kwanan wata na yanzu
• Zaɓi Ƙananan Yankuna a Excel
• Ƙara lokaci na yanzu

Kara "