Excel Shortcuts

Excel Shortcut Ukuhlanganiswa Okubalulekileyo kwizixhobo eziqhelekileyo kunye nezixhobo

Funda konke malunga nezitshixo ezifutshane, kuquka ukudibanisa ukusetyenziswa kwe-Excel kwisakhono esipheleleyo.

01 ngo-27

Faka iWindows Worksheet kwi-Excel

Inqaku le-Excel libonisa indlela yokufaka ifomethi entsha kwincwadi yokusebenzela usebenzisa i-shortcutcut yebhobhobhodi. Faka iWindows Worksheet entsha usebenzisa i-Keyboard Shortcut Press kwaye ubambe iqhosha le-SHIFT kwibhodibhodi. Cinezela kwaye ukhiphe iqhosha le-F11 kwikhibhodi. Iphepha lokusebenzela elitsha liya kufakwa kwincwadi yokusebenza yangoku. Ukongeza ii-worksheets ezongezelelweyo ziyaqhubeka ukucofa nokukhupha iqhosha le-F11 ngelixa ugcina phantsi iqhosha le-SHIFT. Kaninzi "

02 we-27

Gxiba Umbhalo kwiiLilidi ezimbini kwi-Excel

Gqalela itekisi kwiseli Ukuba ufuna ukuba umbhalo uvele kwiimizila emininzi kuseli, ungayifomatha iseli ukuze umbhalo ubhalwe ngokuzenzekelayo, okanye ungangena umgca wendlela. Ingaba ufuna ntoni? Ukubhalwa kwombhalo ngokuzenzekelayo Faka umgca wecala Ukubhaliweyo ngombhalo ngokuzenzekelayo Kwiphepha lokusebenzela, khetha iiseli ofuna ukufometha. Kwiphepha laseKhaya, kwiqela lokuHlanganisa, nqakraza umgca wefowuni yombhalo. I-Excel Ribbon Image Image Notes kwi-cell wraps ukuze uvumelane nobubanzi bekholomu. Xa utshintsha ububanzi bekholomu, ukulungiswa kwedatha kulungisa ngokuzenzekelayo. Ukuba yonke into ehlanganiswe ngombhalo ayibonakali, mhlawumbi kuba umgca uhlelwe kwindawo ephakamileyo okanye ukuba umbhalo ubhalwe kwiiseli ezidibeneyo. Ukwenza konke okubhalwe ngumbhalo obonakalayo, yenza oku kulandelayo ukulungisa ukuphakama komgca: Khetha iseli okanye uluhlu ofuna ukulungisa ukuphakama komgca. Kwiphepha laseKhaya, kwiqela leeSeli, nqakraza iFomathi. I-Excel Ribbon Image Ngaphantsi kwe-Cell Size, yenza enye yezi zinto zilandelayo: Ukuzilungisa ngokuzenzekelayo ukuphakama komgca, nqakraza i-AutoFit Row Height. Ukucacisa ukuphakama komgca, nqakraza ububanzi beRow, uze uthayiphe ukuphakama komgca owufunayo kwibhokisi eliphakamileyo leRow. Iphulo Unokutsala umda ongaphantsi komqolo ukuya ekuphakameni okubonisa konke okubhalwe ngombhalo. Phezulu kwekhasi Phezulu kwekhasi Faka umgca womgca Ungaqalisa umgca omtsha weetekisi kwiphina inqaku elithile kwiseli. Nqakraza kabini iseli apho ufuna ukungena kumgca wendlela. Iqhosha lekhibhodi Ungakhetha kwakhona iseli, uze ucinezele iF2. Kwiseli, nqakraza indawo apho ufuna ukuphula umgca, uze ucinezele i-ALT + ENTER.

Isicatshulwa sombhalo we-Excel yinto ephathekayo yokufometha evumela ukuba ulawule ukubheka kweelayibhile kunye nezihloko kwi- spreadsheet yakho.

Ukubhaliweyo kwombhalo kukuvumela ukuba ufake umbhalo kwiindlela ezininzi kwiiselithi enye kunokubhala isicatshulwa kwiiseli ezininzi kwiphepha lokusebenzela .

Ixesha elithi "lobuchwepheshe" lo mbhalo ukubhala umbhalo kunye nencoko ebalulekileyo yokubhala umbhalo:

Alt + Ngena

Umzekelo: Sebenzisa iiNqamlezo zemiNqampu yokuBhala umbhalo

Umzekelo usebenzisa isicatshulwa sombhalo we-Excel:

1. Kwiseli D1 thayipha itekisi: Imali Yenyanga kunye nokucofa iqhosha lokungena kwikhibhodi.
2. Ekubeni isicatshulwa side kakhulu kwiseli, kufuneka siphululele kwi-cell E1.
3. Kwi-cell E1 thayipha itekisi: Iindleko zenyanga kwaye ucinezela ukhiye wokungena kwikhibhodi.
4. Ngokungena kwedatha kwi-E1 ilebula kwiseli D1 kufuneka inqunywe ekupheleni kweseli D1. Kwakhona, itekisi e-E1 kufuneka ichithe kwi-cell ukuya kwesokudla.
5. Ukulungisa iingxaki ngala malebula, qinisa iiseli D1 ne-E1 kwiphepha lokusebenzela.
6. Cofa kwiTebhu yeKhaya .
7. Cofa kwiComputer Inkinobho kwi- Ribbon .
8. Iibhile eziseli D1 kunye ne-E1 zimele zibonwe ngokubini ngokubhaliweyo kwimbhalo ephule emigqeni emibini ngaphandle kokuhlawulela kwiiseli eziseduze.

Isicatshulwa sombhalo we-Excel yinto ephathekayo yokufometha evumela ukuba ulawule ukubheka kweelayibhile kunye nezihloko kwi-spreadsheet yakho. Kunokuba ukwandise iikholomu zomsebenzi ukwenza izihloko ezide zibonakala, ukugoba umbhalo kukuvumela ukuba ufake umbhalo kwiindlela ezininzi kwiiselinye enye. I-Excel's Wrap Text Example Ukufumana uncedo kulo mzekelo, bonani umfanekiso ongentla. Kwiseli G1 thayipha itekisi: Imali Yenyanga kwaye cinezela ENTER kwikhibhodi. Ekubeni iNgeniso yeNyanga ide kakhulu kwiseli yayo, iya kuhlawulela kwisisele H1. Kwiseli H1 thayipha umbhalo: Iindleko zenyanga kwaye cinezela ENTER kwikhibhodi. Xa idatha ingeniswa kwi-cell H1 yokuqala yebhile Inkcitho yeNyanga nganye kufuneka inqunywe. Ukulungisa ingxaki, dotshela iiseli G1 kunye ne-H1 kwi-spreadsheet ukuze ukhanyise. Cofa kwiTebhu yeKhaya. Cofa kwiComputer Inkinobho kwi-Ribbon. Iilebhile kumaseli G1 kunye ne-H1 kufuneka ngoku ngoku ziboniswe ngokucacileyo ngetekisi ephule emigqeni emibini ngaphandle kokuhlawulela kwiiseli eziseduze.

