I-Excel Gcwalisa I-Down Command

Londoloza isikhathi bese ukwandisa ukunemba ngokukopisha idatha kwamanye amaseli

Umyalo wokugcwalisa we-Microsoft Excel kukusiza ukuba ugcwalise amaseli ngokushesha futhi kalula. Lesi sifundo esifushane sibandakanya izinqamuleli zekhibhodi ukwenza umsebenzi wakho ube lula nakakhulu.

Ukufaka izinombolo, umbhalo, namafomula kuma-spreadsheet e-Excel kungadambisa futhi kulungiswe iphutha uma ufaka umbhalo ngamunye weselula noma ukhethe ngokwehlukana. Uma udinga ukufaka idatha efanayo kuye kwamanani amangqamuzana athile ekholomu , umyalo ogcwalisa phansi ungakwenza lokhu ngokushesha nje ngokusebenzisa ikhibhodi.

Inhlanganisela eyinhloko esebenzayo Umyalo wokugcwalisa phansi i- Ctrl + D (Windows) noma i- Command + D (i-MacOS).

Ukusebenzisa ukugcwalisa phansi ngeSinqamuleli sekhibhodi futhi akukho Mouse

Indlela engcono kakhulu yokubonisa umyalo wokugcwalisa phansi unesibonelo. Landela lezi zinyathelo ukuze ubone ukuthi ungayisebenzisa kanjani Gcwalisa phansi kuzipredishithi zakho ze-Excel.

1. Thayipha inombolo, efana no- 395.54 , ibe esitokisini D1 ku-spreadsheet ye-Excel.
2. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
3. Cindezela bese ubamba ukhiye we- Down Arrow ekhibhodi ukwandisa ukugqamisa kweseli kusuka kuseli D1 kuya ku-D7.
4. Khipha kokubili okhiye.
5. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
6. Cindezela bese ukhulula ukhiye we- D ekhibhodi.

Amaseli D2 kuya ku-D7 kufanele manje agcwaliswe ngemininingwane efanayo njengeseli D1.

Gcwalisa Isibonelo Esiphansi Ukusebenzisa Umouse

Ngezinguqulo eziningi ze-Excel, ungasebenzisa i-mouse yakho ukuze uchofoze esitokisini ngenombolo ofuna ukuyiphindaphinda emaqenjini ngaphansi kwayo bese uchofoza esitokisini sokugcina ebangeni ukuze ukhethe amaseli okuqala namagcina nawo wonke amaseli phakathi kwabo. Sebenzisa isinqamuleli sekhibhodi ye- Ctrl + D (Windows) noma i- Command + D (i-MacOS) ukukopisha inombolo esesitokisini sokuqala kuwo wonke amaseli akhethiwe.

Isixazululo sesici se-AutoFill

Nakhu ukuthi ungayifeza kanjani umphumela ofanayo nesici se-AutoFill:

1. Thayipha inombolo ibe yiseli ku-spreadsheet ye-Excel.
2. Chofoza bese ubamba isibambo sokugcwalisa ekhoneni elingezansi elingakwesokudla leseli eliqukethe inombolo.
3. Hudula isibambo sokugcwalisa phansi ukuze ukhethe amaseli ofuna ukufaka inombolo efanayo.
4. Khipha igundane nenombolo ikopiwe ngayinye yamaseli akhethiwe.

Isici se-AutoFill siphinde sisebenze ngokuzenzekelayo ukukopisha inombolo kumaseli aseduze kumugqa ofanayo. Vele uchofoze bese uhudula isibambo sokugcwalisa kuwo wonke amaseli ngokuzenzekelayo. Uma ukhulula igundane, inombolo ikopishwa kwiseli ngayinye ekhethiwe.

Le ndlela isebenza ngamafomula ngaphezu kokubhaliwe nezinombolo. Esikhundleni sokubambelela ngokukhululekile noma ukukopisha nokusetha ifomula, khetha ibhokisi eliqukethe ifomula. Chofoza bese ubamba isibambo sokugcwalisa bese usihudula phezu kwamaseli ofuna ukufaka ifomula efanayo.