Ungayiqhubela njani itafile kwi-Excel

Indlela yoku-1: Isixhobo sobukhulu besixhobo

Isixhobo "sobukhulu" isixhobo "sikuvumela ukuba uhlele itafile egqityiweyo ngokutshintsha uluhlu lwayo ngokungena kwimilinganiselo emitsha. Ukuba awukadale itafile enjalo onokuyilungisa, yenze, emva kwale nkcazo ingezantsi, emva koko ufumanise ukuba ungayitshintsha njani ubungakanani bayo kwimeko yesidingo.

1. Ngexesha lokudalwa kweeseli ezibekwe kwitafile egcweleyo, unokuchaza imiqolo kunye nomda ukuze ungayiqhubeke. Ukwenza oku, chaza zonke iiseli ezifanelekileyo ngokubamba iqhosha lemouse lasekhohlo.



2. Vula i-Insert Tab.



3. Yandisa icandelo lokuqala "letafile".



4. Kwimenyu ebonakalayo, khetha ukhetho olufanelekileyo ukwenza itafile ngokufunda malunga neempawu zenkcazo yomphunga ngamnye.



5. Xa kusenziwa indawo yedatha kuxhomekeke kuxhomekeka kwiiseli ezikhethiweyo, ngenxa yoko akuyomfuneko ukutshintsha iparameter.



6. Itheyibhuli sele idalwe ngomgca wentambo, ngoko ke ukuqhubeka kwayo akunakuyimfuneko.

Ukuba itafile yenziwe ngaphambili, kuya kufuneka wenze ngokwahlukileyo:

1. Kwithebhu yomyili, cofa kwiqhosha "letafile".



2. Iwindows iya kuvela apho ifaka uluhlu olutsha ngokubalalwa kolwandiso lwetafile, kwaye emva koko uqinisekise utshintsho.



3. Buyela etafileni kwaye uqiniseke ukuba zonke iintshukumo zigqityiwe ngokuchanekileyo kwaye isiphumo sikufanele.

Ngoku, kamsinya nje ukuba ulwandiso lwetheyibhile lufunwa kwakhona, tsalela umnxeba kwakhona esi sixhobo kwaye usete amaxabiso amatsha ukongeza inani elifunekayo lemigca.

Indlela 2: Iitafile zemenyu yemenyu

Xa usebenza netafile egqityiweyo yokwandiswa, ungasebenzisa imenyu yayo yemeko kunye "nokufaka". Oku kuyakongeza kuphela umgca omnye, kodwa akukho nto iya kuthintela imenyu yokuphinda isebenze kwakhona kulwandiso lwetafile enkulu.

1. Cofa enye yemiqolo yetafile ngeqhosha leqhosha lasekunene.



2. Kwimenyu yokujonga umxholo, khetha i "Faka" umtya "wokufaka".



3. Umtya ongenanto uya kongezwa kwindawo yetafile apho i-PKM ifakwe khona.

Indlela 3: "Imenyu" yemenyu

Kwimenyu "yeseli", kukho into eyahlukileyo yokufaka imitya eya kuba luncedo ukuba indawo etafileni sele iphelile. Isebenza esi sixhobo ngokwazisa nge-anagy yangaphambili, kodwa ibizwa ngokwahlukileyo.

1. Kwithebhu yasekhaya, yandisa icandelo "leseli".



2. Kwiphaneli evelayo, cofa "unamathisela".



3. Khetha ukhetho lokufaka umtya kwiphepha okanye kwikholamu, kuxhomekeka kweliphi icala.

Ukuba uhlala udibana nemfuno yokwandisa iitafile, nikela ingqalelo kwizinto ezinokukhetha kuzo "smart". Malunga nokwenza izinto ezinjalo e-Excel, funda eli nqaku lingezantsi.

Funda ngakumbi: usebenzisa "iitafile" ze-Smart "kwiMicrosoft Excel