Lapho usebenza e-Excel, kaningi ungahlangabezana nesimo lapho ingxenye enkulu yohlu lwamashidi isetshenziselwa ukubala futhi ingathwali imithwalo yolwazi kumsebenzisi. Imininingwane enjalo ithatha kuphela isikhala futhi iphazamisa ukunakwa. Ngaphezu kwalokho, uma umsebenzisi ephula ngengozi isakhiwo sabo, lokhu kungaholela ekuphazamisweni kwawo wonke umjikelezo wokubala kudokhumenti. Ngakho-ke, kungcono ukufihla imigqa enjalo noma amaseli ngamanye. Ngaphezu kwalokho, ungafihla idatha edingekayo okwesikhashana nje ukuze ingaphazamisi. Ake sibheke ukuthi lokhu kungenziwa kanjani.
Fihla inqubo
Kunezindlela eziningana ezihluke ngokuphelele zokufihla amaseli ku-Excel. Masihlale kulowo nalowo kubo, ukuze umsebenzisi uqobo aqonde ukuthi yisiphi isimo lapho kuzoba lula kuye ukuthi asebenzise inketho ethile.
Indlela yoku-1: Ukuhlela amaqembu
Enye yezindlela ezaziwa kakhulu zokufihla izinto ukuhlela izinto.
- Khetha imigqa yeshidi ofuna ukulihlela, bese ucasha. Akudingekile ukukhetha wonke umugqa, kepha ungamaka iseli elilodwa emigqeni eqoqiwe. Okulandelayo, iya kuthebhu "Idatha". Ebhlokini "Isakhiwo", ebekwe iribhoni yethuluzi, chofoza inkinobho "Iqembu".
- Iwindows elincane liyavula elikukhuthaza ukuba ukhethe ukuthi yini okudingeka ihlelwe ngamaqoqo: imigqa noma amakholomu. Njengoba sidinga ukuhlanganisa imigqa ngqo, asenzi izinguquko kuzilungiselelo, ngoba inkinobho ezenzakalelayo isethwe esikhundleni esikudingayo. Chofoza inkinobho "Kulungile".
- Ngemuva kwalokhu, kwakheka iqembu. Ukufihla idatha etholakala kuyo, vele uchofoze isithonjana ngesimo sesibonakaliso Susa. Itholakala kwesobunxele sepaneli yokuqondisa mpo.
- Njengoba ubona, imigqa ifihliwe. Ukuze ubakhombise futhi, chofoza uphawu kanye.
Isifundo: Ungawenza kanjani amaqembu e-Excel
Indlela 2: ukudonsela amaseli
Indlela enembile kunazo zonke yokufihla okuqukethwe amaseli mhlawumbe idonsa imingcele yemigqa.
- Setha isikhombisi kuphaneli yokuqondisa mpo, lapho kumakwe khona izinombolo zomugqa, emngceleni ongezansi womugqa okufuna ukukufihla okuqukethwe. Kulokhu, isikhombisi kufanele siguqulwe sibe yisithonjana esesimweni sesiphambano esine-pointer ephindwe kabili, eqondiswe phezulu naphansi. Ngemuva kwalokho bamba phansi inkinobho yegundane kwesobunxele bese udonsela pointer phezulu kuze kube yilapho imingcele engezansi nangaphezulu yomugqa ivaliwe.
- Umugqa uzofihlwa.
Indlela 3: amaseli eqembu ngokuhudula nangokuphonsa amaseli
Uma udinga ukufihla izinto eziningana ngasikhathi sinye usebenzisa le ndlela, kuzofanela ukhethe kuqala.
- Sibamba phansi inkinobho yegundane kwesobunxele bese sikhetha kupaneli eliqonde mpo lokuxhumanisa iqembu lalezo zilayini esifuna ukuzifihla.
Uma ububanzi bukhulu, khona-ke ungazikhethela lokhu okulandelayo: chofoza kwesobunxele kwinombolo yomugqa wokuqala wokuhlelwa kwepaneli yokuhlanganisa, bese ubamba phansi inkinobho I-Shift bese uchofoza inombolo yokugcina yebanga eliqondiwe.
Ungaze ukhethe imigqa eminingana ehlukene. Ukuze wenze lokhu, komunye nomunye wabo kufanele uchofoze inkinobho yegundane kwesobunxele ngenkathi ubambe ukhiye Ctrl.
- Yiba yisikhombisi emngceleni ophansi wanoma iyiphi yale migqa bese uyihudula kuze kube yilapho imingcele ivaliwe.
- Lokhu ngeke kufihle umugqa kuphela osebenza kuwo, kodwa futhi nayo yonke imigqa yebanga elikhethiwe.
Indlela 4: imenyu yokuqukethwe
Lezi zindlela ezimbili zangaphambili, zona, ezinembile kakhulu futhi kulula ukuzisebenzisa, kepha azikwazi ukuqinisekisa ukuthi amaseli afihliwe ngokuphelele. Kuhlala kukhona isikhala esincane, ekubambeni lapho ungakwandisa khona iseli emuva. Ungafihla ngokuphelele umugqa usebenzisa imenyu yokuqukethwe.
- Sikhipha imigqa ngenye yezindlela ezintathu, okuxoxwe ngazo ngenhla:
- kuphela ngegundane;
- usebenzisa ukhiye I-Shift;
- usebenzisa ukhiye Ctrl.
- Sichofoza esikalini sokuqondisa ngokuqondile ngenkinobho yegundane elifanele. Imenyu yokuqukethwe iyavela. Beka uphawu kwento "Fihla".
- Imigqa egqanyisiwe izofihlwa ngenxa yezenzo ezingenhla.
Indlela 5: ithuluzi lamathuluzi
Ungaphinde ufihle imigqa usebenzisa inkinobho kubha yamathuluzi.
- Khetha amaseli asemigqeni ofuna ukuyifihla. Ngokungafani nendlela yangaphambilini, akudingekile ukukhetha umugqa wonke. Iya kuthebhu "Ikhaya". Chofoza inkinobho kubha yamathuluzi. "Ifomathi"elibekwe ebhlokini "Amaseli". Kuluhlu oluqala, hambisa isikhombisi entweni eyodwa eqenjini "Ukubonakala" - Fihla noma ubonise. Kumenyu eyengeziwe, khetha into edingekayo ukufeza inhloso - Fihla Imigqa.
- Ngemuva kwalokho, yonke imigqa ebiqukethe amaseli akhethwe esigabeni sokuqala izofihlwa.
Indlela 6: ukuhlunga
Ukuze ufihle okuqukethwe okungadingeki esikhathini esizayo esiseduze ukuze kungaphazamisi, ungafaka isicelo sokuhlunga.
- Khetha itafula lonke noma elinye lamaseli kunhlokweni yalo. Kuthebhu "Ikhaya" chofoza isithonjana Hlunga nesihlungielibekwe endaweni yethuluzi "Ukuhlela". Uhlu lwezenzo luyavula, lapho sikhetha khona into "Hlunga".
Ungenza futhi ngenye indlela. Ngemuva kokukhetha itafula noma unhlokweni, iya kuthebhu "Idatha". Ukuchofoza izinkinobho "Hlunga". Itholakala ethepheni ebhlokini. Hlunga nesihlungi.
- Noma iyiphi kulezi zindlela ezimbili eziphakanyisiwe oyisebenzisayo, kuzovela isithonjana sokuhlunga kumaseli wekhanda lethebula. Unxantathu omncane omnyama okhomba phansi. Sichofoza lesi sithonjana kwikholamu equkethe imfanelo esizokuhlunga ngayo idatha.
- Imenyu yokuhlunga iyavula. Ungahloli amanani aqukethe emigqeni ehloselwe ukufihlwa. Bese uchofoza inkinobho "Kulungile".
- Ngemuva kwalesi senzo, yonke imigqa lapho kunamanani esingasitholi khona izofihlwa kusetshenziswa isihlungi.
Isifundo: Hlunga futhi uhlunge idatha ku-Excel
Indlela 7: fihla amaseli
Manje ake sixoxe ngokuthi ungawafihla kanjani amangqamuzana ngamanye. Ngokwemvelo, azikwazi ukususwa ngokuphelele, njengemigqa noma amakholomu, ngoba lokhu kuzokonakalisa ukwakheka kwedokhumenti, kepha noma kunjalo kunendlela, uma kungenjalo ukufihla ngokuphelele izakhi ngokwazo, bese kufihla okuqukethwe.
- Khetha iseli elilodwa noma amaningi azofihlwa. Sichofoza kucezu olukhethiwe ngenkinobho yegundane elifanele. Imenyu yokuqukethwe iyavula. Khetha into ekuyo "Ifomethi yeseli ...".
- Ukuqalisa ukufometha kuqala. Sidinga ukuya kuthebhu yakhe. "Inombolo". Ngaphezu kwalokho kuvimba lepharamitha "Amafomethi ezinombolo" qokomisa isikhundla "Zonke izinhlobo". Engxenyeni engakwesokudla yewindi enkundleni "Thayipha" sishayela kule nkulumo elandelayo:
;;;Chofoza inkinobho "Kulungile" ukusindisa izilungiselelo ezifakiwe.
- Njengoba ukwazi ukubona, emva kwalokho yonke imininingwane kumaseli akhethiwe inyamalala. Kepha anyamalala ngamehlo, eqinisweni aqhubeka nokuba lapho. Ukuqiniseka ngalokhu, vele ubheke umugqa wamafomula akhonjiswa kuwo. Uma udinga futhi ukunika amandla ukuboniswa kwedatha kumaseli, uzodinga ukuthi uguqule ifomethi kuwo ube yilowo owawusefasiteleni lokufometha ngaphambilini.
Njengoba ukwazi ukubona, kunezindlela ezahlukahlukene ongafihla ngazo imigqa e-Excel. Ngaphezu kwalokho, iningi labo lisebenzisa ubuchwepheshe obuhluke ngokuphelele: ukuhlunga, ukufaka iqembu, ukuguqula imingcele yeseli. Ngakho-ke, umsebenzisi unokukhethwa okubanzi kakhulu kwamathuluzi ukuxazulula umsebenzi. Angasebenzisa inketho ayibona ifaneleka kakhudlwana esimweni esithile, futhi elula futhi ilula ngokwakhe. Ngaphezu kwalokho, usebenzisa ukufomatha, kungenzeka ukufihla okuqukethwe amaseli ngamanye.
