Isitshixo sokulinganisa esishushu kwi-Excel

Ukusebenza kunye neetafile, ukuhlawula abasebenzisi ukuba basebenzise idatha, ngamanye amaxesha bayalibala imbonakalo yoxwebhu. Esi sisiciko esicacileyo, kuba itafile entle ehlotyweyo iyimfuneko kungekuphela nje ukuba imbono entle kuphela, kodwa ikwazi ukuqonda kwaye ifumane ezinye izinto kuxwebhu. Emva koko, siya kuhlalutya izixhobo zokubona izinto zokubonwayo ngenxa yokugcina iiseli, kunye nendlela yokuzisebenzisa.

Ukuzalisa iiseli kwi-Excel: Iindlela ezisisiseko

Ukuzalisa iiseli ngombala, kuxhomekeka kumxholo wangaphakathi, wenza lula inkqubo yokusebenza kunye nokuqonda ulwazi oluyimfuneko. Obu buchule bubaluleke ngakumbi xa usebenza neetafile ezinkulu ezineenkcukacha ezininzi ezifuna ukuhlelwa. Ukusuka kule nto kulandela ukuba umbala wombala unceda ukulungisa uxwebhu olugqityiweyo kwizinto ezibalulekileyo.

Ukwenza amaxwebhu obukhulu obutsha, ungasebenzisa indlela yencwadana yeeseli zophando. Ukuba ufuna ukwakha itafile ethatha iphepha lonke okanye nangaphezulu, ilungele ukusebenzisa izixhobo ezizodwa. Nokuba kukho abasebenzisi abanenkalipho abafuna ukwenza wonke umsebenzi ngesandla, ukubakho kukuba impazamo iza kuvunyelwa kuxwebhu. Ngakumbi ukulungiselela imisebenzi enjalo kwi-Excel, iiseli zithululelwa ngombala. Ukwenza oku, jonga ngakumbi.

Inombolo ye-1: Ukugcwaliswa kwesiqhelo ngombala

Ukwenza lo msebenzi, siya kufuna isixhobo sokutshintsha ifomathi yeeseli. Ukwenza oku, landela imiyalelo enikiweyo:

1. Ukuqala, ukumisela iseli apho umbala uzakuzalisa khona kwaye uyisebenzise ngokucinezela i-LKM. Mhlawumbi iya kuba ziiseli ezininzi ngexesha elinye.

Nye

1. Kwigumbi "lasekhaya", fumana ibhloko yefonti. Amanye amanyathelo anokwenziwa ngenye yeendlela ezicetywayo:

• Ukugcwalisa umbala weseli, sebenzisa isixhobo "sokugcwalisa umbala", uboniswe ngohlobo lwebhakethi eyenza ukugcwalisa. Ngokucofa i icon ene-triangle, vula ibhokisi yencoko yababini apho ukhetha umbala oyifunayo.

2.

• Ukuba awuphumelelanga ukukhetha umbala womfanekiso onqwenelekayo, emva koko sebenzisa "eminye imibala". Kwifestile evula, khetha enye yeendlela zokukhetha imibala: Ngokwesi sikimu seselula okanye kwi-spectrum. Inketho yesibini yenza ukuba ikwazi ukukhetha ithoni echanekileyo.

3.

• Iqhosha elithi "Landisa umbala" ligcina ukhetho lokugqibela. Ke ngoko, ukuba uceba ukusebenzisa ngokugcwalisa ngombala omnye kwiindawo ezininzi, emva kokwenza ifowuni efunekayo, ungacofa kwiqhosha le-windows ngaphandle kokuvula iifestile ezongezelelweyo.

Inombolo yeNdlela 2: Ukuthulula ngepateni yombala

Ukwenza ukuba ukubulawa kwetafile ye-Excel akuzange kujongeka ngathi kuyadinisa kwaye i-monophonic, kunokwenzeka ukuba yahlukane nokugcwalisa iipateni kuyo. Cinga ngenkqubo yokwenza umsebenzi:

1. Khetha iiseli enye okanye ezingaphezulu apho kufuneka ubeke khona ipateni yombala.
2. Kwithebhu yasekhaya, khangela "ibhloko" yefonti kwaye ucofe iqhosha "Ifomathi yeseli", ibekwe kwikona esezantsi ngasekunene kwaye imelwe njengekrolo ebonisa i-angle.

ezine

1. Kwifestile evula, yiya "ukugcwalisa" umbala ongemva "sikhetha ithoni eyimfuneko yokugcwalisa.

Ntlanu

1. Okulandelayo, yenza enye yezi zinto zilandelayo:

• Ukuze ugcwalise imibala emibini esebenzisa le patheni, yiya kwi "pateni" kwaye ukhethe imibala eyimfuneko. Emva koko, yiya kumhlaba "wephethini" kwaye umisele isitayile soyilo.

6.

• Sebenzisa iziphumo ezikhethekileyo, kufuneka ulandele ikhonkco "lendlela yokufezekisa" kwaye ukhethe iiparamitha ezifanelekileyo. Ukuba iiparamitha ezikhethiweyo zicwangcisiwe, cinezela iqhosha u "Kulungile".

7 Indlela yokuthulula iseli esebenzisa izitshixo ezishushu

Le ndlela inokusetyenziswa ukuba iseli ikhethiwe ngaphambi kombala kwaye akukho ezinye zenziwayo. Inkqubo yezenzo zezenzo: Khetha iiseli ezifuna ukuhlengahlengiswa, kwaye cinezela "amaqhosha" ctrl + y ".

Ukuba ukugcwaliswa kwenziwe, kwaye emva koko, ubuncinci isenzo esinye senziwe, emva koko le ndlela ayizukusebenza, kuba ukudityaniswa kweqhosha elicetywayo kusekwe kwinzala yezenzo zamva nje, ukuba luhlobo lwebhodi eqhotyoshwayo.

Inombolo ye-4 yokudala i-macro

Le ndlela ifuna inkqubo ekhethekileyo ye-macrorecorer apho, ukuba nezakhono ezithile, unokwenza i-macros ukwenza iintshukumo ezahlukeneyo. Emfanekisweni Ungayibona ikhowudi yomzekelo ye-macro yeleacro.

Sibhozo

Ukususwa kweseli

Ukuba ufuna ukususa isalisa seseli ebekhekwe ngaphambili, emva koko sebenzisa imiyalelo engezantsi:

1. Khetha iiseli ezikhukuliseni ngombala okanye zepateni yemibala efuna uhlengahlengiso.
2. Kwithebhu yasekhaya, yiya kwi "font" ibhloko "yefonti". Cofa kwi icon ye-arrow kwaye uvule ibhokisi yencoko yababini. Yiya kwixabiso "akukho siko" kwaye usebenze ngokucinezela i-LKM.

Thoba

Ukuqukumbela

Zininzi iindlela zokugcwalisa umbala weseli. Ngamnye kubo unezibonelelo zayo kunye nezinto ezingalunganga. Kwezinye iimeko, kuyamkeleka ukusebenzisa indlela yokuqala, ekhawulezayo ukugcwalisa, kwabanye kubalulekile ukunikela ingqalelo ekhethekileyo kuyilo, ngoko ukongezwa kweepateni kuluncedo.

Umyalezo osisitshixo esishushu sokugcwalisa i-Excel kwi-Excel ivele kuqala kwitekhnoloji yolwazi.