Ungasusa kanjani intambo ku-Excel

Ngesikhathi sokusebenza ngohlelo lwe-Excel, imvamisa kufanele uphendukele kwinqubo yokususa imigqa. Le nqubo ingahle ibe yodwa neqembu, kuya ngemisebenzi. Intshisakalo ethile kulolu hlelo isuswa ngesimo. Ake sibheke izinketho ezahlukahlukene zale nqubo.

Inqubo yokususa umugqa

Ukukhishwa kokhiye kungenziwa ngezindlela ezihluke ngokuphelele. Ukukhethwa kwekhambi elithile kuya ngokuthi yimiphi imisebenzi umsebenzisi ayibeka phambi kwabo. Cabanga ngezinketho ezahlukahlukene, ezisukela kulokho okulula nokuphela ngezindlela eziyinkimbinkimbi.

Indlela 1: Ukususwa okukodwa ngemenyu yokuqukethwe

Indlela elula yokususa imigqa iyindlela eyodwa yenqubo yale nqubo. Ungayikhipha usebenzisa imenyu yokuqukethwe.

1. Qhafaza kwesokudla kunoma yiliphi amaseli entambo ofuna ukususa. Kumenyu yomongo evelayo, khetha u- "Delete ...".



2. Kuvulwa iwindi elincane, lapho udinga ukucacisa ukuthi yini okudingeka uyisuse. Sihlela kabusha ukushintshela esimweni esithi "String".

   

   Ngemuva kwalokho, into ebekiwe izosuswa.

   Ungaphinde uchofoze inkinobho yegundane yesobunxele eduze kwenombolo yomugqa kwiphaneli yokuxhumanisa mpo. Okulandelayo, chofoza inkinobho yegundane kwesokudla. Kumenyu esetshenzisiwe, ufuna ukukhetha u- "Delete".

   

   Kulokhu, inqubo yokususa idlula ngokushesha futhi ayidingi ukwenza izinyathelo ezengeziwe ewindini lokukhetha into ecubungula.

Indlela 2: Ukususwa okukodwa ngamathuluzi we-tape

Ngaphezu kwalokho, le nqubo ingenziwa kusetshenziswa amathuluzi we-tape athunyelwa kuthebhu yasekhaya.

1. Sikhiqiza ukwabiwa noma kuphi umugqa ofuna ukuwususa. Iya kuthebhu "Yasekhaya". Chofoza ku-pictogram ngesimo sonxantathu omncane, otholakala ngakwesokudla kwesithonjana se- "Delete" ku-block "yamathuluzi". Uhlu ofuna ukukhetha ngalo "susa imigqa kusuka eshidi".



2. Umugqa uzosuswa ngokushesha.

Ungagqamisa futhi intambo yonke ngokuchofoza inkinobho yegundane kwesobunxele ngenombolo yayo kuphaneli yokuxhumanisa mpo. Emva kwalokho, ukuba sethebhu "Yasekhaya", chofoza isithonjana sokususa, esisendaweni ethi "Amathuluzi we-Cell".

Indlela 3: Ukususwa Kweqembu

Ukwenza ukususwa kweqembu kwemigqa, okokuqala, udinga ukukhetha izinto ezidingekayo.

1. Ukuze ususe imigqa embalwa eseduze, ungakhetha amaseli wedatha aseduze kwezintambo kwikholomu efanayo. Ukuze wenze lokhu, bopha inkinobho yegundane kwesobunxele bese usebenzisa isikhombisi phezu kwalezi zinto.

   

   Uma uhla lukhulu, ungakhetha iseli eliphakeme kakhulu ngokuchofoza kulo ngenkinobho yegundane kwesobunxele. Bese ubopha ukhiye we-Shift bese uqhafaza esitokisini esingezansi sebhendi ukuze isuswe. Zonke izinto eziphakathi kwazo zizoqokonyiswa.

   

   Uma udinga ukususa amabanga aphansi atholakala ebangeni ukusuka komunye nomunye, khona-ke ekwabelweni kwawo, kufanele uchofoze kwelinye lamaseli atholakala kuwo, inkinobho yegundane kwesobunxele nge-CTRL key ngasikhathi sinye. Zonke izinto ezikhethiwe zizomakwa.



