Ungawavikela kanjani amaseli ekushintsheni ku-Excel

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.

  1. 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.
  2. Okulandelayo, sibiza imenyu ye-pop-up ngokucindezela inkinobho yegundane kwesokudla, futhi wenze kusebenze ipharamitha ethi "Fometha Amaseli".
Ungawavikela kanjani amaseli ekushintsheni ku-Excel
Khetha okuthi “Fometha Amaseli”
  1. Efasiteleni elithi “Fometha amaseli”, khetha ithebhu ethi “Protection” bese ususa ukumaka ibhokisi eliseduze nepharamitha ethi “Amaseli Avikelekile”, chofoza inkinobho ethi “KULUNGILE”.
Ungawavikela kanjani amaseli ekushintsheni ku-Excel
Thola ithebhu "Ukuvikela".
  1. 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.
  2. Manje ake siqhubekele ekuvikeleni ishidi lokusebenza. Ukuze wenze lokhu, yiya kuthebhu "Ifayela".
  3. Kupharamitha ethi “Imininingwane”, chofoza okuthi “Vikela incwadi yokusebenzela”. Imenyu ye-pop-up izovela lapho siya khona esigabeni esithi "Vikela ishidi lamanje".
Ungawavikela kanjani amaseli ekushintsheni ku-Excel
Vikela ishidi le-Excel lamanje ngemenyu yefayela
  1. Iwindi elincane lizovela, lapho phambi kwepharamitha ethi "Vikela ishidi nokuqukethwe kwamaseli avikelwe", hlola ibhokisi uma lingatholakali. Ngezansi kunohlu lwemibandela ehlukahlukene umsebenzisi ayigcwalisayo ngokubona kwakhe.
  2. Ukuze wenze ukuvikela kusebenze, kufanele ufake iphasiwedi ezosetshenziswa ukuvula ishidi lokusebenzela le-Excel.
Ungawavikela kanjani amaseli ekushintsheni ku-Excel
Faka iphasiwedi ukuze uvikele ishidi
  1. 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:

  1. Okokuqala udinga ukuphinda amaphuzu okuqala angu-5 endleleni yangaphambilini yokusetha ukuvikela, okungukuthi, okokuqala sisusa ukuvikelwa kuyo yonke idatha, bese sibeka ukuvikelwa kumaseli angenakushintshwa.
  2. Ngemva kwalokho, hamba kuthebhu ethi “Buyekeza” bese uthola inketho ethi “Vikela Ishidi” esigabeni esithi “Vikela”.
Ungawavikela kanjani amaseli ekushintsheni ku-Excel
Lapho ungabheka khona okuthi “Vikela Ishidi” ku-Excel
  1. 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.

Ungawavikela kanjani amaseli ekushintsheni ku-Excel
Amapharamitha webhulokhi yamathuluzi "Ukuvikela".

Ukususwa kokuvikela

Manje ake sithole ukuthi singasebenza kanjani ngamaseli avikelwe ezinguqukweni.

  1. Uma uzama ukufaka idatha entsha kuseli elivikelwe, uzoxwayiswa ukuthi iseli livikelekile nokuthi udinga ukususa ukuvikela.
Ungawavikela kanjani amaseli ekushintsheni ku-Excel
Shintsha Isexwayiso
  1. Ukuze ususe ukuvikela, hamba kuthebhu ethi "Buyekeza" futhi kubhulokhi ethi "Ukuvikela" sithola inkinobho ethi "Ishidi elingavikelekile".
  2. Uma uchofoza le nketho, kuvela iwindi elincane elinenkambu yokufaka iphasiwedi.
Ungawavikela kanjani amaseli ekushintsheni ku-Excel
Faka iphasiwedi ukuze ususe ukuvikeleka eshidini le-Excel
  1. 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.

shiya impendulo