Indlela Yokushintsha Amakholomu ku-Excel - Izindlela Ezi-3 Zokusonga Ikholomu ku-Excel

Abasebenzisi abasebenza ngamaspredishithi ku-Excel bangase badinge ukushintsha amakholomu noma, ngamanye amazwi, basonge ikholomu yesobunxele. Nokho, akuwona wonke umuntu ozokwazi ukuzulazula ngokushesha futhi enze lo msebenzi. Ngakho-ke, ngezansi sizokwethula izindlela ezintathu ezikuvumela ukuthi wenze lo msebenzi, ukuze ukwazi ukukhetha okulungele kakhulu futhi okulungele wena.

Hambisa amakholomu ku-Excel ngokukopisha nokunamathisela

Le ndlela ilula futhi iqukethe izinyathelo ezihlanganisa ukusetshenziswa kwemisebenzi ehlanganisiwe ku-Excel.

1. Ukuze uqale, udinga ukukhetha iseli yekholomu, ohlangothini lwesobunxele lapho ikholomu ezohanjiswa izotholakala esikhathini esizayo. Khetha usebenzisa inkinobho yegundane engakwesokudla. Ngemuva kwalokho, iwindi le-pop-up lemenyu yohlelo lizovela phambi kwakho. Kuyo, usebenzisa i-pointer yegundane, khetha into encane ebizwa ngokuthi "Faka" bese uchofoza kuyo.
   

   

2. Kusixhumi esibonakalayo sebhokisi lengxoxo elivelayo, udinga ukuchaza amapharamitha alawo maseli azongezwa. Ukuze wenze lokhu, khetha isigaba esinegama elithi “Ikholomu” bese uchofoza inkinobho ethi “KULUNGILE”.
   

   

3. Ngezinyathelo ezingenhla, udale ikholomu entsha engenalutho lapho idatha izohanjiswa khona.
4. Isinyathelo esilandelayo siwukukopisha ikholomu ekhona kanye nedatha ekuyo kukholomu entsha oyidalile. Ukuze wenze lokhu, hambisa ikhesa yegundane egameni lekholomu ekhona bese uchofoza inkinobho yegundane elingakwesokudla. Igama lekholomu liphezulu kakhulu efasiteleni elisebenzayo lohlelo. Ngemva kwalokho, iwindi le-pop-up lizovela phambi kwakho. Kuyo, kufanele ukhethe into enegama elithi "Kopisha".
   

   

5. Manje hambisa ikhesa yegundane egameni lekholomu oyidalile, ulwazi luzongena kulo. Khetha le kholomu bese ucindezela inkinobho yegundane engakwesokudla. Bese kuzovela iwindi le-pop-up lemenyu yohlelo olusha phambi kwakho. Kule menyu, thola isigaba esibizwa ngokuthi “Namathisela Izinketho” bese uchofoza isithonjana esikwesokunxele, esinegama elithi “Namathisela”.
   

   

   Nakani! Uma ikholomu ozodlulisela kuyo idatha iqukethe amaseli anamafomula, futhi udinga ukudlulisa kuphela imiphumela esenziwe ngomumo, esikhundleni sesithonjana esinegama elithi "Faka", khetha esiseduze kwayo "Faka inani".

   

6. Lokhu kuqeda inqubo yokudlulisa ikholomu ngempumelelo. Nokho, kwakusenesidingo sokususa ikholomu okwadluliselwa kuyo ulwazi ukuze ithebula lingabi nayo idatha efanayo kumakholomu amaningana.
7. Ukuze wenze lokhu, udinga ukuhambisa ikhesa yegundane uye egameni laleli kholomu bese uyikhetha ngokuchofoza inkinobho yegundane elingakwesokudla. Ewindini lemenyu yohlelo elivulayo, khetha into ebizwa ngokuthi "Susa". Lesi bekuyisigaba sokugcina somsebenzi, ngenxa yokuthi uqedele umsebenzi ohlosiwe.
   

   

