Hambisa imigqa ku-Microsoft Excel

Ukusebenza ku-Excel, ngezinye izikhathi ungase ubhekane nesidingo sokutshintsha imigqa ezindaweni. Kunezindlela eziningana ezifakazelwe zalokhu. Abanye babo benza ukunyakaza ngokwezwi ngokuqondile kokuchofoza, kanti abanye badinga isikhathi esiningi sale nqubo. Ngeshwa, akubona bonke abasebenzisi abajwayele konke lokhu okukhethwa ngakho, ngakho-ke ngezinye izikhathi bachitha isikhathi esiningi kulezo zinqubo ezingenziwa ngokushesha kakhulu kwezinye izindlela. Ake sibheke amathuba ahlukahlukene okushiya imigqa ku-Excel.

Isifundo: Indlela yokushintshanisa amakhasi e-Microsoft Word

Shintsha isikhundla semigqa

Shintsha imigqa ngezindlela eziningana. Ezinye zazo zihamba phambili, kepha i-algorithm yabanye inembile.

Indlela 1: Indlela Yokukhokha

Indlela enembile kakhulu yokushintsha imigqa ukudala umugqa omusha ongenalutho ngokufaka okuqukethwe komunye kuwo, kulandelwe ukususa umthombo. Kodwa, njengoba sizobe sisungula kamuva, nakuba le ndlela yokuzikhethela iphakamisa, ayikude kakhulu futhi ayiyona elula.

1. Khetha noma yiliphi iseli emgqeni, ngokuqondile ngenhla esizoyithatha enye umugqa. Yenza ngokuchofoza ngakwesokudla. Imenyu yomongo iqala. Khetha into kuwo "Namathisela ...".



2. Ewindini elincane elivuliwe, elihlinzeka ukukhetha ukuthi yini ngempela ongayifaka, thuthela ushintsho endaweni "Umzila". Chofoza inkinobho "Kulungile".



3. Emva kwalezi zenzo, umugqa ongenalutho ungeziwe. Manje khetha ithebula lombhalo esifisa ukuphakamisa. Futhi ngalesi sikhathi kudinga ukunikezwa ngokuphelele. Sicindezela inkinobho "Kopisha"ithebhu "Ikhaya" kwi-tape ye-instrumental ku-block "Ibhodi lokunamathisela". Kunalokho, ungatheyipha inhlanganisela yamakhi ashisayo Ctrl + C.



4. Beka isikhombisi kuseli elingakwesokunxele emgqeni ongenalutho owenziwe ngaphambilini, bese uchofoza inkinobho Namathiselaithebhu "Ikhaya" kwiqembu lezilungiselelo "Ibhodi lokunamathisela". Ngaphandle kwalokho, kungenzeka ukuthayipha inhlanganisela yokhiye Ctrl + V.



5. Ngemuva kokuthi umugqa ufakwe, kufanele ususe umugqa oyinhloko ukuqedela inqubo. Chofoza kunoma yiliphi iseli lalo umugqa ngenkinobho yegundane kwesokudla. Emenyu yomongo ebonakala emva kwalokhu, khetha into "Susa ...".



6. Njengenkathi yokwengeza umugqa, iwindi elincane livula ukuthi kukukhetha ukhethe ukuthi ufuna ukususa. Hlela kabusha ushintsho endaweni ekuphambene nento "Umzila". Sicindezela inkinobho "Kulungile".

Ngemva kwalezi zinyathelo, into engadingekile izosuswa. Ngakho, ukuvunyelwa kwemigqa kuyokwenziwa.

Indlela 2: inqubo yokufaka

Njengoba ungabona, inqubo yokufaka izintambo ngezindawo ngendlela echazwe ngenhla kunzima kakhulu. Ukuqaliswa kwalo kuzodinga isikhathi esiningi kakhulu. Hlunga inkinga uma udinga ukushintshanisa imigqa emibili, kodwa uma ufuna ukushintshanisa imigqa eyishumi noma ngaphezulu? Kulesi simo, indlela yokufaka elula futhi esheshayo izosindiswa.

1. Chofoza ngakwesobunxele kwinombolo yomugqa kuphaneli yokuxhumanisa eqondile. Ngemuva kwalesi senzo, lonke uchungechunge lugqanyisiwe. Bese uchofoza inkinobho. "Sika"okuyinto yendawo kwi Ribbon kuthebhu "Ikhaya" ebhodini lamathuluzi "Ibhodi lokunamathisela". Imelelwa yi-pictogram ngesimo sekhisi.



2. Ngokuchofoza inkinobho yesokudla yegundane kuphaneli yokuxhumanisa, khetha umugqa ngenhla okufanele sibeke umugqa wokusika weshidi ngaphambilini. Ukuya kumenyu yesimo, hlala ukukhethwa kwento "Faka ama-Cells Cut".



3. Ngemva kwalezi zenzo, umugqa wokusika uzohlelwa kabusha endaweni ecacisiwe.

Njengoba ungabona, le ndlela ihilela ukwenza izenzo ezimbalwa kuneyaphambilini, okusho ukuthi ungagcina isikhathi nayo.

Indlela 3: susa igundane

Kodwa kukhona inketho yokunyakaza ngokushesha kunendlela eyedlule. Kuhilela ukuhudula imigqa besebenzisa kuphela igundane kanye nekhibhodi, kodwa ngaphandle kokusebenzisa imenyu yesimo noma amathuluzi ku-ribbon.

1. Khetha ngokuchofoza inkinobho yegundane lesokunxele umkhakha kwiphaneli yokuxhumanisa yomugqa esifuna ukuthutha.



2. Hambisa isikhombisi kumngcele ongaphezulu walolu umugqa uze uthathe uhlobo lomcibisholo, ekugcineni lapho kunezinhlamvu ezine eziqondiswa eziqondisweni ezahlukene. Sibamba inkinobho ye-Shift ekhibhodi bese nje uhudula umugqa endaweni lapho sifuna khona ukuba itholakale khona.

Njengoba ubona, ukunyakaza kulula futhi umugqa uba lapho umsebenzisi efuna ukuyifaka khona. Ukuze wenze lokhu, udinga nje ukwenza isenzo ngegundane.

Kunezindlela eziningana zokushintshanisa izintambo ku-Excel. Yikuphi okukhethwa kukho okukhethwa kukho okumele kusetshenziswe kuncike ekuthandweni komuntu siqu komsebenzisi. Enye indlela elula futhi ejwayele ngendlela edala yokwenza ukunyakaza, ukwenza inqubo yokukopisha nokususwa okulandelayo kwemigqa, kanti abanye bakhetha izindlela eziningi eziqhubekayo. Ngamunye ukhetha ukukhetha ngokwabo, kodwa-ke, singasho ukuthi indlela esheshayo yokushintsha imigqa kwezinye izindawo kuyindlela yokudonsa negundane.