Qedela ngokuzenzakalela amaseli ku-Excel

Ukuqedela ngokuzenzakalela amaseli ku-Excel kukuvumela ukuthi usheshise ukufakwa kwedatha ekhasini lokusebenzela. Ezinye izenzo ku-Microsoft Excel kufanele ziphindwe izikhathi eziningana, okuthatha isikhathi esiningi. Kuwukwenza ngokuzenzakalelayo imisebenzi enjalo ukuthi umsebenzi wokuqedela ngokuzenzakalela wathuthukiswa. Kulesi sifundo, sizobheka izindlela ezivame kakhulu zokugcwalisa ngokuzenzakalelayo: ukusebenzisa umaka nokugcwaliswa kwe-flash, okuvele okokuqala ku-Excel 2013.

Ukusebenzisa umaka wokugcwalisa okuzenzakalelayo ku-Excel

Kwesinye isikhathi udinga ukukopisha okuqukethwe kumaseli amaningi aseduze ekhasini lokusebenza. Ungakopisha futhi unamathisele idatha kuseli ngayinye ngayinye, kodwa kunendlela elula kakhulu. Ukuze wenze lokhu, udinga ukusebenzisa isibambo sokuqedela ngokuzenzakalela, esikuvumela ukuthi ukopishe futhi unamathisele idatha ngokushesha.

1. Khetha iseli ofuna ukuyiphinda idatha yayo. Isikwele esincane sizovela ekhoneni elingezansi kwesokudla seseli ekhethiwe - lona umaka wokugcwalisa okuzenzakalelayo.
2. Chofoza futhi ubambe inkinobho yegundane kwesokunxele bese uhudula isibambo sokugcwalisa ngokuzenzakalela kuze kube yilapho wonke amaseli adingekayo egqanyisiwe. Ngokushesha, ungagcwalisa amaseli kungaba ikholomu noma umugqa.
3. Dedela inkinobho yegundane ukuze ugcwalise amaseli akhethiwe.

Gcwalisa Ngokuzenzakalelayo Uchungechunge Lwedatha Elandelanayo ku-Excel

Ithokheni yokuqedela ngokuzenzakalela ingasetshenziswa noma nini lapho udinga ukugcwalisa idatha enohlelo olulandelanayo. Isibonelo, ukulandelana kwezinombolo (1, 2, 3) noma izinsuku (ngoMsombuluko, ngoLwesibili, ngoLwesithathu). Ezimweni eziningi, uzofuna ukukhetha amaseli amaningi ngaphambi kokusebenzisa umaka ukuze usize i-Excel inqume isinyathelo sokulandelana.

Isibonelo esingezansi sisebenzisa ithokheni yokuqedela ngokuzenzakalela ukuze uqhubeke nokulandelana kwamadethi kukholomu.

Gcwalisa Ngokushesha ku-Excel

I-Excel 2013 inenketho entsha ye-Flash Fill engafaka idatha ngokuzenzakalelayo eshidini lokusebenzela, ikugcinele isikhathi nomzamo. Njengokugcwalisa Ngokuzenzakalelayo, le nketho ilawula ukuthi yiluphi uhlobo lolwazi olufaka ekhasini lokusebenza.

Esibonelweni esingezansi, sisebenzisa i-Flash Fill ukuze sakhe uhlu lwamagama ohlwini olukhona lwamakheli e-imeyili.

1. Qala ukufaka idatha ekhasini lokusebenza. Uma i-Flash Fill ithola iphethini, ukubuka kuqala kwezinketho kuvela ngezansi kweseli egqanyisiwe.
2. Cindezela u-Enter. Idatha izongezwa eshidini.

Ukuze uhlehlise noma uguqule umphumela wesenzo Sokugcwalisa I-Flash, chofoza kuthegi ehlakaniphile evela eduze kwamanani asanda kwengezwa.