Ungayibeka kanjani iphasiwedi kufayela le-Excel

Ukuphepha nokuvikelwa kwemininingwane kungenye yezindlela eziphambili zokuthuthukiswa kobuchwepheshe banamuhla bolwazi. Ukuhambisana kwale nkinga akuncishisiwe, kepha kukhula kuphela. Ukuvikelwa kwedatha okubaluleke kakhulu kwamafayela wethebula lapho imininingwane ebalulekile ivame ukugcinwa ngolwazi lwezentengiso. Ake sibheke ukuthi ungawavikela kanjani amafayela we-Excel usebenzisa iphasiwedi.

Ukufakwa kwephasiwedi

Abathuthukisi bohlelo baqonda kahle ukubaluleka kokufaka iphasiwedi kumafayili e-Excel, ngakho-ke kunezindlela eziningi zokwenza le nqubo ngasikhathi sinye. Ngasikhathi sinye, kungenzeka ukusungula ukhiye, kokubili lapho kuvulwa le ncwadi noshintsho lwayo.

Indlela 1: Ukubeka iphasiwedi ngenkathi ukonga ifayela

Indlela eyodwa efaka ukusetha iphasiwedi ngqo lapho ukonga incwadi ka-Excel.

1. Iya kuthebhu "yefayela" yohlelo lwe-Excel.



2. Chofoza ku- "Gcina njenge".



3. Ewindini elivula, sichofoza inkinobho ethi "Service", etholakala ezansi. Kumenyu evela, khetha "amapharamitha jikelele ...".



4. Elinye iwindi elincane livuleka. Vele kuso, ungacacisa iphasiwedi kufayela. In the "Iphasiwedi yenkambu yokuvula", sifaka igama elingukhiye elizodinga ukucacisa lapho kuvulwa incwadi. In the "Iphasiwedi ukushintsha" inkambu, faka ukhiye ozofakwa uma udinga ukuhlela leli fayela.

   Uma ufuna ifayela lakho likwazi ukuhlela abantu abangagunyaziwe, kepha ufuna ukushiya ukufinyelela kokubukwa mahhala, kuleli cala, faka kuphela iphasiwedi yokuqala. Uma izinkinobho ezimbili zichaziwe, lapho uvula ifayela, uzokwaziswa ukuthi ungene. Uma umsebenzisi azi ngowokuqala kuphela kubo, khona-ke uzotholakala kuphela ukuze ufunde, ngaphandle kwekhono lokuhlela idatha. Esikhundleni salokho, uzokwazi ukuhlela konke, kepha ngeke kwenzeke ukusindisa lezi zinguquko. Kungagcinwa kuphela ngesimo sekhophi ngaphandle kokushintsha idokhumenti yokuqala.

   Ngaphezu kwalokho, ungabeka umkhaza ngokushesha ngento "encomayo yokufunda kuphela".

   Ngasikhathi sinye, ngisho nomsebenzisi owaziyo womabili iphasiwedi, ifayela elizenzakalelayo lizovulwa ngaphandle kwebha yamathuluzi. Kepha, uma efiswa, uzohlala ekwazi ukuvula leli phaneli ngokucindezela inkinobho efanele.

   Ngemuva kwayo yonke izilungiselelo ewindini elijwayelekile lepharamitha zenziwa, chofoza inkinobho ethi "Kulungile".



5. Iwindi livula lapho ufuna ukufaka khona ukhiye futhi. Lokhu kwenzelwa ukuqinisekisa ukuthi umsebenzisi unephutha ekuqaleni engena kulokho okwejwayelekile. Chofoza inkinobho ethi "KULUNGILE". Uma kwenzeka kuwukungatholwa kwamagama angukhiye, uhlelo luzonikeza ukufaka iphasiwedi futhi.



6. Ngemuva kwalokho, sibuyele efasiteleni elisindisa ifayela futhi. Lapha, uma ufisa, shintsha igama layo bese unquma umkhombandlela lapho kuzoba khona. Lapho konke lokhu kwenziwa, chofoza inkinobho ethi "Gcina".

Ngakho-ke savikela ifayela le-Excel. Manje kuzothatha amaphasiwedi afanele ukuvula nokuhlela.

Indlela 2: Ukubeka iphasiwedi engxenyeni ethi "Imininingwane"

Indlela yesibili isho ukufakwa kwephasiwedi kwisigaba "semininingwane".

