Uma usebenza ku-Excel, ngokuvamile kuvame ukubhekana nesimo lapho ingxenye enkulu yamakhasi esetshenziselwa ukubalwa futhi ayithwali umthwalo wolwazi lomsebenzisi. Idatha enjalo ivele kuphela futhi ihlukanisa ukunakwa. Ngaphezu kwalokho, uma umsebenzisi ephutha ngephutha isakhiwo sabo, lokhu kungabangela ukwephulwa komjikelezo wokubala kulo mbhalo. Ngakho-ke, kungcono ukufihla imigqa enjalo noma amaseli ngabanye. Ngaphezu kwalokho, ungakwazi ukufihla idatha engeke idingeke okwesikhashana ukuze ingaphazamisi. Ake sithole ukuthi lokhu kungenziwa kanjani.
Inqubo yokucubungula
Ungakwazi ukufihla amaseli ku-Excel ngezindlela eziningana ezahlukene ngokuphelele. Ake sihlale ngokuningiliziwe kulowo nalowo, ukuze umsebenzisi ngokwakhe aqonde ukuthi yikuphi okuyoba lula ngaye ukuthi asebenzise inketho ethize.
Indlela 1: Ukuqoqa
Enye yezindlela ezithandwa kakhulu ukufihla izinto ukuzihlanganisa.
- Khetha imigqa yeshidi, okumele iqoqwe, bese ifihla. Akudingekile ukukhetha wonke umugqa, kodwa ungakwazi ukubeka uphawu olulodwa kuphela emigqeni eqoqiwe. Okulandelayo, iya kuthebhu "Idatha". Ku-block "Isakhiwo"elitholakala ebhodini lamathuluzi, chofoza inkinobho "Iqembu".
- Iwindi elincane livuleka, linikeza ukukhetha ukuthi yini okudingeka iqoqwe ngqo: imigqa noma amakholomu. Njengoba sidinga ukuhlela kahle imigqa, asenzi izinguquko ezilungiselelweni, ngoba ukushintsha okuzenzakalelayo kusethwe esimweni esiyidingayo. Sicindezela inkinobho "Kulungile".
- Ngemuva kwalokho iqembu lakhiwa. Ukuze ufihle imininingwane ekhona kuyo, mane uchofoze kusithonjana ngesimo sophawu "susa". Itholakala ngakwesokunxele kwephaneli yokuxhumanisa eqondile.
- Njengoba ungabona, imigqa ifihliwe. Ukuze ubonise futhi, udinga ukuchofoza uphawu plus.
Isifundo: Ungenza kanjani amaqembu ku-Excel
Indlela 2: Ukweqa ngokweqile
Indlela enembile kakhulu yokufihla okuqukethwe kwamaseli mhlawumbe idonsela imingcele yomugqa.
- Beka isikhombisi kuphaneli yokuxhumanisa eqondile, lapho izinamba zomugqa zimakwe, emngceleni ongaphansi kwalowo mgca, okuqukethwe okufunayo esikufihle khona. Kulesi simo, isikhombisi kumele siguquke esithombeni esifane nesiphambano esine-pointer yesibili, eqondiswa phezulu. Bese sibamba inkinobho yesinxele segundane bese uhudulela i-pointer phezulu kuze kube semingcele engezansi neyephezulu yomugqa oseduze.
- Intambo izofihlwa.
Indlela 3: iqembu lifihla amaseli ngokuhudula
Uma udinga ukufihla izakhi eziningana ngesikhathi esisodwa ngale ndlela, kufanele uzikhethe kuqala.
- Gwema inkinobho yegundane lesokunxele bese ukhetha iphaneli eliqondile lama-coordinates iqembu lalezo zindlela esizozifihla.
Uma ububanzi bukhulu, bese ukhetha izakhi ngendlela elandelayo: chofoza ngakwesobunxele kwinombolo yomugqa wokuqala we-panel in iphaneli yokuxhumanisa, bese ubamba inkinobho Shift bese uchofoza inombolo yokugcina yebanga lokukhomba.
Ungakhetha ngisho nemigqa embalwa ehlukene. Ukwenza lokhu, ngamunye wabo kufanele uchofozwe inkinobho yegundane lesokunxele ngenkathi ephethe inkinobho Ctrl.
- Siba isikhombisi emngceleni ongaphansi kwanoma iyiphi yale migqa bese siyidonsela kuze kube sekupheleni kwemingcele.
- Lokhu ngeke kufihla umugqa osebenza kuwo kuphela, kodwa yonke imigqa yebanga elikhethiwe.
Indlela 4: imenyu yokuqukethwe
Lezi zindlela ezimbili zangaphambilini, yiqiniso, ziyinkimbinkimbi kakhulu futhi zilula ukuyisebenzisa, kodwa azikwazi ukunikeza iseli eliphelele elifihlekile. Kukhona isikhala esincane ngaso sonke isikhathi, ukubamba ukuthi ungakwandisa iseli emuva. Ungakwazi ukufihla ngokuphelele ucingo usebenzisa imenyu yesimo.
- Khetha imigqa ngezindlela ezintathu, okukhulunywe ngazo ngenhla:
- kuphela ngegundane;
- usebenzisa ukhiye Shift;
- usebenzisa ukhiye Ctrl.
- Chofoza kusikali esilinganiselwe sezingqungquthela ngenkinobho yegundane kwesokudla. Imenyu yomongo ivela. Maka umcimbi "Fihla".
- Imigqa ekhethiwe izofihlwa ngenxa yezenzo ezingenhla.
Indlela 5: Amathuluzi weTape
Ungase futhi ufihle imigqa ngokusebenzisa inkinobho ebhokisini yethuluzi.
- Khetha amaseli asemigqeni edinga ukufihlwa. Ngokungafani nendlela eyedlule, akudingekile ukukhetha wonke umugqa. Iya kuthebhu "Ikhaya". Chofoza inkinobho kubha yamathuluzi. "Fometha"esisebhange "Amaseli". Kuloluhlu olulandelayo, hlela isikhombisi kunento eyodwa yeqembu. "Ukubonakala" - "Fihla noma Bonisa". Emenyu eyengeziwe, khetha into edingekayo ukuze ufeze umgomo - "Fihla imigqa".
- Emva kwalokho, yonke imigqa equkethe amaseli akhethiwe esigabeni sokuqala izofihlwa.
Indlela 6: Ukuhlunga
Ukuze ufihle eshadini okuqukethwe okungadingeki esikhathini esizayo esiseduze, ukuze kungaphazamisi, ungafaka isicelo sokuhlunga.
- Khetha ithebula lonke noma elinye lamaseli kusihloko salo. Kuthebhu "Ikhaya" chofoza kusithonjana "Hlunga futhi uhlunge"esitholakala ematheni amathuluzi Ukuhlela. Uhlu lwezenzo luvulwa lapho ukhetha into "Hlunga".
Ungenza futhi ngenye indlela. Ngemva kokukhetha ithebula noma ikhanda, iya kuthebhu. "Idatha". Ukuchofoza ku-inkinobho "Hlunga". Itholakala ku-tape ku-block. "Hlunga futhi uhlunge".
- Noma yiziphi izindlela ezimbili eziphakanyisiwe ozisebenzisayo, isithonjana sokuhlunga sizovela ezihlokweni zetafula. Kuyinkimbinkimbi encane emnyama, i-angled downwards. Sichofoza kulesi sithonjana kukholomu equkethe isibonakaliso esizoyihlunga ngayo idatha.
- Imenyu yokuhlunga ivula. Singazihloli izindinganiso eziqukethwe emigqeni ehloselwe ukufihla. Bese uchofoza inkinobho "Kulungile".
- Ngemuva kwalesi senzo, yonke imigqa lapho kunezindinganiso esazisusile kuzo izifihlakele kuyofihlwa ngosizo lwesihlungi.
Isifundo: Hlunga bese uhlunga idatha ku-Excel
Indlela 7: Ukufihla Amaseli
Manje ake sixoxe ngokuthi singafihla kanjani amaseli ngabanye. Ngokwemvelo, angeke asuswe ngokuphelele njengemigqa noma amakholomu, ngoba lokhu kuzobhubhisa isakhiwo sedokhumenti, kodwa nokho kukhona indlela, uma kungenjalo ukufihla ngokuphelele izakhi ngokwabo, bese ufihla okuqukethwe kwabo.
- Khetha amaseli owodwa noma amaningi adinga ukufihlwa. Chofoza kusiqephu esikhethiwe nge inkinobho yegundane kwesokudla. Imenyu yomongo ivulwa. Khetha into kuwo "Ifomethi yeselula ...".
- Ifasitela lokufometha iqala. Sidinga ukuya kuthebhu yakhe "Inombolo". Okuqhubekayo ku-parameter block "Amafomu Amanani" khetha isikhundla "Zonke amafomethi". Ngakwesokudla kwefasitela ensimini "Thayipha" sishayela kule nkulumo elandelayo:
;;;Sicindezela inkinobho "Kulungile" ukulondoloza izilungiselelo zangenisiwe.
- Njengoba ubona, ngemuva kwalokhu, yonke idatha kumaseli akhethiwe akhekile. Kodwa zanyamalala kuphela ngenxa yamehlo, kanti empeleni ziyaqhubeka zikhona. Ukuze uqinisekise lokhu, bheka nje ibha yefomula lapho iboniswa khona. Uma uphinde udinga ukunika amandla ukuboniswa kwedatha kumaseli, kuzodingeka uguqule ifomethi kubo kulowo owawudlule ngefasitela lokufometha.
Njengoba ubona, kunezindlela eziningi ezahlukene ongafihla imigqa ku-Excel. Futhi iningi lazo lisebenzisa ubuchwepheshe obuhlukile ngokuphelele: ukuhlunga, ukuhlanganisa, ukuguqula imingcele yamaseli. Ngakho-ke, umsebenzisi unezinhlobo eziningi kakhulu zamathuluzi wokuxazulula inkinga. Angasebenzisa inketho ayibheka ngokufanelekile esimweni esithile, futhi elula futhi elula kuye. Ngaphezu kwalokho, ngosizo lokufometha kungenzeka ukufihla okuqukethwe kwamaseli ngabanye.
