Izindlela ezi-7 zokwandisa amaseli ku-Excel

Uma usebenzisa i-spreadsheet se-Microsoft Excel, ngezinye izikhathi kuba nezikhathi lapho inani elifakiwe lingangeni kusayizi weseli ojwayelekile. Ngakho-ke, kuyadingeka ukuthi ukwazi ukwandisa imingcele yeseli ukuze lonke ulwazi olufakiwe luboniswe kahle kudokhumenti. Lesi sihloko sizobheka izindlela eziyisikhombisa zokuphusha imingcele.

Inqubo yesandiso

Kunenqwaba yezindlela zokwandisa imingcele yemikhakha. Ungakwazi ukunweba umkhakha noma ububanzi bamaseli ngokwakho noma ngokusebenzisa izinhlobonhlobo zemisebenzi ezenzakalelayo ekhona kuspredishithi.

Indlela yoku-1: I-Manual Border Shift

Ukunwetshwa kwemingcele mathupha kuyindlela elula futhi elula kakhulu. Lokhu kwenziwa ngokusebenzisana nezikali zokuxhumanisa ezivundlile neziqondile zamakholomu nemigqa. I-Walkthrough ibonakala kanje:

1. Sisethela ikhesa yegundane ohlangothini lwesokudla lomkhakha eruleni yohlobo oluvundlile lwekholomu esifuna ukuyinweba. Uma uhambisa phezu kwalo mngcele, ikhesa izothatha isimo sesiphambano ngemicibisholo emi-2 ebheke ezindaweni ezihlukene. Ngokubamba inkinobho yegundane yesokunxele sihambisa umngcele ohlangothini lwesokudla, okusho ukuthi udlulele kancane kunenkaba yeseli esiyikhulisayo.

2. Izenzo ezifanayo zisetshenziselwa ukwandisa imigqa. Udinga nje ukubeka ikhesa phansi komugqa ofuna ukuwenza ube banzi, bese ngokubamba inkinobho yegundane engakwesokunxele hudula umngcele uye kuleveli engezansi.

Kubalulekile! Uma ubeka isikhombisi hhayi ngakwesokudla, kodwa ngakwesokunxele sekholomu (hhayi phansi, kodwa ohlangothini oluphezulu lomugqa) futhi wenze inqubo yokwandisa, khona-ke imikhakha ngeke ishintshe ngosayizi. Kuzoba khona ukushintsha okuvamile ohlangothini ngokuhlela ubukhulu bezingxenye ezisele zeshidi.

Indlela yesi-2: Nweba Imingcele Yemigqa Eminingi noma Amakholomu

Le ndlela ikuvumela ukuthi unwebe amakholomu amaningi nemigqa ngesikhathi esisodwa. I-Walkthrough ibonakala kanje:

1. Senza ukukhethwa kwemikhakha eminingana ngesikhathi esisodwa eruleni yezixhumanisi eziqondile nezivundlile.

2. Sibeka ikhesa ohlangothini lwesokudla lweseli elingakwesokudla noma ohlangothini olungezansi lomkhakha otholakala ngezansi impela. Manje, ngokubamba phansi inkinobho yegundane kwesokunxele, hudula umcibisholo ohlangothini lwesokudla naphansi ukuze unwebe imingcele yethebula.

3. Ngenxa yalokho, akuwona kuphela ububanzi bokugcina okwandayo, kodwa futhi ubukhulu bayo yonke imikhakha yendawo yokukhetha.

Indlela yesi-3: ukucacisa usayizi weseli oqondile

Ngosizo lokuzifaka ngokwakho idatha yezinombolo ngendlela ekhethekile, ungakwazi ukuhlela usayizi wemingcele yamaseli amadokhumenti kusiprosesa sespredishithi se-Excel. Ngokuzenzakalelayo, uhlelo lunobukhulu obungama-8,43 nobude obungu-12,75. Ungakwazi ukwandisa ububanzi bufinyelele kumayunithi angu-255 futhi ukuphakama kube amayunithi angu-409.  Isifundo sesinyathelo ngesinyathelo sibukeka kanje:

1. Ukuze uhlele izici zobubanzi beseli, khetha ububanzi obufunekayo esikalini esivundlile. Ngemva kokukhetha, chofoza kwesokudla ebangeni. Imenyu yokuqukethwe ivela esikrinini, lapho udinga ukukhetha khona into ethi "Ububanzi bekholomu ...".

2. Iwindi elikhethekile livela esikrinini lapho udinga ukusetha ububanzi bekholomu oyifunayo. Sishayela ngenani lezinombolo sisebenzisa ikhibhodi bese uchofoza "OK".

Indlela efanayo isebenzisa ukuhlela ubude bemigqa. I-Walkthrough ibonakala kanje:

