" Hore waxaan u ilaalin jiray feylka Excel oo sirta ah, laakiin hadda waxaan illoobay erayga sirta ah ee Excel. Su'aashaydu waxay ku jirtaa xaalad sidan oo kale ah sidee baan u furi karaa faylka ?
Dad badan ayaa ku dara ereyada sirta ah ee faylasha Excel si ay u xaddidaan gelitaanka ama wax ka beddelka, laakiin mararka qaarkood, waxay dhacdaa in badan in dadku illoobaan erayga sirta ah ee Excel. Tani waxay noqon kartaa niyad jab maadaama isticmaaleyaal badan ay lumin karaan faylal qiimo leh. Laakin uma baahnid inaad ka walwasho taas. Haddii aad illowday eraygaaga sirta ah ee Excel, waxaa jira siyaabo badan oo aad ku furi karto faylkaaga Excel, maqaalkan, waxaan ku soo bandhigaynaa habab qiimo leh oo aad isticmaali karto si aad u furto eraygaaga sirta ah ee Excel.
Xaaladda 1. Fur fur furaha sirta ah ee Excel ee la illoobay si aad faylka u furto
Sida loo furo faylka sirta ah ee Excel-ka ah haddii aad illowday erayga sirta ah? Haddii aad isku aragto xaaladdan, isku day labadan hab ee soo socda.
Habka ugu Wanaagsan: Baasaska loogu talagalay Furaha Furaha Furaha ee Excel
Passper ee Excel Waa mid ka mid ah aaladaha ugu fudud uguna waxtarka badan marka ay timaado in la furo furayaasha sirta ah ee Excel ee la illoobay. Waxaad furi kartaa eraygaaga sirta ah ee Excel adoon saameyn ku yeelan xogta ku jirta faylka. Qalabkani waxa kale oo uu leeyahay heerar guuleed oo sarreeya maaddaama ay isticmaasho algorithms awood leh si loo furo erayga sirta ah. Hoos waxaa ah sifooyinka ugu muhiimsan ee furaha sirta ah ee Excel.
- Waxay leedahay 4 nooc oo weerar ah , kuwaas oo kala ah weerarka isku dhafka ah, weerar qaamuuska, wejiga wejiga iyo weerarka xoogga ah, si loo gaabiyo wakhtiga soo kabashada loona kordhiyo heerka guusha.
- Qalabku wuxuu furi karaa xaashiyo/buugaagta shaqada ilbiriqsiyo gudahood iyada oo aan loo baahnayn furaha sirta ah.
- Waa fududahay in la isticmaalo . Waxaad u soo ceshan kartaa erayga sirta ah ee Excel ee la illoobay si fudud sida 1-2-3.
- Maadaama uu yahay codsi desktop ah, waxaad si toos ah ugu furi kartaa faylka Excel kumbuyuutarkaaga. Sidaa darteed, sirta xogtaada si buuxda ayaa loo dammaanad qaaday .
- Waxay la jaan qaadaya noocyada Microsoft Excel laga bilaabo 97 ilaa 2022. Iyo ma jiro wax xaddidan oo ku saabsan cabbirka faylka .
Waxa kale oo aad hubin kartaa tillaabooyinka fudud ee hoose si aad u furto faylka sirta ah ee xafidan ee Excel:
Tallaabada 1. Launch Passper for Excel, oo waxaad arki doontaa interface user ugu weyn. Dooro "Ladnaansho Passwords."
Tallaabada 2. Guji calaamadda "+" si aad ugu darto faylka Excel ee aad rabto inaad soo ceshato eraygaaga sirta ah. Marka tan la sameeyo, waxaad dooran kartaa qaab weerar sida ay tahay xaaladdaada.
Tallaabada 3. Hadda waad nasan kartaa oo sugi kartaa habka soo kabashada si loo dhammeeyo. Wakhtiga soo kabashada waxa uu si dhaw ula xidhiidha kakanaanta erayga sirta ah iyo nooca soo kabashada ee aad doorato. Ka dib marka erayga sirta ah uu ka soo muuqdo interface-ka, waxaad ku koobi kartaa faylkaaga sirta ah ee Excel oo aad furto.
Habka Caadiga ah: Dib u soo kabashada erayga sirta ah ee Excel ee la illoobay
Haddii aadan rabin inaad ku rakibto barnaamij kasta oo dhinac saddexaad ah kombiyuutarkaaga gaarka ah, waxaad isku dayi kartaa inaad isticmaasho qalabka soo kabashada ee internetka. Sidoo kale way fududahay in lagu furo furaha sirta ah ee Excel online, laakiin waxay u baahan tahay isku xidh internet oo deggan oo xoog badan. Sidoo kale, waxaa xusid mudan inaad u baahan tahay inaad faylkaaga geliso server-kooda si ay u sii wadaan soo kabashada. Kuma talineyno inaad isticmaasho habkan haddii faylkaaga Excel uu ku jiro macluumaad kasta oo xasaasi ah.
Isticmaalayaasha leh isku xirka internetka adag oo aan ka fikirin soo dejinta faylasha, tillaabooyinka soo socda ayaa kaa caawin doona inaad furto faylasha Excel.
Tallaabada 1: Gal website-ka rasmiga ah ee Password Online Recovery.
Tallaabada 2: Guji "Soo rar faylkaaga sir ah" si aad u soo geliso faylkaaga Excel.
Tallaabada 3: Kadib raritaanka, waa inaad gelisaa ciwaan email sax ah.
Tallaabada 4: Hubi sanduuqaaga iimaylka si aad u dhaqaajiso habka kala saarida
Tallaabada 5: Sug qalabku inuu kuu soo ceshado erayga sirta ah. Waxaa lagugu soo ogeysiin doonaa iimayl marka soo kabashadu dhammaato. Furaha sirta ah ee la helay ayaa laguu soo diri doonaa ka dib lacag bixinta.
Xaaladda 2. Fur fur furaha sirta ah ee Excel ee la illoobay si faylka loo beddelo
Haddii aad u dejisay furaha sirta ah wax ka beddel aan la oggolayn laakiin aad illowday erayga sirta ah ee xaashida/buugga shaqada, ma awoodi doontid inaad wax isbeddel ah ku samayso buuggaaga shaqada ama xaashida. Haddii aad xaaladdan ku jirto, waxaad ka saari kartaa xannibaadda hababka hoos ku qoran.
Fur furaha sirta ah si aad u bedesho dhammaan xaashida Excel 1 gujin
leh Passper ee Excel Sida aan kor ku soo sheegnay, waxaad furi kartaa erayga sirta ah si aad hal gujin ugu bedesho xitaa haddii xaashiyo badan laga xannibo wax ka beddelka.
Waa kuwan tillaabooyinka la raacayo:
Tallaabada 1. Ku rakib oo bilow Passper for Excel. Ka dooro "Remove Restrictions" ka menu-ka ugu weyn.
Tallaabada 2. Guji "Dooro faylka" si aad ugu darto xaashida Excel ee aad rabto inaad ka saarto xayiraadaha.
Talaabada 3. Guji "Delete" oo sirta xaddidan ayaa laga saari doonaa ilbiriqsiyo gudahood.
Ku fur xaashida faafinta ee Excel oo wata code VBA
Habka labaad ee aan eegi doonaa waa isticmaalka code VBA. Habkani wuxuu kaliya u shaqayn doonaa Excel 2010, 2007 iyo noocyadii hore. Haddii aad illowday erayga sirta ah ee Excel 2013/2016/2020/2021, hubi hababka kale ee aan ku soo bandhigno maqaalkan.
Fiiro gaar ah: Waa inaad ogaataa in habkani uu waxtar u leeyahay oo keliya xaashiyo dabacsan. Haddii aad haysato dhowr xaashi oo aad u illowday ereyadooda sirta ah, waa inaad furto koodka xaashi kasta, adigoo midba midka kale u furaya.
Tallaabada 1: Fur faylka Excel ee aad illowday erayga sirta ah.
Tallaabada 2: Riix furaha Alt plus F11 ee kiiboodhkaaga waxaana soo bixi doona daaqada VBA.
Tallaabada 3: Guji "Insert" ee aaladda aaladda oo dooro "Module" ee xulashooyinka.
Tallaabada 4: Geli lambarkaaga VBA daaqada VBA.
Tallaabada 5: Riix furaha F5, koodhkana waa la fulin doonaa.
Tallaabada 6: Sug dhowr daqiiqo koodhka VBA si uu u furfuro erayga sirta ah ee Excel. Daaqad cusub oo pop-up ah ayaa kuu soo baxaysa taas oo aad ka heli doonto erayga sirta ah. Qor oo isticmaal si aad u furto xaashida shaqada.
Miyaad illowday eraygaaga sirta ah ee Excel? Fur furaha sirta ah ee Excel Adigoo isticmaalaya Zip
Habkani wuxuu u shaqeeyaa faylalka Excel ee jira noocyada Excel 2007 iyo 2019. Fiiri talaabooyinka hoose
Tallaabada 1: Ku rakib 7-Zip ama nooc kasta oo kale oo ah aaladda riixitaanka Zip sida WinRar PC-gaaga.
Tallaabada 2: Isticmaal cadaadis si aad u furto faylka Excel. Midig ku dhufo faylka oo dooro "Open with WinRar or 7-Zip."
Tallaabada 3: Si aad uga saarto ilaalinta erayga sirta ah xaashidaada, tag "xlworksheets."
Tallaabada 4: Soo hel xaashida aad illowday erayga sirta ah Midig-guji oo dooro ikhtiyaarka "Edit".
Tallaabada 5: Riix Ctrl+F si aad u heshid summada "" oo tirtir.
Tallaabada 6: Ka dib markii la tirtiro, kaydi faylka oo xidh tifaftiraha. Hadda, xaashida shaqada waa la hubiyay.
Fur faylka Excel la'aanteed software
Haddii aad doorbidayso inaad furto faylkaaga Excel adigoon isticmaalin wax software ah, weli waxaa kuu jira hab kale. Si aad uga fogaato luminta xogta, samee kaydka xaashidaada Excel marka hore ka dibna raac tillaabooyinka hoose si aad u furto Excel online.
Tallaabada 1: Fur Google Drive oo gal akoonkaaga Gmailka Guji tab "Cusub" oo dooro Google Sheets.
Tallaabada 2: Dhinaca geeska bidix ee sare ee shaashadda, dhagsii File ka dibna Import.
Tallaabada 3: Sanduuqa wada hadalka ayaa soo bixi doona; Guji "Soo rar" oo dooro fayl qalabkaaga si aad u geliso xaashida sirta ah ee Excel.
Tallaabada 4: Ka dib marka aad soo dejiso xaashidaada Excel, dooro "Beddel Xaashiyaha" oo dhagsii "Import Data." Xaashida Excel ee la ilaaliyo waxay ku furmi doontaa Google Sheets.
Tallaabada 5: Tag "File" oo guji "Download As," ka dibna dooro "Microsoft Excel."
Tallaabada 6: Ka dib markaad furto faylka cusub, waxaad arki doontaa in xaashidaada/buuggaaga shaqada aan la ilaalin sirta ah.
Fiiro gaar ah: Xawaaraha soo raritaanka runtii waa mid gaabis ah oo habka wax-u-qaadista ayaa xayirmi doona haddii ay jiraan xaashiyo badan oo ku jira faylkaaga Excel. Intaa waxaa dheer, faylka cusub ee aad ka soo dejisay Google Sheets wuxuu ahaan doonaa muuqaal la ilaaliyo. Waa inaad awood u gelisaa wax ka beddelka gacanta
Talo: Ma jiraa xal haddii aad illowday eraygaaga sirta ah ee Excel ee Mac?
Sida aad arki karto, xalalka sare ee soo kabashada erayga sirta ah ee Excel ayaa inta badan loogu talagalay isticmaaleyaasha Windows. Isticmaale macOS ahaan, waxaa laga yaabaa inaad la yaaban tahay inaad ka soo kaban karto erayga sirta ah ee Excel ee Mac. Qeybtaan waxaan kuu cadeyn doonaa wax walba. Waad sii wadan kartaa akhrinta
Haddii aad u baahan tahay inaad furto erayga sirta ah ee Excel ee la illoobay si aad wax uga bedesho xaashidaada Excel ama buugga shaqada, hababka kor lagu soo sheegay sida adeegsiga code VBA iyo software ZIP waxay sidoo kale ka shaqeyn karaan macOS. Si kastaba ha noqotee, haddii aad rabto inaad dib u soo ceshato erayga sirta ah ee la illoobay si aad u gasho faylkaaga Excel, waxaa jira 2 siyaabood oo keliya oo adiga kugu habboon. Labada qaab waa in la isticmaalo barnaamijka Keychain Access ama ku wareejinta faylkaaga Excel kumbuyuutarka Windows oo aad ku soo ceshato erayga sirta ah qalab sida Passper ee Excel .
Hadda, waxaan diiradda saari doonaa sidii aan dib ugu soo ceshan lahayn erayga sirta ah ee Excel ee la illoobay ee Mac oo wata barnaamijka Keychain Access. Waxaad raaci kartaa tilmaantan faahfaahsan:
Tallaabada 1: Ka hel galka “Codsiga” kumbiyuutarkaaga oo fur. Marka xigta, tag "Utilities> Keychain Access". Guji si aad u furto
Tallaabada 2: Ka hel "Passwords" qaybta bidix ee barnaamijka Keychain Access oo guji.
Tallaabada 3: Waxaad ku arki doontaa tiirka "Magaca" dhanka bidix ee sare ee shaashadda barnaamijka. Hadda, hoos u dhaadhac ilaa aad ka hesho "Excel" oo guji.
Tallaabada 4: Shaashad cusub ayaa soo bixi doonta Fiiri ikhtiyaarka "muuji erayga sirta ah" ee ku jira "sifaadka" tab. Shaashad kale ayaa soo bixi doonta oo waa inaad gelisaa furaha furaha "login".
Tallaabada 5: Taabo "Ogolow" si aad u sii wadato. Waxaad ku arki doontaa erayga sirta ah sanduuqa "Show password".
Gabagabo
Soo kabashada eraygaaga sirta ah ee Excel ee la iloobay ma aha inay noqoto mid walbahaar ama niyad jab. Waxaa jira habab badan oo wax ku ool ah oo aad ku furi karto faylkaaga Excel sida Passper ee Excel . Waxaad u isticmaali kartaa qalabkan nooc kasta oo Excel ah.