Hambisa amakholomu ku-Excel usebenzisa imisebenzi yokusika nokunamathisela

Uma ngesizathu esithile le ndlela engenhla ibonakala idla isikhathi kuwe, ungasebenzisa le ndlela elandelayo, enezinyathelo ezimbalwa. Kubandakanya ukusebenzisa imisebenzi yokusika nokunamathisela ehlanganiswe ohlelweni.

1. Ukuze wenze lokhu, hambisa ikhesa yegundane egameni lekholomu ofuna ukususa kuyo idatha bese uchofoza kwesokudla egameni layo. Iwindi le-pop-up lemenyu lizovela phambi kwakho. Kule menyu, khetha into ebizwa ngokuthi "Sika".
   

   

   Iseluleko! Ungakwazi futhi ukuhambisa ikhesa yegundane uye egameni laleli kholomu bese, ngemva kokuyikhetha, uchofoze inkinobho yegundane kwesokunxele. Ngemuva kwalokho, cindezela inkinobho ebizwa ngokuthi "Sika", enesithonjana esinomfanekiso wesikele.

2. Bese uhambisa ikhesa yegundane egameni lekholomu ofuna ukuyibeka ngaphambili ekhona. Chofoza kwesokudla egameni laleli kholomu nakwimenyu ephumayo evelayo, khetha into ebizwa ngokuthi “Faka Amaseli Asika”. Kulokhu, inqubo edingekayo ingabhekwa njengeqediwe ngempumelelo.
   

   

Kuyaqapheleka futhi ukuthi izindlela ezimbili esizicubungulile zikuvumela ukuthi uhambise amakholomu amaningana ngesikhathi esisodwa, hhayi eyodwa kuphela.

Ukuhambisa amakholomu ku-Excel usebenzisa igundane

Indlela yokugcina iyindlela eshesha kakhulu yokuhambisa amakholomu. Kodwa-ke, njengoba ukubuyekezwa okuku-inthanethi kubonisa, le ndlela ayidumile kakhulu phakathi kwabasebenzisi be-Excel. Lo mkhuba ungenxa yokuthi ukuqaliswa kwawo kudinga ubuciko bezandla kanye nomyalo omuhle wekhono lokuphatha ikhibhodi negundane. Ngakho-ke, ake siqhubekele ekucabangeleni le ndlela:

1. Ukuze wenze lokhu, udinga ukuhambisa ikhesa yegundane kukholamu edlulisiwe bese uyikhetha ngokuphelele.
   

   

2. Bese uhambisa phezulu komngcele wesokudla noma kwesokunxele wanoma iyiphi iseli kukholomu. Ngemva kwalokho, ikhesa yegundane izoshintsha ibe isiphambano esimnyama esinemicibisholo. Manje, ngenkathi ubambe ukhiye othi “Shift” kukhibhodi, futhi ubambe inkinobho yegundane engakwesokunxele, hudula le kholomu uye endaweni esethebulani ofuna ibe kuyo.
   

   

3. Ngesikhathi sokudlulisa, uzobona umugqa ohlaza oqondile osebenza njengokuhlukanisa futhi ukhombisa lapho ikholomu ingafakwa khona. Lo mugqa usebenza njengohlobo lwesiqondiso.
   

   

4. Ngakho-ke, lapho lo mugqa uhambisana nendawo lapho udinga ukuhambisa ikholomu, uzodinga ukukhulula ukhiye obanjwe kukhibhodi kanye nenkinobho kugundane.
   

   

Kubalulekile! Le ndlela ayikwazi ukusetshenziswa kwezinye izinguqulo ze-Excel ezikhishwe ngaphambi kuka-2007. Ngakho-ke, uma usebenzisa inguqulo endala, buyekeza uhlelo noma sebenzisa izindlela ezimbili zangaphambilini.

Isiphetho

Sengiphetha, kufanele kuqashelwe ukuthi njengoba usujwayele izindlela ezintathu zokwenza ukugoqa kwekholomu ku-Excel, ungakhetha okukhululekile kakhulu kuwe.