Siyaqonda ukuba xa utshintsha ulandelelwano lokubhaliweyo kwigama likaMicrosoft, kufuneka utshintshe yonke into ngesandla kuba igama leMicrosoft alikuniki uphawu lokutshintsha imigca okanye iikholamu zokuphinda uhlengahlengise umbhalo. Inokuba yinto ecaphukisayo kwaye idle ixesha ukuhlengahlengisa imiqolo okanye idatha yekholamu ngesandla kwigama likaMicrosoft. Nangona kunjalo, akufuneki udlule kwinto enye ngeMicrosoft I-Excel njengoko ufumana umsebenzi wokutshintsha kwi-Excel onokuyisebenzisa ukutshintsha iikholamu kwi-Excel.
Xa usebenza kwiphepha le-Excel, uneeseli ezizaliswe ngedatha ethile, kodwa ubeka ngengozi idatha engafanelekanga kwikholamu enye okanye umqolo kwenye ikholamu okanye umqolo. Ngelo xesha, umbuzo uvela Ukutshintsha njani iikholamu okanye imiqolo kwi-Excel ? Ke ngoko, ukukunceda ukuba ufumane umsebenzi wokutshintsha kwe-Excel, size nesikhokelo esincinci onokuthi usilandele.
Imixholo[ fihla ]
- Ukutshintsha njani amaKholamu okanye iMiqolo kwiMicrosoft Excel
- Izizathu zokwenza ukwazi ukutshintshanisa iikholamu okanye imiqolo kwi-Excel
- Indlela yoku-1: Tshintshela iKholam ngokutsalwa
- Indlela yesi-2: Tshintsha iiKholamu ngokuKhophela/Ukuncamathisela
- Indlela yesi-3: Sebenzisa uMphathi weKholamu ukuLungelelanisa kwakhona amaKholam
Ukutshintsha njani amaKholamu okanye iMiqolo kwiMicrosoft Excel
Izizathu zokwenza ukwazi ukutshintshanisa iikholamu okanye imiqolo kwi-Excel
Xa usenza isabelo esibalulekileyo kumphathi wakho, apho kufuneka ufake idatha echanekileyo kwiikholomu ezithile okanye kwimigca kwiphepha le-Excel, ufaka ngengozi idatha yekholomu 1 kwiKholam 2 kunye nedatha yomqolo 1 kumqolo wesi-2. Ke, uyilungisa njani le mpazamo kuba ukuyenza ngesandla izakuthatha ixesha elininzi? Kwaye kulapho umsebenzi wokutshintsha weMicrosoft excel uza luncedo. Ngomsebenzi wokutshintsha, ungatshintsha ngokulula nayiphi na imiqolo okanye iikholamu ngaphandle kokwenza oko ngesandla. Ke ngoko, kubalulekile ukwazi ukuba ungatshintsha njani iikholomu okanye imiqolo kwi-Excel.
Sikhankanya iindlela ezimbalwa zokutshintsha iikholamu okanye imiqolo kwi-Excel. Ungazama ngokulula nayiphi na kwezi ndlela zilandelayo zokutshintshanisa iikholamu okanye imiqolo kwiphepha lomsebenzi le-Excel.
Indlela yoku-1: Tshintshela iKholam ngokutsalwa
Indlela yokutsala ifuna ukuziqhelanisa nanjengoko inokuba nzima ngakumbi kunokuba ivakala. Ngoku, masicinge ukuba unephepha le-Excel elinamanqaku ahlukeneyo enyanga kumalungu eqela lakho kwaye ufuna ukutshintsha amanqaku kuKholamu D ukuya kwikholamu C, emva koko unokulandela la manyathelo ngale ndlela.
1. Sithatha uMzekelo wamanqaku ahlukeneyo enyanga amalungu eqela lethu, njengoko ubona kumfanekiso wekhusi ongezantsi. Kulo mfanekiso wekhusi, siya tshintshanisa amanqaku enyanga kaKholam D ukuya kuKholam C kunye ne-Vice-versa.
2. Ngoku, kufuneka wenze njalo khetha umqolo ukuba ufuna ukutshintsha. Kwimeko yethu, sikhetha ikholamu D ngokucofa phezulu kuKholam D . Jonga umfanekiso wekhusi ukuze uqonde ngcono.
3. Emva kokuba ukhethe ikholamu ofuna ukuyitshintsha, kufuneka wenze njalo yizisa isalathisi semouse ezantsi kwincam yomgca , apho uya kubona ukuba isalathisi semouse sizakujika sisuke kwi mhlophe kunye nekhesa emacala amane .
4. Xa ubona utolo olunamacala amane emva kokubeka ikhesa kumda wekholamu, kufuneka bamba iqhosha lokutshintsha kwaye cofa ekhohlo ukutsala ikholamu kwindawo oyithandayo.
5. Xa utsala ikholamu kwindawo entsha, uya kubona i umgca wofakelo emva komhlathi apho ufuna ukususa umqolo wakho wonke.
6. Ekugqibeleni, Ungatsala umhlathi kwaye ukhulule isitshixo sokutshintsha ukutshintsha umhlathi wonke. Nangona kunjalo, kuya kufuneka utshintshe isihloko sekholamu ngesandla ngokuxhomekeke kwidatha osebenza kuyo. Kwimeko yethu, sinedatha yenyanga, ngoko kufuneka sitshintshe isihloko sekholomu ukugcina ukulandelelana.
Le yayiyindlela enye yokutshintsha iikholamu, kwaye ngokufanayo, ungasebenzisa indlela efanayo ukutshintshisa idatha kwimigca. Le ndlela yokutsala inokufuna ukuziqhelanisa, kodwa le ndlela inokuza luncedo emva kokuba uyifumene kakuhle.
Kwakhona Funda: Uyiguqula njani ifayile yeExcel (.xls) kwifayile ye-vCard (.vcf)?
Indlela yesi-2: Tshintsha iiKholamu ngokuKhophela/Ukuncamathisela
Enye indlela elula yokwenza tshintsha iikholamu kwi-Excel yindlela yokukhuphela/yokuncamathisela, ekulula ukuyisebenzisa kubasebenzisi. Ungalandela la manyathelo kule ndlela.
1. Inyathelo lokuqala ku khetha umqolo ofuna ukuyitshintsha ukunqakraza kwiheader yomhlathi . Kwimeko yethu, sitshintsha uKholamu D ukuya kuKholam C.
2. Ngoku, sika ikholamu ekhethiweyo ngokunqakraza-ekunene kwikholamu kwaye ukhethe ukhetho lokusikwa. Nangona kunjalo, ungasebenzisa indlela emfutshane ngokucinezela i ctrl + x izitshixo kunye.
3. Kufuneka ukhethe ikholamu phambi kokuba ufuna ukufaka ikholamu yakho esikiweyo emva koko cofa ekunene kuluhlu olukhethiweyo ukukhetha ukhetho lwe ' Faka iiseli ezisikiweyo ' ukusuka kwimenyu ye-pop-up. Kwimeko yethu, sikhetha ikholamu C.
4. Nje ukuba ucofe kukhetho lwe ' Faka iiseli ezisikiweyo ,' iya kutshintsha ikholamu yakho yonke kwindawo oyithandayo. Ekugqibeleni, unokutshintsha isihloko sekholamu ngesandla.
Indlela yesi-3: Sebenzisa uMphathi weKholamu ukuLungelelanisa kwakhona amaKholam
Ungasebenzisa umphathi wekholamu eyakhelwe-ngaphakathi ukuya tshintsha iikholamu kwi-Excel . Esi sisixhobo esikhawulezayo nesisebenzayo sokutshintsha iikholamu kwiphepha le-Excel. Umphathi wekholomu uvumela abasebenzisi ukuba batshintshe ukulandelelana kweekholomu ngaphandle kokukopisha ngesandla okanye ukunamathisela idatha. Ngoko ke, ngaphambi kokuba uqhubeke nale ndlela, kufuneka ufake eyona suite yokugqibela ulwandiso kwiphepha lakho le-Excel. Ngoku, nantsi indlela yokutshintsha iikholamu kwi-Excel usebenzisa le ndlela:
1. Emva kokuba ufake ngempumelelo ezongezo zokugqibela kwiphepha lakho le-Excel, kufuneka uye kwi Ithebhu 'yeAblebits data' kwaye ucofe ku ‘Lawula.’
2. Kwithebhu yokulawula, kufuneka wenze njalo khetha umphathi weKholam.
3. Ngoku, iwindow yomphathi wekholamu iya kuvela kwicala lasekunene kwiphepha lakho le-Excel. Kumphathi wekholamu, uya kubona uluhlu lwazo zonke iikholamu zakho.
Isine. Khetha ikholam kwiphepha lakho le-Excel ofuna ukulihambisa kwaye usebenzise iintolo eziphezulu nezisezantsi kumphathi wekholamu yefestile ekhohlo ukuya kuluhlu olukhethiweyo ngokulula. Kwimeko yethu, sikhetha ikholamu D kwiphepha lomsebenzi kwaye sisebenzise utolo oluya phezulu ukuyihambisa phambi kwekholamu C. Ngokufanayo; ungasebenzisa izitshixo zotolo ukuhambisa idatha yomhlathi. Nangona kunjalo, ukuba awufuni ukusebenzisa izixhobo zotolo, ngoko ke unokhetho lokutsala ikholamu kumphathi wekholamu yefestile kwindawo oyifunayo.
Le yayiyenye indlela elula onokuthi ngayo tshintsha iikholamu kwi-Excel. Ke, nayiphi na imisebenzi oyenzayo kumphathi wekholamu yefestile yenziwa ngaxeshanye kwiphepha lakho eliphambili le-Excel. Ngale ndlela, unokuba nolawulo olupheleleyo kuyo yonke imisebenzi yomphathi wekholamu.
eCetyisiweyo:
- Tshintshela ngokukhawuleza phakathi kwaMaphepha okusebenzela kwi-Excel
- Ulisusa njani igama lokugqithisa kwiFayile ye-Excel
- Uyiguqulela njani iCoaxial Cable kwiHDMI
Siyathemba ukuba esi sikhokelo sibe luncedo kwaye ukwazile ukusiqonda Ukutshintsha njani iikholamu okanye imiqolo kwi-Excel . Ezi ndlela zingasentla zilula kakhulu ukuzenza, kwaye zinokuza luncedo xa uphakathi kwesabelo esibalulekileyo. Ngapha koko, ukuba uyayazi enye indlela yokutshintsha iikholamu okanye imiqolo, ungasazisa kwizimvo ezingezantsi.
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.