Uyihambisa kanjani imigqa ku-excel. Goqa imigqa nge-Excel - izindlela ezi-3

Ngezikhathi ezithile, lapho usebenza namaspredishithi, kuyadingeka ukushintsha indawo yemigqa eminingana ehlobene nomunye nomunye. Isibonelo, kube nesimo lapho idatha eshiwo umsebenzisi ifakwe ngephutha kuseli elingalungile, futhi ukulandelana okufanele kwemigqa kudinga ukubuyiselwa. Asikho isidingo sokuphinda ufake lolu lwazi, udinga nje ukushintsha imigqa. Namuhla sizohlaziya izindlela eziningi njengezintathu zokwenza lokhu, futhi sichaze zonke izinzuzo nezingozi zabo.

Uyigoqa Kanjani Imigqa Kuthebula le-Excel

Yiziphi lezi zindlela zomlingo? Kunezindlela ezintathu eziyinhloko zokushintsha imigqa kudokhumenti ye-Excel:

1. Kusetshenziswa ithuluzi elijwayelekile lokukopisha nokunamathisela.
2. Ukusebenzisa igundane ukugoqa imigqa.

Sizohlukanisa indlela yokuqala zibe ezimbili, ngoba ngayinye yazo inezincazelo zayo.

Indlela 1. Ukusebenzisa igundane

Lena enye yezindlela ezinembile kakhulu. Inzuzo yayo eyinhloko ijubane lalesi senzo. Konke okudingeka ube nakho ukuze ugoqe imigqa igundane nekhibhodi. Ake sihlolisise lokho okufanele kwenziwe:

1. Hambisa ikhesa kubha yokuxhumanisa. Lapho senza ukuchofoza kwegundane kwesokunxele emugqeni okufanele siwususe.
2. Ngemva kwalokho, hambisa ikhesa emngceleni ongaphezulu wanoma yimaphi amaseli ayingxenye yalo mugqa. Inothi elibalulekile: ngaphambi kokwenza umsebenzi olandelayo, kufanele uqiniseke ukuthi ikhesa ithathe isimo somcibisholo onezikhombisi ezindaweni ezine ezihlukene.
3. Ngemuva kwalokho, cindezela inkinobho ethi Shift kukhibhodi bese uyibamba phansi. Ngemva kwalokho, sihambisa lo mugqa endaweni efanelekile. Inkinobho yegundane nayo kumele ibanjwe phansi ngalesi sikhathi. Ukhiye we-Shift uyadingeka ukuze kungabikho ukushintshwa kwedatha. Uma uhambisa umugqa ngegundane kuphela, ngaphandle kokusebenzisa ikhibhodi, idatha izovele ishintshwe, futhi kuzodingeka ubuyisele yonke into emuva ukuze ungalahlekelwa ulwazi.

Siyabona ukuthi le ndlela ilula futhi ilula. Into esemqoka ukukhumbula ukuthi udinga ukuhambisa umugqa ngenkathi ubambe ukhiye we-Shift.

Indlela 2. Ngokufaka

Uma kuqhathaniswa nendlela elandelayo, esizoyichaza, le ndlela inenani elikhulu lezinzuzo. Ikuvumela ukuthi uguqule ukuhlelwa kwemigqa ngesikhathi esincane nomzamo. Ake sinikeze isibonelo sangempela sendlela yokusebenza ngale ndlela.

1. Thola inombolo yomugqa esiwudingayo ukuhambisa kubha yokuxhumanisa bese uchofoza kuyo. Ngemva kwalokho, wonke umugqa wakhethwa. Okulandelayo, sibheka ibhulokhi ethi "Ibhodi lokunamathisela" kuribhoni, lapho sibheka khona inkinobho ethi "Sika". I-block ngokwayo itholakala ngokushesha ngakwesokunxele kwe-tape. Ngaphezu kwalokho, inketho enhle ukusebenzisa imenyu yokuqukethwe. Ukuze wenze lokhu, chofoza kwesokudla emgqeni ohambisanayo bese uthola into ethi "Sika". Ungasebenzisa futhi isinqamuleli sekhibhodi u-Ctrl + X.
2. Okulandelayo, udinga ukuchofoza kwesokudla kulayini otholakala ngaphansi kwendawo lapho ufuna ukufaka khona umugqa wokusika. Ngemuva kwalokho, kumenyu evelayo, khetha into ethi "Faka amaseli asikiwe".
3. Ngemva kokuqeda lezi zinyathelo, ulayini uzohamba ngokuzenzakalelayo uye endaweni efanele. Ngesikhathi esifanayo, azikho izinguquko ekulandelaneni kweminye imigqa ezibonwayo.