Le tutorial ihlanganisa indlela yokuthayipha imigca emininzi kwiseli yomsebenzi omnye.

Ixesha elithi "lobuchwepheshe" lo mbhalo ukubhala umbhalo kunye nencoko ebalulekileyo yokubhala umbhalo:

Alt + Ngena

Umzekelo: Sebenzisa iiNqamlezo zemiNqampu yokuBhala umbhalo

Ukusebenzisa isicatshulwa sombhalo we-Excel usebenzisa kuphela ikhibhodi:

1. Cofa kwiseli apho ufuna ukuba umbhalo ube khona
2. Thayipha umgca wokuqala wobhaliweyo
3. Cinezela kwaye ubambe iqhosha lase Alt kwikhibhodi
4. Cinezela kwaye ukhulule ukhiye wokungena kwikhibhodi ngaphandle kokukhipha ikhiye ye-Alt
5. Ukukhululwa kwe-Alt key
6. Inqaku lokufakela kufuneka lihambe kumgca ongaphantsi kwitheyibhile engenayo
7. Thayipha umgca wesibini wombhalo
8. Ukuba unqwenela ukungena kweminye imigca yesicatshulwa, qhubeka ucofa u- Alt + Enter ekupheleni komgca ngamnye
9. Xa zonke izibhalo zifakiwe, cindezela ukhiye wokungena kwikhibhodi okanye nqakraza nge mouse ukuze uye kwenye enye iseli

Kaninzi "

03 wama-27

Yongeza Umhla Okhoyo

Le tutorial ihlanganisa indlela yokongeza ngokukhawuleza umhla okhoyo kwiphepha lokusebenzela usebenzisa kuphela ikhibhodi.

Intlangano ebalulekileyo yokongeza umhla:

Ctrl + ; (iqhosha le-colon elincinane)

Umzekelo: Sebenzisa iiNqamlezo zemiNqampu yokongeza Umhla wamanje

Ukongeza umhla wamanje kwiphepha lokusebenzela usebenzisa kuphela ikhibhodi:

1. Cofa kwiseli apho ufuna usuku luhambe khona.
2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
3. Cinezela kwaye ukhulule iqhosha le-colon ( ; ) kwikhibhodi ngaphandle kokukhipha ikhiye ye Ctrl.
4. Ukukhulula ikhiye ye Ctrl.
5. Umhla wamanje kufuneka udibaniswe kwiphepha lokusebenzela kwisisele ekhethiweyo.

Qaphela: Le nkqubela yebhobhobhodi ayisebenzisi umsebenzi we- TODAY ukuze loo mhla ungatshintshi rhoqo xa iphepha lokusebenzela livuliwe okanye lilungiswa kwakhona. Kaninzi "

04 wama-27

Idatha yeSumer kwi-Excel usebenzisa iiNqamlezo ezifutshane

Idatha yeSumer kwi-Excel usebenzisa iiNqamlezo ezifutshane

Esi sihloko sichaza indlela yokukhawuleza ukungena kwi -SUM umsebenzi we-SUM ukuze ungeze idatha usebenzisa iifotshane zokunqakraza kwikhibhodi.

Inhlanganisela ebalulekileyo yokufaka umsebenzi we-SUM ngu:

" Alt " + " = "

Umzekelo: Ukufaka umsebenzi we-SUM usebenzisa i-Shortcut Keys

1. Faka idatha elandelayo kwiiseli D1 ukuya ku-D3 kwiphepha lokusebenzela lase-Excel: 5, 6, 7
2. Ukuba kuyimfuneko, nqakraza kwi-cell D4 ukwenza i- cell esebenzayo
3. Cinezela kwaye ubambe iqhosha lase Alt kwikhibhodi
4. Cinezela kwaye ukhulule uphawu olulinganayo ( = ) kwikhibhodi ngaphandle kokukhulula ikhiye ye- Alt
5. Ukukhululwa kwe- Alt key
6. Umsebenzi we-SUM kufuneka ungeniswe kwi-cell D4 kunye nodidi lwe- D1: D3 igxininiswe njengengxabano yomsebenzi
7. Cinezela ukhiye wokungena kwikhibhodi ukugqiba umsebenzi
8. Impendulo 18 kufuneka ibonakale kwiseli D4
9. Xa ucofa kwi-cell D4 umsebenzi opheleleyo = ISUM (D1: D3) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

Le ndlela emfutshane ingasetyenziselwa ukuqokelela idatha kwimigca kunye neikholomu.

Qaphela : I-SUM yenzelwe ukuba ifakwe phantsi kwekholomu yedata okanye ekupheleni kwesigcaziso sedatha.

Ukuba umsebenzi we-SUM ungeniswe kwenye indawo ngaphandle kwezi zimbini, uluhlu lweeseli ezikhethiweyo njengengxabano yomsebenzi lungafanelekanga.

Ukutshintsha uluhlu olukhethiweyo, sebenzisa i-pointer yemouse ukugqamisa uluhlu oluchanekileyo ngaphambi kokucofa iqhosha lokungena ukugqiba umsebenzi ngakumbi.

05 ka 27

Ukongeza ixesha langoku

Le tutorial ihlanganisa indlela yokongeza ngokukhawuleza ixesha langoku kwiphepha lokusebenzela usebenzisa kuphela ikhibhodi:

Intlangano ebalulekileyo yokongeza ixesha:

I-Ctrl + Shift + : (ikhiye yekholoni)

Umzekelo: Sebenzisa iiNqamlezo zemiNqampu yokongeza Ixesha langoku

Ukongeza ixesha langoku kwiphepha lokusebenzela usebenzisa kuphela ikhibhodi:

1. Cofa kwiseli apho ufuna ixesha lokuhamba.
   
   
2. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
   
   
3. Cinezela kwaye ukhulule iqhosha lekholoni (:) kwibhodibhodi ngaphandle kokukhulula iifayile zeCtrl kunye neShift .
   
   
4. Ixesha langoku liya kwongezwa kwi-spreadsheet.
   
   

Qaphela: Le ndlela yokuncinci yebhobhokhi ayifuni ukusebenzisa umsebenzi OWA MANJE ukuze umhla ungatshintshi rhoqo xa iphepha lephepha livuliwe okanye lilungiswa kwakhona.

Ezinye zeNqakrazo zeeNqununu zeziThuthi

