Ungayishintsha kanjani itafula phansi ku-Excel

Noma ngubani osebenzela isikhathi eside namatafula we-Excel, ubhekene nezimo lapho udinga ukudlulisa ikholomu eyodwa noma eziningi phansi. Lokhu kungenzeka ngenxa yokuthi inani elikhulu ledatha kufanele lenziwe endaweni yokusebenza noma udinga ukuqhathanisa amatafula amahhotela (amakholomu) phakathi kwawo. Alikho ithuluzi elihlukile lokwenza lesi senzo ku-Excel. Kodwa-ke, lokhu kungenziwa ngokuhlanganisa amakhono alolu hlelo phakathi kwawo. Ngezindlela ezifakazelwe zokuhambisa inkulumo yetafula kule ndatshana.

Ukuhambisa ikholomu eyodwa noma amaningi ngokusebenzisa "Consopy" umsebenzi + "Namathisela"

Indlela efakazelwe futhi ethandwa kakhulu yokuhambisa itafula phansi noma amanye amaqembu - ngokusebenzisa umsebenzi "osikiwe" no "Namathisela". Kodwa-ke, kubalulekile ukubheka ukuthi inqubo izohluka ngandlela thile ngokuya ngokuthi ikholomu eyodwa noma itafula lonke lizoguqulwa. Inqubo yokuhambisa ikholamu eyodwa:

1. Ekuqaleni, udinga ukugqamisa ikholomu ephelele ngolwazi. Ukuze wenze lokhu, chofoza incwadi yesiLatini ngesihloko sayo.
2. Ukusika ikholamu, ungacindezela inhlanganisela yokhiye - Ctrl + x. Inketho yesibili ukubiza imenyu yomongo ngokucindezela inkinobho yegundane efanelekile ekhanda lekholomu, khetha umsebenzi we- "CUST".

Faka umsebenzi "osikiwe" entweni ethile yetafula

1. Igundane liqokonyiswa lapho udinga ukuhambisa ikholomu. Chofoza i-PKM, ukhethe i- "Insert Cut cut cut cut" umsebenzi.
2. Okukhethiwe ekuqaleni kwetafula elisebenzayo kuzodluliselwa endaweni ekhethiwe.

Ukucisha amakholamu ambalwa asondelene ngasikhathi sinye, ungasebenzisa eyodwa yezindlela ezi-3:

1. Kusetshenziswa imisebenzi - "Kopisha ngokuthi" + "Faka" + "Delete" (into esele esele).
2. Kusetshenziswa imiyalo - "ukusikwa" + "Faka".
3. Ukuhudula igundane.

Inqubo yokuhambisa ikholomu eyodwa noma ngaphezulu yethebula ngemiyalo ethi "Kopisha" + "Faka" + "Delete":

1. Okokuqala, udinga ukugqamisa ikholomu eyodwa noma amaningi udinga ukuhambisa. Ungenza i-Mouse noma ngezikhiye kukhibhodi (i-Shift - kufanele ugimeze le nkinobho, chofoza unhlokweni wekholomu yokuqala, ngaphandle kokukhipha izinkinobho, chofoza unhlokweni wekholomu yokugcina kusuka ebangeni lobubanzi) .

Ukwabiwa kwalawo kuphela amaseli agcwele idatha ethile

1. Okulandelayo, kuyadingeka ukumaka indawo etafuleni lapho ufuna ukuhambisa khona ibanga elizinikezele nedatha (ngokucindezela inkinobho yegundane yesobunxele). Chofoza i-PCM endaweni ekhethiwe, kusuka kumenyu yokuqukethwe, khetha "Insert Cocied Cells" umsebenzi.

Ukungeza ibanga elizinikezele endaweni efiselekayo yetafula

1. Isenzo sokugcina udinga ukuthi ukhethe kabusha ikholomu yokuqala nedatha, chofoza i-PCM ukubiza imenyu ethi "Delete".

Hambisa itafula lemisipha

