Ngamanye amaxesha awufuni ukuba ezinye iiseli kumaphepha akho e-excel ziguqulwe. Ungakwenza oko ngokufunda indlela yokutshixa okanye ukuvula iiseli kwi-excel.
IMicrosoft Excel isinika eyona ndlela isemagqabini yokugcina idatha yethu kwitheyibhile necwangcisiweyo. Kodwa le datha inokutshintshwa xa kwabelwana ngayo phakathi kwabanye abantu. Ukuba ufuna ukukhusela idatha yakho kutshintsho lwangabom, ngoko unokukhusela amaphepha akho e-Excel ngokuwatshixa. Kodwa, eli linyathelo eligqithisileyo elinokuthi lingakhethi. Endaweni yoko, unokutshixa iiseli ezithile, iirowu, kunye neekholamu. Umzekelo, unokuvumela abasebenzisi ukuba bafake idatha ethile kodwa batshixe iiseli ngolwazi olubalulekileyo. Kweli nqaku, siza kubona iindlela ezahlukeneyo tshixa okanye uvule iiseli kwi-Excel.
Imixholo[ fihla ]
- Zizitshixa njani okanye uzivule njani iiseli kwi-Excel?
- Uzitshixa njani zonke iiseli kwi-Excel?
- Uzitshixa njani kwaye uzikhusele njani iiSeli zoMnye kwi-Excel?
- Uzivula njani kwaye ungazikhuseli njani iiseli kwi-Excel Sheet?
- Zizivula njani iiSeli ezithile kwiPhepha eliKhuselweyo?
Zizitshixa njani okanye uzivule njani iiseli kwi-Excel?
Ungalitshixa lonke iphepha okanye ukhethe iiseli nganye ngokuxhomekeke kukhetho lwakho.
Uzitshixa njani zonke iiseli kwi-Excel?
Ukukhusela zonke iiseli ezingaphakathi Microsoft Excel , kufuneka ukhusele lonke iphepha. Zonke iiseli kwiphepha ziya kukhuselwa nakuphi na ukubhala ngaphezulu okanye ukuhlela ngokungagqibekanga.
1. Khetha ' Khusela iPhepha ' ukusuka ezantsi kwesikrini kwi' Ithebhu yePhepha lomsebenzi ' okanye ngokuthe ngqo ukusuka ' Ithebhu yophononongo ' kwi Utshintsha iqela .
2. I’ Khusela iPhepha ' ibhokisi yencoko yababini iyavela. Unokukhetha ukukhusela iphepha lakho lokugqwesa ngegama eligqithisiweyo okanye ushiye i ' igama lokugqitha khusela iphepha lakho lokugqwesa ’ ibala alinanto.
3. Khetha iintshukumo kuluhlu ofuna ukuluvumela kwiphepha lakho elikhuselweyo kwaye ucofe ku-'Kulungile.'
4. Ukuba ukhetha ukufaka igama eligqithisiweyo, ‘ Ngqina iphasiwedi ' ibhokisi yencoko yababini iya kuvela. Chwetheza igama lokugqitha lakho kwakhona ukugqiba inkqubo.
Funda kwakhona: Ulisusa njani igama lokugqithisa kwiFayile ye-Excel
Uzitshixa njani kwaye uzikhusele njani iiSeli zoMnye kwi-Excel?
Ungatshixa iiseli enye okanye uluhlu lweeseli ngokulandela la manyathelo angezantsi:
1. Khetha iiseli okanye uluhlu ofuna ukulukhusela. Ungayenza nge mouse okanye ngokusebenzisa i shift kunye nezitshixo zotolo kumagama akho angundoqo. Sebenzisa i Ctrl iqhosha kunye nemouse ukukhetha iiseli ezingekho kufutshane kunye noluhlu .
2. Ukuba ufuna ukutshixa ikholamu epheleleyo kunye nemiqolo (imiqolo), ungazikhetha ngokunqakraza ikholamu yazo okanye unobumba womqolo. Unokukhetha kwakhona imiqolo emeleneyo emininzi ngokunqakraza-ekunene kwimouse okanye usebenzisa isitshixo sokutshintsha kunye nemouse.
3. Unokukhetha kuphela iiseli ezinefomula. Kwi eKhaya thebhu, cofa ku Iqela lokuhlela ke ngoku ' Fumana kwaye Khetha '. Cofa apha Yiya ku Special .
4. Kwincoko yababiniibhokisi, khetha i Iifomula ukhetho kwaye ucofe Kulungile .
5. Nje ukuba ukhethe iiseli ozifunayo eziza kutshixwa, cofa Ctrl + 1 kunye. ‘ Iiseli zokuFomatha ' ibhokisi yencoko yababini iya kuvela. Unokucofa ekunene kwiiseli ezikhethiweyo kwaye ukhethe ukhetho lweeseli zokuFomatha ukuvula ibhokisi yencoko yababini.
6. Yiya kwi ‘ Ukhuseleko ' ithebhu kwaye ujonge ' itshixiwe ' ukhetho. Cofa apha Kulungile , kwaye umsebenzi wakho wenziwe.
Phawula: Ukuba uzama ukutshixa iiseli kwiphepha le-Excel elikhuselwe ngaphambili, kuya kufuneka uvule iphepha kuqala kwaye wenze le nkqubo ingasentla. Wena inokutshixa okanye ivule iiseli kwi-Excel ngo-2007, 2010, 2013, kunye neenguqulelo zika-2016.
Uzivula njani kwaye ungazikhuseli njani iiseli kwi-Excel Sheet?
Ungalivula ngokuthe ngqo lonke iphepha ukuze uvule zonke iiseli kwi-Excel.
1. Cofa apha ' Iphepha elingakhuselekanga ' kwi ' Ithebhu yophononongo ' kwi utshintsho iqela okanye nqakraza kukhetho ngokunqakraza-ekunene kwi Iphepha ithebhu.
2. Ngoku ungenza naluphi na utshintsho kwidatha ekwiiseli.
3. Ungaphinda uvule iphepha usebenzisa i ‘ Iiseli zokuFomatha ibhokisi yencoko.
4. Khetha zonke iiseli ephepheni nge Ctrl + A . Emva koko cofa Ctrl + 1 okanye cofa ekunene kwaye ukhethe Iiseli zokuFomatha . Kwi ' Ukhuseleko ' isithuba sebhokisi yencoko yababini yeeSeli zokuFomatha, sukukhangela i ' Itshixiwe ' ukhetho kwaye ucofe Kulungile .
Kwakhona Funda: Lungisa i-Excel ilinde esinye isicelo ukuba sigqibezele isenzo se-OLE
Zizivula njani iiSeli ezithile kwiPhepha eliKhuselweyo?
Ngamanye amaxesha unokufuna ukuhlela iiseli ezithile kwiphepha lakho le-Excel eKhuselweyo. Ngokusebenzisa le ndlela, unokuvula iiseli nganye kwiphepha lakho usebenzisa igama eliyimfihlo:
1. Khetha iiseli okanye uluhlu ofuna ukuluvula kwiphepha elikhuselweyo ngephasiwedi.
2. Kwi ‘ Uphononongo ' tab, cofa kwi ' Vumela abasebenzisi ukuba bahlele iiRandi ' ukhetho. Kufuneka uvule iphepha lakho kuqala ukuze ufumane ukhetho.
3. Ibhokisi yencoko yababini ethi ‘Vumela abasebenzisi Bahlele Uluhlu’ iyavela. Cofa kwi ' Entsha ' ukhetho.
4. A’ Uluhlu olutsha ' ibhokisi yencoko yababini ibonakala nge Isihloko, Ibhekisa kwiiseli, kwaye Uluhlu lokugqitha intsimi.
5. Kwindawo yeSihlokwana, nika igama kuluhlu lwakho . Kwi ' Ibhekisa kwiseli ' indawo, chwetheza uluhlu lweeseli. Sele inoluhlu lweeseli ezikhethiweyo ngokwendalo.
6. Chwetheza i inombolo yokuvula kwindawo yePasssword kwaye ucofe ku Kulungile .
7. Chwetheza igama lokugqitha kwakhona kwi ‘ Ngqina iphasiwedi ' ibhokisi yencoko yababini kwaye ucofe Kulungile .
8. Uluhlu olutsha luya kongezwa . Ungalandela la manyathelo kwakhona ukwenza uluhlu oluninzi.
9. Cofa kwindawo ethi ' Khusela iPhepha ' iqhosha.
10. Chwetheza igama lokugqithisa kwifestile ethi 'Khusela iPhepha' kulo lonke iphepha kunye khetha iintshukumo ufuna ukuyivumela. Cofa Kulungile .
Shumi elinanye. Chwetheza igama lokugqitha kwakhona kwifestile yokuqinisekisa, kwaye umsebenzi wakho uyenziwe.
Ngoku, nangona iphepha lakho likhuselwe, ezinye zeeseli ezikhuselweyo ziya kuba nenqanaba lokhuseleko olongezelelweyo kwaye ziya kuvulwa kuphela ngephasiwedi. Unako kwakhona ukunika ufikelelo kuluhlu ngaphandle kokufaka igama lokugqitha ngalo lonke ixesha:
Nye.Xa usenza uluhlu, cofa ku ' Iimvume ' ukhetho kuqala.
2. Cofa apha Yongeza iqhosha efestileni. Ngenisa igama labasebenzisi kwi ' Ngenisa amagama ezinto oza kuzikhetha ’ ibhokisi. Ungachwetheza igama lomsebenzisi lomntu njengoko ligcinwe kwindawo yakho . Cofa apha Kulungile .
3. Ngoku khankanya imvume yomsebenzisi ngamnye phantsi ‘ Amagama eqela okanye abasebenzisi ' kwaye ujonge i Vumela ukhetho. Cofa apha Kulungile , kwaye umsebenzi wakho wenziwe.
eCetyisiweyo:
- Ukutshintsha njani iiKholamu okanye iMiqolo kwi-Excel
- Uyiguqula njani ifayile yeExcel (.xls) kwifayile ye-vCard (.vcf)?
- Tshintshela ngokukhawuleza phakathi kwaMaphepha okusebenzela kwi-Excel
- Uyilungisa njani imifanekiso kaWhatsapp engabonisi kwiGalari
Zonke ezi yayiziindlela ezahlukeneyo onokuthi ngazo tshixa okanye uvule iiseli kwi-Excel. Ukwazi ukukhusela iphepha lakho kubaluleke kakhulu ukulikhusela kutshintsho lwengozi. Ungakhusela okanye ungazikhuseli iiseli kwiphepha le-Excel ngaxeshanye okanye ukhethe uluhlu oluthile. Unako kwakhona ukunika abasebenzisi abathile ukufikelela kunye okanye ngaphandle kwegama lokugqitha. Landela la manyathelo angasentla ngononophelo, kwaye akufanele ube nengxaki.
nguPete Mitchell UPete ungumbhali wabasebenzi oPhezulu kwiCyber S. UPete uthanda zonke izinto itekhnoloji kwaye ukwangu-DIYer okhutheleyo entliziyweni. Uneminyaka elishumi yamava okubhala indlela-tos, iimpawu, kunye nezikhokelo zetekhnoloji kwi-intanethi.