Kunyange zvazvo kubatanidzwa kwebasa re "dziviriro" muExcel kuchisimbisa kuchengetedzeka kwemafaira akakosha, zvinogonawo kukonzera matambudziko akawanda kana usiri iwe munyori wefaira (kureva kuti ungasakwanisa kuribvisa zvakananga) kana kuti wakakanganwa kana kuti usingazive nezvepassword (kana faira iri kuchengetedzwa kuburikidza nepassword). Dambudziko iri rinonetsa kana gwaro racho rakachengetedzwa nechero nzira uye nekudaro risingakwanise kugadziriswa kana kuumbwa newe zvachose.
Kune mhando mbiri dzemafaira eExcel akachengetedzwa, rimwe risingabvumidzwe kugadziriswa, uye rimwe risingabvumidzwe kuvhurwa. Nyaya iyi ichapa mhinduro kumamiriro ese ari maviri.
Tichapa gwara rakazara uye riri nyore rekubvisa jira reExcel kana bhuku rebasa, zvichiita kuti rigone kugadziriswa zvizere paunenge uchida.
Usadzivirire Excel nenzira yakatwasuka
Munyori anogona kuchengetedza faira reExcel nenzira dzakasiyana-siyana. Chinhu chinonyanya kutaurwa uye chiri nyore ndechekuti kana uine password iripo kana kuti usingatombodi password zvachose. Muchiitiko ichi, maitiro acho ari nyore kwazvo paExcel 2010, 2013, 2016 na2019.
Faira racho rinogona kunge rakanzi "Marked as Final" izvo zvinoita kuti spreadsheet ive "Read-Only", zvichirambidza chero shanduko dzinofanira kuitwa pariri uye tag icharatidzwa paribhoni yepamusoro. Kuti uwane faira rakadaro, unogona kungodzvanya bhatani rekuti "Edit Anyway" riri muribhoni iro richakupa mukana wakazara wekugadzirisa sezvaunoda.
Munyori anewo sarudzo yekudzivirira faira nepassword achishandisa “Protect Current Sheet” pasi pe “File > Protect Workbook”. Unogona kuvhura faira mune iyi kesi asi mamwe mashandiro aro haazowanikwe. Kuti ugadzirise faira rakadaro, tinya pane “Review” tab wobva wadzvanya pane “Unprotect Sheet”. Mushure meizvi, unogona kuisa password nyore nyore uye kuwana zvizere faira reExcel.
Kana faira racho rakachengetedzwa nesarudzo ye "Encrypt with Password" pasi pe "File > Protect Workbook", hauzobvumirwi kuvhura faira racho usina kuisa password yaro. Kana ukadzvanya kaviri faira rakadaro, mhinduro ichabuda ichikumbira password yefaira racho. Ingoisa password ipapo wodzvanya Enter. Uchave nemvumo yakakwana yefaira racho uye mashandiro aro ese.
Bvisai Dziviriro paExcel Sheet nekubvisa Zvirambidzo
Kana usina password, unogona kusangana nematambudziko akawanda paunenge uchiedza kugadzirisa kana kugadzira faira reExcel.
Apa ndipo pane software iri nyore kwazvo yakaita se Pasipoti yeExcel isarudzo inoshanda. Pasper inoshanda zvikuru pakubvisa zvirambidzo zvinonetsa kubva kuExcel nekuchenjera uye nekukurumidza uye kugadzira faira rakagadzirira kugadziriswa nekufometwa panguva yakakodzera.
Zvimwe zvezvinhu zvinobatsira zvinopihwa nePasper yeExcel ndeizvi:
- Kushanda kwe100% pakubvisa pepa rekushandira/bhuku rebasa reExcel.
- Chimiro chiri nyore uye chinonzwisisika chisingadi matambudziko.
- Yakakura kwazvo mukusarudza kwayo kuenderana, uye inogona kudzivirira Excel 97/2000/2003/2007/2010/2013/2016/2019.
Unogona kudzvanya bhatani iri rekuti Download kuti uwane
Pasipoti yeExcel
.
Dhawunirodha Mahara
Gwaro iri rinokuratidza mashandisiro aungaita Pasper kuti usachengetedze bhuku rako rebasa reExcel/pepa rebasa:
Danho 1: Sarudza Chiito Chinodiwa
Mushure mekunge maitiro ekuisa apera, tanga Pasper paPC yako wobva wadzvanya pa "Bvisa Zvirambidzo".
Danho rechipiri: Kusarudza Mafaira
Dzvanya pakanzi “Sarudza Faira” kuti usarudze faira reExcel raunoda kuti Unprotect.
Danho rechitatu: Bvisa Zvirambidzo
Kana wasarudza faira rakakodzera, chaunongofanira kuita kudzvanya bhatani rekuti “Bvisa”, uye zvese zvinorambidzwa kubva muExcel Worksheet/Workbook yako zvichabviswa nekukasika. Uchakwanisa kuwana Faira reExcel rinogona kugadziriswa zvizere uye risina kuchengetedzwa.
Saka tinoona izvozvo Pasipoti yeExcel Inovhura chinhu chakakosha mudura rako redhijitari chinokubvumidza kuti uwane huwandu husina muganho hwemafaira eExcel paunenge wakasununguka. Ipurogiramu yakakodzera kudhawunirodha kana waneta nematambudziko anokonzerwa nekushanda nemafaira eExcel akachengetedzwa ayo anokupa matambudziko asina basa.
Bvisa kuchengetedzwa kwefaira reExcel nekuwanazve password
Kana uri kubata nefaira reExcel rakachengetedzwa nepassword yekuvhura, Pasipoti yeExcel ine mhinduro iri nyore yekugadzirisa dambudziko iri. Pasper ine mukana wekuvhura mamwe mafaira eExcel akadzivirirwa nepassword uye haagone kuvhurwa kuti aonekwe kana usina mukana wekuwana password iri kutaurwa nezvayo. Kuoma kwepassword iri kutaurwa kunofanirwa kufungwa nezvayo paunenge uchiedza kuivhura nePasper (inogona kutadza kuvhura mapassword akaomarara uye akareba).
Gwaro riri nyore rinoratidza kuti Passper ingashandiswa sei kuvhura Faira reExcel Rinodzivirirwa nePassword rinopiwa pazasi:
Danho 1: Sarudza Chiito Chinodiwa
Mushure mekuisa Pasipoti yeExcel pakombuta yako, unofanira kutanga chirongwa wodzvanya "Recover Passwords", wobva wadzvanya chiratidzo che "+" kuti utsvage faira rako worisarudza.
Danho rechipiri: Sarudza Nzira yekurwisa
Mushure mekuita izvi, unogona kusarudza kubva mumhando ina dzakasiyana dzekurwisa zvichienderana nezvaunoda.
Sarudzo idzi dzinokupa nzira dzakasiyana-siyana zvichienderana neruzivo rwako (kana kushaya) nezve password yakakodzera. Nzira iyi inoshanda zvakasiyana-siyana inovimbisa kukurumidza uye kubudirira kwakanyanya pakushandisa mafaira akavharirwa ne password.
Danho rechitatu: Kupora
Mushure meizvi, zvese zvaunofanirwa kuita kudzvanya bhatani rekuti “Recover” uye Passer for Excel ichatanga maitiro ekutora password yako. Nguva yekudzoreredza password inoenderana nehurefu uye kuoma kwepassword.
Unogona kukopa password itsva yawakawana woichengeta zvakachengeteka. Kana uchinetseka zvakare nedambudziko rakafanana, Pasper yeExcel ichavepo kuti ikubatsire kuwana password zvakare uye kuvhura kushandiswa kwakazara kwefaira reExcel. Unogona kushandisa password yakavhurwa wogadzirisa uye kugadzira pepa rako reExcel wakasununguka.
Sezvakaonekwa munyaya iyi, kubata nemafaira eExcel asina kuchengetedzeka kunogona kuva nyaya yakaoma, zvinonyanya kuoma kana uine magwaro eExcel asingawanikwe zvachose pasina password.
Excel chishandiso chakakosha zvikuru munyika yebhizinesi nekutengeserana. Zvipingamupinyi izvi zvinogona kudhura zvikuru kugadzirisa uye zvinogona kupa mushandisi matambudziko akawanda emari uye ezvekufambisa zvinhu.
Nerombo rakanaka,
Pasipoti yeExcel
iripo here kuderedza matambudziko ese aya, chishandiso che "Gadzirisa Zvese" chinobata nematambudziko ese aya nehungwaru uye zvinobudirira pasina muripo unodhura zvakanyanya kumushandisi. Unogona kuchishandisa kubvisa kana kupwanya mapassword eExcel zviri nyore uye kuvhura faira kuti uwane mukana wakazara wekuwana spreadsheet isina kukanganiswa. Kana ichienzaniswa nemamwe mapurogiramu, Pasper inopa setup iri nyore uye inonzwisisika inodarika makwikwi mune tekinoroji uye zviri nyore.
Dhawunirodha Mahara
