« Ndinateteza kale fayilo ya Excel ndi mawu achinsinsi, koma tsopano ndayiwala mawu achinsinsi a Excel. Funso langa lili mumkhalidwe ngati uwu kuti ndingatsegule bwanji fayilo ?»
Anthu ambiri amawonjezera mapasiwedi ku mafayilo a Excel kuti aletse mwayi kapena kusintha, koma nthawi zina, zimachitika kwambiri kuti anthu amaiwala mawu achinsinsi a Excel. Izi zitha kukhala zokhumudwitsa chifukwa ogwiritsa ntchito ambiri amatha kutaya mafayilo ofunikira. Koma simuyenera kuda nkhawa nazonso. Ngati mwaiwala mawu achinsinsi a Excel, pali njira zambiri zotsegula fayilo yanu ya Excel, ndipo m'nkhaniyi, tikuwonetsa njira zofunika zomwe mungagwiritse ntchito kuti mutsegule password yanu ya Excel.
Mkhalidwe 1. Tsegulani mawu achinsinsi oiwalika a Excel kuti mutsegule fayilo
Momwe mungatsegule fayilo yachinsinsi yotetezedwa ya Excel ngati mwaiwala mawu achinsinsi? Ngati mukukumana ndi vutoli, yesani njira ziwiri zotsatirazi.
Njira Yabwino Kwambiri: Password ya Excel Password Unlocker
Passper kwa Excel Ndi chimodzi mwa zida zosavuta komanso zogwira mtima kwambiri zikafika pakutsegula mapasiwedi oiwalika a Excel. Mutha kutsegula mawu achinsinsi a Excel osakhudza zomwe zili mufayilo. Chida ichi chilinso ndi chiwopsezo chachikulu chifukwa chimagwiritsa ntchito ma aligorivimu amphamvu kuti mutsegule mawu achinsinsi. Pansipa pali zinthu zazikulu za Excel Password Unlocker iyi.
- Ili ndi mitundu 4 yakuukira , kutanthauza kuphatikizika, kuwukira kwa mtanthauzira mawu, kuwukira kwa chigoba ndi kuwukira kwamphamvu, kufupikitsa nthawi yochira ndikuwonjezera chiwongola dzanja.
- Chidachi chikhoza kutsegula mapepala / mabuku ogwirira ntchito mumasekondi popanda kufunikira kwachinsinsi.
- Ndi Zosavuta kugwiritsa ntchito . Mutha kupezanso mawu achinsinsi a Excel omwe mwayiwalika mosavuta monga 1-2-3.
- Popeza ndi pulogalamu yapakompyuta, mutha kutsegula fayilo ya Excel mwachindunji pakompyuta yanu. Chifukwa chake, a Zinsinsi za data yanu ndizotsimikizika .
- Ndi n'zogwirizana ndi Microsoft Excel Mabaibulo kuyambira 97 mpaka 2022. Ndipo palibe malire pa kukula kwa fayilo .
Mutha kuwonanso njira zosavuta pansipa kuti mutsegule fayilo ya Excel yotetezedwa ndi mawu achinsinsi:
Khwerero 1. Yambitsani Passper ya Excel, ndipo mudzawona mawonekedwe ogwiritsira ntchito. Sankhani "Bwezerani Achinsinsi."
Gawo 2. Dinani "+" mafano kuwonjezera wapamwamba Excel mukufuna kuti achire achinsinsi. Izi zikachitika, mutha kusankha njira yowukira malinga ndi momwe mulili.
Gawo 3. Tsopano inu mukhoza kupuma ndi kudikira ndondomeko kuchira kumaliza. Nthawi yobwezeretsa imagwirizana kwambiri ndi zovuta zachinsinsi komanso mtundu wa kuchira womwe mumasankha. Mawu achinsinsi akawoneka pamawonekedwe, mutha kuyikopera ku fayilo yanu yosungidwa ya Excel ndikuyitsegula.
Njira Yodziwika: Bwezerani Mawu Achinsinsi a Excel Oyiwalika Pa intaneti
Ngati simukufuna kukhazikitsa mapulogalamu a chipani chachitatu pa kompyuta yanu, mutha kuyesa kugwiritsa ntchito chida chochira pa intaneti. Ndizosavuta kuti mutsegule mapasiwedi a Excel pa intaneti, koma pamafunika kulumikizana kokhazikika komanso kwamphamvu pa intaneti. Komanso, ndiyenera kunena kuti muyenera kukweza fayilo yanu ku seva yawo kuti mupitirize kuchira. Sitikulimbikitsani kuti mugwiritse ntchito njirayi ngati fayilo yanu ya Excel ili ndi zidziwitso zilizonse.
Kwa ogwiritsa ntchito omwe ali ndi intaneti yolimba ndipo osadandaula kukweza mafayilo, njira zotsatirazi zikuthandizani kuti mutsegule mafayilo anu a Excel.
Gawo 1: Pezani tsamba lovomerezeka la Password Online Recovery.
Gawo 2: Dinani "Kwezani fayilo yanu yosungidwa" kuti mukweze fayilo yanu ya Excel.
Gawo 3: Mukatsitsa, muyenera kulowa imelo yolondola.
Gawo 4: Yang'anani bokosi lanu la imelo kuti mutsegule ndondomekoyi.
Gawo 5: Dikirani chida kuti achire achinsinsi kwa inu. Mudzadziwitsidwa ndi imelo mukamaliza kuchira. Achinsinsi anachira adzatumizidwa kwa inu pambuyo kulipira.
Situation 2. Tsegulani mawu achinsinsi a Excel omwe mwayiwalika kuti musinthe fayilo
Ngati mwakhazikitsa mawu achinsinsi osintha mosaloledwa koma mwayiwala mawu achinsinsi a pepala/buku lantchito, simungathe kusintha buku lanu kapena pepala lanu. Ngati muli mumkhalidwewu, mutha kuchotsa choletsachi ndi njira zomwe zaperekedwa pansipa.
Tsegulani mawu achinsinsi kuti musinthe pamapepala onse a Excel pakadina kamodzi
Ndi Passper kwa Excel Monga tafotokozera pamwambapa, mutha kutsegula mawu achinsinsi kuti musinthe pakadina kamodzi ngakhale masamba angapo atsekedwa kuti asasinthidwe.
Izi ndi njira zoyenera kutsatira:
Khwerero 1. Ikani ndi kukhazikitsa Passper ya Excel. Sankhani "Chotsani Zoletsa" kuchokera ku menyu yayikulu.
Gawo 2. Dinani "Sankhani wapamwamba" kuwonjezera Excel spreadsheet mukufuna kuchotsa zoletsa.
Gawo 3. Dinani "Chotsani" ndi zoletsa achinsinsi adzachotsedwa masekondi.
Tsegulani Excel Spreadsheet ndi VBA Code
Njira yachiwiri yomwe tiwona ndikugwiritsa ntchito VBA code. Njirayi idzagwira ntchito ku Excel 2010, 2007 ndi mitundu yakale. Ngati mwaiwala mawu achinsinsi a Excel 2013/2016/2020/2021, onani njira zina zomwe timapereka m'nkhaniyi.
Zindikirani: Muyenera kudziwa kuti njirayi ndi yothandiza ndi mapepala otayirira. Ngati muli ndi mapepala angapo omwe mwayiwala mawu achinsinsi, muyenera kuyendetsa kachidindo pa pepala lililonse, ndikutsegula chimodzi pambuyo pa chimzake.
Gawo 1: Tsegulani fayilo ya Excel yomwe mwayiwala mawu achinsinsi.
Gawo 2: Dinani batani la Alt kuphatikiza F11 pa kiyibodi yanu ndipo zenera la VBA lidzawonekera.
Gawo 3: Dinani "Ikani" mu toolbar ndikusankha "Module" muzosankha.
Gawo 4: Lowetsani VBA code yanu pawindo la VBA.
Gawo 5: Dinani F5, ndipo code idzachitidwa.
Gawo 6: Dikirani mphindi zochepa kuti VBA code ichotse mawu achinsinsi a Excel. A latsopano Pop-mmwamba zenera adzaoneka mmene mudzapeza achinsinsi. Lembani ndikugwiritsa ntchito kuti mutsegule pepala lanu.
Mwayiwala mawu achinsinsi a Excel? Tsegulani Mawu Achinsinsi a Excel Pogwiritsa Ntchito Zip
Njirayi imagwira ntchito pamafayilo omwe alipo a Excel amitundu ya 2007 ndi 2019. Chongani masitepe pansipa.
Gawo 1: Ikani 7-Zip kapena mtundu wina uliwonse wa Zip compression chida ngati WinRar pa PC yanu.
Gawo 2: Gwiritsani ntchito compression kuti mutsegule fayilo ya Excel. Dinani kumanja pa fayilo ndikusankha "Tsegulani ndi WinRar kapena 7-Zip".
Gawo 3: Kuti muchotse chitetezo chachinsinsi pa spreadsheet yanu, pitani ku "xlworksheets."
Gawo 4: Pezani pepala lomwe mwayiwala mawu achinsinsi. Dinani kumanja ndikusankha "Sinthani".
Gawo 5: Dinani Ctrl+F kuti mupeze tag "" ndikuyichotsa.
Gawo 6: Pambuyo kufufutidwa, kusunga wapamwamba ndi kutseka mkonzi. Tsopano, tsamba lanu lantchito lafufuzidwa.
Tsegulani fayilo ya Excel popanda pulogalamu
Ngati mukufuna kutsegula fayilo yanu ya Excel osagwiritsa ntchito pulogalamu iliyonse, pali njira inanso yanu. Kuti mupewe kutayika kulikonse, pangani zosunga zobwezeretsera za Excel spreadsheet kaye kenako tsatirani njira zomwe zili pansipa kuti mutsegule Excel pa intaneti.
Gawo 1: Tsegulani Google Drive ndikulowa muakaunti yanu ya Gmail. Dinani tabu "Chatsopano" ndikusankha Mapepala a Google.
Gawo 2: Pamwamba kumanzere kwa zenera, dinani Fayilo kenako Import.
Gawo 3: Bokosi la zokambirana lidzawoneka; Dinani "Kwezani" ndikusankha fayilo pa chipangizo chanu kuti mukweze pepala la Excel lotetezedwa ndi mawu achinsinsi.
Gawo 4: Mukatsitsa spreadsheet yanu ya Excel, sankhani "Bwezerani Spreadsheet" ndikudina "Import Data." Tsamba lotetezedwa la Excel lidzatsegulidwa mu Google Mapepala.
Gawo 5: Pitani ku "Fayilo" ndikudina "Koperani Monga," kenako sankhani "Microsoft Excel."
Gawo 6: Mukatsegula fayilo yatsopanoyi, muwona kuti spreadsheet/bookbook yanu sitetezedwanso mawu achinsinsi.
Zindikirani: Liwiro lokwezera limakhala lochedwa kwambiri ndipo njira yokwezera idzakakamira ngati pali masamba ambiri mufayilo yanu ya Excel. Kuphatikiza apo, fayilo yatsopano yomwe mudatsitsa kuchokera ku Google Sheets ikhala yotetezedwa. Muyenera kuyatsa kusintha pamanja.
Langizo: Kodi pali yankho ngati mwaiwala mawu achinsinsi a Excel pa Mac?
Monga mukuwonera, mayankho omwe ali pamwambapa a Excel password recovery ndi makamaka kwa Windows owerenga. Monga wogwiritsa ntchito macOS, mungakhale mukuganiza ngati mutha kupezanso mawu achinsinsi a Excel omwe mwayiwalika pa Mac. Mu gawo ili tikufotokozerani zonse. Mukhoza kupitiriza kuwerenga.
Ngati mukufuna kutsegula mawu achinsinsi a Excel omwe mwayiwalika kuti musinthe pepala lanu la Excel kapena buku lanu, njira zomwe tazitchula pamwambapa monga kugwiritsa ntchito VBA code ndi pulogalamu ya ZIP zitha kugwiranso ntchito pa macOS. Komabe, ngati mukufuna kupezanso mawu achinsinsi oiwalika kuti mupeze fayilo yanu ya Excel, pali njira ziwiri zokha zogwirira ntchito kwa inu. Njira ziwirizi ndikugwiritsa ntchito pulogalamu ya Keychain Access kapena kusamutsa fayilo yanu ya Excel ku kompyuta ya Windows ndikubwezeretsa mawu achinsinsi ndi chida ngati. Passper kwa Excel .
Tsopano, tiwona momwe tingabwezeretsere mapasiwedi a Excel omwe aiwalika pa Mac ndi pulogalamu ya Keychain Access. Mutha kutsatira kalozera mwatsatanetsatane:
Gawo 1: Pezani chikwatu cha "Application" pa kompyuta yanu ndikutsegula. Kenako, pitani ku "Zothandizira> Kufikira kwa Keychain". Dinani kuti mutsegule.
Gawo 2: Pezani "Passwords" kumanzere kwa pulogalamu ya Keychain Access ndikudina.
Gawo 3: Mudzawona ndime ya "Dzina" kumanzere kumanzere kwa pulogalamu yayikulu. Tsopano, pendani pansi mpaka mutapeza "Excel" ndikudina pa izo.
Gawo 4: Chinsalu chatsopano chidzawonekera. Chongani "Onetsani mawu achinsinsi" mu tabu "Makhalidwe". Chinsalu china chidzawonekera ndipo muyenera kulowa "login" keychain password.
Gawo 5: Dinani "Lolani" kuti mupitirize. Mudzawona mawu achinsinsi mu bokosi la "Show password".
Mapeto
Kubwezeretsanso mawu achinsinsi a Excel omwe mwaiwala sikuyenera kukhala kupsinjika kapena kukhumudwitsa. Pali njira zambiri zothandiza zomwe mungatsegule fayilo yanu ya Excel monga Passper kwa Excel . Mutha kugwiritsa ntchito chida ichi pamtundu uliwonse wa Excel.