• Ukongeza Umhla wamanje
• Khetha ii-Non-Adjacent Cells kwi-Excel
• ALT - TAB Ukutshintshwa kwiWindows

Kaninzi "

06 we-27

Faka i-Hyperlink

Faka i-Hyperlink kwi-Excel usebenzisa iiNqamlezo ezifutshane

Izifundo ezihambelanayo : Faka iiHlinklink kunye neeMpawu zeMpawu kwi-Excel

Inqaku le-Excel lihlanganisa indlela yokufaka ngokukhawuleza i-hyperlink kwisicatshulwa esikhethiweyo usebenzisa izitshixo ezinqumla kwi-Excel.

Inhlanganisela ebalulekileyo engasetyenziselwa ukufaka i-hyperlink yile:

Ctrl + k

Umzekelo: Faka i-Hyperlink usebenzisa i-Shortcut Keys

Uncedo ngale miyalelo nqakraza kumfanekiso ongentla

1. Kwiphepha lokusebenzela lase-Excel cakraza kwi-cell A1 ukwenza i- cell esebenzayo
2. Thayipha igama ukuba usebenze njengombhalo we-anchor njengeSpredishithi kwaye cinezela iqhosha lokungena kwikhibhodi
3. Cofa kwifowuni A1 ukuyenza kwakhona iseli esebenzayo
4. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi
5. Cinezela kwaye ukhulule incwadi ( k ) ukhiye kwikhibhodi ukuvula ibhokisi yencoko ye- Hyperlink ibhokisi
6. Kwile dilesi: umgca kwizantsi kwibhokisi yencoko yebhokisi yencoko i-URL epheleleyo njenge:
   http://spreadsheets.about.com
   
7. Cofa u-Ok ugcwalise i hyperlink uze uvale ibhokisi yencoko
8. Umbhalo we-anchor kwiseli ye-A1 kufuneka ngoku ngokuluhlaza okwesibhakabhaka kumbala kwaye ucacisiwe ngokubonisa ukuba uqulethelwano

Ukuvavanya i-Hyperlink

1. Beka isikhombisi semouse phezu kwe-hyperlink kwi-cell A1
2. Isalathisi selotshi kufuneka sitshintshe kwisimboli sandla
3. Cofa kwi-hyperlink text anchor
4. Isikhangeli sakho sewebhu kufuneka sivule kwiphepha elichongwe nge-URL

Susa i-Hyperlink

1. Beka isikhombisi semouse phezu kwe-hyperlink kwi-cell A1
2. Isalathisi selotshi kufuneka sitshintshe kwisimboli sandla
3. Ngcofa ngakwesokudla kwimbhalo ye-anchor ye-hyperlink ukuvula imenyu ye- Context drop down
4. Cofa kuChotho lwe-Hyperlink kwimenyu
5. Umbala obomvu kunye nesigxina kufuneka kususwe kumbhalo we-anchor obonisa ukuba i-hyperlink isusiwe

Ezinye iifutshane zebhodi zekhibhodi

Faka isicelo sokufometha kwemali

Ukusebenzisa ukuCwangciswa koBuchule

Yongeza iMingcele kwi-Excel

Kaninzi "

07 we-27

Bonisa iifomula

Inhlanganisela ebalulekileyo engasetyenziselwa ukubonisa iifomula ngu: Ctrl + `(ikhonkco ebhaliweyo engundoqo) Kwiinkalobho ezininzi eziqhelekileyo, iqhosha lempembelelo yengcwaba lifumaneka kwinqanaba lenombolo 1 kwikhoneni eliphezulu lasekhohlo lebhodibhodi kwaye libukeka njengemuva apostrophe. Bonisa iifomula usebenzisa i-shortcuts Keys Example Cindezela kwaye ubambe iqhosha le Ctrl kwikhibhodi Cindezela kwaye ukhulule ikhibhodi yokubhaliweyo yengxolo (`) ukhiye kwikhibhodi ngaphandle kokukhulula ikhiye ye Ctrl Ukukhulula ikhi Ctrl Ngokubonisa iifomula Bonisa iifomula ezingatshintshi ispredishithi, kuphela indlela eboniswa ngayo. Ukwenza kube lula ukufumana iiseli ezinemifomula Ivumela ukuba ufunde ngokukhawuleza kuwo onke amafomula ukujonga iimpazamo Xa ucofa kwifomula, i-Excel ichaza ngombala iiferensi zesetyenzisiweyo ezisetyenziswe kwifom. Oku kunceda ukuba ulandele idatha esebenzayo kwifom. Phrinta ispredishithi kunye namafomula okubonisa. Ukwenza njalo, kuya kukuvumela ukuba uphendule ispredishithi kunzima ukufumana iimpazamo. Kaninzi "

08 ka 27

I-Excel Shortcut Keys - Hlehlisa

Le khosi ye-keycut shortcutcut shows you how to "undo" utshintsho olwenziwe kwiphepha lokusebenzela lase Excel.

Izifundo ezihambelanayo: Isixhobo sokuHlaziya kwe-Excel .

Qaphela: Kubalulekile ukuba ukhumbule ukuba xa usebenzisa i-Hlehlisa, "iyakhupha" izenzo zakho kwi-oda elichanekileyo owalisebenzisayo.

Inhlanganisela yeqhosha elifutshane elisetyenziselwa "ukuguqula" utshintsho ngu:

• Ctrl + " Z "

Umzekelo wendlela yokuHlaziya utshintsho usebenzisa i-Shortcut Keys

1. Thayipha idatha ethile kwiseli , njenge-A1 kwi-spreadsheet kwaye cinezela ukhiye wokungena kwikhibhodi.
   
   
2. Cofa kwilo lisele ukwenza iseli esebenzayo .
   
   
3. Cofa kwikhaya lasekhaya lebhoni .
   
   
4. Faka isicelo kwiindlela ezilandelayo zokufomatha idatha yakho:
   • utshintshe umbala wefonti,
   • ukwandisa ikholomu,
   • gxi ninisa,
   • utshintshe uhlobo lwefonti ku-Arial Black,
   • Iziko lilungelelanise idatha
   
   
5. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
   
   
6. Cinezela kwaye ukhulule incwadi " Z " kwikhibhodi.
   
   
7. Idatha yeseli kufuneka ishintshe ukulungelelaniswa kwesobunxele njengoko utshintsho lokugqibela (ulungelelaniso lwangaphakathi) lucacisiwe.
   
   
8. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi kwakhona.
   
   
9. Cinezela kwaye ukhulule incwadi " Z " kwikhibhodi kabini ngaphandle kokukhulula ikhiye ye Ctrl .
   
   
10. Akuyi kususwa kuphela umnqamlezo kodwa umgca awuyi kuba ngu-Arial Black.
    
    
11. Oku kwenzeka ngenxa yokuba, njengoko kuchaziwe ngasentla, isici sokuhlengahlengisa "sichitha" izenzo zakho kwi-oda elandelelanayo oye wazisebenzisa.
    
    