Le ndlela yenza kube nokwenzeka ukugoqa imigqa ngezinyathelo ezintathu nje. PKodwa-ke, le ndlela ihamba kancane kakhulu kunaleyo eyedlule, njengoba kudingekile ukwethula imenyu yokuqukethwe, ukucinga amathuluzi ahambisanayo kuwo, kanye nakuribhoni. Kodwa uma kuqhathaniswa nendlela elandelayo, lena ishesha kakhulu. Asiqhubekele endleleni ethatha isikhathi esiningi, kodwa kusafanele yaziwe umsebenzisi we-Excel onguchwepheshe.

Indlela 3. Ngokukopisha

Le ndlela ifana kakhulu nedlule, kodwa idinga ukuthi umsebenzisi enze ezinye izinyathelo ezengeziwe. Le ndlela isikisela isidingo sokudala irowu eyengeziwe ngaphandle kwanoma yiluphi ulwazi, bese ukopisha idatha kusuka kumugqa wangempela uye kuyo, bese ukhipha izimpinda. Ake sibone ngokwenza ukuthi lokhu kwenziwa kanjani.

1. Kuyadingeka ukukhetha iseli kumugqa ngaphansi kwalelo lapho sifuna ukufaka khona idatha. Yenza ukuchofoza kwesokudla bese kuvela imenyu yokuqukethwe. Kuyo, khetha into ethi "Faka".
2. Ngemuva kwalokho, kuzovela iwindi elincane lapho udinga ukukhetha into "yomugqa". Siqinisekisa izenzo zethu.
3. Ngemuva kwalokho, kuzovela umugqa owengeziwe, manje esidinga ukukhetha umugqa esidinga ukuwudlulisela kulowo osanda kudalwa.
4. Chofoza kuso bese ukopisha. Ungasebenzisa futhi ithuluzi elihambisanayo kuribhoni noma ucindezele izinkinobho ze-Ctrl + C. Umsebenzisi angakhetha indlela evumelana kakhulu naye.
5. Ngemuva kwalokho, chofoza iseli yokuqala kumugqa osanda kwakhiwa bese uchofoza okuthi “Namathisela” noma ungasebenzisa futhi inhlanganisela yokhiye Ctrl + V.
6. Isinyathelo esilandelayo ukususa izimpinda. Ukuze wenze lokhu, chofoza kwesokudla iseli kusuka kumugqa wokuqala bese ukhetha into ethi "Susa" ohlwini lwemisebenzi evelayo. Ngokufanayo, kuzovela iwindi lapho sidinga ukukhetha into "yomugqa" futhi siqinisekise izenzo zethu.

Ngenxa yalokho, ulayini wethu ususiwe endaweni ethile wayiswa kwenye. Njengoba ubona, le nto idinga inani elikhulu lezenzo ezengeziwe. Ayikulungele kahle ukuhambisa izinombolo ezinkulu zemigqa. Amaphutha nawo angenzeka, ngoba ekusebenzeni kulula kakhulu ukukhohlwa ukususa umugqa omdala.

Lapho ungase udinge ukugoqa imigqa ku-Excel

Kunezimo eziningi lapho ungase udinge ukugoqa imigqa ku-Excel. Isibonelo, ukuhleleka kwempahla kunendima. Noma umsebenzisi ufuna ukubeka phambili enye idatha. Isibonelo, abantu abaningi babhala phansi izinhlelo zabo zansuku zonke ku-Excel futhi bahlele izinto ngale ndlela, bathumele ezokuqala phezulu, nalabo abangalinda phansi. Kungakhathaliseki ukuthi yisiphi isizathu sokufuna ukufunda ukugoqa umugqa kusuka kuwe, manje usuyazi ukuthi ukwenze kanjani. Ukuqeqeshwa okuncane, futhi ungasebenzisa ulwazi lwakho ekusebenzeni. Ngikufisela inhlanhla.