Excel

Ungalikhusela njani iphepha lokugqwesa ngaphandle/ngegama lokugqitha

Logama nje usebenzisa iWindows okanye iMac, kufuneka uqhelane namaxwebhu eMicrosoft Excel. Kuya kuba nzima kakhulu kumntu wesithathu ukuguqula amaxwebhu akho, ukuba nje amaxwebhu e-Excel egciniwe kwaye ekhuselwe ngamagama ayimfihlo okhuseleko kwiPC yakho.

Nangona kunjalo, izinto eziyimfihlo ezilityelweyo ngamanye amaxesha ziyenzeka emva kokukhusela amaxwebhu akho ngephasiwedi yokhuseleko. Oku akuthethi ukuba uphulukene nawo onke la maxwebhu ngonaphakade. Usenako ukuyiqokelela, kodwa kufuneka kuqala wamkele izisombululo kuzo susa igama lokugqitha kwifayile ye-excel . Eli nqaku labelane ngazo zonke izisombululo onokuthi uzithathe ukuze ungakhuseli amaxwebhu akho e-Excel/iifayile/amaxwebhu akhuselwe ngephasiwedi yokhuseleko.

Icandelo 1: Loluphi uhlobo lwegama lokugqitha enalo i-Excel?

Kukho inani leepropathi ezakhelwe-ngaphakathi zokubethela ezibandakanyekayo kwi-Excel kubasebenzisi bayo kwaye zimi ngolu hlobo lulandelayo:

Ivula igama lokugqithisa

Igama lokuvula lolona hlobo lokhuseleko olusetyenziswa ngabasebenzisi abaninzi. Oku kusetyenziswa rhoqo ukuvula uxwebhu olugqwesileyo. Ukuba uxwebhu lwe-Excel lufihliwe ngegama lokuvula lokuvula, ngalo lonke ixesha uvula olu xwebhu, uya kucelwa ukuba ufake igama lokhuseleko lokhuseleko.

Ivula igama lokugqithisa

guqula igama lokugqithisa

I-password yokuguqula isetyenziswa ngokubanzi zii-ofisi kunye neenkampani. Ekubeni igama layo lizingisa, aliyi kuvumela abasebenzisi ukuba baguqule i-Excel sheet okanye incwadi yomsebenzi ngalo lonke ixesha umsebenzisi efuna ukusebenzisa uxwebhu. Oku kwaziwa njengamaxwebhu okufunda kuphela njengoko kukuvumela ukuba ufunde uxwebhu ngaphandle kwezithintelo. Umsebenzisi kuya kufuneka anikeze igama eliyimfihlo elifihliweyo phambi kokuguqula uxwebhu.

guqula igama lokugqithisa

Iphasiwedi yokufunda kuphela

Oku kuyafana namaxwebhu e-Excel anokuguqulwa kwegama lokugqitha. Iya kuvumela kuphela abasebenzisi ukuba bafunde uxwebhu.

Igama lokugqitha lesakhiwo sencwadi yomsebenzi

Olu hlobo loguqulelo oluntsonkothileyo lubaluleke kakhulu nanini na xa ungafuni ukuba umntu wesithathu adibanise, ashukume, acime, afihle okanye athiye ngokutsha into ethile. Oku kukwabizwa ngokuba "ukukhusela i-Excel sheet structure." Ke ngoko, nasiphi na isiqulatho kwisakhiwo asikwazi ukuhlelwa ngaphandle kokungena igama eligqithisiweyo.

Igama lokugqithisa lephepha

I-sheet password ivalela ngokubanzi abasebenzisi ekutshintsheni, ekuguquleni, okanye ekucimeni umxholo kwiphepha lomsebenzi. Oku kunokuvumela kuphela abasebenzisi ukuba babe nofikelelo lokuhlela inxalenye yephepha lomsebenzi endaweni yalo lonke iphepha lomsebenzi.

Igama lokugqithisa lephepha

Icandelo 2: Indlela yokuvula i-Excel Ekhuselweyo nge-Password eyaziwayo

Enye yeendlela ezilula zokungakhuseli iifayile ze-Excel ezikhuselweyo kukwenza oko ngegama eliyimfihlo elaziwayo. Kuba uyayazi igama eligqithisiweyo, konke okufuneka ukwenze kukufaka igama eligqithisiweyo apho kuyimfuneko kwaye uya kufumana ukufikelela kwifayile. La manyathelo angezantsi aya kukukhokela ukuba uvule ifayile ye-Excel.