2. Ukuqhuba ukususwa okuqondile kwemigqa, shayela imenyu yokuqukethwe noma uye kumathuluzi we-tape, bese ulandela izincomo ezinikezwe ngesikhathi sencazelo yendlela yokuqala neyesibili yale ncwadi yebhukwana.

Khetha izinto ozifunayo nazo zingaba ngephaneli yokuxhumanisa mpo. Kulokhu, hhayi amaseli ahlukile azokwabiwa, kepha imigqa iphelele ngokuphelele.

1. Ukuze uqokomise iqembu eliseduze, chofoza inkinobho yegundane kwesobunxele bese usebenzisa isikhombisi ngaphezulu kwephaneli yokuxhumanisa mpo kusuka entweni ephezulu yomugqa ukuze isuswe phansi.

   

   Ungasebenzisa futhi inketho usebenzisa ukhiye we-Shift. Chofoza ngokuchofoza kwesobunxele kwinombolo yokuqala yohlobo lwebanga elizosuswa. Bese uphina ukhiye we-Shift bese uqhafaza kwinombolo yokugcina yendawo ebekiwe. Lonke uhla lwemigqa elele phakathi kwalezi zinombolo luzoqokonyiswa.

   

   Uma imigqa esuswayo ihlakazekile ngaphesheya kweshidi futhi ingabi umngcele komunye nomunye, khona-ke kulokhu, kufanele uchofoze inkinobho yegundane kwesobunxele kanye nazo zonke izinombolo zale migqa kuPhring Pin.



2. Ukuze ususe imigqa ekhethiwe, chofoza kunoma iyiphi inkinobho yegundane elifanele. Kumenyu yokuqukethwe, umisa entweni ethi "Delete".

   

   Ukukhishwa kokususwa kwazo zonke izinto ezikhethiwe kuzokhiqizwa.

Isifundo: Ungayikhetha kanjani i-Excel

Indlela 4: Ukususa izinto ezingenalutho

Kwesinye isikhathi imigqa engenalutho ingatholakala etafuleni, idatha evela kwayo eyayisuswe phambilini. Izici ezinjalo zisuswa kangcono eshidini. Uma zitholakala eduze komunye nomunye, kungenzeka ukuthi usebenzise enye yezindlela ezachazwa ngenhla. Kepha yini okufanele yenze uma kunezintambo eziningi ezingenalutho futhi zisakazeke kuyo yonke indawo yetafula elikhulu? Ngemuva kwakho konke, inqubo yokusesha kwabo nokususwa kungathatha isikhathi eside. Ukusheshisa isixazululo salo msebenzi, ungasebenzisa i-algorithm elandelayo.

1. Iya kuthebhu "Yasekhaya". Ku-ribbon yeteyipu sichofoza ku- "Thola futhi kwabele" isithonjana. Itholakala eqenjini lokuhlela. Uhlu oluvula, chofoza entweni ethi "Ukwabiwa Kweqembu Lamaseli".



2. Ukukhethwa okuncane kweqembu lamaseli kwethulwa. Sibeka ukushintshela endaweni "engenalutho yamaseli". Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



3. Njengoba sibona, ngemuva kokuthi sisebenzise lesi senzo, zonke izinto ezingenalutho ziyaqokonyiswa. Manje ungasebenzisa ukususa noma yiziphi izindlela okufanele kuxoxwe ngazo ngenhla. Isibonelo, ungachofoza inkinobho ethi "Delete", etholakala ethepheni kuthebhu efanayo "Ikhaya", lapho sisebenza khona manje.

   

   Njengoba ubona, zonke izinto ezingenalutho zetafula zasuswa.

Qaphela! Lapho usebenzisa le ndlela, umugqa kufanele ungabi nalutho ngokuphelele. Uma kunezinto ezingenalutho etafuleni elisezincucu eziqukethe idatha ethile njengasesithombeni esingezansi, le ndlela ayikwazi ukusetshenziswa. Ukusetshenziswa kwayo kungafaka ukushintshwa kwento kanye nokuphazamiseka kwesakhiwo setafula.

