Indlela Yokukhiya Amaseli nokuvikela Ama-Worksheets ku-Excel

Ukuze uvimbele izinguquko zengozi noma ezenzakalelayo kwezinye izakhi ezisekhasini lokusebenzela noma ebhukwini , i-Excel ineamathuluzi okuvikela ezinye izakhi zomsebenzi ongasetshenziswa noma ngaphandle kwephasiwedi.

Ukuvikela idatha kusuka ekushintsheni kwiphepha lokusebenzela le-Excel kuyinkqubo ezinyathelo ezimbili.

1. Ukukhiya / ukuvula amaseli athile noma izinto, ezifana namashadi noma ihluzo, kushidi lokusebenzela.
2. Ukusebenzisa okukhethwa kweShidi Lokuvikela - kuze kube sekugcineni isinyathelo sesi-2, zonke izakhi zephepha lokusebenza kanye nedatha zisengozini yokushintsha.

Qaphela : Ukuvikela izakhi zephepha lokusebenzela akufanele kudideke nokuphepha kwephasiwedi yezinga lokusebenzela, okunikeza izinga eliphakeme lokuphepha futhi lingasetshenziswa ukuvimbela abasebenzisi ekuvuleni ifayela ngokuphelele.

Isinyathelo 1: Vala / Vula Amaseli ku-Excel

Ngokuzenzakalelayo, wonke amaseli kuphepha lokusebenzela lase-Excel livaliwe. Lokhu kwenza kube lula ukuvikela yonke idatha nokufometha ekhasini elilodwa lokusebenzela ngokusebenzisa okukhethwa kukho ishidi lokuvikela.

Ukuze uvikele idatha kuwo wonke amashidi encwadini yokusebenzela, inketho yeshidi lokuvikela kumele isetshenziswe eshidi ngalinye.

Ukuvula izinguquko ezithile zezimvume zamangqamuzana ezenziwa kulawa maseli ngemuva kokusetshenziswa kweshidi / isofthiwe yokuvikela.

Amaseli angavulwa ngokusebenzisa inketho ye-Cell Cell. Le nketho isebenza njengenguquko yokuguquguquka - inamazwi amabili kuphela noma izikhundla - KUYA noma ku-OFF. Njengoba wonke amaseli ekuqaleni evalelwe kuphepha lokusebenzela, ngokuchofoza inketho kuvula wonke amaseli akhethiwe.

Amaseli athile ekhredithi lokusebenzela angashiywa avuliwe ukuze idatha entsha ingeziwe noma idatha ekhona ishintshiwe.

Amaseli aqukethe amafomula noma enye idatha ebalulekile agcinwa ivaliwe ukuze kuthi uma ukhetho lwephepha lokuvikela / lokusebenzela lusetshenzisiwe, lawa maseli awakwazi ukuguqulwa.

Isibonelo: Vula Amaseli ku-Excel

Esithombeni ngenhla, ukuvikelwa kuye kwasetshenziselwa amaseli. Izinyathelo ezingezansi ezihlobene nesibonelo sekhasi lomsebenzi esithombeni ngenhla.

Kulesi sibonelo:

• Amaseli I6 kuya ku-J10 avuliwe ukuze avumele idatha ingezwe noma ihlelwe uma kudingeka.
• Amaseli I10 noJ10, aqukethe amafomula wokubala imali ephelele, asele ekhiyiwe.
• Okukhethwa kukho kwephepha lokuvikela kusebenziwe kulephepha lokusebenzela.

Izinyathelo zokuvala / ukuvula amaseli:

1. Gqamisa amaseli I6 kuya ku-J10 ukuze ukhethe.
2. Chofoza kuthebhu yasekhaya .
3. Khetha ukhetho lwefomathi ebhodini ukuvula uhlu lokudonsa phansi.
4. Chofoza ku- Lock Cell option ukhetho olungezansi ohlwini.
5. Amaseli agqamile I6 kuya ku-J10 manje avuliwe.

Amashadi wokuvula, amabhokisi ombhalo, nama-Graphics

Ngokuzenzakalelayo, wonke amashadi, amabhokisi emibhalo, nezinto ezihlukisiwe zezithombe - njengezithombe, ubuciko bevidiyo, ubuciko, ne-Smart Art - okukhona ephepheni lokusebenzela livaliwe futhi ngenxa yalokho livikelwe uma kusetshenziswe indlela yokuvikela i - Protect Shee .