Inyathelo loku-1 : Vula ifayile ye-Excel ekhuselweyo ngegama eliyimfihlo.

Inyathelo lesi-2 : Kuba ifayile ikhuselwe ngegama eliyimfihlo, uya kubona ifestile ephumayo kwiscreen xa uzama ukuvula ifayile. Le festile i-pop-up iya kukwazisa ukuba ifayile ye-Excel inegama lokugqitha oza kuyidinga ngaphambi kokuba uyivule ifayile. Uya kubona indawo yokubhaliweyo apho kufuneka ufake igama eligqithisiweyo.

Inyathelo lesi-3 : Faka igama eligqithisiweyo elichanekileyo kwindawo yokubhaliweyo ukuze uvule ifayile ye-Excel.

Uyivula njani i-Excel ekhuselweyo ngegama eliyimfihlo elaziwayo

Inyathelo lesi-4 : Zama ukuvula ifayile kwaye kufuneka unikwe imvume yokufikelela.

Le ndlela yeyona ilula kuba iyafana kuzo zonke iinguqulelo ze-Excel ukusuka ngo-2007 ukuya ku-2019.

Icandelo 3: Njani khusela i-excel sheet ngaphandle kwegama lokugqitha

Le ndlela ibaluleke kakhulu ku-2010 kunye nenguqulo yangaphambili. Nceda uqaphele ukuba ayihambelani neenguqulelo ezintsha.

Inyathelo loku-1 : Okokuqala, yenza ugcino lwefayile ye-Excel ekhuselweyo ngegama eliyimfihlo.

Inyathelo lesi-2 : Okwesibini, nqakraza ekunene kuxwebhu lwe-Excel kwaye ucofe iqhosha lokuqamba ngokutsha.

Inyathelo lesi-3 : Guqula ulwandiso lwefayile lube “.zip” ukusuka ku “.сsv” okanye “.xls”.

Guqula ulwandiso lwefayile lube ".zip" ukusuka ".сsv" okanye ".xls"

Inyathelo lesi-4 : Cofa imixholo yefayile ecinezelweyo ngoku.

Inyathelo lesi-5 : Fumana ifayile ephela ngo “.xml” ifomathi.

Fumana ifayile ephela ".xml" ifomathi

Inyathelo lesi-6 : Emva koko, cofa kabini ifayile yeXML kwaye uvule ifayile ngomhleli weXML.

Emva koko cofa kabini kwifayile yeXML kwaye uvule ifayile ngomhleli weXML

Inyathelo lesi-7 : Cofa "Ctrl + F" kwaye ukhangele "uKhuselo lwePhepha". Khangela umgca oqala nge »

Inyathelo lesi-8 : Cima elo gama kwifayile kwaye ucofe Gcina.

Cima elo gama kwifayile kwaye ucofe Gcina.

Inyathelo lesi-9 : Emva koko tshintsha ifayile ye-“.zip” ibe ngu-“.сsv” okanye “.xls” kwaye ucofe u-Enter. Ngoku iphepha lakho lomsebenzi aliyi kukhuselwa kwaye ngoku ungavula uxwebhu lwakho ngaphandle kwegama lokugqitha. Oku kuya kukuvumela ukuba ufikelele kuxwebhu lwakho lwe-Excel.

Ububi:

  • Iyahambelana kuphela no-2007 okanye inguqulelo yangaphambili.
  • Asiyondlela ethembekileyo.
  • Inzima kakhulu.

Icandelo lesi-3: ULingakhuselwa njani iPhepha le-Excel elinegama lokugqithisa eliBuyiselekayo

Obu buchule bobona buchule bunikezelwayo bokuvula ifayile/uxwebhu olukhuselweyo lokugqitha xa ulahlekelwe ligama eligqithisiweyo okanye ungenalo igama lokugqitha. Isixhobo esinamandla nesithembekileyo esisinikezayo apha Ipasile le-Excel . Sebenzisa kakuhle iPasser ye-Excel ukufikelela kunye nokuvula amaxwebhu akhuselweyo ngegama eliyimfihlo. Le nkqubo yokubuyisela i-password ye-Excel iya kukuvumela ukuba ubuyise iifayile zakho ze-Excel kulo naluphi na uhlobo lweMicrosoft (ezifana no-Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021). Ukuza kuthi ga ngoku, le nkqubo ithathwa njengenye yezona zixhobo zingcono ngabasebenzisi kwihlabathi liphela ukubuyisela amagama ayimfihlo kwiifayile ezikhuselweyo zeExcel.