Isifundo: Ungayisusa Kanjani Imigqa Engenalutho Ekudingisweni

Indlela 5: Ukusebenzisa ukuhlunga

Ukuze ususe imigqa esimweni esithile, ungafaka ukuhlela. Ukuhlunga izinto ngesikhombisi esisunguliwe, sizokwazi ukuqoqa yonke imigqa ezanelisa isimo ndawonye uma ihlakazekile etafuleni lonke, futhi ibasuse ngokushesha.

1. Sigqamisa yonke indawo yetafula lapho ukuhlunga kufanele kuhlungwe khona, noma elinye lamaseli alo. Iya kuthebhu ethi "Home" bese uqhafaza kwisithonjana esithi "Hlunga nesihlungi", esitholakala eqenjini lokuhlela. Uhlu lwezinketho zokukhetha ezivula, khetha into "yangokwezifiso".

   

   Izenzo ezihlukile nazo zingenziwa, ezizophinde ziholele ekuvulekeni kwewindows lokuhlunga ngokwezifiso. Ngemuva kokunikeza noma iyiphi into yetafula, iya kuthebhu yedatha. Lapho ku-Izilungiselelo Group "Hlunga bese uhlunga" Sichofoza inkinobho ethi "Hlunga".



2. Iwindi lokuhlunga elilungisekayo liqalile. Qiniseka ukuthi uhlola ibhokisi, esimweni sokungabikho kwalo, ezungeze into "Idatha yami iqukethe izihloko", uma itafula lakho linesigqoko. Ku- "Hlunga ngensimu", udinga ukukhetha igama lekholomu lapho kuzokwenzeka khona ukukhethwa kwamanani ukuze kususwe. Ensimini ethi "Hlunga", udinga ukucacisa ukuthi i-paramitha izokhethwa kanjani ngokunemba:
   • Amanani;
   • Umbala weseli;
   • Umbala wefonti;
   • Isithonjana Seseli.

   Konke kuncike ezimweni ezithile, kepha ezimweni eziningi inqubo "yezincazelo" kufanelekile. Yize ngokuzayo sizokhuluma ngokusetshenziswa kwesinye isikhundla.

   Ensimini ethi "Order" udinga ukucacisa ukuthi iyiphi idatha ehlelwe ngayo. Ukukhethwa kwezindlela kule nkambu kuncike kwifomethi yedatha yekholomu ekhethiwe. Isibonelo, imininingwane yombhalo, i-oda lizoba "kusuka ku-A kuye ku-z" noma "kusuka ku-I at to a", kodwa usuku "olusuka ku-Old To The Old". Empeleni, i-oda ngokwalo alinandaba, kusukela kunoma yikuphi, amagugu athakazelisa kithi azobe ahlangene.

   Ngemuva kokuhlelwa kwaleli windi kwenziwa, chofoza inkinobho ethi "KULUNGILE".



3. Yonke imininingwane yekholomu ekhethiwe izohlelwa ngenqubomgomo enikeziwe. Manje singangeza eduze kwezinto zanoma yiziphi zalezo zinketho ezaxoxwa lapho zibheka izindlela ezedlule, futhi zizicime.

Ngendlela, ngendlela efanayo ingasetshenziselwa ukuqoqwa kwamaqembu nokususwa kweMisi emincane yemigqa engenalutho.

QAPHELA! Kuyadingeka ukubheka ukuthi lapho wenza uhlobo olunjalo lokuhlunga, ngemuva kokususa amaseli angenalutho, isikhundla semigqa siyohluka kokuqala. Kwezinye izimo akunandaba. Kepha, uma nakanjani udinga ukubuyisa indawo yokuqala, khona-ke ngaphambi kokuhlunga, kufanele kwakhiwe ikholomu eyengeziwe futhi kubalwe kuyo yonke imigqa eqala ngeyokuqala. Ngemuva kokususwa kwezinto ezingafuneki, ungahle uhlele ikholomu lapho lokhu kubalwa kutholakala khona kusuka kuncane kuya kokuningi. Kulokhu, itafula lizothola i-oda lokuqala, ngokwemvelo lezinto ezikude.

