Ungayitshintsha njani itafile phantsi kwe-Excel

Nabani na osebenze ixesha elide ngeetafile ze-Excel, ujongene neemeko xa kufuneka ugqithise iikholamu enye okanye ezingaphezulu. Oku kunokuba ngenxa yenyani yokuba inani elikhulu ledatha kufuneka lenziwe kwindawo yokusebenza okanye kufuneka uthelekise iitafile zehotele (iikholamu) phakathi kwawo. Akukho sixhobo sahlukileyo sokwenza le ntshukumo kwi-Excel. Nangona kunjalo, oku kungenziwa ngokudibanisa amandla ale nkqubo phakathi kwawo. Kwiindlela eziqinisekisiweyo zokuhambisa itafile ngakumbi kweli nqaku.

Umsebenzi omnye okanye ngaphezulu kwikhompyutha "yokusika" kunye "Copy" + "paste"

Inkqubo eqinisekisiweyo kunye neyona ndlela ithandwayo yokuhambisa itafile phantsi okanye kwamanye amaqela-ngokusebenzisa "ukusika" kunye "nokuncamathisela". Nangona kunjalo, kubalulekile ukuba uthathele ingqalelo ukuba le nkqubo iza kwahluka ngokuxhomekeke kwikholamu enye okanye itafile yonke iya kutshintshwa. Inkqubo yokuhambisa ikholamu enye:

1. Ekuqaleni, kufuneka ubalaselise ikholamu yonke ngolwazi. Ukwenza oku, cofa kwileta yesiLatin kwisihloko sayo.
2. Ukusika ikholamu, unokucinezela ukudityaniswa okuphambili - i-CTRL + X. Inketho yesibini kukutsalela imenyu yemeko ngokucinezela iqhosha lemouse ekunene kwintloko yesihloko sekholamu, khetha "umsebenzi" osikiweyo ".

Sebenzisa umsebenzi "osikiweyo" kwitafile ethile

1. Imouse ibalaseliswa apho kufuneka uqhubele ikholamu. Cofa i-PKM, khetha "Faka umsebenzi wokusika".
2. Into ekhethiweyo yokuqala yetheyibhile yokusebenza iya kutshintshelwa kwindawo ekhethiweyo.

Ukutshintsha iikholamu ezininzi ezikufuphi ngexesha, ungasebenzisa iindlela ezi-3:

1. Sebenzisa imisebenzi - "Ikopi" + "Faka" + "Cima" (Into eseleyo).
2. Sebenzisa imiyalelo - "Sika" + "Faka".
3. Ukutsala imouse.

Inkqubo yokuhambisa itheyibhile enye okanye engaphezulu yetheyibhile ngemiyalelo "Ikopi" + "faka" + "Cima":

1. Okokuqala, kufuneka ubalaselisa i-teamum enye okanye ezingaphezulu kuya kufuneka uhambe. Ungayenza imouse okanye ngamaqhosha kwikhibhodi .

Ukwabiwa kuphela kwezi sendlela ezizaliswe yidatha ethile

1. Emva koko, kuyimfuneko ukuphawula indawo etafileni apho ufuna ukuhambisa uluhlu olunikezelweyo kunye nedatha (ukucinezela iqhosha lemouse lasekhohlo). Cofa i-PCM kwindawo ekhethiweyo, kwimenyu yemeko, khetha "ukufaka iiseli ezikhutshelweyo".

Ukongeza uluhlu olunikezelweyo kwitafile efunekayo

1. Inyathelo lokugqibela kufuneka ukhethe kwakhona ikholamu yokuqala ngedatha, cofa i-PCM ukufowunela imenyu yemeko, cofa iqhosha u "Cima".

Hambisa itafile yemisipha

Eyona ndlela ilula yokuhambisa iikholamu zomntu ngamnye okanye ngokukhawuleza kwitheyibhile ye-Excel-Tsala imouse. Inkqubo:

