Okuqukethwe
Enkambweni yokusebenza namadokhumenti ku-Excel, abasebenzisi bangakha amashidi amasha, okudingeka kakhulu ezimweni eziningi ukuze kuxazululwe umsebenzi ngempumelelo. Kodwa-ke, ngokuvamile kunesidingo sokususa amashidi angadingekile ngolwazi olungadingekile, ngoba athatha indawo eyengeziwe kubha yesimo somhleli, isibonelo, uma eningi kakhulu futhi ufuna ukwenza kube lula ukushintsha phakathi kwawo. Kumhleli, kungenzeka ukususa kokubili ikhasi elingu-1 nangaphezulu ngesikhathi. Lesi sihloko sixoxa ngezindlela okungenzeka ngazo ukwenza le nqubo.
Ukususa ishidi ku-Excel
Incwadi yokusebenzela ye-Excel inenketho yokwenza amakhasi amaningi. Ngaphezu kwalokho, imingcele yokuqala isethwe ngendlela yokuthi idokhumenti isivele ihlanganisa amashidi angu-3 phakathi nenqubo yokudala. Nokho, kunezimo lapho umsebenzisi edinga ukususa inani lamakhasi ngolwazi noma angenalutho, ngoba aphazamisa umsebenzi. Lokhu kungenziwa ngezindlela eziningana.
Ukusebenzisa imenyu yokuqukethwe kuyindlela evamile futhi elula yokwenza inqubo yokukhipha, empeleni, ngokuchofoza oku-2:
- Ngalezi zinhloso, kusetshenziswa imenyu yokuqukethwe, ebizwa ngokuchofoza kwesokudla ekhasini elizosuswa.
- Ewindini elivulayo, khetha "Susa".
1 - Ngemuva kwalokho, ikhasi elingadingekile lizosuswa unomphela encwadini.
Ukususwa ngamathuluzi ohlelo
Indlela ecatshangelwayo ayithandwa kakhulu, kodwa futhi ingasetshenziswa ngokulinganayo nezinye.
- Ekuqaleni, ishidi elizosuswa likhethiwe.
- Ngemuva kwalokho kufanele uye kumenyu ethi “Ekhaya”, uchofoze kubhulokhi ethi “Amaseli, ohlwini oluvulayo, cindezela umcibisholo omncane eduze kwenkinobho ethi “Susa”.
2 - Khetha okuthi “Susa Ishidi” kumenyu ye-pop-up.
3 - Ikhasi elishiwo lizosuswa encwadini.
Kubalulekile! Uma iwindi elinohlelo linwetshiwe kakhulu ngobubanzi, ukhiye othi "Susa" uboniswa kumenyu ethi "Ekhaya" ngaphandle kwesidingo sokuchofoza "Amaseli" kusengaphambili.
Isusa amashidi amaningi ngesikhathi esisodwa
Inqubo yokususa amashidi amaningi encwadini iyafana nezindlela ezichazwe ngenhla. Kodwa-ke, ukuze ususe amakhasi amaningana, ngaphambi kokwenza isenzo ngokwaso, kuyadingeka ukukhetha wonke amashidi angadingekile azosuswa kumhleli.
- Uma amakhasi engeziwe ehlelwa ngokulandelana, angakhethwa ngale ndlela: ishidi eli-1 lichofozwa, bese inkinobho ethi "Shift" icindezelwe futhi ibanjwe bese kukhethwa ikhasi lokugcina, ngemva kwalokho ungakhulula inkinobho. Ukukhethwa kwalawa mashidi kungenzeka ngokulandelana - kusukela ekudluleleni kuya kokuqala.
4 - Esimeni lapho amakhasi azosuswa khona engekho emgqeni, abelwe ngokuhlukile. Inkinobho ethi "Ctrl" icindezelwe, ngemuva kokuchofoza inkinobho yegundane kwesokunxele wonke amashidi adingekayo akhethiwe, bese kukhishwa inkinobho.
5 - Uma amakhasi angadingekile abiwe, kungenzeka ukuthi uqale inqubo yokususa ngokwayo nganoma iyiphi yalezi zindlela ezingenhla.
Ukubuyisela ishidi elisusiwe
Kwesinye isikhathi kuvela isimo sokuthi umsebenzisi asuse amashidi kumhleli ngephutha. Akubona kuzo zonke izimo kuzokwazi ukubuyisela ikhasi elisusiwe. Akukho ukuqiniseka okugcwele ukuthi ikhasi lizobuyiselwa, noma kunjalo, ezimweni eziningi kungenzeka ukufeza umphumela omuhle.
Lapho iphutha eliphelele litholwa ngesikhathi (ngaphambi kokulondoloza idokhumenti ngezinguquko ezenziwe), yonke into ingalungiswa. Udinga ukuqeda ukusebenza nomhleli, cindezela inkinobho enqamulayo phezulu kwesokudla sedokhumenti. Ebhokisini lengxoxo elivelayo, khetha inketho ethi “Ungalondolozi”. Ngemva kokuvulwa okulandelayo kwedokhumenti, wonke amakhasi azobe esendaweni.
Kubalulekile! Kufanele kukhunjulwe ukuthi ngenqubo yale ndlela yokutakula, idatha efakwe kudokhumenti ngemva kokugcina kokugcina (uma kwakukhona iqiniso lokwenza izinguquko) izonyamalala. Kulokhu, umsebenzisi uzoba nokukhetha ukuthi yiluphi ulwazi olubaluleke kakhulu kuye.
Uma iphutha litholwa ngenkathi ifayela ligcinwa, khona-ke ithuba lomphumela omuhle liphansi nakakhulu, kodwa esimweni esinjalo kukhona ithuba lokuphumelela.
- Isibonelo, kusihleli se-Excel 2010 nasezinguqulweni zakamuva, ungavula "Ifayela" kumenyu enkulu bese ukhetha "Imininingwane".
- Phansi maphakathi nemonitha, uzobona ibhulokhi ethi "Izinguqulo", equkethe izinguqulo ezihlukile zencwadi. Zikuyo ngenxa yokulondoloza okuzenzakalelayo, okwenziwa umhleli ngokuzenzakalelayo njalo ngemizuzu eyi-10 (uma umsebenzisi engayikhubaza le nto).
7 - Ngemuva kwalokho, ohlwini lwezinguqulo, udinga ukuthola okwakamuva ngedethi, bese uchofoza kukho.
- Ewindini elivulayo, ungabona incwadi egciniwe.
- Ukuze uqedele inqubo yokubuyisela, chofoza okuthi "Buyisela" ngenhla kwethebula.
- Umhleli uhlongoza ukufaka le nguqulo esikhundleni sedokhumenti elondolozwe ngaphambilini ngumsebenzisi. Uma lokhu kuyinketho oyifunayo, kufanele uchofoze "OK". Uma ufuna ukulondoloza inketho ngayinye, udinga ukunikeza ifayela igama elehlukile.
8
Ukuthuthukiswa okungajabulisi kakhulu kwemicimbi kungase kube inketho lapho idokhumenti ingagcinwanga futhi ivaliwe. Uma umsebenzisi ethola ukuthi ibhuku alikho lapho ephinda evula ibhuku, ithuba lokubuyisela idokhumenti liphansi kakhulu. Ungazama ukuphinda izinyathelo ezivela esibonelweni sangaphambilini futhi, ngemva kokuvula iwindi elithi “Version Control”, khetha okuthi “Buyisela Izincwadi Ezingalondoloziwe”. Kungenzeka ukuthi ifayela elidingekayo lizotholakala ohlwini oluvulayo.
Ekuphetheni, kufanele kuthiwe mayelana nendlela elula yokususa ishidi elifihliwe emehlweni e-prying. Ekuqaleni, kufanele iboniswe, lapho inkinobho yegundane engakwesokudla icindezelwa kunoma iyiphi ilebula futhi inketho ethi "Display" icushiwe.
Ishidi elidingekayo likhethiwe efasiteleni, "KULUNGILE" icindezelwe. Inqubo elandelayo iyafana.
Isiphetho
Inqubo yokususa amashidi angadingekile kumhleli ilula futhi ilula ngokuphelele. Nokho, ngesikhathi esifanayo, ngezinye izikhathi kuyasiza kakhulu “ukukhipha” incwadi nokwenza umsebenzi ube lula. Ukusebenzisa noma yiziphi izindlela ezingenhla, ungafinyelela umphumela omuhle.