1. Khetha iseli noma ububanzi bamaseli esikalini sokuxhumanisa sohlobo olume mpo. Chofoza kwesokudla kule ndawo. Kumenyu yokuqukethwe evelayo, chofoza into ethi “Ubude bomugqa ...”.

2. Kuvela iwindi elincane esikrinini. Kuleli windi, udinga ukufaka izinkomba ezintsha zobude bemikhakha yebanga elikhethiwe. Ngemva kokwenza zonke izilungiselelo, chofoza "OK".

Amanani ezinombolo afakiwe abona ukwanda kobude nobubanzi bemikhakha.

Abasebenzisi abaningi abanelisekile ngesistimu esetshenziswe kusiprosesa sespredishithi ukuze kuboniswe usayizi wamaseli eshidi ngamayunithi avezwe enanini lezinhlamvu. Umsebenzisi angashintsha iyunithi yokulinganisa iye kwenye nganoma yisiphi isikhathi. I-Walkthrough ibonakala kanje:

1. Sithuthela engxenyeni ethi "Ifayela" bese uchofoza into ethi "Izinketho", etholakala kwesokunxele sefasitela.
2. Iwindi lezinketho livela esibukweni. Udinga ukunaka ohlangothini lwesobunxele, lapha udinga ukuchofoza kuthebhu ethi "Okuthuthukisiwe".
3. Ngezansi sifuna ibhulokhi yezilungiselelo ebizwa ngokuthi "Isikrini".
4. Lapha sithola umbhalo othi "Amayunithi phezu kwerula." Sivula uhlu bese sizikhethela iyunithi yokulinganisa efaneleka kakhulu. Kunamayunithi afana namasentimitha, amamilimitha nama-intshi.
5. Ngemuva kokukhetha, kufanele uchofoze ku-"KULUNGILE" ukuze izinguquko zisebenze.
6. Ilungile! Manje ungenza ukuguqulwa kosayizi womngcele weseli kumayunithi akulungele kakhulu.

