Ungayifaka njani itafile ekuthinjweni

Ngamanye amaxesha kukho iimeko xa kufuneka iguqule itafile, oko kukuthi, tshintsha imigca kunye neekholamu kwiindawo. Ewe kunjalo, unokuyibulala ngokupheleleyo yonke idatha njengoko uyifunayo, kodwa inokuthatha ixesha elithile. Asingabo bonke abasebenzisi be-Excel ebalaseleyo ukuba le prosebor ye-tabium inomsebenzi oya kunceda le nkqubo. Masifunde ngokweenkcukacha indlela imigca eyenza ngayo iikholamu kwi-Excel.

Inkqubo yokuvula

Utshintsho kwiindawo zeekholamu kunye nemigca e-Presele ibizwa ngokuba yintuthuko. Unokwenza le nkqubo ngeendlela ezimbini: ngokufaka okhethekileyo kunye nokusebenzisa umsebenzi.

Indlela yoku-1: Ukufakwa okukhethekileyo

Fumana indlela yokuThengisa itafile nge-Excel. Ukutshintsha usebenzisa ukufaka okhethekileyo yeyona ndlela ilula kunye nolona hlobo luphakamileyo lwe-coup yoluhlu lwetafile yabasebenzisi.

1. Sibonisa itafile yonke kunye nesikhombisi semouse. Cofa kuyo ngoku ngasekunene. Kwimenyu ebonakalayo, khetha into "ikopi" okanye ucofe nje kwikhibhodi idibene ne-CTRL + C.



2. Siba ngokufanayo okanye kwelinye iphepha kwiseli engenanto, kuya kufuneka ibe sisisele esisekhohlo setafile entsha. Cofa kuyo kwiqhosha le mouse lasekunene. Kwimenyu yokujonga umxholo, qhubeka ngokusebenzisa "ukufaka okhethekileyo ..." into. Kwimenyu eyongezelelweyo evelayo, khetha into ngegama elifanayo.



3. I-windows yoqwalaselo ekhethekileyo ivula. Faka ibhokisi yokujonga malunga ne "Traves" Ixabiso. Cofa kwiqhosha "Kulungile".

Njengoko ubona, emva kwezi zenzo, itafile yomthombo yakhutshelwa kwindawo entsha, kodwa sele ineeseli ezingena eziguqukayo.

Emva koko, unokucima itafile yoqobo ngokukhetha ngokucofa isikhombisi, kwaye ngokukhetha "Cima ..." into. Kodwa awukwazi ukwenza le nto ukuba ayizukuphazamisa iphepha.

Indlela 2: Umsebenzi wesicelo

Indlela yesibini yokujika i-Excel iquka ukusetyenziswa komsebenzi owodwa we-TRAC.

1. Khetha indawo kwiphepha elilinganayo nenqanaba letafile yomthombo. Cofa kwindawo ethi "Faka umsebenzi" Icon ibekwe ngasekhohlo kwi-formula yoluhlu.



2. I-Wizard ivula. Uluhlu lwezixhobo ezibonisiweyo lufuna igama "Transp". Emva kokuba ifunyenwe, sabela kwaye sicinezele iqhosha "Kulungile".



3. Iwindow yempikiswano ivula. Eli nqaku linempikiswano enye kuphela - "uluhlu". Sibeka isikhombisi kwintsimi yayo. Ukulandela oku, siyayisebenzisa yonke itafile esifuna ukutshintsha. Emva kokuba idilesi yoluhlu olunikezelweyo irekhodwa endle, cofa kwiqhosha "Kulungile".



4. Sibeka isikhombisi ekupheleni komtya wefomula. Kwikhibhodi, uhlobo lwe-CTRL + Shift + Ngenisa indibaniselwano yesitshixo. Esi senzo siyimfuneko ukuze idatha iguqulwe ngokuchanekileyo, kuba asijonganga iseli enye, kodwa i-gragy arragy.



5. Emva koko, le nkqubo iqhuba inkqubo yotshintsho, oko kukuthi, itshintsha iikholamu kunye nemigca kwiindawo ezisetafileni. Kodwa ukudluliselwa kwenziwe ngaphandle kokufomatha.



6. Sifotile itafile ukuze sinembono eyamkelekileyo.

Inqaku lendlela yokuThengiswa, ngokuchasene neyangaphambili, kukuba idatha yokuqala ayinakususwa, njengoko oku kuya kususa uluhlu oludlulisiweyo. Ngapha koko, naluphi na utshintsho kwidatha oluphambili luya kukhokelela kutshintsho olufanayo kwitafile yabo entsha. Ke ngoko, le ndlela intle ngakumbi ekusebenzeni ngeetafile ezinxulumene noko. Kwangelo xesha, kunzima kakhulu kwinketho yokuqala. Ukongeza, xa usebenzisa le ndlela, kuyimfuneko ukugcina umthombo, obungasoloko sisona sisombululo sifanelekileyo.

Sifumanise ukuba ungayitshintsha njani iikholamu kunye nemitya ye-Excel. Zimbini iindlela eziphambili zokujika itafile. Kuthekani ngabo kuxhomekeke ekubeni uceba ukufaka idatha enxulumene okanye hayi. Ukuba akukho zicwangciso zinjalo, kuyacetyiswa ukuba basebenzise inguqulelo yokuqala yokusombulula umsebenzi njengolula.