Ungayifihla kanjani imigqa namaseli ku-Excel

Lapho usebenza ohlelweni lwe-Excel, kuvame kakhulu ukuthola isimo lapho kubekwa khona ingxenye enkulu yohlu lwamaqabunga ukubala nje futhi ayithwali umthwalo wolwazi womsebenzisi. Imininingwane enjalo ihlala endaweni futhi iphazamisa ukunakwa. Ngaphezu kwalokho, uma umsebenzisi ezokwephula ngephutha ukwakheka kwawo, angaphula umjikelezo wokubala wonke kudokhumenti. Ngakho-ke, imigqa enjalo noma amaseli ngamunye kungcono ukucasha. Ngaphezu kwalokho, ungafihla leyo mininingwane edingeka nje okwesikhashana ukuze ingaphazamisi. Ake sibheke ukuthi yiziphi izindlela ezingenziwa.

Inqubo yokucasha

Fihla amaseli ezintweni ezihle kakhulu kungaba izindlela ezihlukene eziningana ngokuphelele. Masigxile komunye nomunye wabo ukuze umsebenzisi uqobo aqonde, kusiphi isimo esizoba lula ukusebenzisa inketho ethile.

Indlela 1: Ukuqoqwa kwamaqembu

Enye yezindlela ezithandwa kakhulu zokufihla izinto ukuhlela kwabo.

1. Sigqamisa imigqa yeshidi edinga ukuhlukaniswa, bese sicasha. Akudingekile ukwaba yonke intambo, futhi kungaphawulwa kuphela ngeseli elilodwa emigqeni eqoqwe. Okulandelayo, iya kuthebhu "Idatha". Esivikelweni "sesakhiwo", esitholakala kwiribhoni yetheyipu, cindezela inkinobho ethi "Gig".



2. Iwindi elincane liyavula, elinikezela ukukhetha ukuthi yini ezidinga ukuhlukaniswa kabusha: imigqa noma amakholomu. Njengoba sidinga imigqa yeqembu, asikhiqizi noma yiziphi izinguquko kuzilungiselelo, ngoba ukushintshwa okuzenzakalelayo kusethelwe esimweni esikudingayo. Chofoza inkinobho ethi "KULUNGILE".



3. Emva kwalokho, kwakhiwa iqembu. Ukufihla idatha etholakala kuyo yanele ukuchofoza isithonjana ngesibonakaliso se- "minus". Kubekwa ngakwesobunxele kwephaneli yokuxhumanisa mpo.



4. Njengoba ubona, imigqa ifihliwe. Ukubakhombisa futhi, udinga uchofoze uphawu lwe- "Plus".

Isifundo: Ungayenza kanjani iqembu e-Excel

Indlela 2: Amaseli Wokucabanga

Indlela enembile kakhulu yokufihla okuqukethwe kwamaseli, mhlawumbe, ukudonsela imingcele yemigqa.

1. Sisungula isikhombisi kuphaneli yokuxhumanisa mpo, lapho izinombolo zemigqa zimakwe khona, emkhawulweni ophansi walologi, okuqukethwe okufuna ukucasha. Kulokhu, isikhombisi kufanele siguqulele kwisithonjana ngesimo sesiphambano esine-pointer ephindwe kabili, eqondiswe phezulu naphansi. Bese uphinise inkinobho yegundane kwesobunxele bese udonsa isikhombisi kuze kube yilapho imingcele engaphansi kanye nengaphezulu yomugqa ayivali.



2. Intambo izofihlwa.

Indlela 3: Iqembu Fihla Ukwelashwa Kweselula

Uma udinga le ndlela ukufihla izinto eziningana ngasikhathi sinye, khona-ke kufanele kwabelwe.

1. Vala inkinobho yegundane kwesobunxele bese ugqamisa ukuxhumanisa kuphaneli yokuxhumanisa mpo okufisayo ukucasha.

   

   Uma uhla lukhulu, bese ukhetha izinto ezilandelayo: chofoza inkinobho yesokunxele ngenombolo yemigqa yokuqala ye-array ku-array panel, bese uqhafaza inkinobho yokushintsha bese uchofoza inombolo yokugcina.

   

   Ungaqokomisa ngisho nemigqa eminingana ehlukene. Ukuze wenze lokhu, kulowo nalowo kubo, kufanele uchofoze inkinobho yegundane kwesobunxele nge-Ctrl Pinch.



2. Siba isikhombisi emngceleni ophansi sanoma iyiphi yale migqa bese yelula kuze kube yilapho imingcele ivaliwe.



3. Kulokhu, hhayi kuphela intambo izofihlwa, osebenza ngayo, kodwa futhi yonke imigqa yokwabelwa uhla.

Indlela 4: Imenyu yomongo

Izindlela ezimbili ezedlule, kunjalo, zinembile kakhulu futhi kulula ukuzisebenzisa, kepha azinakukwazi ukunikeza amaseli aphelele. Kuhlala kunesikhala esincane, sibambelele lapho ungaphendukela khona iseli. Fihla ngokuphelele intambo kungenzeka kusetshenziswa imenyu yokuqukethwe.

1. Sigqamisa umugqa ngesinye sezindlela ezintathu esichazwe ngenhla:
   • kuphela negundane;
   • usebenzisa ukhiye we-Shift;
   • Usebenzisa ukhiye we-CTRL.



