Susa umugqa ku-Microsoft Excel

Ngesikhathi usebenza ne-Excel, kuvame ukudingeka ukuba usebenzise indlela yokususa imigqa. Le nqubo ingaba kokubili eyodwa neqembu, kuye ngemisebenzi. Inentshisekelo enkulu kulokhu kuyisuswe kwesimo. Ake sibheke izinketho ezahlukene kule nqubo.

Inqubo yokukhipha imigqa

Ukususa imigqa kungenziwa ngezindlela ezahlukene ngokuphelele. Ukukhethwa kwesisombululo esithile kuncike emisebenzini umsebenzisi ozibeke yona. Cabangela okukhethwa kukho okuhlukahlukene, kusukela kokulula nokuphelela ngezindlela eziyinkimbinkimbi.

Indlela 1: ukususwa okukodwa ngemenyu yesimo

Indlela elula yokususa imigqa inguqulo eyodwa yale nqubo. Ungayigijima usebenzisa imenyu yesimo.

1. Sichofoza ngokuqondile kunoma iyiphi yamaseli omugqa okususwa. Emenyu yomongo evelayo, khetha into "Susa ...".



2. Iwindi elincane livuleka lapho kudingeka khona ukuthi ucacise lokho okudingekile ukususwa. Hambisa ushintsho endaweni "Umzila".

   

   Ngemuva kwalokho, into ecacisiwe izosuswa.

   Ungachofoza futhi inkinobho yegundane lesokunxele kwinombolo yomugqa epanini lokuhlela eliqondile. Khona-ke kufanele uchofoze ekukhetheni inkinobho yegundane efanele. Emenyu esebenziwe, khetha into "Susa".

   

   Kulesi simo, inqubo yokususa kwenzeka ngokushesha futhi akukho sidingo sokwenza izenzo ezengeziwe efasiteleni lokukhetha into yokucubungula.

Indlela 2: Ukususwa Okukodwa Ukusebenzisa Amateyipu Amathuluzi

Ngaphezu kwalokho, le nqubo ingenziwa ngokusebenzisa amathuluzi kuthebhu, afakwa kuthebhu "Ikhaya".

1. Yenza ukhetho noma yikuphi ohlwini ofuna ukususa. Iya kuthebhu "Ikhaya". Chofoza kusithonjana ngesimo senxantathu encane, esekwesokudla kwesithonjana "Susa" ebhodini lamathuluzi "Amaseli". Uhlu luvela lapho okudingeka ukhethe khona into. "Susa imigqa kusuka kweshidi".



2. Umzila uzosuswa ngokushesha.

Ungaphinda ukhethe umugqa uwonke ngokuchofoza inkinobho yegundane lesokunxele kwinombolo yayo kuphaneli eqondile yezixhumanisi. Ngemuva kwalokho, ekubeni kuthebhu "Ikhaya"chofoza kusithonjana "Susa"efakwe ebhodini lamathuluzi "Amaseli".

Indlela ye-3: Inqwaba yokususa

Ukwenza umugqa ususe imigqa, okokuqala, udinga ukwenza ukukhethwa kwezakhi ezidingekayo.

1. Ukuze ususe imigqa eminingana eseduzane, ungakhetha amaseli aseduze lale migqa esekholomu elifanayo. Ukwenza lokhu, ubambe inkinobho yegundane lesokunxele bese uhudula isikhombisi phezu kwalezi zakhi.

   

   Uma ububanzi bukhulu, khona-ke ungakhetha iseli eliphezulu kakhulu ngokuchofoza kuso ngenkinobho yegundane lesokunxele. Bese ubambe ukhiye Shift bese uchofoza esitokisini esingaphansi kobubanzi ofuna ukususa. Zonke izakhi eziphakathi kwazo zizokhethwa.

   

   Uma kunesidingo sokususa imigqa yesigcawu esivela kude kusuka komunye nomunye, ukuyikhetha, chofoza kwenye yamaseli kuwo ngenkinobho yegundane lesokunxele ngenkathi ngesikhathi esifanayo ubambe isihluthulelo Ctrl. Zonke izinto ezikhethiwe zizophawulwa.



