Lapho usebenza e-Excel, kwesinye isikhathi ungahlangabezana nesidingo sokushintshana kwemigqa. Kunezindlela eziningana ezifakazelwe zalokhu. Abanye babo bathuthela ngokoqobo ekuchofozeni okumbalwa, kanti abanye badinga isikhathi eside sale nqubo. Ngeshwa, akubona bonke abasebenzisi abajwayelene nazo zonke lezi zinketho, ngakho-ke kwesinye isikhathi bachitha isikhathi esiningi kulezo zinqubo ezingenziwa ngokushesha ngezinye izindlela. Ake sibheke izinketho ezahlukahlukene zokushintshana kwemigqa e-Excel.
Isifundo: Ungashintsha kanjani amakhasi ku-Microsoft Word
Shintsha ukuma kwemigqa
Ungashintshana ngemigqa ngezinketho eziningana. Ezinye zazo ziyaqhubeka kancane, kepha i-algorithm yabanye inembile.
Indlela yoku-1: ikhophi inqubo
Indlela enembile yokushintshana kwemigqa ukudala umugqa omusha ongenalutho nokuqukethwe kolunye okungeziwe kuwo, bese ususa umthombo. Kepha, njengoba kamuva sisungula, yize le ndlela izikisela yona, kukude kakhulu futhi akusiyona elula.
- Khetha noma isiphi iseli emgqeni, ngqo ngenhla esizokhulisa omunye umugqa. Qhafaza kahle igundane. Imenyu yokuqukethwe iqala. Khetha into ekuyo "Namathisela ...".
- Ewindini elincane elivulayo, eliphakamisa ukuthi ukhethe ukuthi ufaka ini, hambisa ukushintshela esimweni "Umugqa". Chofoza inkinobho "Kulungile".
- Ngemuva kwalezi zinyathelo, kufakwa umugqa ongenalutho. Manje khetha umugqa wethebula esifuna ukuwuphakamisa. Futhi kulokhu, udinga ukuyikhetha ngokuphelele. Chofoza inkinobho Kopishaetholakala kuthebhu "Ikhaya" ngebhande lamathuluzi ebhlokini Ibhodi yokunamathisela. Esikhundleni salokho, ungathayipha inhlanganisela ye-hotkey I-Ctrl + C.
- Sibeka isikhombisi esitokisini sangakwesokunxele somugqa ongenalutho owengeziwe ngaphambili, bese uchofoza inkinobho Namathiselaetholakala kuthebhu "Ikhaya" eqenjini lezilungiselelo Ibhodi yokunamathisela. Ngenye indlela, ungathayipha inhlanganisela yokhiye I-Ctrl + V.
- Ngemuva kokufakwa komugqa, ukuqedela inqubo oyidingayo ukuze ususe umugqa oyinhloko. Sichofoza kunoma yisiphi iseli lalolu ulayini ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe evela ngemuva kwalokho, khetha "Susa ...".
- Njengasendabeni yokwengeza umugqa, kuvuleka iwindi elincane elikhetha ukukhetha okudingeka lisuswe. Sishintsha switch siye endaweni ephambene nento "Umugqa". Chofoza inkinobho "Kulungile".
Ngemuva kwalezi zinyathelo, into engadingekile izosuswa. Ngakho-ke, ukuguquguquka komugqa kuzokwenziwa.
Indlela 2: inqubo yokufaka
Njengoba ubona, inqubo yokufaka izintambo esikhundleni ngezindawo ngendlela echazwe ngenhla iyinkimbinkimbi impela. Ukuqaliswa kwaso kuzodinga inani elikhulu lesikhathi. Uhafu wenkinga, uma udinga ukushintshela imigqa emibili, kepha uma ufuna ukushintshana ngemigqa eminingi noma ngaphezulu? Kulokhu, indlela elula futhi esheshayo yokufaka izokusiza.
- Qhafaza kwesobunxele kwinombolo yomugqa kuphaneli yokuqondisa mpo. Ngemuva kwalesi senzo, kuqokonyiswa umugqa wonke. Bese uchofoza inkinobho Sika, enziwe wabekwa endaweni iribhoni kuthebhu "Ikhaya" ebhokisini lamathuluzi Ibhodi yokunamathisela. Simelelwa yisithonjana sesikere.
- Ngokuchofoza inkinobho yegundane kwesokudla kwiphaneli yokuhlanganisa, khetha umugqa ngenhla okufanele ubekwe khona umugqa wephepha ngaphambili. Iya kumenyu yokuqukethwe, yeka ukukhetha entweni Namathisela Amaseli.
- Ngemuva kwalezi zenzo, umugqa wokusika uzohlelwa kabusha endaweni ebekiwe.
Njengoba ukwazi ukubona, le ndlela ifaka ukwenza izinto ezimbalwa kuneyedlule, okusho ukuthi ungonga isikhathi ngosizo lwayo.
Indlela 3: hambisa igundane
Kepha futhi kukhona inketho esheshayo yokuhamba kunendlela eyedlule. Kubandakanya ukuhudula kanye nokuphonsa izintambo usebenzisa kuphela igundane nekhibhodi, kepha ngaphandle kokusebenzisa imenyu yokuqukethwe noma amathuluzi kubambo.
- Khetha isigaba esinenkinobho yegundane kwesobunxele kupaneli yokuhlanganisa yomugqa esifuna ukuwuhambisa.
- Sisusa isikhombisi siye emngceleni ongenhla walayini kuze kuthathe ukwakheka komcibisholo, ekugcineni lapho kukhona izinkomba ezine eziqondiswe ezinhlangothini ezihlukile. Sibambe inkinobho ye-Shift kukhibhodi bese simane sidonsele umugqa siye lapho sifuna ukuba khona.
Njengoba ubona, ukunyakaza kulula kakhulu futhi umugqa usendaweni ngqo lapho umsebenzisi efuna ukuyifaka. Ukuze wenze lokhu, udinga nje ukwenza isenzo ngegundane.
Kunezindlela eziningi zokushintshana kwemigqa e-Excel. Yikuphi kokukhethwa okuhlongozwayo ongakusebenzisa kuya ngokuya ngokuthandwa ngumsebenzisi. Eyodwa ilula kakhulu futhi ijwayele kakhulu indlela yakudala yokuhamba, ukwenza inqubo yokukopisha nokususa okwalandela kwemigqa, kanti abanye bakhetha izindlela ezithuthukile kakhulu. Wonke umuntu uzikhethela inketho uqobo, kodwa, ngeqiniso, singasho ukuthi indlela esheshayo yokushintshana kwemigqa inketho yokuhudula ngegundane.