1. Njengoba okokugcina, yiya kuthebhu ethi "File".
2. Engxenyeni ethi "Imininingwane", chofoza inkinobho ethi "Vikela ifayela". Uhlu lwezinketho ezingenzeka zokuvikelwa kokhiye wefayela liyavula. Njengoba ubona, ungavikela iphasiwedi hhayi kuphela ifayela eliphelele, kepha futhi neshidi elihlukile, kanye nokuthola ukuvikelwa kwezinguquko ekwakhekeni kwesakhiwo sencwadi.



3. Uma simisa ukukhethwa entweni ethi "ENCIPAT Iphasiwedi", iwindi lizovuleka lapho kufanele kufakwe igama elingukhiye. Le phasiwedi ihlangabezana nesihluthulelo sokuvula incwadi esiyisebenzisile ngendlela edlule ngenkathi igcina ifayela. Ngemuva kokufaka idatha, cindezela inkinobho ethi "Kulungile". Manje, ngaphandle kokwazi ukhiye, ifayela akekho ongalivula.



4. Uma ukhetha into ethi "Vikela Ishidi Lamanje", iwindi lizovulwa ngenani elikhulu lezilungiselelo. Kukhona newindi lokufaka iphasiwedi. Leli thuluzi likuvumela ukuthi uvikele ishidi elithile ekuhlelweni. Ngasikhathi sinye, ngokungafani nokuvikelwa ezinguquko ekusindisweni ngokusindisa, le ndlela ayihlinzeki ngekhono lokudala ikhophi elilungisiwe leshidi. Zonke izenzo zivinjelwe kukho, yize zizosindiswa ngencwadi zingagcinwa.

   Izilungiselelo zezinga lokuvikelwa umsebenzisi angazibeka, adalule amabhokisi okuhlola ezintweni ezithile. Ngokuzenzakalelayo, kuzo zonke izenzo zomsebenzisi ezingeyona eyakho iphasiwedi, etholakala eshidini kuphela ukukhetha kwamaseli. Kepha, umbhali wedokhumenti angavumela ukufomatha, ukufaka nokususa imigqa namakholomu, ukuhlunga, ukusebenzisa i-autofilter, ushintsho ezintweni kanye nemibhalo, njll. Ungasusa ukuvikelwa cishe nganoma yisiphi isenzo. Ngemuva kokusetha izilungiselelo, chofoza inkinobho ethi "Kulungile".



5. Uma uchofoza ku- "Suppled Sakheka sencwadi ethi" Into ", ungabeka ukuvikela ukwakheka kwedokhumenti. Izilungiselelo zihlinzeka nge-blockage yoshintsho esakhiweni, zombili ngephasiwedi futhi ngaphandle kwawo. Esimweni sokuqala, lokhu kubizwa okubizwa ngokuthi "ukuvikelwa kwesiwula", okungukuthi, kusuka entweni engahlosile. Esimweni sesibili, lokhu sekuvikelekile ekushintsheni kwedokhumenti okuhlosiwe kwabanye abasebenzisi.

Indlela 3: Ukufakwa kwephasiwedi kanye nokususwa kwayo kuthebhu ethi "Ukubuyekezwa"

Amandla okufaka iphasiwedi ekhona futhi kwithebhu ethi "Ukubuyekezwa".

1. Iya kuthebhu engenhla.



2. Sifuna i-Change Tool Block ethepheni. Chofoza inkinobho ethi "Vikela iqabunga", noma "Vikela incwadi". Lezi zinkinobho azihambelani ngokuphelele nezinto "Vikela ishidi lamanje" futhi "ukuvikela ukwakheka kwencwadi" esigabeni "sokwaziswa", esivele sikhulume ngenhla. Ezinye izenzo ziyafana ngokuphelele.



3. Ukuze ususe iphasiwedi, udinga uchofoze inkinobho ethi "Susa Leaf Protection" ethepheni bese ufaka igama elingukhiye elifanele.

Njengoba ubona, iMicrosoft Excel inikeza izindlela eziningana zokuvikela ifayela ngephasiwedi, kokubili ekuphambeni ngamabomu, nasezenzweni ezingahlosile. Ungadlula ngokuvulwa kwencwadi nokuhlela noma ukuguqula izinto zayo ezihlelekile. Ngasikhathi sinye, umbhali angazichaza, lapho eshintsha khona afuna ukuvikela lo mbhalo.