Uma kuseli lesipredishithi Microsoft Excel izimpawu (#######) ziyavezwa, okusho ukuthi ikholomu ayinazo izinkomba zobubanzi obanele ukuze zibonise kahle okuqukethwe kweseli. Ukunweba imingcele kusiza ukugwema leli phutha elibi.

Indlela yesi-4: Amathuluzi eRibhoni

Kuribhoni yethuluzi lesipredishithi se-Microsoft Excel, kunenkinobho ekhethekile ekuvumela ukuthi uhlele usayizi wemingcele yeseli. I-Walkthrough ibonakala kanje:

1. Sikhetha iseli noma ububanzi beseli, inani esifuna ukuhlela.

2. Sithuthela engxenyeni ethi "Ekhaya".
3. Chofoza into ethi "Fometha", etholakala kuribhoni yamathuluzi ebhulokhi ebizwa ngokuthi "Amaseli". Uhlu lwezinguquko ezingenzeka luvezwa esibukweni.
4. Sidinga ama-elementi afana nokuthi “Ububanzi bekholomu …” kanye “nobude bomugqa …”. Ngokuchofoza ngokuhlukile kusici ngasinye, singena kuzilungiselelo ezincane windows, osekuxoxwe ngakho emiyalweni engenhla.
5. Emabhokisini okuhlela usayizi wemingcele yeseli, faka izinkomba ezidingekayo zobude nobubanzi bendawo ekhethiwe yemikhakha. Ukwandisa imingcele, kuyadingeka ukuthi izinkomba ezintsha ezethulwe zibe phezulu kunezokuqala. Sichofoza inkinobho ethi "OK".

6. Ilungile! Ukunwetshwa kwemingcele yamaseli kube yimpumelelo.

Indlela yesi-5: Nweba Wonke Amaseli Eshidi noma Incwadi Yokusebenzela

Ngokuvamile, abasebenzisi bespredishithi i-Microsoft Excel badinga ukukhulisa wonke amaseli eshidi lokusebenzela noma idokhumenti yonke iyonke. Ake sithole ukuthi sikwenza kanjani. I-Walkthrough ibonakala kanje:

1. Okokuqala, sikhetha wonke amaseli ekhasini lomsebenzi. Kukhona inhlanganisela yokhiye okhethekile Ctrl + A, okuvumela ukuthi ukhethe ngokushesha wonke amaseli eshidi. Kukhona indlela yesibili yokukhetha okusheshayo, eyenziwa ngokuchofoza isithonjana sikanxantathu esiseduze nesikali sokuxhumanisa esivundlile nesiqondile.

2. Ngemva kokukhetha wonke amaseli ngendlela eyodwa kulezi ezingenhla, udinga uchofoze into eyaziwa yithi ebizwa ngokuthi “Format”, etholakala kubha yamathuluzi yebhulokhi ethi “Amaseli.
3. Setha amanani ezinombolo ezintweni "Ubude bomugqa ..." kanye "nobubanzi bekholomu" ngendlela efanayo naleyo echazwe ngenhla.

Ngokukhohlisa okufanayo, ungakwazi ukwandisa usayizi wemikhakha yawo wonke umbhalo. Kunomehluko omncane kuphela ku-algorithm yezenzo. I-Walkthrough ibonakala kanje:

1. Phansi kwespredishithi se-Microsoft Excel, ngaphezu kwebha yesimo, kunamalebula eshidi ledokhumenti. Kufanele uchofoze kwesokudla kunoma yiziphi izinqamuleli. Imenyu yokuqukethwe ivela, lapho udinga uchofoze entweni "Khetha wonke amashidi".

2. Ukukhethwa kwawo wonke amashidi kube yimpumelelo. Manje kusele ngosizo lwesici esijwayelekile esithi "Fometha" ukuguqula usayizi wamaseli wawo wonke umbhalo. Ukuhlela kwenziwa ngendlela efanayo naleyo echazwe ngenhla.

Indlela yesi-6: I-AutoFit Ubude Beseli Nobubanzi Kokuqukethwe

Le ndlela ivamise ukusetshenziselwa ukulungisa ngokushesha usayizi wamaseli, imvamisa ukunwetshwa. I-Walkthrough ibonakala kanje:

1. Setha ikhesa yegundane esikalini sokuxhumanisa esivundlile siye emngceleni ongakwesokudla wekholomu, inani esihlela ukulishintsha ngokuzenzakalelayo. Ngemuva kokuthi ikhesa ithathe isimo sesiphambano ngemicibisholo eya ezindaweni ezahlukene, chofoza kabili inkinobho yegundane kwesokunxele.

2. Ububanzi bekholomu buzoqondana ngokuzenzakalela nomkhakha oqukethe inani elikhulu kakhulu lezinhlamvu.
3. Lokhu kukhohlisa kungenziwa ngokushesha maqondana nenani elikhulu lamakholomu. Udinga nje ukuwakhetha kuphaneli yokuxhumanisa, bese uchofoza kabili emngceleni ongakwesokudla wanoma yiziphi izakhi ezifakwe endaweni ekhethiwe.

4. Ukukhohlisa okufanayo kungasetshenziswa ukwenza ukukhetha okuzenzakalelayo kobude bomugqa. Udinga nje ukukhetha i-elementi eyodwa noma inombolo kuphaneli yokuxhumanisa eqondile, bese uchofoza kabili emngceleni ongezansi womugqa (noma umngcele ongezansi wanoma iyiphi iseli) efakwe endaweni ekhethiwe.

Indlela yesi-7: Lungisa Okuqukethwe Kube Ububanzi Bekholomu

Indlela elandelayo ecatshangelwayo ayikwazi ukubizwa ngokuthi ukunwetshwa okuphelele kobukhulu bemikhakha, kuhilela ukuncishiswa okuzenzakalelayo kwezinhlamvu zombhalo kumasayizi afanele ubukhulu bamaseli. I-Walkthrough ibonakala kanje:

1. Senza ukukhetha kohlu lwamaseli esifuna ukusebenzisa kuwo amapharamitha wokukhetha okuzenzakalelayo kobubanzi. Chofoza kwesokudla endaweni ekhethiwe. Imenyu yokuqukethwe ivela esibukweni. Chofoza into ethi “Fometha Amaseli…”.

2. Kuvele iwindi lokufometha. Sithuthela engxenyeni ebizwa ngokuthi "Ukuhlanganisa". Kubhulokhi yepharamitha ethi “Display”, qoka ibhokisi eduze kwento ethi “AutoFit Width”. Sithola into ethi "KULUNGILE" ngezansi kwefasitela bese uchofoza kuyo.

3. Ngemuva kokwenza lokhu kukhohlisa okungenhla, imininingwane efakwe kumaseli izokwehla ukuze ingene emkhakheni.

Kubalulekile! Uma kunolwazi oluningi oluthayiphiwe kuseli eliguqulwayo, indlela yokulinganisa ngokuzenzakalelayo izokwenza umbhalo ube mncane kangangokuthi ungafundeki. Ngakho-ke, uma kunombhalo omningi, kungcono ukusebenzisa ezinye izindlela zokushintsha imingcele yamaseli. Ukwengeza, kufanele kuqashelwe ukuthi ukukhetha okuzenzakalelayo kusebenza kuphela ngolwazi lombhalo, ngakho-ke angeke kusetshenziswe ezinkomba zezinombolo.

Isiphetho

Kuspredishithi se-Microsoft Excel, kunenombolo enkulu yezindlela ezihlukene zokuhlela usayizi weseli hhayi kuphela, kodwa ishidi lonke ngisho nedokhumenti, ukuze noma ubani azikhethele inketho elula kakhulu yokwenza inqubo yokwandisa.