Gcina ixesha kwaye ukwandise ukuchaneka ngokukopisha idatha kwezinye iiseli
Umyalelo wokuzaliswa kweMicrosoft Excel kukunceda uzalise iiseli ngokukhawuleza kwaye kulula. Esi sifundo esifutshane sibandakanya iifutshane zebhodibhodi ukwenza umsebenzi wakho ube lula.
Ukufaka iinombolo, itekisi kunye neifomula kwi-spreadsheets ze-Excel ziyakhathaza kwaye zilungelelaniswe impazamo xa ufaka isicatshulwa nganye yeselunkile okanye uxabise ngokwahlukileyo. Xa udinga ukufaka idatha efanayo kwifom yeeseli ezikufutshane kwikholam , umyalelo wokugcwalisa phantsi unokukwenza ngokukhawuleza ukukwenza ngoku usebenzisa ikhibhodi.
Inhlanganisela ebalulekileyo esebenzayo Umyalelo wokugcwalisa u- Ctrl + D (Windows) okanye i- Command + D (i-MacOS).
Ukusebenzisa Ukugcwalisa Ngeqhosha leKhodibhodi yeKhodi kwaye akukho Mouse
Indlela efanelekileyo yokubonisa umyalelo wokugcwalisa umzekelo. Landela lamanyathelo ukuze ubone indlela yokusebenzisa Gcwalisa phantsi kwi-spreadsheets zakho ze-Excel.
- Thayipha inombolo, efana ne- 395.54 , kwi- cell D1 kwi-spreadsheet ye-Excel.
- Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi.
- Cinezela kwaye ubambe iqhosha laseNtshonalanga phantsi kwebhodibhodi ukwandisa ukugqwesa kweeseli kwiseli D1 ukuya kwi-D7.
- Ukukhupha zombini izitshixo.
- Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
- Cinezela kwaye ukhulule ikhi yeD e kwikhibhodi.
Iiseli zeD2 ukuya kwi-D7 kufuneka ngoku zizaliswe ngedata efanayo kunye neseli D1.
Gcwalisa Umzekelo Osebenzisa Uluhlu
Ngeenguqu ezininzi ze-Excel, ungasebenzisa imouse yakho ukucofa kwiseli nenombolo ofuna ukuyiphinda kwiiseli phantsi kwayo kwaye uklikha kwi-cell yokugcina kwimiba ukukhetha iiseli zokuqala nezokugqibela kunye nazo zonke iiseli phakathi kwabo. Sebenzisa i-shortcut Ctrl + D (Windows) okanye i- Command + D (i-MacOS) ukukopisha inombolo esekuqaleni kweseli kuzo zonke iiseli ezikhethiweyo.
Isisombululo seSigqibo se-AutoFill
Nantsi indlela yokufeza umphumo ofanayo kunye nesici se-AutoFill:
- Thayipha inamba kwiseli kwi-spreadsheet ye-Excel.
- Cofa uze ubambe kwisibambo sokugcwalisa kwikhoneni elingezantsi lasezantsi leseli equle inombolo.
- Hudula isibambo sokugcwalisa phantsi ukuze ukhethe iiseli ofuna ukudibanisa inombolo efanayo.
- Ukukhulula imouse kwaye inombolo ikopishwe kwiiseli nganye ezikhethiweyo.
I-AutoFill ifayile isebenza ngokukhawuleza ukukopisha inamba kumaseli athile kumqolo omnye. Chofoza nje uze udibanise isibambo sokugcwalisa kwiiseli ngokubanzi. Xa ukhulula imouse, inombolo ikopishwa kwiseli nganye ekhethiweyo.
Le ndlela isebenza ngamafomula ngaphezu kokubhaliweyo kunye namanani. Esikhundleni sokubambelela ngokukhawuleza okanye ukukopisha kunye nokwenza ifomula, khetha ibhokisi equle ifom. Cofa uze ubambe isibambo sokugcwalisa uze uyihuqe phezu kweeseli ofuna ukufumana ifomula efanayo.