Yizame simahla

  • Ijolise ekufumaneni kwakhona igama lokugqitha lokuvula kwiifayile zakho ezikhuselweyo ze-Excel, nokuba lintsonkothe ​​kangakanani na igama lokugqitha.
  • Esi sixhobo sinokusetyenziselwa ukususa izithintelo kwi-password ekhuselweyo ye-Excel spreadsheet ukuba unokuvula kwaye ufunde i-Excel sheet ngaphandle kokuhlela amalungelo.
  • Iintlobo ze-4 zokubuyisela zibonelelwa ukuqinisekisa ukuba izinga eliphezulu lokubuyisela.
  • Itekhnoloji yeCPU kunye neGPU yamkelwa, ngoko ke isantya sokubuyisela sikhawuleza kangangezihlandlo ezili-10 kunezinye izixhobo zokubuyisa iphasiwedi ye-Excel.
  • Zonke iinguqulelo zeefayile ze-Excel zixhaswa, njenge-Excel 2019, 2016, 2013, njl.

Nanga amanyathelo okuvula ifayile efihliweyo ye-Excel enePassers ye-Excel

Inyathelo loku-1 : Qala ngokumisela isoftwe. Kujongano oluphambili, iya kukubonisa iindlela ezi-2 zokubuyisela. Cofa ngokulula "Buyisa amagama okugqithisa".

Ukususwa kwephasiwedi ye-Excel

Inyathelo lesi-2 : Cofa i Yongeza iqhosha kwaye ufake ifayile ye-Excel apho ufuna ukubuyisela igama eligqithisiweyo. Okulandelayo, khetha uhlobo lohlaselo lwegama lokugqitha ofuna ukuba nalo kuxwebhu. Kukho iintlobo ezi-4 zohlaselo eziphambili zesixhobo: Uhlaselo lweBrute Force, uHlaselo oluDibeneyo, uHlaselo lweSiginitsha, kunye neMask Attack. Khetha leyo ikufanele kakhulu.

khetha indlela yokubuyisela ukubuyisela igama eligqithisiweyo

Inyathelo lesi-3 : Lungisa iparameter ngokokhetho olukhethileyo kwezine. Emva kokuba ugqibile ngokuseta iiparamitha, cofa uBuyisela. Kwangoko, isixhobo sokubuyisela igama eligqithisiweyo le-Excel siya kuqhuba ifayile kwaye sikunikeze igama eligqithisiweyo onokulisebenzisa ukuvula ifayile ye-Excel.

Icandelo 5: Susa izithintelo zokuHlela iPhepha loMsebenzi/iNcwadi yoMsebenzi kwiSekondi ezi-3

Ungasebenzisa kwakhona iPasser yeprogram ye-Excel ukususa ukukhuselwa kumaphepha kunye neencwadi zokusebenza kwi-Excel, nangaphandle kokuba negama lokugqitha.

Yizame simahla

Inyathelo loku-1 : Faka ngokulula iPasspers yeExcel kwikhompyuter yakho. Yivule kwaye ukhethe ukhetho lwesibini oluboniswe kwi-interface yePC yakho.

Ukususa izithintelo ze-Excel

Inyathelo lesi-2 : Cofa i Fayile iqhosha ukungenisa ifayile yakho (Excel sheet). I-Excel sheet iya kuvela kwiprogram ebonisa uphawu olutshixiweyo.

khetha ifayile ebalaseleyo

Inyathelo lesi-3 : Ngeli xesha umda wokuhlela kwifayile eyongeziweyo uya kususwa kwimizuzwana emi-3. Kakuhle kakhulu! Kwaye ngalo mba, yongeza ukhuseleko lokugqitha kwispredishithi sakho kwixesha elizayo xa usigcina.

susa izithintelo ze-Excel

Ukuqukumbela

Sikubonise izixhobo kunye neendlela zokufumana kwakhona kunye nokuvula iifayile ze-Excel ezikhuselwe ngegama eliyimfihlo. Ukuba ujonge izisombululo ezithe ngqo ngakumbi, umzekelo, ungalikhuseli njani iphepha le-Excel ngaphandle kwegama lokugqitha, Ipasile le-Excel Iya kuqhubeka iyindlela yakho engcono.

Yizame simahla

Izithuba eziyeleleneyo

Shiya iMpendulo

Idilesi yakho ye-imeyile ayizupapashwa.

Buyela phezulu iqhosha
Yabelana nge
Khuphela ikhonkco