Ngokuvamile, uma usebenzisa amatafula, abasebenzisi kudingeka bashintshe usayizi wamaseli. Ngezinye izikhathi idatha ayifani nezakhi zobungako bamanje futhi kufanele yande. Ngokuvamile kukhona isimo esihlukile, ukuze ulondoloze isikhala somsebenzi eshadini futhi uqiniseke ukuthi ukuhlanganiswa kolwazi kuhlanganiswa, kuyadingeka ukunciphisa usayizi wamaseli. Chaza izenzo ezingasetshenziswa ukushintsha usayizi weseli ku-Excel.
Bheka futhi: Indlela yokwandisa iseli ku-Excel
Izinketho zokushintsha usayizi wezingxenye zeshidi
Ngokushesha kufanele kuqashelwe ukuthi ngenxa yezizathu zemvelo, ukushintsha inani lensimbi eyodwa kuphela ngeke kusebenze. Ngokushintsha ukuphakama kwesici esisodwa sephepha, ngaleyo ndlela sishintsha ukuphakama kwalo lonke umugqa lapho kutholakala khona. Ukushintsha ububanzi bayo - sishintsha ububanzi bekholomu lapho itholakala khona. Ngokubanzi, i-Excel ayinayo lezinketho eziningi zokususa iseli. Lokhu kungenziwa ngokuhudula ngemingcele, noma ngokubeka usayizi othize ngamagama wenombolo usebenzisa ifomu elikhethekile. Masifunde ngalunye lwalezi zindlela ngokuningiliziwe.
Indlela yoku-1: Hudula futhi wehlisa imingcele
Ukushintsha usayizi weseli ngokuhudula imingcele yindlela elula futhi enembile kakhulu.
- Ukuze ukwandise noma unciphise ukuphakama kweseli, thuthela isikhombisi kumngcele ophansi womkhakha ephaneli elungelelanisa lomugqa lapho likhona khona. I-cursor kumele iguqulwe ibe umcibisholo okhomba kuzo zombili izinkomba. Cisha inkinobho yegundane lesokunxele bese uhudulela isikhombisi phezulu (uma ufuna ukuyinciphisa phansi) noma phansi (uma ufuna ukuyandisa).
- Ngemuva kokuphakama kweseli kufinyelele ezingeni elimukelekile, khulula inkinobho yegundane.
Ukushintsha ububanzi bezinto zeshidi ngokuhudula imingcele kwenzeka ngesimiso esifanayo.
- Sibeka isikhombisi emngceleni ongakwesokudla womkhakha wekholomu kuphaneli yokuxhumanisa enezingqimba, lapho itholakala khona. Ngemva kokuguqula isikhombisi ibe ngumcibisholo we-bidirectional, sibopha inkinobho yesinxele yesinxele bese siyidonsela ngakwesokudla (uma imingcele idinga ukuhanjiswa eceleni) noma ngakwesobunxele (uma imingcele kufanele ifakwe kancane).
- Lapho sifinyelela usayizi owamukelekayo wento, esiyishintsha usayizi, khulula inkinobho yegundane.
Uma ufuna ukushintsha izinto eziningana ngesikhatsi esifanayo, khona-ke kulesi simo kufanele kubonakale kuqala imikhakha ehambelanayo kwipaneli yokuqondisa eqondile noma ehambisana nendawo, kuye ngokuthi yini okudingeka ishintshwe kwimeko ethile: ububanzi noma ukuphakama.
- Inqubo yokukhethwa kuzo zombili imigqa namakholomu cishe iyafana. Uma udinga ukwandisa amaseli ahlelwe ngokulandelana, bese uchofoza inkinobho yegundane lesokunxele emkhakheni kwiplanethi yokuxhumanisa ehambelana nendawo yokuqala. Emva kwalokhu, ngendlela efanayo, chofoza kumkhakha wokugcina, kodwa manje sekuvele ukhiye okwamanje Shift. Ngakho-ke, yonke imigqa noma amakholomu atholakala phakathi kwalezi zinhlaka izobe eqokonyiswe.
Uma udinga ukukhetha amangqamuzana angekho eduze komunye nomunye, ngakho-ke kulokhu, ukulandelana kwezenzo kuhlukile. Chofoza ngakwesobunxele kumunye wemikhakha yekholomu noma umugqa okufanele ukhethwe. Bese, ubambe isihluthulelo Ctrl, sichofoza kuzo zonke ezinye izakhi ezisephaneli ethile yezixhumanisi ezihambelana nezinto ezizokhethwa. Wonke amakholomu noma imigqa lapho lawa maseli atholakala khona.
- Khona-ke, kufanele sithuthe imingcele ukuze sishintshe kabusha amaseli ayifunayo. Khetha umngcele ofanele kule iphaneli yokuxhumanisa futhi, ulinde umcibisholo ohlosiwe kabili, ubambe inkinobho yegundane lesokunxele. Khona-ke sithutha umngcele kwiphaneli yokuxhumanisa ngokuhambisana nalokho okudingeka kwenziwe (ukwandisa (mncane) ububanzi noma ukuphakama kwezakhi zamashidi) njengoba nje kuchazwe ngokuhlukahluka kokususwa okukodwa.
- Ngemuva kokuthi usayizi ufinyelele inani elifunayo, khulula i-mouse. Njengoba ubona, ukubaluleka kokungena kuphela umugqa noma ikholomu, nemingcele okwenziwa ngayo ukukhwabanisa, kodwa nazo zonke izinto ezikhethiwe ngaphambilini zishintshile.
Indlela 2: shintsha inani ngendima yamanani
Manje ake sithole ukuthi ungashintsha kanjani usayizi wezinto ezenziwe ngamashidi ngokukucacisa ngenkulumo ethile yamanani ensimini eyenzelwe ngokuqondile le njongo.
Ku-Excel, ngokuzenzakalelayo, ubukhulu bezakhi zeshidi bucaciswe kumayunithi akhethekile. Enye yeyunithi enjalo ilinganisa uphawu olulodwa. Ngokuzenzakalelayo, ububanzi beseli buyi-8.43. Okungukuthi, engxenyeni ebonakalayo yesici esisodwa sephepha, uma singanwetshwa, ungangena izinhlamvu ezingaphezu kuka-8. Ububanzi obuphezulu buyi-255. Inombolo enkulu yabalingiswa esitokisini ngeke isebenze. Ububanzi obuncane buyi-zero. Into enobukhulu obufihliwe.
Ukuphakama komugqa okuzenzakalelayo kunamaphuzu angu-15. Ubukhulu bayo buhluka ukusuka kumaphoyinti angu-0 kuya ku-409.
- Ukuze ushintshe ukuphakama kwesici seshidi, ukhethe. Bese, ehlezi kuthebhu "Ikhaya"chofoza kusithonjana "Fometha"okuyinto posted on the tape eqenjini "Amaseli". Kusuka ohlwini lokudonsa, khetha ukhetho "Ukuphakama komugqa".
- Iwindi elincane livula ngensimu. "Ukuphakama komugqa". Yilapho sidinga ukubeka inani elifunayo kumaphoyinti. Yenza isenzo bese uchofoza inkinobho "Kulungile".
- Ngemuva kwalokho, ukuphakama komugqa lapho ingxenye ekhethiwe yeshidi itholakala kuyoguqulwa ibe yinani elicacisiwe kumaphoyinti.
Ngendlela efanayo, ungashintsha ububanzi bekholomu.
- Khetha isici seshidi lapho ungashintsha khona ububanzi. Ukuhlala kuthebhu "Ikhaya" chofoza inkinobho "Fometha". Emenyu evula, khetha inketho "Ububanzi bekholomu ...".
- Ivula cishe efana nefasitela esiyibonile kwimeko yangaphambilini. Nalapha futhi ensimini udinga ukubeka inani kumayunithi akhethekile, kodwa kuphela lesi sikhathi sizokhombisa ububanzi bekholomu. Ngemva kokwenza lezi zenzo, chofoza inkinobho "Kulungile".
- Ngemva kokwenza umsebenzi ocacisiwe, ububanzi bekholomu, ngakho-ke iseli esiyidingayo, lizoguqulwa.
Kukhona enye inketho yokushintsha usayizi wezakhi zamashidi ngokucacisa inani elicacisiwe ngenkulumo yezinombolo.
- Ukuze wenze lokhu, khetha ikholomu noma umugqa lapho iseli efiseleka khona, kuye ngokuthi yini ofuna ukuyishintsha: ububanzi nokuphakama. Ukukhethwa kwenziwa ngokusebenzisa iphaneli yokuxhumanisa usebenzisa izinketho esizicabangayo Indlela 1. Bese uchofoza ekukhethweni nge inkinobho yegundane kwesokudla. Imenyu yenkathi icushiwe, lapho udinga ukukhetha into "Ukuphakama komugqa ..." noma "Ububanzi bekholomu ...".
- Iwindi yesayizi ivuleka, okuxoxwa ngenhla. Kubalulekile ukungena ukuphakama okufunayo noma ububanzi beseli ngendlela efanayo njengoba kuchazwe ekuqaleni.
Kodwa-ke, abanye abasebenzisi namanje abanelisekile ngesistimu eyamukelwa ku-Excel ngokucacisa ubukhulu bezinto ezenziwe ngamashidi kumaphoyinti abhalwe ngenani labalingiswa. Kulaba abasebenzisi, kungenzeka ukushintshela kwesinye isilinganiso sezinga.
- Iya kuthebhu "Ifayela" bese ukhetha into "Izinketho" kwimenyu yokuma kwesokunxele.
- Iwindi yemingcele iqalisiwe. Engxenyeni yalo engakwesokunxele imenyu. Yiya esigabeni "Okuthuthukisiwe". Ngakwesokudla kwefasitela kunezilungiselelo ezihlukahlukene. Skrolela phansi ibha yokuphenya bese ubheka ibhulogi lamathuluzi. "Isikrini". Kulesi sikhungo sitholakala ensimini "Izinyathelo emgqeni". Sichofoza kuso futhi kusukela ohlwini lokudonsela phansi sikhetha i-unit of measurement efanele. Kukhona okukhethwa kukho okulandelayo:
- Amentimitha;
- Izigidi;
- Amasentimitha;
- Izinyathelo ngokuzenzakalelayo.
Ngemva kokukhetha, ngoba izinguquko zisebenza, chofoza inkinobho "Kulungile" phansi kwefasitela.
Manje ungalungisa ushintsho ngobukhulu bamaseli ngosizo lwezinketho ezibalwe ngenhla, usebenzisa i-unit ekhethiwe yokulinganisa.
Indlela 3: Ukuvuselela okuzenzekelayo
Kodwa-ke, ubona, akuzona ngaso sonke isikhathi esivumelana ngaso sonke isikhathi ukuba uhlale ushintsha kabusha amaseli, uzilungiselele kokuqukethwe okuqondile. Ngenhlanhla, i-Excel inikeza ikhono lokusetha ngokuzenzekelayo izinto zezhidi ngokuya ngobukhulu bemininingwane equkethe.
- Khetha iseli noma iqembu, idatha engafaneleki kwisici sephepha eliqukethe. Kuthebhu "Ikhaya" chofoza inkinobho ejwayelekile "Fometha". Emenyu evulekayo, khetha inketho okufanele isetshenziswe entweni ethize: "Ukukhetha okukhethwa kukho kokuphakama komugqa" noma "Ukukhetha okuzenzakalelayo kokuphakama kwekholomu".
- Ngemuva kokuthi i-parameter ecacisiwe isetshenziswe, ubukhulu beseli buzoshintsha ngokuvumelana nokuqukethwe kwabo, kusiqondiso esikhethiwe.
Isifundo: Ukukhetha okuzenzakalelayo kokuphakama komugqa ku-Excel
Njengoba ungabona, ungashintsha usayizi wamaseli ngezindlela eziningana. Zingahlukaniswa ngamaqembu amakhulu amabili: ukuhudula imingcele nokufaka usayizi wamanani ensimini ekhethekile. Ngaphezu kwalokho, ungasetha ukukhethwa okuzenzakalelayo kokuphakama noma ububanzi bemigqa namakholomu.