Isifundo: Ukuhlunga idatha ku-Excel

Indlela 6: Sebenzisa ukuhlunga

Ukususa izintambo eziqukethe amanani athile, ungasebenzisa futhi ithuluzi elinjalo njengokuhlunga. Inzuzo yale ndlela ukuthi uma kungazelelwe yile migqa ake uyidinge futhi, ungahlala ubuya kubo.

1. Sigqamisa lonke itafula noma unhlokweni ngesikhombisi ngenkinobho yegundane kwesobunxele. Chofoza inkinobho eselejwayelekile ejwayelene nenkinobho ethi "Hort and Hille Filter", etholakala kuthebhu yasekhaya. Kepha kulokhu isikhundla se- "Filter" sikhethiwe ohlwini lokuvula.

   

   Njengasendleleni edlule, umsebenzi ungaxazululwa ngethebhu yedatha. Ukuze wenze lokhu, ngenkathi kuwo, kufanele uchofoze inkinobho ethi "Filter", etholakala kubha yamathuluzi "Hlunga bese uhlunga" ithuluzi.



2. Ngemuva kokwenza noma iyiphi yezenzo ezingenhla, uphawu lokuhlunga luvela eduze komngcele ofanele weseli ngalinye le-cap, i-angle engela. Sichofoza kulolu bhali kwikholamu lapho inani lapho sizosusa khona imigqa.



3. Imenyu yokuhlunga iyavuleka. Susa imikhaza kulawo magugu emigqeni esifuna ukuyikhipha. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".

Ngakho-ke, imigqa equkethe amanani asuse kuwo amabhokisi okuhlola azofihlwa. Kepha bangaphinde babuyiselwe futhi, basuse ukuhlunga.

Isifundo: Isicelo sokuhlunga ku-Excel

Indlela 7: Ukufomatha okunemibandela

Ngokunembe kakhudlwana, ungabeka amapharamitha okukhetha imigqa uma usebenzisa amathuluzi wokufomatha anemibandela kanye nokuhlunga noma ukuhlunga. Kunezindlela eziningi zokufaka zokufaka kulokhu, ngakho-ke sibheka isibonelo esithile ukuze uqonde indlela yokusebenzisa leli thuba. Sidinga ukususa imigqa etafuleni lapho inani lemali engenayo lingaphansi kwama-ruble ayi-11,000.

1. Sabela i- "Revenue Mant" ikholamu, esifuna ukufaka ngayo ukufomatha okunemibandela. Ukuba sethebhu "Yasekhaya", sichofoza kwisithonjana esithi "Ukufometha Okunemibandela", esitholakala ethepheni kubhulokhi "izitayela". Ngemuva kwalokho, uhlu lwezenzo luyavuleka. Sikhetha isikhundla "Imithetho yokwabiwa kwamaseli". Okulandelayo, enye imenyu yethulwa. Kudinga ukukhetha ngokuqondile umongo womthetho. Kufanele ngabe kukhethwe, kususelwa emsebenzini wangempela. Esimweni sethu somuntu ngamunye, udinga ukukhetha isikhundla esithi "Esincane ...".



2. Iwindi lokufometha elinemibandela liqalwa. Ensimini yesobunxele, setha inani lama-11000. Wonke amanani angaphansi kokuthile azofomethwa. Ensimini efanele, kungenzeka ukuthi ukhethe noma yiluphi umbala wokufometha, yize ungashiya nenani elizenzakalelayo lapho. Ngemuva kokuthi izilungiselelo zenziwe, chofoza inkinobho ethi "Kulungile".



3. Njengoba ubona, wonke amaseli lapho kungaphansi kwama-ruble angaphansi kuka-11,000, apendwe ngombala okhethiwe. Uma sidinga ukusindisa i-oda lokuqala, ngemuva kokususa imigqa, senza ezinye izinombolo kwikholomu eseduze netafula. Sethula iwindi lokuhlunga esivele lisijwayele "inani le-Revenue Revenue" ikholomu nganoma iyiphi indlela okwakuxoxwa ngayo ngenhla.