2. Ukuze senze inqubo eqondile yokususa imigqa, sibiza imenyu yesimo sokwemvelo noma siya ematayeni ebhebheni, bese ulandela izincomo ezanikezwa ngenkathi kuchazwa izindlela zokuqala nezesibili zaleli bhukwana.

Ungakhetha futhi izakhi ezifunayo ngokusebenzisa iphaneli yokuxhumanisa eqondile. Kulesi simo, akulona amaseli ngabanye azokwabiwa, kodwa imigqa ngokuphelele.

1. Ukuze ukhethe iqembu eliseduze lemigqa, ubambe inkinobho yegundane lesokunxele bese uhudula isikhombisi eceleni kwephaneli yokuxhumanisa ebonakalayo kusuka entweni yokugqama ephezulu ukuze ususwe phansi.

   

   Ungasebenzisa futhi inketho usebenzisa ukhiye Shift. Chofoza inkinobho yegundane lesobunxele emgqeni wokuqala wokuqala webanga okufanele lisuswe. Bese ubamba ukhiye Shift bese uchofoza inombolo yokugcina yendawo ecacisiwe. Lonke uhla lwemigqa phakathi kwalezi zinombolo luzoqokonyiswa.

   

   Uma imigqa esusiwe isakazeke kulo lonke ishidi futhi ungangena emngceleni komunye nomunye, ngakho-ke kulokhu, udinga uchofoze inkinobho yesinxele segundane kuzo zonke izinombolo zala migqa kuphaneli yokuxhumanisa nekhiye eligcinwe phansi Ctrl.



2. Ukuze ususe imigqa ekhethiwe, chofoza kunoma yikuphi ukukhethwa inkinobho yegundane kwesokudla. Emenyu yomongo, simisa entweni "Susa".

   

   Ukusebenza ukususa zonke izinto ezikhethiwe kuzokwenziwa.

Isifundo: Indlela yokwenza ukukhethwa ku-Excel

Indlela 4: Susa Izinto ezingenalutho

Ngezinye izikhathi itafula lingase libe nemigqa engenalutho, idatha esasuswa ngaphambili. Izakhi ezinjalo zisuswe kangcono eshadini nhlobo. Uma zikhona eduze komunye nomunye, kungenzeka ukuthi usebenzise enye yezindlela ezichazwe ngenhla. Kodwa kuthiwani uma kunezinamba eziningi ezingenalutho futhi zihlakazekile kuyo yonke indawo yetafula elikhulu? Phela, inqubo yokusesha nokususwa kwabo ingathatha isikhathi esiningi. Ukusheshisa isixazululo sale nkinga, ungasebenzisa i-algorithm elandelayo.

1. Iya kuthebhu "Ikhaya". Ngethuluzi lebhebhoni chofoza isithonjana "Thola futhi uqokomise". Itholakala eqenjini Ukuhlela. Kulolu hlu oluvula ukuchofoza entweni "Ukukhetha iqembu lamaseli".



2. Iwindi elincane lokukhetha iqembu lamaseli liqala. Beka inkinobho endaweni "Amaseli angenalutho". Emva kwalokho, chofoza inkinobho "Kulungile".



3. Njengoba ubona, ngemuva kokufaka lesi senzo, zonke izakhi ezingenalutho zikhethiwe. Manje ungasebenzisa noma yiziphi izindlela ezixoxwa ngenhla ukuze ususe. Isibonelo, ungachofoza inkinobho "Susa"okuyinto itholakala kwi Ribbon kuthebhu efanayo "Ikhaya"lapho sisebenza khona manje.

   

   Njengoba ubona, konke okufakiwe kwetafula okungenalutho kususiwe.

Nakani! Uma usebenzisa le ndlela, umugqa kufanele ungabi nalutho. Uma ithebula linezinto ezingenalutho ezilandelanayo eziqukethe idatha, njengezithombe ngezansi, le ndlela ayikwazi ukusetshenziswa. Ukusetshenziswa kwalo kungabandakanya ukushintsha kwezakhi kanye nokwephula isakhiwo setafula.

