Indlela Excel itheyibhile ukudibanisa umqolo: ezineenkcukacha imiyalelo

Ukuba usebenza umhleli, leyo ziyingxenye yempahla ye iyonke Microsoft Office, ngoko ngokuqinisekileyo kufuneka akwazi Excel njani itheyibhile ukudibanisa umqolo, njengoko esi senzo udla efunekayo ngexesha imisebenzi ethile xa uhlela uxwebhu. Makhe zama ukulungisa lo mba. Ukuze ukudibanisa umqolo kwi Excel spreadsheet, awufuni ukusebenzisa naziphi na iinkonzo ezongezelelweyo. Yonke kwenziwa ngqo usebenzisa izixhobo umlinganiselo ukuba akhoyo kule nkqubo. Namhlanje siza kuthetha ukuba ukwenza njani ilungelo ukudibanisa okanye ukucima lwemiqolo nemihlathi ngendlela spreadsheet Excel. Ngokuqinisekileyo eli nqaku liza kukunceda zokujongana nemiba efana yonke inkqubo iya kuchazwa inyathelo version step.

yokuqalisa

Into yokuqala ekufuneka nqakraza kwi menu iqhosha "Qala", uyaqaphela kwikona esezantsi ekhohlo screen sakho. Ngaphezu koko, kufuneka uye kwindawo of "Iinkqubo Zonke", ngokulandelelana, ngoko ukufumana isicelo Excel. Running le program elenziwe kwifolda ekwabelwana ukuba unalo igama Microsoft Office ngqo.

ukuhlela

Inyathelo lesibini. Ukulungisa itafile ethile, into yokuqala ufuna isicelo, kwaye benze oku, khetha ukusuka kwiprogram ye-Excel uluhlu uvule. Xa uxwebhu iyasebenza, kufuneka ukulayisha ifayile ekhoyo okanye uqale ekuqaleni, nanku ke kuya kuxhomekeka kwiimfuno zakho kuphela.

endle ezongezelelweyo

Inyathelo lesithathu. Kufuneka imenyu phantsi etafileni kwaye wenze kukhethwe iseli entsha, nto leyo ehambisana kwi kwikholam. Emva koko cofa Tab kwibhodi yakho iqhosha okhethekileyo, kuyimfuneko ukwenza ukudaleka umgca omtsha engenanto. Loo nto bonke, landela imiyalelo - kwaye ungafunda ukuba avelele indlela itheyibhile ukudibanisa umqolo.

umyalelo

Inyathelo lesine. Ngoku kufuneka ukuba ufake ixabiso ezifunekayo esiseleni, kunokuba zombini iisimboli nokubhaliweyo ethile. Unako kwakhona ukudibanisa umqolo omtsha okanye utsale phantsi isiqu ubungakanani page. Le limiter na emazantsi-ekunene kwetafile ofuna ukuyihlela.

Inyathelo lesihlanu. Kufuneka kwenziwe nangononophelo olukhulu. Kufuneka ukhethe umqolo phambi apho uceba ukwenza elitsha (ezongeziweyo), ngoko ukuba kufuneka ukuvula i menu okhethekileyo, ebizwa ngokuba "iiseli." Olu phawu ibekwe kwiqela lenjongo encotsheni-Microsoft Office. Ukuze ufake inkqubo Excel ukuba icace ngakumbi, sicebisa ukuba ukukhumbula onke amanyathelo, kangangokuba akukho ngozi kwakhona uxwebhu lakho kwaye wenze zonke kakhulu ezichanekileyo.

Xa inyathelo wesithandathu kufuneka ukhethe iqela elilodwa, leyo igama "Cola", ngoko nqakraza utolo lokwalatha, ebekwe ecaleni emgceni. Noko ke, kulula ukuba uqaphele, ukuze uhambe okungalungile.

Inyathelo lesixhenxe. Ngoku kufuneka ukukhankanya into eyodwa, ebizwa "Faka umqolo phezulu itafile." Ukuze wenze likwiphulo lokongeza, kufuneka usebenzise umsebenzi ofanayo 'ukusuka ngezantsi ". Kuyimfuneko ukuba ukongeza into efunekayo ekupheleni kolu xwebhu. Noko ke, yonke into icacile, yaye kwitheyibhile Excel ukufaka umqolo, sele uyazi phantse.

Inyathelo lwesibhozo kubalulekile kakhulu ukuba yimbonakalo njengento kwindawo ethile. Kufuneka phambi-ukhethe umqolo phambi ofuna ukufaka entsha. Kwixa elizayo, ungenza ngokulula ukuyisusa kwindawo oyifunayo. Emva kokukhetha indlela umgca ukuvula i menu. Oku kwenziwa ngokusebenzisa i ekunene iqhosha le mouse. Okulandelayo, khetha umyalelo "Cola", ngoko ke kufuneka ubone umgca omtsha, ungahlela uwedwa.

isiphelo

Inyathelo lethoba. Xa ucofa ucinezela iqhosha lemouse ekunene kumgca ethile ukongeza entsha, ungakhetha intshukumo ofunekayo, okanye vula umxholo menu esiseleni, kufuneka kuqala watshoyo. Ngaphezu koko, kwi-drop-down menu, khetha i tab "Faka". Eli nyathelo yinkqubo eyahlukileyo eza kunceda ukuqonda ukuba Excel njani itheyibhile ukudibanisa umqolo, ngoko musa hambanisi kunye nemiyalelo, le ndlela kuyinto enye.

Ukugcwalisa. Inyathelo yeshumi. Kuya kufuneka ukuba ukhankanye umxholo menu ukhetho "Uluhlu imiqolo phezulu", kufuneka ukuba kuqinisekiswe ukuba umsebenzi okhethiweyo kwenziwa. Faka intsimi entsha ungakwazi ngokwakho, kwakunye ukuba ukususa ngokukhawuleza xa kuyimfuneko. Xa ndiqukumbela, siphawula ukuba Excel - yinkqubo esele ezidalwe ngokukhethekileyo ukuba spreadsheet. Ngamandla yesicelo, unako ukwenza izibalo ezoqoqosho manani kunye nokusetyenziswa kwezixhobo lomzobo. Okwangoku, Excel - le yenye yeenkqubo idumileyo ehlabathini.