Indlela yokuBalwa ngokuzenzekelayo kwi-Excel Excel

Inkqubo ye-Excel ye-Excel ibonelela abasebenzisi ngeendlela ezininzi zokuzenzekelayo. Ezinye zazo zilula kangangoko kunokwenzeka, zombini ekusebenzeni nasekusebenzeni, ngelixa ezinye zintsonkothile, kodwa zikwaqokelela amathuba amakhulu.

Indlela yoku-1: Ukuzalisa imigca emibini yokuqala

Indlela yokuqala ithetha ukuzaliswa kwemigca emibini yokuqala ngamanani.

1. Kumtya wokuqala okhethiweyo ngenxa yenani, sibeka inani - "1", kwi-yesibini ("2".



2. Sibalaselisa ezi seli zimbini zizalisa. Siba kwikona esezantsi ngasekunene kwezona zinto ziphantsi kuzo. Ukuzalelwa kokugcwaliswa kuyavela. Cofa iqhosha lemouse lasekhohlo kunye neqhosha elinepuni, liyiluleke kude kube sekupheleni kwetafile.

Njengoko ubona, inani lemigca lizaliswe ngokuzenzekelayo ngolungelelwano.

Le ndlela ilula kwaye ilungile, kodwa ilungile kuphela iitafile ezincinci, njengoko kukutsala uphawu etafileni kwikhulu elinamakhulu aliqela, kwaye kusanzima.

Indlela 2: Sebenzisa umsebenzi

Indlela yesibini yokuzaliswa ngokuzenzekelayo ibonelela ngokusetyenziswa kwe "ntambo".

1. Khetha iseli apho inani lenombolo "loku-1" liya kuba khona. Singena kumtya wefom yefomula "= umgca (A1)". Cofa kwiqhosha lokungena kwikhibhodi.



2. Njengakwicala elidlulileyo, Khuphela ifomula kwiiseli ezisezantsi zetafile yale kholamu kwiiseli ezisezantsi zokugcwalisa. Ngeli xesha kuphela esingamazisa iiseli ezimbini zokuqala, kodwa inye kuphela.

Njengoko ubona, inani lemitya kunye nale meko ilungiselelwe.

Kodwa, ngokukhulu, le ndlela ayifani kakhulu kwale yangaphambili kwaye ayisombululi ingxaki ngemfuneko yokutsala itafile yonke.

Indlela 3: Ukusetyenziswa kwenkqubela phambili

Indlela nje yesithathu yokusebenzisa inkqubela phambili ilungele iitafile ezinde enenani elikhulu lemigca.

1. Inombolo yokuqala yeseli ngendlela eqhelekileyo, kwi "1" yedijithi ukusuka kwiqhosha apho.



2. Kwiteyiphu kwi-Tool yebar yokuhlela, ekhoyo kwithebhu yasekhaya, cofa kwiqhosha "Laselisa". Kwimenyu ebonakalayo, cofa kwinkqubela phambili ".



3. Ifestile "yokuqhubela phambili" ivula. Kwindlela "ye" Indawo "kufuneka usete ukutshintshela kwisikhundla" ngeekholamu ". Inguqulelo "yohlobo" kufuneka ibe kwindawo ye-arithmetic. Kwintsimi "yenyathelo", kufuneka usete inani "1" ukuba ifakwe enye apho. Qiniseka ukuba ugcwalisa intsimi "yoMda". Apha kuya kufuneka uchaze inani lemigca efunekayo ukubalwa. Ukuba le parameter ayizaliswa, inani elizenzekelayo ayenziwanga. Ekupheleni, cofa kwiqhosha "Kulungile".

Njengoko ubona, intsimi yale migca yonke yetafile yakho iya kubalwa ngokuzenzekelayo. Kule meko, nokuba ungatsali nantoni na.

Njengolunye ukhetho, ungasebenzisa le nkqubo ilandelayo yendlela efanayo:

1. Kwiseli yokuqala, beka inani "1", kwaye chaza lonke uluhlu lweeseli ofuna ukubala.



2. Fowunela i-windows "uqhubela phambili" isixhobo ngendlela efanayo esithetha ngayo ngasentla. Kodwa ngeli xesha akukho mfuneko yokuba ungene okanye utshintshe. Ukubandakanya, faka idatha kwicandelo "lomda" aliyi kuba, kuba uluhlu olufunayo sele luphelisiwe. Kwanele ukucofa iqhosha "Kulungile".

Olu khetho lulungile ngenxa yokuba akufuneki, uqikelele, itafile inemigca emininzi. Kwangelo xesha, kuya kufuneka uwabele zonke iiseli zekholamu kunye neenombolo, okuthetha ukuba sibuyela ngokufanayo kangangokuba kusetyenziswa iindlela zokuqala: Ukuyibeka etafileni kwi-Niza yaya kwi-Niza.

Njengoko ubona, zintathu iindlela eziphambili zokusebenza ngokuzenzekelayo kwimiqolo. Kwezi zinto, ezona zinto zisebenzayo zinokhetho kunye nenani lemigca emibini yokuqala ekopisha (njengeyona ndlela ilula) kunye nokukhetha ukusebenzisa iitafile ezinkulu).