Ungalungisa njani iikholamu ezimbalwa kwi-Excel

Ukukwazi ukulungisa iikholamu kwi-Excel yinto eluncedo kwinkqubo evumela ukuba uyikhusele le ndawo ukugcina ukubonakala kolwazi. Iluncedo kwimeko yomsebenzi oneetafile ezinkulu, umzekelo, xa kufuneka kuthelekise. Kukho ithuba lokulungisa ikholamu eyodwa okanye ifake imizuzu eliqela ngaxeshanye, into esiya kuyithetha ngokweenkcukacha apha ngezantsi.

Ungayilungisa njani ikholamu yokuqala kwi-Excel?

Ukukhusela ikholamu yelolo, kuyakufuneka wenze oku kulandelayo:

1. Vula ifayile kunye netafile oceba ukuyihlela.
2. Yiya kwi-Toolbar kwicandelo "Jonga".
3. Fumana umsebenzi ocetywayo "nqaba le ndawo".
4. Kuluhlu lokulahla, khetha "ukhusele ikholam yokuqala".

Nye

Emva kwezenzo ezigqityiweyo, uya kubona ukuba umda utshintshe kancinane, kwaba mnyama kwaye uncitshisiwe, kwaye xa ufunda itafile, ulwazi lokuqala lwekholamu aluyi kutshabalalisa.

2.

Ungayilungisa njani iikholamu ezimbalwa kwi-Excel?

Ukulungisa iikholamu ezininzi ngaxeshanye, uya kuba nenani lezenzo ezongezelelweyo. Eyona nto iphambili kukukhumbula ukuba amanqaku eekholamu ezenzeka kwisona sesampulu yasekhohlo, eqala ngo-A. Ke ayizukukwazi ukulungisa iikholamu ezahlukeneyo kwenye indawo embindini wetafile. Ke, ukuphumeza ukusebenza, kuya kufuneka wenze oku kulandelayo:

1. Masithi kufuneka silungiselele iikholamu ezintathu ngaxeshanye (uKhetho A, B, C), ukuze uqale ukuqaqambisa ikholamu yonke D okanye iseli d

3.

1. Emva koko, kufuneka uye kwi-Toolbar kwaye ukhethe i-Tab ebizwa ngokuba "mbono".
2. Kuya kufuneka usebenzise ukhetho "lokubopha le ndawo".

ezine

1. Kuluhlu Uya kuba nemisebenzi eliqela, phakathi kwakweza kuyimfuneko ukukhetha "Fibula indawo".
2. Ukuba yonke into yenziwa ngokuchanekileyo, iikholamu ezintathu ezichaziweyo ziya kubanjwa kwaye zinokusetyenziswa njengomthombo wolwazi okanye uthelekiso.

Ungayilungisa njani ikholamu kunye nomtya?

Kunokubakho imeko enjalo ukuba iyimfuneko ukulungisa ikholamu ngokukhawuleza kunye nomtya osondeleyo wokuphumeza isabelo, kuya kufuneka wenze oku kulandelayo:

1. Ekuqaleni, kuya kufuneka usebenzise iseli njengendawo esisekelweni. Eyona mfuneko iphambili kule meko isebenza ukuba iseli kufuneka ibekwe ngokungqongqo ekulekweni komtya kunye nekholamu. Ekuqaleni, oku kungavakala kunzima, kodwa ngenxa ye-screennshot eqhotyoshelweyo unokuqonda ngokukhawuleza izinto zalo mzuzu.
2. Yiya kwi-Toolbar kwaye usebenzise ithebhu ye-tib.
3. Kufuneka ufumane into ethi "ukhusele indawo" kwaye ucofe kuyo ngeqhosha lasekhohlo.
4. Ukusuka kuluhlu oluhlayo-phantsi kwanele ukukhetha ukhetho "Qiza indawo".

Ntlanu

Kuyenzeka ukuba ulungise iiphaneli ezininzi kwangoko ukuze usetyenziswe kwixesha elizayo. Umzekelo, ukuba ufuna ukulungisa iikholamu ezimbini zokuqala kunye nemigca emibini, emva koko ke yendlela ecacileyo uya kudinga ukuqaqambisa iseli ye-C3. Kwaye ukuba ufuna ukulungisa imiqolo emithathu kunye neekholamu ezintathu kwangoko, kuba kuya kufuneka ubalaselise i-D4 iseli. Kwaye ukuba ufuna iseti engasentla, umzekelo, iikholamu ezintathu, ke iyakuthatha ukukhupha iseli ye-D3 ukuya kuhlanganisa. Emva kokubamba ukufana, uyakubona umgaqo wokudityaniswa nokusebenzisa ngenkalipho kuyo nayiphi na itafile.

6.

Ungayisusa njani isabelo seendawo e-Excel?

Emva kokuba ulwazi olusuka kwiikholamu ezisisigxina lusetyenziswa ngokupheleleyo, kuya kufuneka ucinge ngokususa ulungiso. Ngokukodwa ityala elinjalo kukho umsebenzi owedwa kwaye uyisebenzise, ​​kufuneka wenze oku kulandelayo:

1. Okokuqala, kufuneka uqiniseke ukuba iikholamu ezisisigxina azisafuneki emsebenzini wakho.
2. Ngoku yiya kwi-Toolbar ephezulu kwaye uye kwi-theb yolo mbono.
3. Sebenzisa umsebenzi.
4. Ukusuka kuluhlu oluhlayo, khetha "Shenxisa ingingqi".

7.

Ukuqukumbela

Njengoko ubona, sebenzisa umsebenzi wemisebenzi akukho nzima, kwanele ukusebenzisa zonke izinto ezikhoyo kwaye ulandela ngononophelo iingcebiso. Eli nqaku kufuneka liluncedo kuwe, ngenxa yoko kufanelekile ukhumbula umgaqo-nkqubo wokusetyenziswa kwayo.

Umyalezo Ungalungisa njani iikholamu ezimbalwa kwi-Excel kwi-Excel kuqala kwitekhnoloji yolwazi.