Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina

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.
Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
Ukukhethwa kweseli elitholakala ngezansi nangakwesokudla kwendawo yokudokha. Lokhu kukhetha kuyamukeleka uma umsebenzisi edinga ukuphina unhlokweni wethebula
  • Ngemuva kokwenza ukukhohlisa kwangaphambilini, uzodinga ukushintshela kuthebhu ethi "Buka". Itholakala kukholamu yezinketho phezulu kusixhumi esibonakalayo se-Excel.
Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
Indawo yethebhu ethi Buka ku-Microsoft Excel 2016. Kwezinye izinguqulo zesofthiwe, lesi sigaba sisendaweni efanayo.
  • 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.
Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
I-algorithm yezenzo zokulungisa izindawo ku-Excel esithombeni esisodwa. Imiyalelo elula necacile engadingi ukukhohlisa okwengeziwe
  • Qinisekisa ukuthi indawo ekhethiwe ngaphambilini igxilile ekhasini lokusebenza. Manje yonke into ebingenhla nakwesokunxele seseli izovezwa kuthebula njengoba uskrolela phansi, futhi ngeke inyamalale ekubukeni.
Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
Ukucindezela inkinobho ethi “Friza amafasitelana” ngokushesha ngemva kokuya kuthebhu ethi “Buka”, udlule isigatshana esithi “Iwindi”
  • 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.
Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
Ukubukeka kwendawo ephiniwe ku-Excel. Indawo oyifunayo ilungisiwe futhi ayinyamalala ekhasini lokusebenza njengoba idokhumenti iskrolwa

Nakani! Ukuze ulungise imininingwane etholakala kwesokunxele seseli ekhethiwe, uzodinga ukukhetha into ephezulu yekholomu etholakala kwesokudla sendawo oyifunayo, bese wenza okufanayo.

Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
Izenzo zokufriza amaseli angaphezulu kwanoma yimuphi umugqa ohlwini lwethebula. Iseli lokuqala emugqeni kufanele ligqanyiswe.

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:

  1. Vula idokhumenti ye-Excel. Ngemuva kokuvela kwenkambu yokusebenza epuletini, awudingi ukukhetha noma yimaphi amaseli.
  2. Iya kuthebhu ethi "Buka" kuribhoni yezinketho phezulu ewindini lohlelo.
  3. Manje udinga ukuchofoza inkinobho ethi "Iwindi" ukuze uvule isigatshana esinezici zokuphina.
  4. Chofoza i-LMB kumbhalo othi “Susa ukuphina izifunda”.
  5. Hlola umphumela ngokuskrola phansi kwetafula. Ukulungiswa kwamaseli akhethwe ngaphambilini kufanele kukhanselwe.
Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
Inqubo yokukhipha ukuphina izifunda ku-Microsoft Office Excel

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.
Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
Igqamisa ikholomu ukuze uphine ezandulele
  • Okulandelayo, udinga ukuya ngokufanayo kuthebhu ethi "Buka" bese uchofoza inkinobho ethi "Freeze Izindawo" ukuze ulungise ububanzi obufunekayo bamakholomu ekhasini lokusebenza ngalinye.
Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
Indlela eya ekulungiseni amakholomu adingekayo wohlu lwethebula. I-algorithm eyethulwe ibalulekile kunoma iyiphi inguqulo ye-Microsoft Office Excel
  • 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.
Ungamisa kanjani indawo ku-Excel. Ukuphina indawo ku-Excel nokususa ukuphina
Umphumela wokugcina wamakholomu okuphina, okufanele atholwe uma zonke izenzo zenziwe ngendlela efanele

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.

shiya impendulo