Isifundo: Ungasusa kanjani imigqa engenalutho ku-Excel

Indlela 5: Ukusebenzisa Uhlobo

Ukuze ususe imigqa ngesimo esithile, ungasebenzisa ukuhlunga. Ngemva kokuhlunga izici ngokuvumelana nesimiso esinqunyiwe, sizokwazi ukuqoqa yonke imigqa eyanelisa isimo ndawonye uma ihlakazekile kuyo yonke ithebula, futhi isuse masinyane.

1. Khetha yonke indawo yetafula okufanele uhlele, noma enye yamaseli ayo. Iya kuthebhu "Ikhaya" bese uchofoza isithonjana "Hlunga futhi uhlunge"esithombeni Ukuhlela. Kuhlu lokukhethwa kukho okuvula, khetha into "Hlunga ngezifiso".

   

   Ungenza futhi ezinye izenzo eziholela ekuvuleni iwindi lokuhlunga ngokwezifiso. Ngemuva kokukhetha noma iyiphi into etafuleni, iya kuthebhu "Idatha". Kukhona eqenjini lezilungiselelo "Hlunga futhi uhlunge" cindezela inkinobho "Hlunga".



2. Iwindi lokuhlunga ngokwezifiso liqala. Qiniseka ukuhlola ibhokisi uma lilahlekile "Idatha yami inezihloko"uma itafula lakho linenhloko. Ensimini "Hlunga nge" udinga ukukhetha igama lekholomu, okuzobe kube ukukhethwa kwamanani wokususwa. Ensimini "Hlunga" udinga ukucacisa ukuthi iyiphi ipharamitha ezosetshenziselwa ukukhethwa:
   • Amanani;
   • Umbala weselula;
   • Umbala wefonti;
   • Isithonjana seselula

   Konke kuxhomeke ezimweni ezithile, kepha ezimweni eziningi umgomo ufanelekile. "Amanani". Nakuba esikhathini esizayo sizoxoxa ngokusebenzisa indawo ehlukile.

   Ensimini "Hlela" udinga ukucacisa ukuthi i-oda lizohlelwa kanjani. Ukukhethwa kwezinqubo kule nkambu kuncike ekufomeni kwedatha yekholomu eveziwe. Isibonelo, ukuze uthole idatha yombhalo, umyalelo uzoba "Kusukela ku-A ukuya ku-Z" noma "Z kuya ku-A"kanye nosuku "Kusukela endala ukuya emisha" noma "Kusukela okusha kuya endala". Eqinisweni, lo myalelo ngokwawo awunandaba, ngoba kunoma yikuphi, izindinganiso zentshisekelo kithi zizohlala ndawonye.
   Ngemva kokusetha kule window, chofoza inkinobho "Kulungile".



3. Yonke idatha yekholomu ekhethiwe izohlungwa ngezinqubo ezicacisiwe. Manje singakwazi ukuhlukanisa izici eziseduze nganoma iyiphi yalezi zindlela ezixoxwa ngazo lapho sicabangela izindlela zangaphambilini, futhi ususe kuzo.

Ngendlela, indlela efanayo ingasetshenziselwa ukuqoqa nokuxoshwa kwemigqa engenalutho.

Qaphela! Kumele kuqashelwe ukuthi uma wenza lolu hlobo lokuhlunga, ngemuva kokususa amaseli angenalutho, isikhundla semigqa izohluka kusukela ekuqaleni. Kwezinye izimo akubalulekile. Kodwa, uma nakanjani udinga ukubuyisa indawo yangempela, ngaphambi kokuthi ukuhlunga kufanele ukhethe ikholomu eyengeziwe bese ubala yonke imigqa kuwo, kuqala ngeyokuqala. Ngemuva kokuthi izakhi ezingafuneki zisuswe, ungaphinda uhlunge ngekholomu lapho lokhu kubalwa kutholakala khona kuncane kunazo zonke kuya kwekhulu. Kulesi simo, itafula lizothola ukuhlelwa kwangempela, ngokwemvelo kuthatha izinto ezisusiwe.