1. Imouse yabelwe enye okanye ezingaphezulu. Ukuba udibanisa i-LKM ngeqhosha le-Shift, unokukhawuleza uphawula uluhlu.
2. Sika isikhombisi semouse ukuya kumda wekholamu okanye uluhlu oluphawulweyo, eliya kutshintsha kweliphi icala. Kubalulekile ukuba ulinde ukubonakala komfanekiso womnqamlezo kunye neentolo eziphazamisayo kwiindlela ezahlukeneyo.
3. Okulandelayo, kufuneka ubambe iqhosha le-Shift, utsala uluhlu lwamanqanaba apho kufuneka uyitshintshe khona kumda okhethiweyo.

Xa i-1 okanye iikholamu ezininzi ziya kuhanjiswa kwindawo oyifunayo, kufuneka ukhuphe iqhosha lemouse kunye neqhosha le-Shift.

Sebenzisa i-macros

Abasebenzisi abanamanqanaba aphezulu omsebenzi ngeetheyibhile ze-Excel baya kusebenzisa nje i-macro ekhethekileyo ukuze basebenzise izinto ezikhethekileyo zetafile, ukunikezelwa kwiindawo eziphawulwe kwiindawo eziphawulweyo. Ukuphumeza le nkqubo, kufuneka ubhale ngokuzimeleyo i-vba macro. Nangona kunjalo, le ndlela inento ebalulekileyo. Ixesha elide lixesha lokumisela i-macro ukuya kwikholamu okanye uluhlu oluphawulweyo ukuba lutshintshelwe kwindawo oyifunayo.

Hambisa imitya enye okanye engaphezulu

Ingqwalaselo eyodwa kufuneka inikezwe kwinkqubo eyaneleyo - i-off-up-up-up okanye ngaphezulu kwetafile. Inkqubo yokuhambisa umgca omnye:

1. Cinezela iqhosha lemouse lasekhohlo ngenani lomgca ekufuneka ususwe (isikali ngamanani akwicala lasekhohlo le tafile).
2. Emva kokuba intsimi ekhethiweyo iyavela, yehlisa imouse nge-lkm eboshwe kwinani elifunayo lemiqolo.

Xa umgca okhethiweyo ubekwe kwindawo oyifunayo, kufuneka ukhuphe iqhosha lemouse. Inkqubo yokuhambisa imigca ekufuphi:

1. Cofa ekhohlo kwinombolo yokuqala yomgca ukusuka kuluhlu. Cofa iqhosha le-Shift.
2. Skrolela imouse ukuze uskrole itafile.
3. Khupha iqhosha le-Shift emva koluhlu olufunekayo lwemigca elibonisiweyo.

Emva koko, ihlala icinezela i-LKM ngalo naliphi na inani lemigca ekhethiweyo, itshintshe lonke ixesha. Inkqubo yokufuduka phantsi imigca eliqela efumaneka ngokwahlukeneyo omnye komnye:

1. Cofa kwiqhosha le-CTRL.
2. Iqhosha leqhosha lasekhohlo laphawula yonke imigca ekufuneka ishukunyiswe.

Cinezela i-LKM ngalo naliphi na inani lemigca ekhethiweyo, ubashukumisele kwindawo ethile, uyeke iqhosha lemouse.

Ukuqukumbela

Inkqubo yokuhambisa itafile esebenzayo okanye uluhlu olunikezelweyo luyinkimbinkimbi, ukuba awuyazi indlela yokudibanisa imisebenzi esisiseko ye-Excel. Kulula kakhulu ukushenxiswa kwezinto ezisebenzayo zomsebenzi ekhohlo okanye ngasekunene. Nangona kunjalo, ukuba bayayiqonda nenkqubo yokuhamba ngaphezulu kwithiyori, ekusebenzeni akufuneki kungabikho kubunzima.

Umyalezo njengoko kwi-Excel susa itafile phantsi kwakufakwe kuqala kwitekhnoloji yolwazi.