Ezinye i-Excel Shortcut Keys Tutorials

• Ukongeza ixesha langoku
• Khetha ii-Non-Adjacent Cells kwi-Excel
• ALT - TAB Ukutshintshwa ngokukhawuleza kwiWindows

Kaninzi "

09 we-27

Ukukhetha Amaseli angaqhelekanga

Khetha ii-Non-Adjacent Cells kwi-Excel

I-Tutorial echaphazelekayo: Khetha iiNteli ezingaqhelekanga usebenzisa i-Keyboard kunye neMouse

Ngokukhetha iiseli ezininzi kwi-Excel ungasusa idatha, ufake ifomathi njengemida okanye u-shading, okanye usebenzise ezinye iinketho kwiindawo ezinkulu zephepha lokusebenzela zonke ngexesha elinye.

Ngamanye amaxesha iiseli azikho kwiibhloko ezithintekayo. Kule meko kunokwenzeka ukuba ukhethe amaseli angaqhelekanga.

Oku kungenziwa ngokusebenzisa ikhibhodi kunye ne mouse kunye kunye kuphela usebenzisa ikhibhodi.

Ukusebenzisa i-Keyboard kwiModelo eyongeziweyo

Ukukhetha ii-cell ezingasondelene kunye nebhodibhodi kufuna ukuba usebenzise ikhibhodi kwiModeli eyongeziweyo .

Imodi eyongeziweyo isebenze ngokucinezela iqhosha le- F8 kwikhibhodi. Uvale imodi eyongeziweyo ngokucinezela iifayile zeShift kunye neF8 kwikhibhodi ndawonye.

Khetha iiSeleli ezingaqhelekanga ezingaqhelekanga kwi-Excel usebenzisa i-Keyboard

1. Hambisa isikhombisi seseli kwifowuni yokuqala ofuna ukuyikhetha.
2. Cinezela ukhulule iqhosha le- F8 kwikhibhodi ukuqala Imodi eyongeziweyo kunye nokugqamisa iseli yokuqala.
3. Ngaphandle kokuhambisa isalathisi seeseli, cinezela kwaye ukhulule izitshixo zeShift + F8 kwikhibhodi ndawonye ukuvala imodeli enwetshiwe.
4. Sebenzisa izitshixo zitshixo kwibhobhobho ukuhambisa isalathisi seseli kwisisele elandelayo ofuna ukuyibeka.
5. Isisele sokuqala kufuneka sihlale sigxininiswe.
6. Ngesikhokhelo sesisele kwisisele esilandelayo ukuba sikhankanywe, phinda amanyathelo 2 no-3 ngasentla.
7. Qhubeka ukongeza iiseli kwibala eliqakathekileyo ngokusebenzisa iifayile zeF8 neShift + F8 ukuqala nokuyeka imodeli enwetshiwe.

Ukukhetha iiselithi ezingekhoyo kunye neeNkalo ezingekho kwi-Excel usebenzisa i-Keyboard

Landela amanyathelo angezantsi ukuba uluhlu olufunayo ukhetha luqulethe umxube weeseli ezizimeleyo njengoko kuboniswe kumfanekiso ongentla.

1. Hambisa isikhombisi seseli kwisisele yokuqala kwiqela leeseli ofuna ukuligqamisa.
2. Cinezela kwaye ukhulule iqhosha le- F8 kwikhibhodi ukuqala Imodi eyongeziweyo .
3. Sebenzisa izitshixo zitshixo kwibhodibhodi ukwandisa uluhlu oluqakathekileyo ukubandakanya zonke iiseli kwiqela.
4. Kuzo zonke iiseli kwiqela elikhethiweyo, cinezela kwaye ukhulule izitshixo zeShift + F8 kwikhibhodi ndawonye ukuze ucime imodi eyongeziweyo.
5. Sebenzisa izitshixo zitshixo kwikhibhodi ukuhambisa isikhombisi seseli kude neqela elikhethiweyo leeseli.
6. Iqela lokuqala leeseli kufuneka lihlale libalaselisiwe.
7. Ukuba kukho iiseli ezininzi ezinqwenela ukugqamisa, hlela kwiseli yokuqala kwiqela uze uphinde uphendule amanqanaba 2 ukuya ku-4 ngaphezulu.
8. Ukuba kukho iiseli ngamnye ozifunayo ukongeza kwibala eligqityiweyo, sebenzisa isethi yokuqala yemiyalezo ngasentla ukugqamisa iiseli ezilodwa.

Kaninzi "

10 kwi-27

Khetha ii-Non-Adjacent Cells kwi-Excel kunye nekhibhodi kunye neMouse

I-Tutorial ehambelanayo: Ukukhetha iiselingi ezingezizo eziqhelekileyo usebenzisa i-Keyboard

Ngokukhetha iiseli ezininzi kwi-Excel ungasusa idatha, ufake ifomathi njengemida okanye u-shading, okanye usebenzise ezinye iinketho kwiindawo ezinkulu zephepha lokusebenzela zonke ngexesha elinye.

Ngethuba usebenzisa i-drag drag indlela yokhetho kunye ne mouse ukugqamisa ngokukhawuleza ibhloko yeeseli eziseduze mhlawumbi indlela eqhelekileyo yokukhetha ngaphezulu kwesinye iseli, kukho amaxesha apho iifayile ofuna ukuyibeka zingekho ngaphaya komnye.

Xa oku kwenzeka, kunokwenzeka ukhethe ii-cell ezingahambisani. Nangona ukhetha iiseli ezingahambisani nazo zenziwa kuphela ngebhodibhodi , kulula ukwenza usebenzisa ikhibhodi kunye ne mouse ndawonye.

Ukukhetha iiselithi ezingezizo kwi-Excel

Ukuze uncede kulo mzekelo, bonani umfanekiso ongentla.

1. Cofa kwifowuni yokuqala ofuna ukuyikhetha kunye ne-pointer ye mouse ukuze wenze iseli esebenzayo .
   
   
2. Ukukhupha iqhosha le mouse.
   
   
3. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
   
   
4. Cofa kuzo zonke iiseli ofuna ukuzikhetha Ngaphandle kokukhulula ikhiye ye Ctrl .
   
   
5. Emva kokuba zonke iiseli ezifunwayo zikhethiweyo, khupha ikhiye ye Ctrl .
   
   
6. Musa ukucofa nakwezinye i-pointer ye mouse xa ukhulula ikhi Ctrl okanye uya kucima ukugqwesa kwiiseli ezikhethiweyo.
   
   
7. Ukuba ukhulula ikhi ye Ctrl ngokukhawuleza kwaye unqwenela ukugqamisa iiseli ezininzi, cindezela kwaye ubambe iqhosha le Ctrl kwakhona uze uklikha kwiiseli ezongezelelweyo.
   
   

