Okuqukethwe
I-Microsoft Office Excel ivame ukudala amathebula anolwazi oluningi oluyinkinga ukuthi lungene ekhasini elilodwa lomsebenzi. Ngenxa yalesi simo, kunzima kumsebenzisi ukuqhathanisa idatha etholakala emaphethelweni ahlukene edokhumenti, futhi kuthatha isikhathi esiningi ukupheqa ithebula ukuze uthole ulwazi oludingekayo. Ukuze ugweme inkinga enjalo, izindawo ezibalulekile ku-Excel zingalungiswa ngaso sonke isikhathi, zilungiswe engxenyeni ebonakalayo yedokhumenti, ukuze umsebenzisi akwazi ukuthola ngokushesha ulwazi oluthakazelisayo kuye. Lesi sihloko sizoxoxa ngezindlela zokuphina nokukhipha izindawo ku-Excel.
Indlela yokuphina izindawo
Kunezindlela ezimbalwa ezivamile zokufeza umsebenzi, ngayinye ehambisana nenguqulo ethile yohlelo. Inqubo yezinguqulo ezahlukene ze-Microsoft Excel izohluka kancane. Ngokuvamile, inqubo yokulungisa izindawo ezidingekayo ohlelweni olucutshungulwayo ihlukaniswe ngezinyathelo ezilandelayo:
- Khetha iseli lokuqala kuthebula. Leli seli kufanele libe ngaphansi kwendawo ofuna ukuyiphina engxenyeni ebonakalayo yesikrini. Ngaphezu kwalokho, idatha etholakala ngenhla nangakwesokunxele sento ekhethiwe izolungiswa uhlelo.
- Ngemuva kokwenza ukukhohlisa kwangaphambilini, uzodinga ukushintshela kuthebhu ethi "Buka". Itholakala kukholamu yezinketho phezulu kusixhumi esibonakalayo se-Excel.
- Okulandelayo, emgqeni ovuliwe wamanani, udinga ukuchofoza i-LMB kunkinobho ethi "Iwindi" kanye.
- Amathuluzi amaningana azoboniswa, phakathi kwawo okudingeka uchofoze isithonjana esithi "Freeze amafasitelana". Kumamonitha abanzi anombukiso wokucaca okuphezulu, isigaba sokubuka sibonisa ngokushesha izinketho zezinto zokuphina. Labo. Akumele uchofoze inkinobho yewindi.
- Qinisekisa ukuthi indawo ekhethiwe ngaphambilini igxilile ekhasini lokusebenza. Manje yonke into ebingenhla nakwesokunxele seseli izovezwa kuthebula njengoba uskrolela phansi, futhi ngeke inyamalale ekubukeni.
- Umsebenzisi angaphinda aphine wonke amaseli angaphezulu komugqa okhethiwe. Ukuze wenze lokhu, uzodinga ukukhetha iseli oyifunayo phakathi kwetafula, bese ngendlela efanayo uye kuthebhu ethi "Buka", lapho uchofoza inkinobho ethi "Freeze izindawo". Le ndlela yokulungisa ifaneleka kakhulu lapho umuntu edinga ukulungisa unhlokweni wethebula ekhasini lomsebenzi ngalinye.
Nakani! Ukuze ulungise imininingwane etholakala kwesokunxele seseli ekhethiwe, uzodinga ukukhetha into ephezulu yekholomu etholakala kwesokudla sendawo oyifunayo, bese wenza okufanayo.
Izifunda zisuswe kanjani ukuphina
Abasebenzisi abangenalwazi be-Microsoft Office Excel abazi ukuthi bangakhipha kanjani ukuphina izindawo ebezikhiyiwe ngaphambilini. Konke kulula lapha, into esemqoka ukulandela izincomo ezithile:
- Vula idokhumenti ye-Excel. Ngemuva kokuvela kwenkambu yokusebenza epuletini, awudingi ukukhetha noma yimaphi amaseli.
- Iya kuthebhu ethi "Buka" kuribhoni yezinketho phezulu ewindini lohlelo.
- Manje udinga ukuchofoza inkinobho ethi "Iwindi" ukuze uvule isigatshana esinezici zokuphina.
- Chofoza i-LMB kumbhalo othi “Susa ukuphina izifunda”.
- Hlola umphumela ngokuskrola phansi kwetafula. Ukulungiswa kwamaseli akhethwe ngaphambilini kufanele kukhanselwe.
Ulwazi Olwengeziwe! Ukukhipha izindawo ku-Excel kwenziwa ngokulandelana ncamashi ngokuqhathaniswa nokuzilungisa.
Indlela yokufriza indawo kusuka kumakholomu
Kwesinye isikhathi ku-Excel udinga ukufriza hhayi imigqa, kodwa amakholomu. Ukuze ubhekane nomsebenzi ngokushesha, ungasebenzisa i-algorithm elandelayo:
- Nquma amakholomu okudingeka alungiswe, thola izinombolo zabo, ezibhalwe phezulu ohlwini ngendlela yezinhlamvu A, B, C, D, njll.
- Sebenzisa inkinobho yegundane kwesokunxele ukuze ukhethe ikholomu elandela ububanzi obukhethiwe. Isibonelo, uma udinga ukulungisa amakholomu A no-B, kuzomele ukhethe ikholomu C.
- Okulandelayo, udinga ukuya ngokufanayo kuthebhu ethi "Buka" bese uchofoza inkinobho ethi "Freeze Izindawo" ukuze ulungise ububanzi obufunekayo bamakholomu ekhasini lokusebenza ngalinye.
- Efasiteleni lohlobo lomongo, uzodinga ukukhetha inketho yokuqala yokulungisa imigqa namakholomu amathebula.
- Hlola umphumela. Esigabeni sokugcina, udinga ukupheqa phansi idokhumenti futhi uqiniseke ukuthi indawo ebekiwe ayinyamalala ekhasini lokusebenza, okungukuthi elinamathiselwe kulo.
Isiphetho
Ithuluzi lokulungisa izindawo ku-Excel longa isikhathi kubasebenzisi abasebenza ngenani elikhulu lolwazi. Into ephiniwe izohlala ivela ekhasini lokusebenza njengoba uskrola kulo. Ukuze wenze kusebenze umsebenzi onjalo ngokushesha, kufanele ufunde ngokucophelela ulwazi olungenhla.