Isifundo: Ukuhlunga idatha ku-Excel

Indlela 6: Sebenzisa Ukuhlunga

Ungasebenzisa futhi ithuluzi elinjengokuhlunga ukususa imigqa equkethe amagugu athile. Inzuzo yale ndlela yukuthi uma uke udinge le migqa futhi, ungawabuyisela njalo.

1. Khetha yonke ithebula noma i-header ene-cursor ecindezelwe phansi inkinobho yegundane lesokunxele. Chofoza inkinobho esivamile kakade kithi. "Hlunga futhi uhlunge"elitholakala kuthebhu "Ikhaya". Kodwa manje, ohlwini oluvula, khetha isikhundla "Hlunga".

   

   Njengendlela esekuqaleni, inkinga ingabuye ixazululwe ngokusebenzisa ithebhu "Idatha". Ukwenza lokhu, ukuhlala kulo, udinga ukuchofoza inkinobho "Hlunga"esitholakala kwibhulogi yamathuluzi "Hlunga futhi uhlunge".



2. Ngemva kokwenza noma yikuphi okwenziwe ngenhla, uphawu lokuhlunga luzovela ngesonxantathu nge-angle engezansi eduze komngcele ongakwesokudla weseli ngayinye yekhanda. Chofoza kulesi simboli kukholomu lapho kutholakala khona inani, lapho sizosusa khona umugqa.



3. Imenyu yokuhlunga ivula. Susa uphawu kumagugu emigqeni esifuna ukususa. Emva kwalokho kufanele ucindezele inkinobho "Kulungile".

Ngakho-ke, imigqa equkethe amanani owasusa kuwo ama-markmarks azofihlwa. Kodwa bangakwazi ukuvuselelwa njalo ngokususa ukuhlunga.

Isifundo: Isebenzisa isihlungi ngokugqamile

Indlela 7: Ukufometha okunemibandela

Ungakwazi ngisho nokubeka ngokucacile imingcele yokukhetha imigqa, uma usebenzisa amathuluzi wokufometha okunemibandela kanye nokuhlunga noma ukuhlunga. Kunezinketho eziningi zokufaka izimo kuleli cala, ngakho sizobuka isibonelo esithile ukuze uqonde indlela yokusebenzisa lesi sici. Sidinga ukususa imigqa etafuleni lapho inani lemali engenayo lingaphansi kwama-ruble angu-11 000.

1. Khetha ikholomu "Inani lemali engenayo"Kuzo sifuna ukusebenzisa ukufometha okunemibandela. Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza kusithonjana "Ukufometha okunemibandela"esitholakala ku-tape ku-block "Izitayela". Emva kwalokho uhlu lwezenzo luvulwa. Khetha isikhundla lapho "Imithetho yokukhethwa kweseli". Imenyu eyodwa ngaphezulu eqalisiwe. Kuyadingeka ukuthi ukhethe ngokuqondile lokho okushiwo umthetho. Kufanele kube khona ukukhetha ngokusekelwe enkingeni yangempela. Esimeni sethu, kudingeka ukhethe isikhundla. "Okungaphansi ...".



2. Ifasitela yokufometha enemibandela iqala. Ensimini engakwesokunxele wabeka inani 11000. Wonke amanani angaphansi kunalokho azofomathwa. Endaweni efanele ungakhetha noma yikuphi ukufometha kombala, nakuba ungaphinde ushiye inani elizenzakalelayo lapho. Ngemuva kokuthi izilungiselelo zenziwe, chofoza inkinobho "Kulungile".



3. Njengoba ubona, onke amangqamuzana okukhona amanani angeniso yemali engaphansi kuka-11,000 ruble, aqoshwe kumbala okhethiwe. Uma sidinga ukugcina i-oda langempela, ngemuva kokususa imigqa, senza izinombolo ezengeziwe ekholomu eceleni kwetafula. Siqala iwindi lesimo sekholomu, esivele sijwayele kithi "Inani lemali engenayo" noma yiziphi izindlela ezixoxwe ngenhla.