Ezinye zeNqakrazo zeeNqununu zeziThuthi

• Ukongeza ixesha langoku
• Ukongeza Umhla wamanje
• ALT - TAB Ukutshintshwa ngokukhawuleza kwiWindows

Kaninzi "

11 kwi-27

ALT - TAB Ukutshintshwa kwiWindows

Akunjalo nje nge-Excel shortcut, i-ALT-TAB Ukutshintshwa yindlela esheshayo yokuhamba phakathi kwamaxwebhu avulekileyo kwi-Windows (Win key + Tab kwi-Windows vista).

Ukusebenzisa ikhibhodi ukufeza umsebenzi kwikhompyutheni ngokuqhelekileyo kusebenza ngokugqithiseleyo kunokusebenzisa imouse okanye esinye isixhobo sokukhomba, kunye ne-ALT-TAB Ukutshintshwa ngenye yezetyenziso ezisetyenziswa kakhulu kule miqhosha yebhobhobhodi.

Usebenzisa i-ALT-TAB Ukutshintshwa

1. Vula ubuncinane iifayile ezimbini kwi-Windows. Ezi zinokuba ziifayile ezimbini ze-Excel okanye iFayile ye-Excel kunye nefayile ye-Microsoft Word ngokomzekelo.
   
   
2. Cinezela kwaye ubambe iqhosha lase Alt kwikhibhodi.
   
   
3. Cinezela kwaye ukhulule ukhiye weTeb kwikhibhodi ngaphandle kokuvumela ukuhamba kwekhiye ye- Alt .
   
   
4. I-window ye-ALT-TAB yokutshintsha ngokukhawuleza kufuneka ibonakale phakathi kwesikrini sakho sekhompyutha.
   
   
5. Le festile kufuneka ifumane uphawu lwexwebhu ngalunye oluvulekileyo kwikhompyutha yakho.
   
   
6. I icon yokuqala ngakwesobunxele iya kuba yincwadi ekhoyo-ebonakalayo kwisikrini.
   
   
7. Isithonjana sesibini ukusuka ngakwesobunxele kufuneka sikhankanywe ibhokisi.
   
   
8. Ngezantsi kweemifanekiso kufuneka kube negama loxwebhu olugqityiwe kwibhokisi.
   
   
9. Ukukhupha i- Alt kunye neefestile ukutshintshela kumqulu ogqityiweyo.
   
   
10. Ukuhambisa kwamanye amaxwebhu abonisiwe kwi-window ye-ALT-TAB Fast Switch, qhubeka ugcina i- Alt ngeli xesha uthabatha ukhiye weTeb . Ithempu nganye kufuneka ishukumise ibhokisi ecacileyo ekhohlo ukuya kwesokudla ukusuka kwirekhodi enye ukuya elandelayo.
    
    
11. Ukukhupha i- Alt ukhiye xa uxwebhu olufunwayo lugqitywa.
    
    
12. Emva kokuba i-ALT-TAB Fast Switch window ivuliwe, unokuguqula isalathiso sebhokisi eligqwesileyo - uyishukumisela ukusuka kwesokudla ukuya kwesobunxele - ngokubamba phantsi iqhosha leShift kunye ne- Alt ukhiye uze uthayiphe ukhiye weTeb .

Ezinye iifutshane zebhodi zekhibhodi

• Ukongeza ixesha langoku
• Ukongeza Umhla wamanje
• Fihla iikholomu kwi-Excel

Kaninzi "

12 kwi-27

I-Excel iya kuNceda

Izifundo ezihambelanayo: I- Excel Igama leBhokisi lokuHlola .

I- Go To feature in Excel ingasetyenziswa ukukhawuleza ukuya kwiiseli ezahlukeneyo kwispredishithi . Eli nqaku liqukethe umzekelo wendlela yokusebenzisa ukuhamba ukuya kwiiseli ezahlukileyo usebenzisa i-shortcut keyboard.

Nangona kungabalulekanga kumaphepha okusebenzela abasebenzisa kuphela iikholomu ezimbalwa kunye nemigqa , kwiifayile ezinkulu zokusebenzela zingabanceda ukuba neendlela ezilula zokuxhuma ukusuka kwindawo enye yephepha lokusebenzela kwenye.

Ukuvula i- Go Ukufaka usebenzisa ikhibhodi, cinezela iqhosha le- F5

Umzekelo usebenzisa i-Excel ye- Go to feature for Navigation:

1. Cinezela iqhosha le-F5 kwikhibhodi ukuzisa ibhokisi yencoko yokuya kwiNcoko yababini.
2. Thayipha kwiseferensi yeseli yendawo efunwayo kwindawo yokubhekisa kwibhokisi yencoko. Kule meko: HQ567 .
3. Cofa kwiqhosha lase- OK okanye cofa iqhosha lokungena kwikhibhodi.
4. Ibhokisi elimnyama elijikeleze iseli esebenzayo kufuneka lijonge kwi-cell HQ567 eyenza iseli elitsha elisebenzayo.
5. Ukuhambisa kwenye iseli, phinda amanyathelo 1 ukuya ku-3.

IziThutho eziHlangeneyo

• I-Excel Igama leBhokisi lokuHlola
• Iingxelo zeSeli kwiifomu
• Ukongeza ii-Hyperlink kunye neeMpawu kwi-Excel

Kaninzi "

13 wama-27

I-Excel Gcwalisa I-Command Down

Ukuba udinga ukufaka idatha efanayo - itekisi okanye amanani - kwinani lamaseli alandelayo kwikholam , umyalelo wokugcwalisa phantsi unokukwenza ngokukhawuleza ukukwenza ngoku usebenzisa ikhibhodi.

Inqaku le-Excel libonisa indlela yokufaka umyalelo wokugcwalisa phantsi kwi- spreadsheet ye- Excel usebenzisa i-shortcutcut yebhobhobhodi.

Inhlanganisela ebalulekileyo esebenzayo Umyalelo wokugcwalisa ngu:

• Ctrl + D

Umzekelo: Ukusebenzisa Gcwalisa phantsi ngeKhothibhodi yekhibhodi

Ukuze uncede kulo mzekelo, bonani umfanekiso ongentla.

1. Thayipha inombolo, efana ne- 395.54 kwiseli D1 kwi-Excel.
   
   
2. Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi
3. Cinezela kwaye ubambe iqhosha laseNtshonalanga phantsi kwebhodibhodi ukwandisa ukugqwesa kweeseli kwiseli D1 ukuya kwi-D7.
4. Ukukhupha zombini izitshixo.
5. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
6. Cinezela kwaye ukhulule ikhi " D " kwikhibhodi.
7. Iiseli zeD2 ukuya kwi-D7 kufuneka ngoku zizaliswe ngedata efanayo kunye neseli D1.

