Umsebenzisi ngamunye osebenza ku-Excel, ngokushesha uzohlangana nesimo lapho okuqukethwe kweseli kungangeni kumingcele yawo. Kulesi simo, kunezindlela eziningana ezivela kule nkinga: ukunciphisa ubukhulu bokuqukethwe; vumelana nesimo esikhona; ukwandisa ububanzi bamaseli; ukwandisa ukuphakama kwawo. Mayelana ne-version yokugcina, okungukuthi ngokukhethwa okuzenzekelayo kokuphakama komugqa, sizokhuluma ngokuqhubekayo.
Isicelo sokukhethwa
I-Auto Fit iyithuluzi elihlanganisiwe le-Excel elisiza ukwandisa amaseli ngokuqukethwe. Masinyane kufanele kuqashelwe ukuthi, naphezu kwegama, lo msebenzi awusebenzi ngokuzenzakalelayo. Ukuze ukwandise isici esithile, udinga ukukhetha uhla bese usebenzisa ithuluzi elicacisiwe kulo.
Ngaphezu kwalokho, kufanele kushiwo ukuthi ukuphakama okuzenzakalelayo kusebenza ku-Excel kuphela kulawo maseli aqoshiwe amagama anikwe amandla ekufomeni. Ukuze unike amandla le ndawo, khetha iseli noma ububanzi eshidi. Chofoza ekukhethweni ngenkinobho yegundane efanele. Kuhlu oluhambelana nomongo, khetha isikhundla "Fometha amaseli ...".
Kukhona ukusebenza kwewindi lesifomethi. Iya kuthebhu "Ukuqondanisa". Ebhokisini lesethingi "Bonisa" hlola ibhokisi eceleni kwepharamitha "Phatha ngamazwi". Ukuze ulondoloze futhi usebenzise izilungiselelo zokushintsha ukucushwa, chofoza inkinobho "Kulungile"elitholakala phansi kule window.
Manje, esikhwameni esikhethiwe seshidi, ukugoqa amagama kufakiwe futhi ungasebenzisa ukukhethwa okuzenzakalelayo kokuphakama komugqa kuwo. Cabanga ukuthi ungakwenza kanjani ngezindlela ezehlukene usebenzisa isibonelo se-Excel 2010. Noma kunjalo, kufanele kuqashelwe ukuthi i-algorithm efana neyodwa yezenzo ingasetshenziselwa izinguqulo zombili kamuva ze-Excel 2007.
Indlela 1: Iphaneli yokuhlela
Indlela yokuqala ihilela ukusebenza ngepaneli yokuhlela eqondile lapho izinamba zegqafula zetafula zitholakala khona.
- Chofoza kunombolo yomugqa ohlangothini lwe-coordinate ofuna ukusebenzisa ukuphakama kwemoto. Ngemuva kwalesi senzo, lonke umugqa uzoqokonyiswa.
- Sifika emngceleni ophansi womugqa emkhakheni wephaneli lokuxhumanisa. I-cursor kufanele ithathe uhlobo lomcibisholo okhomba ezinkomba ezimbili. Chofoza kabili inkinobho yegundane lesokunxele.
- Ngemva kwalezi zenzo, ububanzi obungasashintshi, ukuphakama komugqa kuzokwandisa ngokuzenzekelayo njengoba kudingekile, ukuze wonke umbhalo owo wonke amangqamuzana awo abonakale kushidi.
Indlela 2: Vumela ukufaniswa okuzenzakalelayo kumigqa eminingi
Indlela engenhla ifanele uma udinga ukuvumela ukufaniswa okuzenzakalelayo ngomugqa owodwa noma emibili, kodwa kuthiwani uma kunezinto eziningi ezifanayo? Emva kwakho konke, uma senza ngokuvumelana ne-algorithm echazwe ngokuhluka kokuqala, inqubo kumele kusetshenziswe isikhathi esiningi. Kulesi simo, kukhona indlela yokuphuma.
- Khetha lonke uhla lwemigqa lapho umsebenzi ocacisiwe kufanele uxhumeke kwiphaneli yokuxhumanisa. Ukuze wenze lokhu, ubambe inkinobho yegundane lesokunxele bese uhudula isikhombisi phezu kwesigaba esilandelayo sephaneli yokuxhumanisa.
Uma ububanzi bukhulu kakhulu, bese uchofoza ngakwesobunxele emkhakheni wokuqala, bese ubamba inkinobho Shift kwikhibhodi bese uchofoza kumkhakha wokugcina wephaneli yokuxhumanisa yendawo oyifunayo. Kulesi simo, yonke imigqa yayo izogqanyiswa.
- Beka isikhombisi emngceleni ongaphansi kweminye imikhakha ekhethiwe ephaneli lokuxhumanisa. Kulesi simo, isikhombisi kumele sithathe ifomu efanayo nesikhathi sokugcina. Chofoza kabili inkinobho yegundane lesokunxele.
- Ngemuva kokusebenzisa inqubo engenhla, yonke imigqa yebanga elikhethiwe izokwenyuka ngokuphakama ngobukhulu bemininingwane egcinwe kumaseli awo.
Isifundo: Indlela yokukhetha amaseli ku-Excel
Indlela 3: Inkinobho ku-ribbon yamathuluzi
Ngaphezu kwalokho, ungasebenzisa ithuluzi elikhethekile kutheyipu ukuvula i-autoselection ngokuphakama kweseli.
- Khetha ibanga kushidi ofuna ukusebenzisa i-autoselection. Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza inkinobho "Fometha". Leli thuluzi lifakwe kuzilungiselelo zokuvimba. "Amaseli". Kulolu hlu oluvela eqenjini "Usayizi Weselula" khetha into "Ukukhetha okukhethwa kukho kokuphakama komugqa".
- Ngemuva kwalokho, imigqa yebanga elikhethiwe liyokwandisa ukuphakama kwazo njengoba kunesidingo ukuze amaseli abo abonise konke okuqukethwe kwabo.
Indlela 4: Khetha ukuphakama kwamaseli ahlanganisiwe
Ngesikhathi esifanayo, kufanele kuqashelwe ukuthi umsebenzi we-autoselection awusebenzi ngamaseli ahlanganisiwe. Kodwa kulokhu, futhi, kunesixazululo kule nkinga. Indlela yokuphuma ukusebenzisa i-algorithm yezenzo lapho ukuhlangana kwangempela kweli cell kungenzeki, kodwa kubonakala kuphela. Ngakho-ke, sizokwazi ukusebenzisa ubuchwepheshe bokufanisa ngokuzenzakalelayo.
- Khetha amaseli ofuna ukuhlanganisa. Chofoza ekukhethweni ngenkinobho yegundane efanele. Yiya entweni yemenyu "Fometha amaseli ...".
- Ewindini lokufometha elivula, iya kuthebhu "Ukuqondanisa". Ebhokisini lesethingi "Ukuqondanisa" ensimini yepharamitha "Ngokuvamile" khetha inani "Ukukhetha okuphakathi". Ngemuva kokumisa, chofoza inkinobho "Kulungile".
- Emva kwalezi zenzo, idatha iyatholakala kulo lonke indawo eyabelwe, nakuba empeleni isalondolozwe esitokisini esisele, ngoba ukuhlanganiswa kwezakhi, eqinisweni, akukenzekanga. Ngakho-ke, uma, isibonelo, udinga ukususa umbhalo, khona-ke kungenziwa kuphela kuseli elingakwesokunxele. Bese ukhetha uhla lonke lweshidi lapho umbhalo ubeka khona. Kuzo zonke izindlela ezintathu zangaphambilini ezichazwe ngenhla, sifaka ukuphakama kwe-autosampling.
- Njengoba ubona, emva kwalezi zenzo, ukukhethwa okuzenzakalelayo kokuphakama komugqa kwenziwe ngephutha lokuphikelela lokuhlanganisa izakhi.
Ukuze ungahle ufake ngesandla ukuphakama komugqa ngamunye ngokwehlukana, uchithe isikhathi esiningi kuwo, ikakhulukazi uma itafula likhulu, kungcono ukusebenzisa ithuluzi elihle le-Excel njengokukhetha ngokuzenzakalela. Ngalo, ungaguqula ngokuzenzakalelayo usayizi wemigqa yanoma yiluphi uhla ngokuqukethwe. Inkinga kuphela engase ivele uma usebenza endaweni yetshe lapho amaseli ahlangene atholakala khona, kodwa kulokhu, ungathola futhi indlela yokuphuma kwesimo samanje ngokuhlanganisa izinto ngokukhetha.
