Ungashintsha kanjani imigqa ku-Excel

Lapho usebenza kumhleli wespredishithi, ngokuvamile kuba kudingekile ukushintsha imigqa kudokhumenti yesipredishithi. Ukwenza le nqubo elula, kunezindlela eziningi ezahlukene. Esihlokweni, sizocubungula ngokuningiliziwe zonke izindlela ezisivumela ukuthi sisebenzise inqubo yokushintsha indawo yemigqa kudokhumenti yespredishithi se-Excel.

Indlela yokuqala: imigqa ehambayo ngokukopisha

Ukwengeza umugqa ongenalutho osizayo, lapho idatha evela kwenye i-elementi izofakwa kamuva, kungenye yezindlela ezilula. Naphezu kokulula kwayo, akuyona esheshayo ukuyisebenzisa. Imiyalelo enemininingwane ibukeka kanje:

1. Senza ukukhetha kweseli elithile emugqeni, ngaphezu kwalokho sihlela ukusebenzisa ukukhushulwa komunye umugqa. Chofoza inkinobho yegundane kwesokudla. Imenyu encane yokuqukethwe ekhethekile ivele esibukweni. Sithola inkinobho ethi "Faka ..." bese uchofoza kuyo LMB.

2. Kuvele iwindi elincane esikrinini, elibizwa ngokuthi “Engeza Amaseli”. Kunezinketho ezimbalwa zokwengeza izakhi. Sibeka uphawu eduze kombhalo othi "umugqa". Chofoza i-LMB engxenyeni ethi "KULUNGILE" ukuze uqinisekise izinguquko ezenziwe.

3. Umugqa ongenalutho uvele olwazini lwethebula. Sikhetha umugqa esihlela ukuwenyusa. Udinga ukuyikhetha ngokuphelele. Sithuthela esigatshaneni "Ekhaya", sithola ibhulokhi yamathuluzi "Ibhodi lokunamathisela" bese uchofoza i-LMB engxenyeni ebizwa ngokuthi "Kopisha". Enye inketho evumela ukuthi usebenzise le nqubo ukusebenzisa inhlanganisela yokhiye okhethekile "Ctrl + C" kukhibhodi.

4. Hambisa isikhombisi endaweni yokuqala yomugqa ongenalutho owengezwe izinyathelo ezimbalwa ezedlule. Sidlulela esigatshaneni esithi "Ekhaya", sithola ibhulokhi yamathuluzi "Ibhodi lokunamathisela" bese uchofoza kwesokunxele into ebizwa ngokuthi "Namathisela". Enye inketho evumela ukuthi usebenzise le nqubo ukusebenzisa inhlanganisela yokhiye okhethekile "Ctrl +V” kukhibhodi.

5. Ulayini odingekayo wengeziwe. Sidinga ukususa umugqa wokuqala. Chofoza inkinobho yegundane engakwesokudla kunoma iyiphi ingxenye yalo mugqa. Imenyu encane yokuqukethwe ekhethekile ivele esibukweni. Sithola inkinobho ethi "Susa ..." bese uchofoza kuyo LMB.

6. Iwindi elincane liphinde lavela esikrinini, manje elinegama elithi "Susa Amaseli". Kunezinketho ezimbalwa zokususa lapha. Sibeka uphawu eduze kombhalo othi "umugqa". Chofoza inkinobho yegundane engakwesokunxele engxenyeni ethi "KULUNGILE" ukuze uqinisekise izinguquko ezenziwe.

7. Into ekhethiwe isusiwe. Senze ukuvunyelwa kwemigqa yedokhumenti yesipredishithi. Ilungile!

Indlela Yesibili: Ukusebenzisa Inqubo Yokunamathisela

Indlela engenhla ibandakanya ukwenza inani elikhulu lezenzo. Ukusetshenziswa kwayo kunconywa kuphela ezimeni lapho kudingekile ukushintshanisa imigqa embalwa. Uma udinga ukwenza inqubo enjalo ngenani elikhulu ledatha, kungcono ukusebenzisa ezinye izindlela. Umyalelo onemininingwane womunye wabo ubukeka kanje:

1. Chofoza inkinobho yegundane kwesokunxele enombolweni ye-serial yomugqa, etholakala kuphaneli yezixhumanisi zohlobo olume mpo. Umugqa wonke ukhethiwe. Sithuthela esigatshaneni "Ekhaya", sithola ibhulokhi yamathuluzi "Ibhodi lokunamathisela" bese uchofoza i-LMB entweni enegama elithi "Sika".

2. Chofoza kwesokudla kubha yokuhlanganisa. Kuvele imenyu encane yokuqukethwe okukhethekile esibukweni, lapho udinga ukukhetha into enegama elithi "Faka amaseli asikiwe" usebenzisa i-LMB.

3. Ngemva kokwenza lokhu kukhohlisa, senze ukuthi umugqa osikiwe wengezwe endaweni ethile. Ilungile!

Indlela Yesithathu: Ukushintshanisa Ngegundane

Isihleli sethebula sikuvumela ukuthi usebenzise imvume yomugqa ngendlela eshesha kakhulu. Le ndlela ihlanganisa ukuhamba kwemigqa usebenzisa igundane lekhompyutha kanye nekhibhodi. Ibha yamathuluzi, imisebenzi yomhleli, nemenyu yokuqukethwe ayisetshenziswa kulesi simo. Imiyalelo enemininingwane ibukeka kanje:

1. Sikhetha inombolo ye-serial yomugqa kuphaneli yokuxhumanisa esihlela ukuyihambisa.

2. Hambisa isikhombisi segundane kuhlaka olungaphezulu lwalo mugqa. Iguqulwa ibe isithonjana ngendlela yemicibisholo emine ekhomba ezindaweni ezahlukene. Bamba phansi okuthi “Shift” bese uhambisa umugqa endaweni lapho sihlele ukuwuhambisa khona.

3. Ilungile! Ngezinyathelo ezimbalwa, sisebenzise ukuhambisa umugqa endaweni esiyifunayo sisebenzisa igundane lekhompyutha kuphela.

Isiphetho neziphetho mayelana nokushintsha indawo yemigqa

Sithole ukuthi umhleli wespredishithi unezindlela eziningi ezishintsha ukuma kwemigqa kudokhumenti. Umsebenzisi ngamunye uzokwazi ukuzikhethela ngokuzimela indlela elula kakhulu yokuhamba. Ukufingqa, singasho ukuthi indlela ehilela ukusetshenziswa kwegundane lekhompyutha iyindlela eshesha kakhulu futhi elula yokuqalisa inqubo yokushintsha indawo yemigqa kudokhumenti yesipredishithi.