Indlela elula yokuhambisa amakholomu ngamanye noma ngokushesha okuningi etafuleni le-Excel - ukuhudula igundane. Inqubo:

1. Igundane labelwe ikholomu eyodwa noma amaningi. Uma uhlanganisa i-LKM ngenkinobho yokushintsha, ungamaka ngokushesha ibanga.
2. Sika isikhombisi segundane emngceleni wekholomu noma ibanga elimakiwe, lapho kuzoshintsha khona. Kubalulekile ukulinda ukubonakala kwesithombe sesiphambano nemicibisholo ihlukane ngezindlela ezihlukile.
3. Okulandelayo, udinga ukubamba ukhiye we-Shift, uhudule uhla lwebanga lapho udinga ukuwususela khona umngcele okhethiwe.

Lapho amakholomu angu-1 noma amaningana azohanjiswa endaweni oyifunayo, udinga ukukhipha inkinobho yegundane kanye nokhiye we-Shift.

Sebenzisa ama-macros

Abasebenzisi abanezinga eliphakeme lomsebenzi namatafula we-Excel bamane basebenzise i-macro ekhethekile ukuhambisa izinto ngazinye zetafula, amabanga azinikezele ezindlini ezimakiwe. Ukuze usebenzise le nqubo, kufanele uphinde ubhale ngokuzimela i-VBA Macro. Kodwa-ke, le ndlela inokubuya okukhulu. Isikhathi eside yisikhathi sokulungiselela i-macro kwikholamu noma ebangeni elimakiwe elizodluliselwa endaweni efiselekayo yetafula.

Hambisa imigqa eyodwa noma ngaphezulu yethebula

Ukunakwa okukhethekile kufanele kunikezwe inqubo evamile ngokwanele - susa imigqa eyodwa noma ngaphezulu kwetafula. Inqubo yokuhambisa umugqa owodwa:

1. Cindezela inkinobho yegundane yesobunxele ngenombolo yomugqa okumele uhanjiswe (isikali esinezinombolo sitholakala ohlangothini lwesobunxele lwetafula).
2. Ngemuva kokuthi inkambu ekhethiwe ivele, lahla igundane nge-LKM ehlanganiswe nenombolo oyifunayo.

Lapho umugqa okhethiwe utholakala endaweni oyifunayo, udinga ukukhipha inkinobho yegundane. Inqubo yokuhambisa imigqa eseduze:

1. Qhafaza kwesobunxele kwinombolo yokuqala yomugqa ovela ebangeni. Chofoza ukhiye we-Shift.
2. Skrolela igundane ukuhambisa itafula.
3. Khipha inkinobho yokushintsha ngemuva kokuthi uhla oludingekayo lwemigqa luqokonyiswa.

Ngemuva kwalokho, kusele ukucindezela i-LKM kunoma iyiphi inombolo yemigqa ekhethiwe, shintsha lonke uhla phansi. Inqubo yokuxoshwa phansi imigqa eminingana etholakala ngokwahlukana komunye nomunye:

1. Chofoza inkinobho ye-CTRL.
2. Inkinobho yegundane kwesobunxele Maka yonke imigqa edinga ukuhanjiswa.

Cindezela i-LKM kunoma iyiphi inombolo yemigqa ekhethiwe, ibathuthele endaweni ethile phansi, bayeke inkinobho yegundane.

Ukugcina

Inqubo yokuhambisa itafula elisebenzayo noma uhla oluzinikezele luyinkimbinkimbi impela, uma ungazi ukuthi ungahlanganisa kanjani imisebenzi eyisisekelo ye-Excel. Kulula kakhulu ukudilizwa izinto ngazinye zento yokusebenza ngakwesokunxele noma ngakwesokunene. Kodwa-ke, njengoba kuqondakalise inqubo yokuhlehlisa okuningi emcabangweni, ngokuzijwayeza akufanele kube khona ubunzima.

Umlayezo njengaku-Excel Moval the Table phansi avele kuqala kubuchwepheshe bolwazi.