Ukushiya izinto ezinjalo zivuliwe ukuze zishintshwe uma ishidi livikelwe:

1. Khetha into okumele ivuliwe; Ukwenza kanjalo kufakazela ithebhu yefomathi ku-ribbon.
2. Chofoza ithebhu yefomethi .
3. Esikhathini Sokulinganisa ngakwesokudla ngakwesokunene sebhebhoni, chofoza inkinobho yokuqalisa ibhokisi lengxoxo (umcibisholo omncane okhomba phansi) eduze kwegama Usayizi ukuvula ifomathi yomsebenzi wokufometha (fometha ibhokisi lebhokisi lengxoxo ku-Excel 2010 no 2007)
4. Esigabeni se- Properties esakhiweni somsebenzi, susa uphawu lokuhlola kusuka ebhokisini lokuhlola elikhiyiwe, futhi uma lisebenza, kusuka ebhokisini lokuhlola umbhalo womkhiqizo.

Isinyathelo sesi-2: Ukusebenzisa i-Option Protect Sheet Option ku-Excel

Isinyathelo sesibili enqubo - ukuvikela lonke iphepha lokusebenzela - lisetshenziselwa ukusebenzisa ibhokisi lengxoxo ye-Protect Sheet.

Ibhokisi lebhokisi liqukethe uchungechunge lwezinketho ezikhomba ukuthi yiziphi izingxenye zeshidi lokusebenza ezingashintshwa. Lezi zakhi zifaka:

• Ukwengeza iphasiwedi ukuvimbela ukuphepha kwephepha lokusebenza ukuthi kuvaliwe.
• Ukukhetha amaseli avaliwe futhi angavuliwe.
• Ukuhlela, ukuhambisa, noma ukususa idatha.
• Ukwengeza / ukususa imigqa namakholomu .
• Ukufihla noma ukukhipha ikholomu nemigqa.
• Ukushintsha ukufometha kwenombolo - izimpawu zemali, izimpawu zamaphesenti, izinombolo zamadayimenti, njll.
• Ukushintsha ukufometha kwamaseli - ukungeza / ukususa imingcele , izinguquko zesinxele noma umbala wefonti, ukufaka umbhalo , njll.

Qaphela : Ukwengeza iphasiwedi akuvimbeli abasebenzisi ekuvuleni iphepha lokusebenzela nokubuka okuqukethwe.

Uma izinketho ezimbili ezivumela umsebenzisi ukuba aqokomise amaseli avaliwe futhi avuliwe avaliwe, abasebenzisi ngeke bakwazi ukwenza noma yiziphi izinguquko kushidi lokusebenzela - ngisho noma liqukethe amaseli angavaliwe.

Izinketho ezisele, njengokufometha amaseli nokuhlunga idatha, akusebenzi wonke okufanayo. Isibonelo, uma ifomathi yefomathi yokukhetha ihloliwe uma ishidi livikelwe, wonke amaseli angafomathwa.

Uhlobo lokukhetha, ngakolunye uhlangothi, luvumela kuphela kulawo maseli avuliwe ngaphambi kokuba ishidi livikelwe ukuze lihlelwe.

Isibonelo: Ukusebenzisa Option Sheet Sheet Option

1. Vula noma ukhiye amaseli afisekayo kushidi lokusebenza lwamanje.
2. Chofoza kuthebhu yasekhaya .
3. Khetha ukhetho lwefomathi ebhodini ukuvula uhlu lokudonsa phansi.
4. Chofoza ku- Ukuvikela Ishidi leShidi ngaphansi kwehlu ukuze uvule ibhokisi lengxoxo ye- Protect Sheet.
5. Hlola noma ungacubungula izinketho oyifunayo.
6. Chofoza OK ukuvala ibhokisi lengxoxo bese uvikela ipheshana.

Ukuvala ukuvikelwa kokuphepha kweshidi

Ukuvimbela ishidi lokusebenzela ukuze wonke amaseli ahlelwe:

1. Chofoza kuthebhu yasekhaya .
2. Khetha ukhetho lwefomathi ebhodini ukuvula uhlu lokudonsa phansi.
3. Chofoza kokukhethwa kweShidi Lokungavinjelwe ngaphansi kwehlu ukuze ungavimbeli ishidi.

Qaphela : Ukungavimbeli ishidi lokusebenzela akusho umthelela esimweni samaseli avaliwe noma avuliwe.