4. Iwindi lokuhlunga livula. Njengokuhlala kunjalo, sidonsela ukunakekela "Into Yami Yedatha iqukethe" kumi uphawu lokuhlola. In the "Hlunga ngenkambu", khetha i- "Revenue Mant" Colog. In the "Hlunga" field, setha inani elithi "I-Cell Colour". Ensimini elandelayo, khetha umbala, imigqa okudingeka uyisuse, ngokuya ngefomethi enemibandela. Kuthu, lo umbala opinki. Ensimini ethi "Order", sizobekwa lapho izingcezwana ezimakiwe zizobekwa khona: kusuka ngaphezulu noma ngaphansi. Kodwa-ke, akunakubaluleka okuyisisekelo. Kuhle futhi ukungamangali ukuthi igama elithi "i-oda" lingashintshwa ngakwesobunxele sensimu uqobo. Ngemuva kwazo zonke izilungiselelo ezingenhla zenziwa, cindezela inkinobho ethi "Kulungile".



5. Njengoba sibona, yonke imigqa lapho kukhona khona amaseli wesampula ahlukaniswe ndawonye. Bazotholakala phezulu noma phansi kwetafula, kuya ngokuthi amapharamitha womsebenzisi athathwe yiphindi lokuhlunga. Manje umane ukhethe lezi zinzulu ngendlela esiyithandayo, futhi siyasuswa kusetshenziswa imenyu yomongo noma inkinobho yetheyipu.



6. Ungase uhlele amanani kwikholamu yokubala ukuze ithebula lethu lithathe i-oda elifanayo. Ikholomu engadingekile enezinombolo ingasuswa ngokuyikhetha bese ucindezela inkinobho ethi "Delete" ku-Ribbon esijwayele kithi.

Umsebenzi uxazululwa esimweni esibekiwe.

Ngaphezu kwalokho, kungenzeka ukukhiqiza ukusebenza okufanayo nokufomatha okunemibandela, kepha kuphela ngemuva kwalokho ngokuhlunga idatha.

1. Ngakho-ke, sisebenzisa ukufometha okunemibandela kwikholomu "yenani lemali" ngesimo esifanayo ngokuphelele. Faka phakathi ukuhlunga etafuleni kwenye yalezo zindlela esevele ziveziwe ngenhla.



2. Ngemuva kokuthi izithonjana zivele ekhanda, zibonisa isihlungi, chofoza lokho kuzo, ezitholakala kwikholamu lesikweletu. Kumenyu evula, khetha into ethi "Umbala" ". Ebhulokini le- "Cell Flower" Parameters, khetha inani le- "Cha Gcwalisa".



3. Njengoba ubona, ngemuva kwalesi senzo, yonke imigqa eyayigcwele umbala usebenzisa ukufometha okunemibandela inyamalala. Zifihlwe isihlungi, kepha uma ususa ukuhlunga, khona-ke kuleli cala, izinto ezichaziwe zizophinde ziboniswe kudokhumenti.

Isifundo: Ukufomatha okunemibandela ku-Efpelle

Njengoba ubona, kunenani elikhulu kakhulu lezindlela zokukhipha imigqa engadingekile. Yini ngempela inketho incike emsebenzini kanye nenani lezinto ezisusiwe. Isibonelo, ukususa imigqa eyodwa noma emibili, kungenzeka kakhulu ukukwenza ngamathuluzi ajwayelekile wokususa we-solo. Kepha ukuze uhlukanise imigqa eminingi, amaseli noma izinto ezingenalutho esimweni esinikeziwe, kukhona ama-algorithms ngezenzo ezenza lula umsebenzi wabasebenzisi futhi usindise isikhathi sabo. Amathuluzi anjalo afaka iwindi lokukhetha iqembu lamaseli, ukuhlunga, ukuhlunga, ukufomatha okunemibandela, nokunye.