Okuqukethwe
Kwezinye izimo, kuba kudingekile ukuvikela imininingwane kumaseli wedokhumenti ye-Excel ukuthi ingashintshwa. Amaseli anamafomula anqunyiwe noma amaseli anedatha ngesisekelo sokubala okwenziwayo angaphansi kokuvikelwa okunjalo. Uma okuqukethwe kwamaseli anjalo kushintshaniswa, khona-ke ukubala kumathebula kungase kwephulwe. Futhi, ukuvikelwa kwedatha kumaseli kubalulekile lapho udlulisela ifayela kubantu besithathu. Ake sibheke ezinye zezindlela ezivame kakhulu zokuvikela amaseli ekushintsheni ku-Excel.
Vula ukuvikelwa kweseli
Umsebenzi ohlukile wokuvikela okuqukethwe kwamaseli ku-ExcelNgeshwa onjiniyela be-Excel akazange abone kusengaphambili. Kodwa-ke, ungasebenzisa izindlela ezikuvumela ukuthi uvikele lonke ishidi lokusebenzela ezinguqukweni. Kunezindlela eziningana zokusebenzisa ukuvikela okunjalo, esizojwayelana nakho manje.
Indlela 1: Ukusebenzisa Imenyu Yefayela
Njengendlela yokuqala, cabanga ukunika amandla ukuvikelwa kweshidi le-Excel ngemenyu yefayela.
- Okokuqala, khetha okuqukethwe kweshidi lokusebenzela. Ukuze wenze le nqubo ibe lula, mane uchofoze unxantathu ezimpambanweni zamabha wokuxhumanisa ekhoneni eliphezulu kwesokunxele. Kulabo abathanda ukusebenzisa okhiye abashisayo, kukhona inhlanganisela esheshayo elula "Ctrl + A". Uma ucindezela inhlanganisela kanye ngeseli esebenzayo ngaphakathi kwetafula, kukhethwa ithebula kuphela, futhi uma ulicindezela futhi, kukhethwa lonke ishidi lokusebenza.
- Okulandelayo, sibiza imenyu ye-pop-up ngokucindezela inkinobho yegundane kwesokudla, futhi wenze kusebenze ipharamitha ethi "Fometha Amaseli".
- Efasiteleni elithi “Fometha amaseli”, khetha ithebhu ethi “Protection” bese ususa ukumaka ibhokisi eliseduze nepharamitha ethi “Amaseli Avikelekile”, chofoza inkinobho ethi “KULUNGILE”.
- Manje sikhetha indawo edingekayo yamaseli adinga ukuvikelwa ekuhleleni okungafunwa, isibonelo, ikholomu enamafomula. Futhi, khetha "Fometha Amaseli" futhi kuthebhu "Ukuvikela", buyisela uphawu lokuhlola kulayini "Amaseli Avikelwe". Phuma ewindini ngokuchofoza KULUNGILE.
- Manje ake siqhubekele ekuvikeleni ishidi lokusebenza. Ukuze wenze lokhu, yiya kuthebhu "Ifayela".
- Kupharamitha ethi “Imininingwane”, chofoza okuthi “Vikela incwadi yokusebenzela”. Imenyu ye-pop-up izovela lapho siya khona esigabeni esithi "Vikela ishidi lamanje".
- Iwindi elincane lizovela, lapho phambi kwepharamitha ethi "Vikela ishidi nokuqukethwe kwamaseli avikelwe", hlola ibhokisi uma lingatholakali. Ngezansi kunohlu lwemibandela ehlukahlukene umsebenzisi ayigcwalisayo ngokubona kwakhe.
- Ukuze wenze ukuvikela kusebenze, kufanele ufake iphasiwedi ezosetshenziswa ukuvula ishidi lokusebenzela le-Excel.
- Ngemuva kokufaka iphasiwedi, kuzovela iwindi lapho udinga ukuphinda khona iphasiwedi bese uchofoza "Kulungile".
Ngemva kwalezi zikhohlisi, ungakwazi ukuvula ifayela, kodwa ngeke ukwazi ukwenza izinguquko kumaseli avikelwe, kuyilapho idatha ekumaseli angavikelekile ingashintshwa.
Indlela yesi-2: Buyekeza Ithuluzi Lethebhu
Enye indlela yokuvikela idatha kumaseli wedokhumenti ye-Excel ukusebenzisa amathuluzi esigabeni sokubukeza. Ukulandelana kwezenzo kanje:
- Okokuqala udinga ukuphinda amaphuzu okuqala angu-5 endleleni yangaphambilini yokusetha ukuvikela, okungukuthi, okokuqala sisusa ukuvikelwa kuyo yonke idatha, bese sibeka ukuvikelwa kumaseli angenakushintshwa.
- Ngemva kwalokho, hamba kuthebhu ethi “Buyekeza” bese uthola inketho ethi “Vikela Ishidi” esigabeni esithi “Vikela”.
- Uma uchofoza inkinobho ethi “Vikela Ishidi”, kuzovela iwindi lokufaka igama-mfihlo, elifana nasendleleni edlule.
Ngenxa yalokho, sithola ishidi le-Excel, eliqukethe inani lamaseli avikelwe ezinguqukweni.
Nakani! Uma usebenza ku-Excel ngendlela ecindezelwe ngokuvundlile, lapho-ke uchofoza kubhulokhi yamathuluzi ebizwa ngokuthi “Ukuvikela”, kuvulwa uhlu lwemiyalo, oluqukethe imiyalo etholakalayo.
Ukususwa kokuvikela
Manje ake sithole ukuthi singasebenza kanjani ngamaseli avikelwe ezinguqukweni.
- Uma uzama ukufaka idatha entsha kuseli elivikelwe, uzoxwayiswa ukuthi iseli livikelekile nokuthi udinga ukususa ukuvikela.
- Ukuze ususe ukuvikela, hamba kuthebhu ethi "Buyekeza" futhi kubhulokhi ethi "Ukuvikela" sithola inkinobho ethi "Ishidi elingavikelekile".
- Uma uchofoza le nketho, kuvela iwindi elincane elinenkambu yokufaka iphasiwedi.
- Kuleli windi, faka iphasiwedi esetshenziswe ukuvikela amaseli bese uchofoza "Kulungile".
Manje ungaqala ukwenza izinguquko ezidingekayo kunoma imaphi amaseli kudokhumenti.
Kubalulekile! Khetha iphasiwedi okulula ukuyikhumbula kodwa okunzima ukuthi abanye abasebenzisi bayiqagele.
Isiphetho
Njengoba kuphawuliwe ekuqaleni, awukho umsebenzi okhethekile ku-Excel ukuvikela amaseli akhethiwe ezinguqukweni ezingafuneki. Kodwa-ke, kunezindlela ezimbalwa ezinokwethenjelwa ezikuvumela ukuthi ukhawulele ukufinyelela kudatha equkethwe efayeleni, noma okungenani uvikele idokhumenti ekulungisweni, okungase konakalise umsebenzi okuchithwe kuwo isikhathi esiningi nomzamo.