Ezinye iifutshane zebhodi zekhibhodi

• Hlaziya Hlaziya
• Ukongeza Umhla wamanje
• Ukufometha Umhla

Kaninzi "

14 we-27

Ukusebenzisa ukuCwangciswa koBuchule

Inqaku le-Excel libonisa indlela yokusebenzisa ifomathi yokufometha usebenzisa iifotshane zokunqamla kwikhibhodi.

Kukho ukudibanisa ezimbini ezibalulekileyo ezingasetyenziselwa ukongeza okanye ukususa ukufometha kweedaliki kwiedatha:

• Ctrl + " I " zitshixo
• Ctrl + " 3 "

Umzekelo: Sebenzisa iiNqakrazo zeeNqakrazo zokufaka iifayile zokuFometha

Ukuze uncede kulo mzekelo, bonani umfanekiso kumnene.

1. Thayipha enye idatha kwiseli , njenge-E1 kwispredishithi kwaye cinezela iqhosha lokungena kwikhibhodi.
   
   
2. Cofa kwilo lisele ukwenza iseli esebenzayo .
   
   
3. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
   
   
4. Cinezela kwaye ukhulule incwadi " I " kwibhodibhodi.
   
   
5. Ukufometha komzobozo kufuneka kusetyenziswe kwiedatha kwiseli.
   
   
6. Cinezela kwaye ukhulule iifayile ze- Ctrl + " I " kwakhona ukususa ukufometha kweetaliki.
   
   

Ezinye iifutshane zebhodi zekhibhodi

• Yongeza ixesha langoku
• Khetha ii-Non-Adjacent Cells kwi-Excel
• ALT - TAB Ukutshintshwa ngokukhawuleza kwiWindows

15 we-27

Faka isicelo sokuFometha kweNombolo

Le tutorial iquka indlela yokufometha amanani kwiiseli ezikhethiweyo usebenzisa kuphela ikhibhodi:

Iifomati zeenombolo ezisetyenzisiweyo kwiedata ezikhethiweyo zi:

• indawo ezimbini zokugqibela
• i-comma njengabahluli bamawaka (,)
• uphawu lokunciphisa (-) ngexabiso elibi

Inhlanganisela ebalulekileyo engasetyenziselwa ukufomatha ukufomatha kwemali kwidatha :

Ctrl + Shift + ! (isikhalazo)

Umzekelo: Sebenzisa iiNqakrazo zeNqamlezo zokufaka ifomathi yefowuni

Lo mzekelo uboniswa kumfanekiso ongentla

1. Yongeza idatha elandelayo kwiiseli A1 ukuya ku-A4:
   4578.25102 45782.5102 457825.102 4578251.02
2. Gqamisa iiseli ezi-A1 ukuya kwi-A4 ukuzikhetha
3. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi
4. Cinezela kwaye ukhulule iqhosha lokumangalisa ( ! ) Kwikhibhodi ngaphandle kokukhulula iifayile zeCtrl kunye neShift
5. Ukukhupha ii- Ctrl kunye neShift
6. Amanani kwiiseli A1 ukuya kwi-A4 kufuneka ukuba ifomathiweyo ibonise kuphela indawo ezimbini zokugqibela nangona inani leenombolo linamaqela angaphezu kwembini
7. Iiseli kufuneka kwakhona zibe ne-comma edibeneyo njengowesahluli sewaka
8. Ukuqakraza nayiphi na iseli ibonisa inani elingenakutshintshwa kwinombolo yefom ephezulu kwiphepha lokusebenzela

Ezinye iifutshane zebhodi zekhibhodi

• Ukongeza Umhla wamanje
• Ukongeza ixesha langoku
• ALT - TAB Ukutshintshwa ngokukhawuleza kwiWindows

Kaninzi "

16 kwee-27

Faka isicelo sokufometha kwemali

Le tutorial iquka indlela yokukhawuleza ukufometha kwemali kwiiseli ezikhethiweyo usebenzisa kuphela ikhibhodi:

Inhlanganisela ebalulekileyo engasetyenziselwa ukufomatha ukufomatha kwemali kwidatha :

• Ctrl + Shift + 4

Umzekelo: Sebenzisa iiNqakrazo zeNqamlezo zokufaka ifomathi yokuFometha kwemali

Ukuze uncede kulo mzekelo, bonani umfanekiso kumnene.

1. Yongeza idatha elandelayo kwiiseli A1 ukuya kwi-B2: 7.98, 5.67, 2.45, -3.92
   
   
2. Hudula ukhethe iiseli A1 ukuya ku-B2 ukuzigqamisa.
   
   
3. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
   
   
4. Cinezela kwaye ukhulule inombolo yesine ( 4 ) kwikhibhodi ngaphandle kokukhipha iifayile zeCtrl kunye neShift .
   
   
5. Kwiiseli ze-A1, A2, kunye ne-B1 idenari yedola ( i-$ ) kufuneka ifakwe kwi-data.
   
   
6. Kwiseli yeB2, kuba idatha iyinombolo engafanelekanga, kufuneka ibomvu kwaye ijikelezwe ngamakhonkqo ajikeleziweyo ukongezelela ekubeni ne-dollar sign ( $ ) eyongeziweyo.
   
   

Ezinye iifutshane zebhodi zekhibhodi

• Ukongeza Umhla wamanje
• Ukongeza ixesha langoku
• ALT - TAB Ukutshintshwa ngokukhawuleza kwiWindows

Kaninzi "

17 kwee-27

Faka isicelo sokufometha kweepesenti

Leli phuzu le-Excel liquka ukufometha kweepesenti kwiiseli ezikhethiweyo kwi- spreadsheet ye- Excel usebenzisa izitshixo ezimfutshane kwikhibhodi.

Inhlanganisela ebalulekileyo engasetyenziselwa ukufomatha ukufomatha kwemali kwidatha :

• Ctrl + Shift + 5

Umzekelo Wendlela Yokufaka Ukufometha Kwemaphesenti usebenzisa i-Shortcut Keys

Ukuze uncede kulo mzekelo, bonani umfanekiso ongentla.

1. Yongeza idatha elandelayo kwiiseli A1 ukuya kwiB2: .98, -34, 1.23, .03
   
   
2. Hudula ukhethe iiseli A1 ukuya ku-B2 ukuzigqamisa.
   
   
3. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
   
   
4. Cinezela kwaye ukhulule inombolo yesihlanu ( 5 ) kwikhibhodi ngaphandle kokukhulula iifayile zeCtrl kunye neShift .
   
   
5. Kwiiseli ezi-A1 ukuya kwi-B2 idatha kufuneka iguqulwe kwipesenti kunye nomqondiso wepesenti ( % ) eyongeziweyo kwidatha.

