" A baya na kare fayil ɗin Excel tare da kalmar sirri, amma yanzu na manta kalmar sirri ta Excel. Tambayata ita ce a cikin yanayi irin wannan ta yaya zan iya buɗe fayil ɗin ?
Mutane da yawa suna ƙara kalmomin shiga zuwa fayilolin Excel don hana samun dama ko gyarawa, amma wani lokacin, yana faruwa da yawa cewa mutane suna manta kalmar sirri ta Excel. Wannan na iya zama abin takaici saboda yawancin masu amfani na iya rasa fayiloli masu mahimmanci. Amma ba lallai ne ka ƙara damuwa da hakan ba. Idan kun manta kalmar sirri ta Excel, akwai hanyoyi da yawa don buɗe fayil ɗin Excel ɗinku, kuma a cikin wannan labarin, zamu gabatar da hanyoyi masu mahimmanci waɗanda zaku iya amfani da su don buɗe kalmar sirri ta Excel.
Halin 1. Buɗe kalmar sirrin Excel manta don buɗe fayil
Yadda ake buɗe fayil ɗin Excel mai kare kalmar sirri idan kun manta kalmar sirri? Idan kun sami kanku a cikin wannan yanayin, gwada hanyoyi biyu masu zuwa.
Mafi kyawun Hanyar: Fasfo don buɗe kalmar wucewa ta Excel
Fasfo don Excel Yana daya daga cikin mafi sauƙi kuma mafi inganci kayan aiki idan ya zo ga buše kalmar sirri manta Excel. Kuna iya buɗe kalmar sirri ta Excel ba tare da shafar bayanan da ke cikin fayil ɗin ba. Wannan kayan aiki kuma yana da babban rabo mai girma kamar yadda yake amfani da algorithms masu ƙarfi don buɗe kalmar sirri. A ƙasa akwai manyan fasalulluka na wannan Mai buɗe kalmar sirri ta Excel.
- Yana da nau'ikan hari guda 4 , wato harin haɗin gwiwa, harin ƙamus, harin abin rufe fuska da harin ƙarfi, don rage lokacin dawowa da haɓaka ƙimar nasara.
- Kayan aiki na iya buɗe zanen gado/littattafan aiki cikin dakiku ba tare da buƙatar kalmar sirri ba.
- Shin Sauƙi don amfani . Kuna iya dawo da kalmar sirrin Excel manta da sauƙi kamar 1-2-3.
- Da yake aikace-aikacen tebur ne, zaku iya buɗe fayil ɗin Excel kai tsaye akan kwamfutarku. Saboda haka, da sirrin bayanan ku yana da cikakken garanti .
- Ya dace da nau'ikan Microsoft Excel daga 97 zuwa 2022. Kuma babu iyaka akan girman fayil .
Hakanan zaka iya duba matakai masu sauƙi a ƙasa don buše fayil ɗin Excel mai kare kalmar sirri:
Mataki 1. Kaddamar da Fasfo don Excel, kuma za ku ga babban mai amfani. Zaɓi "Mai da kalmomin shiga."
Mataki 2. Danna alamar "+" don ƙara fayil ɗin Excel da kake son dawo da kalmar wucewa. Da zarar an yi haka, zaku iya zaɓar yanayin hari gwargwadon yanayin ku.
Mataki 3. Yanzu za ka iya hutawa da kuma jira da dawo da tsari don kammala. Lokacin dawowa yana da alaƙa da rikitarwar kalmar sirri da nau'in dawo da da kuka zaɓa. Bayan kalmar sirri ta bayyana akan mahaɗin, zaku iya kwafa shi zuwa fayil ɗin Excel ɗin ku da aka ɓoye sannan ku buɗe shi.
Hanyar gama gari: Mayar da kalmar wucewa ta Excel da aka manta akan layi
Idan ba ka son shigar da kowane shirye-shirye na ɓangare na uku akan kwamfutarka na sirri, zaka iya gwada amfani da kayan aikin dawo da kan layi. Hakanan yana da sauƙi don buɗe kalmomin sirri na Excel akan layi, amma yana buƙatar ingantaccen haɗin Intanet mai ƙarfi. Har ila yau, yana da daraja ambaton cewa kana buƙatar loda fayil ɗin ku zuwa uwar garken su don ci gaba da farfadowa. Ba mu ba da shawarar ku yi amfani da wannan hanyar ba idan fayil ɗin Excel ɗin ku ya ƙunshi kowane bayani mai mahimmanci.
Ga masu amfani waɗanda ke da haɗin Intanet mai ƙarfi kuma ba su damu da loda fayiloli ba, matakai masu zuwa zasu taimaka muku buɗe fayilolin Excel.
Mataki 1: Shiga cikin official website na Kalmar wucewa Online farfadowa da na'ura.
Mataki na 2: Danna "Loda fayil ɗin da aka ɓoye" don loda fayil ɗin Excel ɗin ku.
Mataki na 3: Bayan lodawa, dole ne ka shigar da ingantaccen adireshin imel.
Mataki na 4: Bincika akwatin saƙo na imel ɗin ku don kunna tsarin ɓoye bayanan.
Mataki na 5: Jira kayan aiki don dawo da kalmar wucewa a gare ku. Za a sanar da ku ta imel da zarar an gama murmurewa. Za a aika maka kalmar sirri da aka dawo bayan biya.
Halin 2. Buɗe kalmar sirrin Excel da aka manta don gyara fayil
Idan kun saita kalmar sirri don gyara mara izini amma kun manta kalmar sirri don takardar/littafin aiki, ba za ku iya yin wani canje-canje ga littafin aikinku ko takardar ba. Idan kuna cikin wannan yanayin, zaku iya cire wannan ƙuntatawa tare da hanyoyin da aka bayar a ƙasa.
Buɗe kalmar sirri don canzawa a cikin duk takaddun Excel a cikin dannawa 1
Tare da Fasfo don Excel Kamar yadda muka ambata a sama, zaku iya buɗe kalmar sirri don gyarawa ta dannawa ɗaya ko da an katange zanen gado da yawa daga gyara.
Waɗannan su ne matakan da za a bi:
Mataki 1. Shigar da kaddamar da Fasfo don Excel. Zaɓi "Cire ƙuntatawa" daga babban menu.
Mataki 2. Danna "Zaɓi fayil" don ƙara ma'auni na Excel da kake son cire ƙuntatawa daga.
Mataki 3. Danna "Delete" da kuma ƙuntatawa kalmar sirri za a cire a cikin dakika.
Buɗe Fayil na Excel tare da lambar VBA
Hanya ta biyu da za mu duba ita ce amfani da lambar VBA. Wannan hanyar za ta yi aiki ne kawai don Excel 2010, 2007 da sigogin baya. Idan kun manta kalmar sirri ta Excel 2013/2016/2020/2021, duba wasu hanyoyin da muke gabatarwa a wannan labarin.
Lura: Dole ne ku san cewa wannan hanyar tana da tasiri kawai tare da zanen gado mara kyau. Idan kuna da zanen gado da yawa waɗanda kuka manta da kalmomin shiga, dole ne ku kunna code na kowane takarda, buɗe su ɗaya bayan ɗaya.
Mataki 1: Bude fayil ɗin Excel wanda kuka manta kalmar sirri.
Mataki na 2: Danna maɓallin Alt da F11 akan madannai kuma taga VBA zai bayyana.
Mataki na 3: Danna "Saka" a cikin kayan aiki kuma zaɓi "Module" a cikin zaɓuɓɓukan.
Mataki na 4: Shigar da lambar VBA ɗin ku a cikin taga VBA.
Mataki na 5: Danna maɓallin F5, kuma za a aiwatar da lambar.
Mataki na 6: Jira ƴan mintuna don lambar VBA don yanke kalmar sirri ta Excel. Wani sabon taga pop-up zai bayyana inda zaku sami kalmar wucewa. Rubuta shi kuma yi amfani da shi don buɗe takardar aikinku.
Manta kalmar sirri ta Excel? Buɗe Kalmar wucewa ta Excel Amfani da Zip
Wannan hanyar tana aiki don fayilolin Excel na yanzu don nau'ikan Excel 2007 da 2019. Duba matakan da ke ƙasa.
Mataki 1: Shigar 7-Zip ko kowane nau'in kayan aikin matsawa na Zip kamar WinRar akan PC ɗin ku.
Mataki na 2: Yi amfani da matsawa don buɗe fayil ɗin Excel. Danna-dama akan fayil ɗin kuma zaɓi "Buɗe tare da WinRar ko 7-Zip."
Mataki na 3: Don cire kariyar kalmar sirri daga maƙunsar bayanan ku, je zuwa "xlworksheets."
Mataki na 4: Nemo takardar da kuka manta kalmar sirri. Danna-dama kuma zaɓi zaɓi "Edit".
Mataki na 5: Danna Ctrl+F don nemo alamar "" kuma share shi.
Mataki na 6: Bayan gogewa, ajiye fayil ɗin kuma rufe editan. Yanzu, an duba takardar aikinku.
Buɗe fayil ɗin Excel ba tare da software ba
Idan kun fi son buɗe fayil ɗin Excel ɗinku ba tare da amfani da kowace software ba, har yanzu akwai wata hanya a gare ku. Don guje wa duk wani asarar bayanai, fara ƙirƙirar madadin maƙunsar bayanan ku na Excel sannan ku bi matakan da ke ƙasa don buɗe Excel akan layi.
Mataki 1: Bude Google Drive kuma shiga cikin asusun Gmail ɗinku. Danna shafin "Sabo" kuma zaɓi Google Sheets.
Mataki na 2: A saman kusurwar hagu na allon, danna Fayil sannan kuma Shigo.
Mataki na 3: Akwatin maganganu zai bayyana; Danna "Loka" kuma zaɓi fayil akan na'urarka don loda takardar Excel mai kariya ta kalmar sirri.
Mataki na 4: Bayan loda maƙunsar bayanan ku na Excel, zaɓi "Maye gurbin Fassara" kuma danna "Import Data." Za a buɗe takardar Excel mai kariya a cikin Google Sheets.
Mataki na 5: Je zuwa "File" kuma danna "Download As," sannan zaɓi "Microsoft Excel."
Mataki na 6: Bayan buɗe wannan sabon fayil, za ku ga cewa maƙunsar rubutu/littafin aikinku ba a kare kalmar sirri ba.
Lura: Saurin ƙaddamarwa yana da jinkirin gaske kuma tsarin ƙaddamarwa zai makale idan akwai maƙunsar bayanai da yawa a cikin fayil ɗin Excel ɗin ku. Bugu da ƙari, sabon fayil ɗin da kuka zazzage daga Google Sheets zai kasance cikin kariya mai kariya. Dole ne ku kunna gyara da hannu.
Tukwici: Shin akwai mafita idan kun manta kalmar sirri ta Excel akan Mac?
Kamar yadda kake gani, mafita na sama don dawo da kalmar wucewa ta Excel galibi ga masu amfani da Windows ne. A matsayin mai amfani da macOS, kuna iya mamakin ko za ku iya dawo da kalmar wucewa ta Excel da aka manta akan Mac. A wannan bangare za mu bayyana muku komai. Kuna iya ci gaba da karantawa.
Idan kuna buƙatar buše kalmar wucewa ta Excel da aka manta don canza takaddar Excel ko littafin aiki, hanyoyin da aka ambata a sama kamar amfani da lambar VBA da software na ZIP kuma na iya aiki akan macOS. Koyaya, idan kuna son dawo da kalmar sirri da aka manta don samun damar fayil ɗin Excel ɗinku, akwai hanyoyi guda 2 kawai don yin aiki a gare ku. Hanyoyi guda biyu sune don amfani da shirin samun damar Keychain ko canja wurin fayil ɗin Excel ɗin ku zuwa kwamfutar Windows kuma dawo da kalmar wucewa tare da kayan aiki kamar. Fasfo don Excel .
Yanzu, za mu mayar da hankali kan yadda za a mai da manta kalmar sirri Excel a kan Mac tare da Keychain Access shirin. Kuna iya bin cikakken jagorar mai zuwa:
Mataki 1: Nemo babban fayil ɗin “Application” a kan kwamfutarka kuma buɗe shi. Na gaba, je zuwa "Utilities> Keychain Access". Danna don buɗe shi.
Mataki na 2: Nemo “Passwords” a gefen hagu na shirin shiga Keychain kuma danna kan shi.
Mataki na 3: Za ku ga shafi "Sunan" a saman hagu na babban allon shirin. Yanzu, gungura ƙasa har sai kun sami "Excel" kuma danna kan shi.
Mataki na 4: Wani sabon allo zai bayyana. Duba zaɓin "Nuna kalmar sirri" a cikin "Halayen" tab. Wani allo zai bayyana kuma dole ne ka shigar da kalmar wucewa ta keychain "login".
Mataki na 5: Danna "Bada" don ci gaba. Za ku ga kalmar sirri a cikin akwatin "Nuna kalmar sirri".
Kammalawa
Mayar da kalmar wucewa ta Excel da aka manta ba dole ba ne ya zama mai damuwa ko takaici. Akwai hanyoyi masu tasiri da yawa ta hanyar da za ku iya buše fayil ɗin ku na Excel kamar Fasfo don Excel . Kuna iya amfani da wannan kayan aiki don kowane sigar Excel.