4. Iwindi yokuhlela ivula. Njengoba kunjalo, qaphela ngento "Idatha yami inezihloko" kwakukhona uphawu. Ensimini "Hlunga nge" sikhetha ikholomu "Inani lemali engenayo". Ensimini "Hlunga" setha inani Umbala weselula. Esikhathini esilandelayo, khetha umbala, imigqa ofuna ukuyisusa, ngokusho kokufometha okunemibandela. Esimweni sethu kuba pink. Ensimini "Hlela" khetha ukuthi iziqephu ezimakwe zizobekwa kuphi: ngenhla noma ngezansi. Nokho, akunandaba. Kuyafaneleka futhi ukuphawula ukuthi igama "Hlela" kungashintshwa ngakwesokunxele kwensimu ngokwayo. Ngemuva kokuthi zonke izilungiselelo ezingenhla zisebenze, chofoza inkinobho. "Kulungile".



5. Njengoba ungabona, yonke imigqa lapho kukhona khona amangqamuzana akhethiwe ngesimo ihlanganiswe ndawonye. Zizotholakala phezulu noma phansi kwetafula, kuye ngokuthi yiziphi izilinganiso umsebenzisi ezichazwe iwindi lokuhlunga. Manje simane sikhethe le migqa ngendlela esiyithandayo, futhi siyisuse ngokusebenzisa imenyu yesimo noma inkinobho ebhethini.



6. Khona-ke ungakwazi ukuhlunga amanani ngekholomu ngokufaka izinombolo ukuze itafula lethu lithole umyalelo wangaphambilini. Ikholomu engadingekile enezinombolo zingasuswa ngokuyikhetha bese uchofoza inkinobho esazi "Susa" kwi-tape.

Umsebenzi wokuthola isimo unikezwe.

Ngaphezu kwalokho, ungenza ukufana okufanayo nokufometha okunemibandela, kodwa emva kwalokho ungakucula idatha.

1. Ngakho, fometha ukufometha okunemibandela kukholomu. "Inani lemali engenayo" ngokuba isimo esifanayo ngokuphelele. Sika amandla ukuhlunga etafuleni ngenye yalezi zindlela ezivele zivezwe ngenhla.



2. Kanye ekhanda kukhona imifanekiso efanekisela isihlungi, chofoza kuleyo ekholomu "Inani lemali engenayo". Emenyu evula, khetha into "Hlunga ngembala". Ku-block parameter "Hlunga ngombala weseli" khetha inani "Ayikho igcwalisa".



3. Njengoba ubona, ngemuva kwalesi senzo, yonke imigqa egcwele umbala esebenzisa ukufometha okunemibandela yanyamalala. Zifihliwe yisihlungi, kepha uma ususa ukuhlunga, kulokhu, izakhi ezicacisiwe zizophinde zivele kudokhumenti.

Isifundo: Ukufometha okunemibandela ku-Excel

Njengoba ungabona, kunezinamba eziningi kakhulu zokususa imigqa engadingeki. Yikuphi okukhethwa kukho okumele usebenzise kuncike emsebenzini kanye nenombolo yezakhi okufanele zisuswe. Isibonelo, ukukhipha imigqa eyodwa noma emibili kunokwenzeka kakhulu ukukwenza namathuluzi ajwayelekile wokususwa okukodwa. Kodwa ukuze ukhethe imigqa eminingi, amangqamuzana angenalutho noma izakhi ngokuya ngesimo esinikeziwe, kunezinyathelo zokulungiswa kwemisebenzi ezenza umsebenzi kube lula kubasebenzisi futhi ulondoloze isikhathi sabo. Amathuluzi anjalo afaka iwindi lokukhetha iqembu lamaseli, ukukhetha, ukuhlunga, ukufometha okunemibandela, njll.