Siyaqonda ukuthi uma ushintsha ukulandelana kombhalo ku-Microsoft word, kufanele uguqule yonke into mathupha ngoba iMicrosoft word ayikuniki isici sokushintshanisa imigqa noma amakholomu ukuze uhlele kabusha umbhalo. Kungase kucasule kakhulu futhi kudle isikhathi ukuhlela kabusha imigqa noma idatha yekholomu ngesandla ku-Microsoft word. Kodwa-ke, akudingekile ukuthi udlule entweni efanayo ngeMicrosoft I-Excel njengoba uthola umsebenzi wokushintshanisa ku-Excel ongawusebenzisa ukushintshanisa amakholomu ku-Excel.
Uma usebenza eshidini le-Excel, unamaseli agcwele idatha ethile, kodwa ubeka ngephutha idatha engalungile yekholomu eyodwa noma umugqa kwenye ikholomu noma umugqa. Ngaleso sikhathi, kuphakama umbuzo othi Ungashintsha kanjani amakholomu noma imigqa ku-Excel ? Ngakho-ke, ukukusiza ukuthi uthole umsebenzi wokushintshanisa we-Excel, size nomhlahlandlela omncane ongawulandela.
Okuqukethwe[ fihla ]
- Ungawashintsha kanjani Amakholomu noma Imigqa ku-Microsoft Excel
- Izizathu zokwazi ukuthi ungashintsha kanjani amakholomu noma imigqa ku-Excel
- Indlela 1: Shintsha Ikholomu Ngokuhudula
- Indlela yesi-2: Shintshanisa amakholomu ngokukopisha/ukunamathisela
- Indlela yesi-3: Sebenzisa Umphathi Wekholomu Ukuze Uhlele Kabusha Amakholomu
Ungawashintsha kanjani Amakholomu noma Imigqa ku-Microsoft Excel
Izizathu zokwazi ukuthi ungashintsha kanjani amakholomu noma imigqa ku-Excel
Uma wenza umsebenzi obalulekile womphathi wakho, lapho kufanele ufake khona idatha efanele kumakholomu noma imigqa ethile eshidini le-Excel, ufaka ngephutha idatha yekholomu 1 kuKholamu 2 kanye nedatha yomugqa 1 kumugqa wesi-2. Ngakho-ke, ulilungisa kanjani leli phutha ngoba ukulenza mathupha kuzokuthatha isikhathi esiningi? Futhi kulapho umsebenzi wokushintshanisa we-Microsoft excel usiza khona. Ngomsebenzi wokushintshanisa, ungakwazi ukushintsha kalula noma yimiphi imigqa noma amakholomu ngaphandle kokuthi ukwenze ngokwakho. Ngakho-ke, kubalulekile ukwazi ukuthi ungashintsha kanjani amakholomu noma imigqa ku-Excel.
Sibala izindlela ezimbalwa zokushintsha amakholomu noma imigqa ku-Excel. Ungazama kalula noma iyiphi yalezi zindlela ezilandelayo ukushintshanisa amakholomu noma imigqa ekhasini lokusebenzela le-Excel.
Indlela 1: Shintsha Ikholomu Ngokuhudula
Indlela yokudonsa idinga ukuzijwayeza okuthile njengoba ingaba yinkimbinkimbi kunalokho ezwakalayo. Manje, ake sithi uneshidi le-Excel elinamaphuzu ahlukene anyanga zonke amalungu eqembu lakho futhi ufuna ukushintshanisa amaphuzu Ekholomu D ukuya kukholomu C, bese ungakwazi ukulandela lezi zinyathelo zale ndlela.
1. Sithatha Isibonelo sezikolo ezihlukene zanyanga zonke zamalungu eqembu lethu, njengoba ubona kusithombe-skrini esingezansi. Kulesi skrini, sizoya shintsha izikolo zanyanga zonke Zekholomu D zibe Ikholomu C futhi Ngokuphambene nalokho.
2. Manje, kufanele khetha ikholomu ukuthi ufuna ukushintsha. Esimeni sethu, sikhetha ikholomu D ngokuchofoza phezulu kuKholamu D . Bheka isithombe-skrini ukuze uqonde kangcono.
3. Ngemva kokukhetha ikholomu ofuna ukuyishintsha, kufanele yehlisa ikhesa yegundane lakho emaphethelweni omugqa , lapho uzobona khona ukuthi isikhombisi segundane sizosuka ku-a okumhlophe kuhlanganisa nekhesa yomcibisholo enezinhlangothi ezine .
4. Uma ubona ikhesa yomcibisholo enezinhlangothi ezine ngemva kokubeka ikhesa emaphethelweni ekholomu, kufanele bamba ukhiye wokushintsha futhi chofoza kwesokunxele ukuze uhudule ikholomu endaweni oyithandayo.
5. Uma uhudula ikholomu endaweni entsha, uzobona i umugqa wokufaka ngemva kwekholomu lapho ufuna ukuhambisa khona ikholomu yakho yonke.
6. Ekugcineni, ungahudula ikholomu bese ukhulula ukhiye we-shift ukuze ushintshe yonke ikholomu. Nokho, kungase kudingeke uguqule isihloko sekholomu mathupha kuye ngedatha osebenza kuyo. Esimweni sethu, sinedatha yanyanga zonke, ngakho-ke kufanele siguqule isihloko sekholomu ukuze sigcine ukulandelana.
Lena kwakuyindlela eyodwa yokushintshanisa amakholomu, futhi ngokufanayo, ungasebenzisa indlela efanayo ukushintsha idatha emigqeni. Le ndlela yokuhudula ingase idinge ukuzijwayeza okuthile, kodwa le ndlela ingase ibe usizo ngemva kokuba usuyingcweti.
Funda futhi: Ungaguqula kanjani ifayela le-Excel (.xls) libe ifayela le-vCard (.vcf)?
Indlela yesi-2: Shintshanisa amakholomu ngokukopisha/ukunamathisela
Enye indlela elula yokwenza shintsha amakholomu ku-Excel indlela yokukopisha/yokunamathisela, esebenziseka kalula kubasebenzisi. Ungalandela lezi zinyathelo zale ndlela.
1. Isinyathelo sokuqala uku khetha ikholomu ofuna ukushintshana ngakho ngokuchofoza unhlokweni wekholomu . Thina, sishintsha Ikholomu D ukuze Ikholomu C.
2. Manje, sika ikholomu ekhethiwe ngokuchofoza kwesokudla kukholamu bese ukhetha inketho yokusika. Nokho, ungasebenzisa futhi isinqamuleli ngokucindezela inkinobho ctrl +x okhiye ndawonye.
3. Kufanele ukhethe ikholomu ngaphambi kwalokho ofuna ukufaka ikholomu yakho esikiwe bese kuthi chofoza kwesokudla kukholamu ekhethiwe ukukhetha inketho ' Faka amaseli asikiwe 'kusuka kumenyu ye-pop-up. Esimweni sethu, sikhetha ikholomu C.
4. Uma uchofoza okukhethwa kukho kokuthi ' Faka amaseli asikiwe ,’ izoshintsha yonke ikholomu yakho iye endaweni oyithandayo. Ekugcineni, ungakwazi ukushintsha isihloko sekholomu mathupha.
Indlela yesi-3: Sebenzisa Umphathi Wekholomu Ukuze Uhlele Kabusha Amakholomu
Ungasebenzisa isiphathi sekholomu esakhelwe ngaphakathi ukuze shintsha amakholomu ku-Excel . Leli ithuluzi elisheshayo nelisebenzayo lokushintsha amakholomu eshidini le-Excel. Umphathi wekholomu uvumela abasebenzisi ukuthi bashintshe ukuhleleka kwamakholomu ngaphandle kokukopisha mathupha noma ukunamathisela idatha. Ngakho, ngaphambi kokuqhubeka nale ndlela, kufanele ufake i-suite yokugcina isandiso eshidini lakho le-Excel. Manje, nansi indlela yokushintshanisa amakholomu ku-Excel usebenzisa le ndlela:
1. Ngemva kokufaka ngempumelelo izengezo eziphezulu kakhulu eshidini lakho le-Excel, kufanele uye ku Ithebhu ethi 'Ablebits data' bese uchofoza ku ‘Phatha.’
2. Kuthebhu yokuphatha, kufanele khetha Isiphathi Sekholomu.
3. Manje, iwindi lomphathi wekholomu lizovela ngakwesokudla seshidi lakho le-Excel. Kumphathi wekholomu, uzobona uhlu lwawo wonke amakholomu akho.
Ezine. Khetha ikholomu eshidini lakho le-Excel ofuna ukulihambisa futhi usebenzise imicibisholo ephezulu naphansi efasiteleni lomphathi wekholomu kwesokunxele ukuze unyakazise ikholomu oyikhethile kalula. Kithina, sikhetha ikholomu D ekhasini lokusebenza futhi sisebenzisa umcibisholo obheke phezulu ukuyihambisa ngaphambi kwekholomu C. Ngokufanayo; ungasebenzisa okhiye bemicibisholo ukuze uhambise idatha yekholomu. Kodwa-ke, uma ungafuni ukusebenzisa amathuluzi omcibisholo, futhi unenketho yokuhudula ikholomu kuwindi lesiphathi sekholomu uye endaweni oyifunayo.
Lena kwakungenye indlela elula ongakwazi ngayo shintsha amakholomu ku-Excel. Ngakho-ke, noma yimiphi imisebenzi oyenzayo efasiteleni lomphathi wekholomu yenziwa kanyekanye eshidini lakho le-Excel eliyinhloko. Ngale ndlela, ungalawula ngokugcwele yonke imisebenzi yomphathi wekholomu.
Kunconyiwe:
- Shintsha Ngokushesha Phakathi Kwamakhasi Okusebenzela ku-Excel
- Ungalisusa kanjani iphasiwedi kufayela le-Excel
- Indlela Yokuguqula Ikhebula Le-Coaxial libe yi-HDMI
Sithemba ukuthi lo mhlahlandlela ube wusizo futhi ukwazile ukuqonda Ungashintsha kanjani amakholomu noma imigqa ku-Excel . Izindlela ezingenhla zilula kakhulu ukuzenza, futhi zingaba usizo lapho uphakathi komsebenzi othile obalulekile. Ngaphezu kwalokho, uma wazi enye indlela yokushintshanisa amakholomu noma imigqa, ungasazisa kumazwana angezansi.
Pete Mitchell U-Pete ungumbhali wabasebenzi Omkhulu eCyber S. UPete uthanda zonke izinto zobuchwepheshe futhi ungu-DIYer oshisekayo enhliziyweni. Unesipiliyoni seminyaka eyishumi ebhala ukuthi kwenziwa kanjani, izici, nemihlahlandlela yobuchwepheshe ku-inthanethi.