Okuqukethwe
Uma usebenza ngamathebula amade angalingani mpo esikrinini futhi anenani elikhulu lamakholomu, ngezikhathi ezithile kuba nesidingo sokuskrola isikrini ukuze ubonise umugqa ophezulu onezihloko kuwo. Ukuze kube lula, uhlelo lwe-Excel lunikeza ikhono lokulungisa unhlokweni wethebula phezulu kwesikrini ngaso sonke isikhathi ifayela livuliwe. Izinketho zokufeza lokhu kuxoxwa ngazo ngezansi.
Umugqa owodwa kuphela odinga ukuphinwa
- Emugqeni ophezulu weribhoni yohlelo, hamba kuthebhu ethi "Buka".
- Esigabeni esithi "Iwindi" (amagama esigaba akhonjiswe emgqeni ongezansi weribhoni), thola into ethi "Freeze izindawo" bese uchofoza unxantathu engxenyeni engakwesokudla.
- Ohlwini oluvulayo, khetha okuthi “Khiya umugqa ophezulu” ngokuchofoza inkinobho yegundane kwesokunxele. Umphumela uzoba ubukhona obuhlala njalo esikrinini somugqa wesihloko sethebula, esiqhubekayo ngisho nangemva kokuba ifayela selivaliwe.
Umugqa ophezulu uphiniwe
Ukunamathisela unhlokweni emigqeni eminingi
Uma udinga ukulungisa imigqa eminingana, kufanele wenze ngendlela ehlukile:
- Kukholomu yesokunxele yethebula, chofoza iseli lomugqa wokuqala elingeyona ingxenye yesihloko. Kulokhu, iseli A3.
Ukulandelana kwezenzo zokulungisa imigqa eminingana - Yiya kuthebhu ethi “Buka”, chofoza okuthi “Izindawo Zokufriza” bese ukhetha into ethi “Freeze Izindawo” ohlwini lokudonsela phansi. Ngenxa yalokho, yonke imigqa etholakala ngaphezu kwalowo iseli elikhethiwe elingelakhe izolungiswa phezulu esikrinini.
Isihloko simisiwe etafuleni, esihlanganisa imigqa emibili ephezulu
"Ithebula elihlakaniphile" - enye inketho yokulungisa unhlokweni
Uma uwazi amaspredishithi ahlakaniphile e-Excel, kunenye indlela ewusizo yokuwaphina. Yiqiniso, le nketho isebenza kuphela endabeni yesihloko somugqa owodwa.
- Kuthebhu ethi Ikhaya yeribhoni, khetha ithebula lonke.
- Esigabeni esithi “Izitayela” (emgqeni ongezansi weribhoni), chofoza into ethi “Fometha Njengethebula”. Iwindi elineqoqo lezitayela zetafula lizovuleka. Kuyo udinga ukuchofoza inketho efanelekile kakhulu.
Ibhokisi likaqhwithi “Ithebula elinezihloko” - Iwindi elithi “Ukufometha Kwethebula” liyavela, lapho kuboniswa khona imingcele yethebula lesikhathi esizayo, kanye nebhokisi lokuhlola elithi “Ithebula Elinezihloko” nalo likhona. Qiniseka ukuthi eyakamuva ihloliwe.
- Vala iwindi ngokuchofoza inkinobho ethi "OK".
“Ithebula elihlakaniphile” elinenhlokweni engashintshi
Ungakwazi ukudala "ithebula elihlakaniphile" ngenye indlela:
- Ngemuva kokukhetha indawo oyifunayo, iya kuthebhu yeribhoni ethi "Faka" bese uchofoza into ethi "Amathebula".
- Ohlwini oluvelayo, chofoza into ethi "Ithebula".
- Ngemva kokuthi iwindi elithi “Dala Ithebula” livela nokuqukethwe okufanayo newindi elithi “Ithebula Lefomethi”, udinga ukulandela izinyathelo ezifanayo nalezo esezibalulwe ngenhla. Ngenxa yalokho, kuzovela "ithebula elihlakaniphile" elinekepisi eligxiliwe phezulu.
Indlela yesibili yokudala "ithebula elihlakaniphile"
Ungaphrinta kanjani itafula elinesihloko ekhasini ngalinye
Lapho uphrinta ithebula elihlanganisa amakhasi amaningana, kuyasiza ukuba nesihloko salo ekhasini ngalinye. Lokhu kukuvumela ukuthi usebenze nanoma yiliphi ikhasi eliphrintiwe ngokwehlukana. Ku-Excel, lokhu kungenzeka kunikezwe futhi kungenziwa ngale ndlela elandelayo.
- Yiya kuthebhu yeribhoni "Isakhiwo Sekhasi" futhi esigabeni "Ukusethwa Kwekhasi" (emgqeni ongezansi weribhoni) chofoza ibhokisi elinomcibisholo kwesokudla sombhalo.
Ukulandelana kwezenzo efasiteleni elikhulu le-Excel - Ewindini Lokusethwa Kwekhasi elivulekayo, hamba kuthebhu ethi Ishidi.
- Chofoza ibhokisi elithi “Ngemigqa” (okwesibili ukusuka phezulu).
- Buyela etafuleni futhi, ngokuhambisa ikhesa, ethathe isimo somcibisholo omnyama obheke kwesokudla, eduze kwekholomu enezinombolo zomugqa, khetha umugqa noma imigqa lapho inhlokweni yethebula ikhona.
Ukulandelana kwezenzo ewindini elithi "Ukusethwa Kwekhasi". - Kulokhu, zonke izenzo ziyaqedwa, kodwa umphumela wazo awuboniswa esikrinini.
Ukubuka kwethebula ngemva kokukhetha unhlokweni ozowuphrinta ekhasini ngalinye
Kubalulekile! Ukuze uqiniseke ukuthi umgomo ufinyelelwe, udinga ukuya kuthebhu yeribhoni ethi "File" bese uchofoza into ethi "Phrinta". Ewindini elivulayo, uhlobo lwedokhumenti ngenxa yokuphrinta kwalo luzovezwa.
Lapha, ngokuchofoza onxantathu emgqeni ongezansi wefasitela noma ngokuskrola isondo legundane, ngekhesa ekhasini lethebula, ungabuka wonke amakhasi ukuze uhlole ukuba khona kwesihloko kulelo nalelo khasi.
iziphetho
Ku-Excel, kunezindlela ezimbili zokubonisa unomphela unhlokweni wethebula esikrinini. Enye yazo ihilela ukusetshenziswa kokulungisa indawo, okwesibili - ukuguqula itafula libe "elihlakaniphile" ngokufometha indawo ekhethiwe yokufaka itafula kuyo. Zombili izindlela zenza kube nokwenzeka ukuphina umugqa owodwa, kodwa owokuqala kuphela okuvumela ukuthi wenze lokhu ngesihloko esihlanganisa imigqa eminingi.. I-Excel nayo inokunethezeka okwengeziwe - ikhono lokuphrinta idokhumenti enesihloko ekhasini ngalinye, okwandisa ngokuqinisekile ukusebenza kahle kokusebenza nalo.