Uma usebenza ngemininingwane ebalulekile ngeshidi ngalunye kwi-Microsoft Excel, umuntu kufanele ahlole njalo amapharamitha. Kodwa, uma kuneziningi zazo, futhi indawo yazo idlulela ngaphesheya kwesikrini, ukuhambisa njalo ibha yokuphenya kuyinto engavamile. Abathuthukisi be-Excel bavele banakekelwa kalula ngabasebenzisi ngokuletha kulolu hlelo ithuba lokulungisa izindawo. Ake sithole indlela yokulungisa indawo eshiweni ku-Microsoft Excel.
Izindawo zokuphina
Sizocubungula indlela yokulungisa izindawo kushidi usebenzisa isibonelo se-Microsoft Excel 2010. Kodwa, ngaphandle kokuphumelela okuncane, i-algorithm ezochazwa ngezansi ingasetshenziswa ku-Excel 2007, 2013 no-2016.
Ukuze uqale ukuqinisa indawo, udinga ukuya kuthebhu ethi "Buka". Bese ukhetha iseli elitholakala ngezansi futhi ngakwesokudla kwendawo eqinisekisiwe. Okusho ukuthi indawo yonke ezoba ngaphezulu nangakwesobunxele bale seli izolungiswa.
Ngemuva kwalokho, chofoza inkinobho ethi "Lungisa indawo", elitholakala ku-ribbon eqenjini lamathuluzi "Iwindi". Kuhlu lokudonsa oluvela, futhi khetha into ethi "Hlela izindawo".
Ngemuva kwalokho, indawo ehlala phezulu nakwesobunxele beselula ekhethiwe izobe isilungisiwe.
Uma sikhetha iseli lokuqala ngakwesobunxele, khona-ke wonke amaseli angaphezu kwawo ayokwenziwa.
Lokhu kulungele ikakhulukazi lapho izihloko zetafula ziqukethe imigqa eminingana, ngoba ukwamukelwa nge-line line fixation kungenakwenzeka.
Ngokufanayo, uma usebenzisa i-pin, ukhetha iseli eliphezulu kakhulu, khona-ke yonke indawo ngakwesobunxele bayo izolungiswa.
Thola izindawo
Ukuze uthole izindawo ezikhonjiwe, akudingeki ukhethe amaseli. Kwanele ukuchofoza inkinobho ethi "Fix izindawo" ezisebhini, bese ukhetha into "Susa izindawo".
Ngemuva kwalokho, zonke izigaba ezinikezwe ezikuleli shidi zizovalwa.
Njengoba ubona, inqubo yokulungiswa nokuphinda ukuphina izinkampani kwi-Microsoft Excel ilula, futhi ungasho ngisho, enembile. Into enzima kakhulu ukuthola ithebhu efanele yohlelo, lapho amathuluzi okuxazulula lezi zinkinga atholakalayo. Kodwa, ngenhla sichazile ngokuningiliziwe inqubo yokulungisa nokulungisa izindawo kule mhleli wesipredishithi. Lesi sici esiwusizo kakhulu, ngoba, ngokusebenzisa umsebenzi wokulungisa indawo, ungathuthukisa kakhulu ukusebenza kwe-Microsoft Excel, futhi ugcine isikhathi sakho.