Ezinye zeNqakrazo zeeNqununu zeziThuthi

• Faka isicelo sokufometha kwemali
• Ukusebenzisa ukuCwangciswa koBuchule
• Yongeza iMingcele kwi-Excel

Kaninzi "

18 we-27

Khetha Zonke iiseli kwiTable Data Data

Leli qhosha le-Excel lihlanganisa indlela yokukhetha zonke iiseli kwietafile yedatha ye-Excel usebenzisa i-shortcut keyboard. Ukwenza njalo kukuvumela ukuba wenze iinguqu ezifana nokufometha, ububanzi bekholomu, njl. Kwiphepha lokusebenzela konke kanye.

Inqaku elidibeneyo : Ukudala iData yeDatha kwi-Excel .

Qaphela: Uncedo ngolu mzekelo, bonani umfanekiso ekunene.

Umzekelo weendlela zokukhetha zonke iiseli kwiTable Data

1. Vula iphepha lokusebenzela lase Excel eliqukethe itafile yedata okanye ukudala itafile yedata .
   
   
2. Cofa kunaliphi iseli kwitafile yedatha.
   
   
3. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
   
   
4. Cinezela kwaye ukhulule itekisi " A " ikhibhodi ngaphandle kokukhulula ikhiye ye Ctrl .
   
   
5. Zonke iiseli kwitheyibhile yedata kufuneka zigqitywe.
   
   
6. Cinezela kwaye ukhulule incwadi " A " okwesibini.
   
   
7. Umgca ohamba phambili wetafile yedatha kufuneka ukhankanywe kunye netafile yedatha.
   
   
8. Cinezela kwaye ukhulule incwadi " A " okwesithathu.
   
   
9. Zonke iiseli ezikwiphepha lokusebenzela kufuneka zigqitywe.

Ezinye iifutshane zebhodi zekhibhodi

• Khetha ii-Non-Adjacent Cells kwi-Excel
• Yongeza iMingcele kwi-Excel
• Fihla iikholomu kwi-Excel

Kaninzi "

19 wama-27

Khetha iNdlela Yonke kwi-Excel usebenzisa i-Shortcut Keys

Khetha Iifolo kwiWindows Worksheet

Leli qhosha le-Excel lihlanganisa indlela yokukhawuleza ukhethe okanye ukugqamisa umgca opheleleyo kwiphepha lokusebenzela usebenzisa izitshixo ezifutshane kwikhibhodi kwi-Excel.

Inhlanganisela ebalulekileyo esetyenziselwa ukukhetha umgca:

SHIFT + SPACEBAR

Umzekelo: Sebenzisa iiNqakrazo zeeNqakrazo zokukhetha iRow Worksheet Row

1. Vula i-Excel Worksheet - akufuneki ukuba nayiphi na idatha ekhoyo
2. Cofa kwiseli kwiphepha lokusebenzela - njenge-A9 - ukwenza iseli esebenzayo
3. Cinezela kwaye ubambe iqhosha le- SHIFT kwibhodibhodi
4. Cinezela kwaye ukhulule ukhiye we SPACEBAR kwibhodibhodi ngaphandle kokukhipha ikhiye ye- SHIFT
5. Khulisa i-key SHIFT
6. Zonke iiseli kumqolo okhethiweyo kufuneka zigqitywe - kubandakanywa nomxholo wesigcawu

Kaninzi "

20 kwi-27

Gcina kwi-Excel

I-Excel Gcina iifayile ezifutshane

Leli qhosha lase-Excel lihlanganisa indlela yokugcina ngokukhawuleza idatha ngokusebenzisa izitshixo ezimfutshane kwikhibhodi kwi-Excel.

Inhlanganisela ebalulekileyo engasetyenziselwa ukugcina idatha yile:

Ctrl + S

Umzekelo: Sebenzisa iiNqamlezo zendlela yokuSondeza ukuLondoloza iphepha lokuSebenza

1. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi
2. Cinezela kwaye ukhulule ukhiye ( S ) kwikhibhodi ngaphandle kokukhulula ikhiye ye Ctrl
3. Ukukhulula ikhiye ye Ctrl

Ixesha Lokugcina Longa

Ukuba sele ulondoloze iphepha lokusebenzela kuphela isibonakaliso sokuthi i-Excel igcina ifayile yakho ingaba isalathisi semouse sitshintshana ngokufutshane kwisithonjana se-hourglass uze ubuyele kumqondiso oqhelekileyo omhlophe kunye nomqondiso.

Ubungakanani bexesha uphawu lwe-hourglass luhlala lubonakala luxhomekeke kwisixa sedatha ye-Excel kufuneka isindise. Eyona mkhulu yedatha yokugcina, ixesha elide i-hourglass icon iya kubonakala.

Ukuba ulondoloza iphepha lokusebenzela okokuqala ngqa ibhokisi yencoko yababini iya kuvula.

Xa ifayile igcinwa okokuqala ngqahlulo lweenkcukacha kufuneka icaciswe kwibhokisi yebhokisi yencoko yokugcina :

• igama lefayili (kufika kwiibali ezingama-255 kuquka iindawo)
• indawo (ifolda) apho ifayile iya kugcinwa khona

Gcina rhoqo

Ukususela ekusebenziseni iifayile ze-shortcut ze Ctrl + S yindlela elula yokugcina idatha yinto efanelekileyo yokugcina rhoqo - ubuncinane ngemizuzu emihlanu-ukuphepha ukulahlekelwa kwedatha xa kwenzeka ukuphazamiseka kwekhompyutha. Kaninzi "

21 kwi-27

Fihla uze udibanise iikholam kunye neendlela kwi-Excel

22 we-27

Ukufometha Umhla

Le ncwadana ye-Excel ibonisa ukuba ungayifometha njani umhla (usuku, inyanga, ifomathi yonyaka) kwi- spreadsheet ye- Excel usebenzisa i-shortcut keyboard.

Ukufometha Umhla usebenzisa i-Keyboard Shortcut

