« Ke kile ka sireletsa faele ea Excel ka password, empa joale ke lebetse password ea Excel. Potso ea ka e boemong bo kang bona hore na nka bula file joang ?»
Batho ba bangata ba kenya li-password ho lifaele tsa Excel ho thibela phihlello kapa ho li fetola, empa ka linako tse ling, ho etsahala haholo hore batho ba lebale phasewete ea Excel. Sena se ka ferekanya kaha basebelisi ba bangata ba ka lahleheloa ke lifaele tsa bohlokoa. Empa ha u sa tlameha ho tšoenyeha ka seo. Haeba u lebetse phasewete ea hau ea Excel, ho na le mekhoa e mengata ea ho notlolla faele ea hau ea Excel, 'me sehloohong sena, re tla hlahisa mekhoa ea bohlokoa eo u ka e sebelisang ho notlolla phasewete ea hau ea Excel.
Boemo 1. Notlolla phasewete e lebetsoeng ea Excel ho bula faele
U ka bula file ea Excel e sirelelitsoeng joang haeba u lebetse phasewete? Haeba u iphumana u le boemong bona, leka mekhoa e ’meli e latelang.
Mokhoa o Molemo ka ho Fetisisa: Password bakeng sa Excel Password Unlocker
Passper bakeng sa Excel Ke e 'ngoe ea lisebelisoa tse bonolo le tse sebetsang haholo ha ho tluoa tabeng ea ho notlolla li-password tsa Excel tse lebetsoeng. U ka notlolla phasewete ea hau ea Excel ntle le ho ama data e faeleng. Sesebelisoa sena se boetse se na le sekhahla se phahameng sa katleho kaha se sebelisa li-algorithms tse matla ho notlolla phasewete. Ka tlase ke likarolo tsa mantlha tsa Excel Password Unlocker ena.
- E na le mefuta e 4 ea tlhaselo , e leng tlhaselo ea motsoako, tlhaselo ea dikishinari, tlhaselo ea mask le tlhaselo ea matla a sehlōhō, ho khutsufatsa nako ea ho hlaphoheloa le ho eketsa sekhahla sa katleho.
- Sesebelisoa se ka notlolla maqephe / libuka tsa mosebetsi ka metsotswana ntle le tlhoko ea password.
- Na Ho bonolo ho e sebelisa . U ka khutlisa password ea Excel e lebetsoeng habonolo joalo ka 1-2-3.
- Kaha ke sesebelisoa sa komporo, o ka notlolla faele ea Excel ka kotloloho khomphuteng ea hau. Ka hona, the boinotši ba data ea hau bo tiisitsoe ka botlalo .
- E lumellana le liphetolelo tsa Microsoft Excel ho tloha ho 97 ho ea ho 2022. Le ha ho na moeli ho boholo ba faele .
U ka sheba mehato e bonolo e ka tlase ho notlolla faele ea Excel e sirelelitsoeng ka password:
Mohato 1. Qala Passper bakeng sa Excel, 'me u tla bona ka sehloohong segokanyimmediamentsi sa sebolokigolo. Khetha "Khutlisa Li-passwords."
Mohato oa 2. Tobetsa letšoao la "+" ho eketsa faele ea Excel eo u batlang ho fumana phasewete ea hau. Ha sena se se se entsoe, o ka khetha mokhoa oa tlhaselo ho latela boemo ba hau.
Mohato 3. Joale u ka phomola 'me u emetse hore ts'ebetso ea ho hlaphoheloa e phethe. Nako ea ho hlaphoheloa e amana haufi-ufi le ho rarahana ha phasewete le mofuta oa ho hlaphoheloa oo u o khethang. Kamora hore phasewete e hlahe sehokelong, o ka e kopitsa faeleng ea hau e patiloeng ea Excel ebe oa e bula.
Mokhoa o Tloaelehileng: Fumana Password e Lebetsoeng ea Excel Online
Haeba u sa batle ho kenya mananeo a mang a mang khomphuteng ea hau, u ka leka ho sebelisa sesebelisoa sa ho hlaphoheloa inthaneteng. Hape ho bonolo ho notlolla li-password tsa Excel inthaneteng, empa ho hloka khokahano ea inthanete e tsitsitseng le e matla. Hape, ho bohlokoa ho bolela hore o hloka ho kenya faele ea hau ho seva sa bona ho tsoela pele ka ho hlaphoheloa. Ha re khothaletse hore u sebelise mokhoa ona haeba faele ea hau ea Excel e kenyelletsa tlhahisoleseling efe kapa efe ea bohlokoa.
Bakeng sa basebelisi ba nang le khokahano e matla ea Marang-rang mme ba sa tsotelle ho kenya lifaele, mehato e latelang e tla u thusa ho notlolla lifaele tsa hau tsa Excel.
Mohato oa 1: Fumana webosaete ea semmuso ea Password Online Recovery.
Mohato oa 2: Tobetsa "Kenya faele ea hau e patiloeng" ho kenya faele ea hau ea Excel.
Mohato oa 3: Kamora ho kenya, o tlameha ho kenya aterese e nepahetseng ea lengolo-tsoibila.
Mohato 4: Sheba inbox ea hau ea lengolo-tsoibila ho kenya tšebetsong mokhoa oa ho hlakola.
Mohato oa 5: Emela sesebelisoa ho khutlisa phasewete bakeng sa hau. U tla tsebisoa ka lengolo-tsoibila hang ha ho hlaphoheloa ho felile. Phasewete e fumanweng e tla romelwa ho wena kamora ho lefa.
Boemo ba 2. Notlolla password ea Excel e lebetsoeng ho fetola faele
Haeba u seta phasewete bakeng sa phetoho e sa lumelloeng empa u lebetse phasewete ea leqephe/buka ea mosebetsi, u ke ke ua khona ho etsa liphetoho bukeng ea hau ea mosebetsi kapa lakane. Haeba u le boemong bona, u ka tlosa thibelo ena ka mekhoa e fanoeng ka tlase.
Notlolla phasewete ho fetola maqephe ohle a Excel ka ho tobetsa ha 1
Ka Passper bakeng sa Excel Joalokaha re boletse ka holimo, u ka notlolla phasewete ho fetola ka tobetsa e le 'ngoe esita le haeba maqephe a mangata a thibetsoe ho fetola.
Mehato e latelang ke ena:
Mohato oa 1. Kenya le ho qala Passper bakeng sa Excel. Khetha "Tlosa Lithibelo" ho tsoa ho menu e kholo.
Mohato 2. Tobetsa "Khetha faele" ho eketsa Excel spreadsheet u batla ho tlosa lithibelo ho tloha.
Mohato 3. Click "Delete" le lithibelo phasewete tla tlosoa ka mor'a metsotsoana.
Notlolla Excel Spreadsheet ka VBA Code
Mokhoa oa bobeli oo re tla o sheba ke ho sebelisa khoutu ea VBA. Mokhoa ona o tla sebetsa feela ho Excel 2010, 2007 le liphetolelo tsa pejana. Haeba u lebetse password ea Excel 2013/2016/2020/2021, sheba mekhoa e meng eo re e hlahisang sehloohong sena.
Tlhokomeliso: U tlameha ho tseba hore mokhoa ona o sebetsa feela ka maqephe a hlephileng. Haeba u na le maqephe a 'maloa ao u lebetseng li-password tsa ona, u tla tlameha ho tsamaisa khoutu bakeng sa leqephe ka leng, u li bula ka mor'a tse ling.
Mohato oa 1: Bula faele ea Excel eo u lebetse phasewete.
Mohato oa 2: Tobetsa konopo ea Alt plus F11 ho keyboard ea hau mme fensetere ea VBA e tla hlaha.
Mohato oa 3: Tobetsa "Insert" ka har'a toolbar ebe u khetha "Module" likhethong.
Mohato 4: Kenya khoutu ea hau ea VBA fensetereng ea VBA.
Mohato oa 5: Tobetsa konopo ea F5, 'me khoutu e tla etsoa.
Mohato oa 6: Ema metsotso e seng mekae pele khoutu ea VBA e hlakola password ea Excel. Ho tla hlaha fensetere e ncha ea pop-up moo u tla fumana phasewete. E ngole fatše 'me u e sebelise ho notlolla leqephe la mosebetsi oa hau.
U lebetse phasewete ea hau ea Excel? Notlolla Password ea Excel U sebelisa Zip
Mokhoa ona o sebetsa bakeng sa lifaele tsa Excel tse seng li ntse li le teng bakeng sa liphetolelo tsa Excel 2007 le 2019. Sheba mehato e ka tlase.
Mohato oa 1: Kenya 7-Zip kapa mofuta ofe kapa ofe oa sesebelisoa sa compression sa Zip joalo ka WinRar khomphuteng ea hau.
Mohato oa 2: Sebelisa compression ho bula faele ea Excel. Tobetsa faeleng ka ho le letona ebe u khetha "Bula ka WinRar kapa 7-Zip".
Mohato oa 3: Ho tlosa tšireletso ea password ho spreadsheet ea hau, e ea ho "xlworksheets."
Mohato 4: Fumana lakane eo u lebetse phasewete. Tobetsa ka ho le letona ebe u khetha khetho ea "Edit".
Mohato oa 5: Tobetsa Ctrl+F ho fumana "tag" ebe o e hlakola.
Mohato oa 6: Ka mor'a ho hlakola, boloka faele 'me u koale mohlophisi. Joale, leqephe la hau la mosebetsi le hlahlobiloe.
Notlolla faele ea Excel ntle le software
Haeba u khetha ho notlolla faele ea hau ea Excel ntle le ho sebelisa software, ho sa na le mokhoa o mong bakeng sa hau. Ho qoba tahlehelo efe kapa efe ea data, theha bekapo ea Excel spreadsheet pele ebe u latela mehato e ka tlase ho notlolla Excel inthaneteng.
Mohato oa 1: Bula Google Drive 'me u kene ho akhaonto ea hau ea Gmail. Tobetsa "Ncha" tab ebe u khetha Google Sheets.
Mohato oa 2: K'honeng e kaholimo ho le letšehali ea skrine, tobetsa Faele ebe u kenya.
Mohato oa 3: Lebokose la puisano le tla hlaha; Tobetsa "Laola" 'me u khethe faele sesebelisoa sa hau ho kenya leqephe la Excel le sirelelitsoeng ka password.
Mohato 4: Kamora ho kenya spreadsheet ea hau ea Excel, khetha "Fetola Spreadsheet" ebe o tobetsa "Import Data." Leqephe le sirelelitsoeng la Excel le tla buloa ho Google Sheets.
Mohato oa 5: Eya ho "File" ebe o tobetsa "Download As," ebe u khetha "Microsoft Excel."
Mohato oa 6: Kamora ho bula faele ena e ncha, u tla bona hore spreadsheet/bookbook ea hau ha e sa sirelelitsoe ka password.
Tlhokomeliso: Lebelo la ho kenya le tsamaea butle 'me mokhoa oa ho kenya o tla tsitsa haeba ho na le li-spreadsheet tse ngata faeleng ea hau ea Excel. Ho feta moo, faele e ncha eo u e jarollotseng ho Google Sheets e tla ba boemong bo sirelelitsoeng. U tlameha ho lumella ho hlophisa ka letsoho.
Keletso: Na ho na le tharollo haeba u lebetse phasewete ea hau ea Excel ho Mac?
Joalokaha u bona, litharollo tse kaholimo tsa ho hlaphoheloa ha password ea Excel li etselitsoe basebelisi ba Windows haholo. Joaloka mosebelisi oa MacOS, u kanna oa ipotsa hore na u ka fumana password e lebetsoeng ea Excel ho Mac. Karolong ena re tla hlakisa tsohle bakeng sa hau. U ka tsoela pele ho bala.
Haeba o hloka ho notlolla phasewete e lebetsoeng ea Excel ho fetola leqephe la Excel kapa buka ea mosebetsi, mekhoa e boletsoeng ka holimo joalo ka ho sebelisa VBA khoutu le software ea ZIP le eona e ka sebetsa ho macOS. Leha ho le joalo, haeba u batla ho khutlisa phasewete e lebetsoeng ho fihlella faele ea hau ea Excel, ho na le mekhoa e 2 feela ea ho u sebeletsa. Mekhoa ena e 'meli ke ho sebelisa lenaneo la Keychain Access kapa ho fetisetsa faele ea hau ea Excel khomphuteng ea Windows le ho fumana phasewete ka sesebelisoa se kang. Passper bakeng sa Excel .
Joale, re tla shebana le mokhoa oa ho khutlisa li-password tsa Excel tse lebetsoeng ho Mac ka Keychain Access lenaneo. U ka latela tataiso e qaqileng e latelang:
Mohato oa 1: Fumana foldara ea "Application" khomphuteng ea hau ebe u e bula. Ka mor'a moo, e ea ho "Lisebelisoa> Ho fihlella ha Keychain". Tobetsa ho e bula.
Mohato oa 2: Fumana "Passwords" karolong e ka ho le letšehali ea lenaneo la Keychain Access 'me u tobetse ho lona.
Mohato oa 3: U tla bona kholomo ea "Lebitso" ka holimo ka letsohong le letšehali la skrine ea sehlooho ea lenaneo. Joale, tsamaisetsa fatše ho fihlela u fumana "Excel" 'me u tobetse ho eona.
Mohato 4: Ho tla hlaha skrine e ncha. Sheba khetho ea "Show password" ho "Attributes" tab. Ho tla hlaha skrine e 'ngoe 'me u tla tlameha ho kenya senotlolo sa "login" keychain.
Mohato oa 5: Tobetsa "Lumella" ho tsoela pele. U tla bona phasewete lebokoseng la "Show password".
Qetello
Ho fumana phasewete ea hau e lebetsoeng ea Excel ha ho hlokahale hore e be khatello ea maikutlo kapa e ferekanyang. Ho na le mekhoa e mengata e sebetsang eo ka eona u ka notlollang faele ea hau ea Excel joalo ka Passper bakeng sa Excel . U ka sebelisa sesebelisoa sena bakeng sa mofuta ofe kapa ofe oa Excel.