2. Chofoza esikalini mpo zokuxhumanisa ngenkinobho yegundane efanele. Imenyu yomongo iyavela. Sigubha into ethi "Fihla".



3. Imigqa ekhethiwe ngenxa yezenzo ezingenhla izofihlwa.

Indlela 5: Ithuluzi le-TOOL

Ungase futhi ufihle izintambo ngokusebenzisa inkinobho kubha yamathuluzi.

1. Khetha amaseli asemigqeni okufanele afihlwe. Ngokungafani nendlela edlule, akudingekile ukwaba wonke umugqa. Iya kuthebhu "Yasekhaya". Chofoza inkinobho kwi-Ribbon yefomethi yefomethi, etholakala ku-block "cell". Ohlwini olwethuliwe, siletha isikhombisi endaweni kuphela yephuzu "lokubonakala" - "Fihla noma libonise". Kumenyu eyengeziwe, khetha into edingekayo ukwenza ilitshe - "Fihla imigqa".



2. Ngemuva kwalokho, yonke imigqa ebiqukethe iseli ezabelwe esigabeni sokuqala izofihlwa.

Indlela 6: Ukuhlunga

Ukuze ufihle okuqukethwe kusuka eshidini, elingeke alidinge esikhathini esizayo esiseduze ukuze lingaphazamisi, ungafaka isicelo sokuhlunga.

1. Sigqamisa lonke itafula noma elinye lamaseli ku-cap yalo. Kuthebhu "Yasekhaya", chofoza kwisithonjana esithi "Hlunga nesihlungi", esitholakala kubha yamathuluzi yokuhlela. Uhlu lwezenzo luvula lapho ukhetha khona into "yokuhlunga".

   

   Ungakwenza futhi ngenye indlela. Ngemuva kokukhetha itafula noma ama-cap, iya kuthebhu yedatha. Ukuchofoza inkinobho ethi "Filter". Itholakala ku-ribbon ku- "hlobo bese uhlunga" block.



2. Noma yiziphi izindlela ezimbili ezihlongozwayo ongazisebenzisi, isithonjana sokuhlunga sizovela kumaseli weThebula Cap. Unxantathu omncane wombala omnyama, i-angle eqonde phansi phansi. Chofoza kulesi sithonjana kukholamu, lapho uphawu luqukethwe khona lapho sizohlunga khona imininingwane.



3. Imenyu yokuhlunga iyavuleka. Susa imikhaza kulawo magugu aqukethwe emigqeni eyenzelwe ukucasha. Bese uchofoza inkinobho ethi "KULUNGILE".



4. Ngemuva kwalesi senzo, yonke imigqa lapho kukhona amanani asuse kuwo amabhokisi okuhlola azofihlwa kusetshenziswa isihlungi.

Isifundo: Ukuhlunga nokuhlunga idatha ukuze udlule

Indlela 7: Fihla amaseli

Manje ake sixoxe ngokuthi ungafihla kanjani amaseli ngamanye. Ngokwemvelo, ngeke zisuswe ngokuphelele, njengekholamu noma amakholomu, ngoba zizobhubhisa ukwakheka kwalo mbhalo, kodwa nokho kunendlela uma kungazifihli ngokuphelele izinto ngokwabo, bese zifihla okuqukethwe kwazo.

1. Khetha amaseli owodwa noma amaningi ukucasha. Chofoza kwingxenye ezinikezelwe ngenkinobho yegundane efanele. Imenyu yomongo iyavula. Khetha kuyo "ifomethi yeseli ...".



2. Iwindi lokufometha liyasungulwa. Sidinga ukuya kuthebhu yakhe "yenombolo". Okulandelayo, ku- "Numeric forms" Amapharamitha, khetha isikhundla esithi "Zonke Izinhlobo" Zamafomethi. Ngakwesokunene sewindi kunkambu ye- "hlobo", shayela le nkulumo elandelayo:

   ;;;

   Chofoza inkinobho ethi "Kulungile" ukusindisa izilungiselelo ezifakiwe.



3. Njengoba ubona, emva kwalokho, yonke imininingwane emangqamuzaneni akhethiwe yanyamalala. Kepha banyamalala kuphela ngamehlo, futhi empeleni bayaqhubeka nokuba lapho. Ukuqinisekisa ukuthi lokhu kwanele ukubheka intambo yamafomula lapho aboniswa khona. Uma udinga ukuvula ukubonisa idatha kumaseli, uzodinga ukushintsha ifomethi kufomethi kubo ngewindi lefomethi.

Njengoba ubona, kunezindlela ezimbalwa ezahlukahlukene ongafihla ngazo imigqa ku-Excel. Ngaphezu kwalokho, iningi labo lisebenzisa ubuchwepheshe obuhluke ngokuphelele: ukuhlunga, ukuhlela, imingcele yamaseli. Ngakho-ke, umsebenzisi unokukhethwa okubanzi kakhulu kwamathuluzi okuxazulula umsebenzi. Ingasebenzisa inketho ebona efanelekile esimweni esithile, futhi ikhululekile futhi ibe lula kuye. Ngaphezu kwalokho, usebenzisa ukufomatha kungenzeka ukufihla okuqukethwe kwamaseli ngamanye.