1. Yongeza usuku olufunwayo kwiseli kwi-spreadsheet ye-Excel.
   
   
2. Cofa kwiseli ukwenzela ukuba yenze iseli esebenzayo .
   
   
3. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
   
   
4. Cinezela kwaye ukhulule ikhi yesalathisi yenombolo ( # ) kwikhibhodi ngaphandle kokukhulula iifayile zeCtrl kunye neShift .
   
   
5. Umhla kwiseli esebenzayo iya kufomelwa ngosuku, inyanga, ifomathi yonyaka.
   
   

Ezinye iifutshane zebhodi zekhibhodi

• Ukongeza Umhla wamanje
• Ukongeza ixesha langoku
• ALT - TAB Ukutshintshwa ngokukhawuleza kwiWindows

Kaninzi "

23 wama-27

Ukufometha ixesha langoku

Le khosi ye-Excel ibonisa indlela yokufometha ixesha langoku (iyure, imfutshane, kunye ne-AM / PM ifomathi) kwi- spreadsheet ye- Excel usebenzisa i-shortcutcut yebhobhobhodi.

Ukufometha Ixesha langoku usebenzisa i-Keyboard Shortcut

1. Sebenzisa umSebenzi we- MAN ukuze ungeze umhla kunye nexesha elikhoyo kwi- cell D1.
   
   
2. Cofa kwiseli D1 ukwenzela ukuba yenze iseli esebenzayo .
   
   
3. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
   
   
4. Cinezela kwaye ukhulule inombolo yesibini ( 2 ) kwikhibhodi ngaphandle kokukhulula iifayile zeCtrl kunye neShift .
   
   
5. Umsebenzi okhoyo kwiseli D1 iya kufomathiswa ukubonisa ixesha langoku kwiyure, imfutshane kunye nefom ye-AM / PM.
   
   

Ezinye iifutshane zebhodi zekhibhodi

• Hlaziya Hlaziya
• Ukongeza Umhla wamanje
• Ukufometha Umhla

Kaninzi "

24 kwi-27

Tshintsha phakathi kwama-Worksheets

Njengenye indlela yokusebenzisa imouse, kulula ukusebenzisa i-shortcut yebhodibhodi ukutshintsha phakathi kwamaphepha e-Excel.

Iitshixo ezisetyenzisiweyo ziquka ukhiye we- CTRL okanye iPGUP (iphepha phezulu) okanye iPGDN (iphepha eliphantsi)

Umzekelo - tshintsha phakathi kwama-Worksheet kwi-Excel

Ukufudukela ngakwesokudla:

1. Cinezela kwaye ubambe iqhosha le CTRL kwikhibhodi.
2. Cinezela kwaye ukhulule ikhibhodi yePGDN (iphepha lezantsi ) kwikhibhodi.
3. Ukuhambisa elinye iphepha kumqolo wesokudla kwaye ukhulule ikhiye ye- PGDN okwesibini.

Ukuhambisa ngakwesobunxele:

1. Cinezela kwaye ubambe iqhosha le CTRL kwikhibhodi.
2. Cinezela kwaye ukhulule ukhiye wePGUP (iphepha phezulu) kwikhibhodi.
3. Ukuhambisa elinye iphepha kumshicileli wesobunxele uze ukhulule ikhiye ye - PGUP okwesihlandlo sesibini.

Ezinye iifutshane zebhodi zekhibhodi

• Fihla iikholomu kwi-Excel
• Fihla iiRows kwi-Excel
• Ukongeza Umhla wamanje

Qaphela: Ukukhetha amanqaku amaninzi asebenzayo usebenzisa ikhibhodi, cinezela: Ctrl + Shift + PgUp ukukhetha amaphepha ukuya kwesobunxele Ctrl + Shift + PgDn ukukhetha amaphepha ngakwesokudla .

25 kwi-27

Hlela iiseli kunye neF2 Function Key

I-Excel Hlela iisekisi eziKhethiweyo

Umsebenzi wesici F2 uvumela ukuba uguqule ngokukhawuleza kwaye uhlele idatha yeseli ngokusebenza kwimodi yokuhlela ye-Excel kwaye ufake ifowuni yokufaka ekupheleni kwezinto ezisetyenziswayo zeseli.

Umzekelo: Ukusebenzisa iF2 Key ukwenza iziqulatho zeSeli

Lo mzekelo ukhankanya indlela yokuhlela ifomula kwi-Excel

1. Faka idatha elandelayo kwiiseli 1 ukuya ku-D3: 4, 5, 6
2. Cofa kwifowuni E1 ukwenzela ukuba yenze iseli esebenzayo
3. Faka ifom elandelayo kwiseli E1:
   = D1 + D2
4. Cinezela ukhiye wokungena kwikhibhodi ukugqiba ifomu - impendulo 9 ifanele ivele kwiseli E1
5. Cofa kwifowuni E1 kwakhona wenze iteksi esebenzayo
6. Cinezela iqhosha leF2 kwikhibhodi
7. I-Excel ingena kwimodi yokuhlela kunye nenqaku lokufaka lifakwe ekupheleni kwefomula yangoku
8. Shintsha ifomula ngokungeza + i-D3 ekupheleni kwayo
9. Cindezela ukhiye wokungena kwibhodibhodi ukugqiba ifomu uze ushiye imodi yokuhlela - inani elitsha lefomyula - 15 - kufuneka ivele kwiseli E1

Qaphela: Ukuba ukhetho lokuvumela ukuhlela ngqo kwiiseli luvaliwe, ukucofa iqhosha le-F2 liya kubeka i-Excel kwimodi yokuhlela, kodwa inqaku lokufaka liya kutshintshwa kwibha yefomula ngaphaya kwephepha lokusebenzela ukuze uhlele okuqukethwe kweseli. Kaninzi "

26 kwi-27

Khetha Zonke iiseli kwiWindows Worksheet

27 kwi 27

Yongeza iMida

Inqaku le-Excel lihlanganisa indlela yokongeza umngcele kwiiseli ezikhethiweyo kwi- spreadsheet ye- Excel usebenzisa i-shortcutcut yebhobhobhodi.

Izifundo ezihambelanayo: Ukongeza / Ukufometha iMida e-Excel .

Intlangano ebalulekileyo yokongeza ixesha:

Ctrl + Shift + 7

Umzekelo wendlela yokongeza imida ngokusebenzisa i-Keyboard Shortcut

Ukuze uncede kulo mzekelo, bonani umfanekiso kumnene.

1. Faka iinombolo 1 ukuya ku-9 kwiiseli D2 ukuya kwi-F4.
   
   
2. Hudula ukhethe iiseli D2 kwi-F4 ukuzigqamisa.
   
   
3. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
   
   
4. Cinezela kwaye ukhulule inombolo yesisixhenxe ( 7 ) kwikhibhodi ngaphandle kokukhulula iifayile zeCtrl neeShift.
   
   
5. Iiseli zeD2 ukuya kwiF4 kufuneka zijikelezwe ngumda omnyama.
   
   

Ezinye iifutshane zebhodi zekhibhodi

• Ukongeza Umhla wamanje
• Khetha ii-Non-Adjacent Cells kwi-Excel
• Ukongeza ixesha langoku

Kaninzi "