Ungafriza Kanjani Amakholomu Amaningi ku-Excel

Ikhono lokufriza amakholomu ku-Excel isici esiwusizo ohlelweni esikuvumela ukuba umise indawo ukuze ugcine ulwazi lubonakala. Kuyasiza uma usebenza namatafula amakhulu, isibonelo, lapho udinga ukuqhathanisa. Kungenzeka ukumisa ikholomu eyodwa noma uthwebule amaningana ngesikhathi esisodwa, esizoxoxa ngakho ngokuningiliziwe ngezansi.

Ungafriza kanjani ikholomu yokuqala ku-Excel?

Ukuze umise ikholomu eyodwa, udinga ukwenza okulandelayo:

1. Vula ifayela lethebula ofuna ukulihlela.
2. Iya kubha yamathuluzi esigabeni esithi "Buka".
3. Thola emsebenzini ohlongozwayo "Izindawo zokukhiya".
4. Ohlwini oludonsela phansi, khetha "Friza ikholomu yokuqala".

Ngemva kokuqeda izinyathelo, uzobona ukuthi umngcele ushintshile kancane, ube mnyama futhi ube mkhulu, okusho ukuthi ulungisiwe, futhi lapho ufunda itafula, ulwazi lwekholomu yokuqala ngeke luphele futhi, empeleni, izolungiswa ngokubonakalayo.

Ungawamisa kanjani amakholomu amaningi ku-Excel?

Ukuze ulungise amakholomu amaningana ngesikhathi esisodwa, kufanele wenze inombolo yezinyathelo ezengeziwe. Into esemqoka okufanele uyikhumbule ukuthi amakholomu abalwa kusukela kusampula kwesokunxele, kuqala ngo-A. Ngakho-ke, ngeke kwenzeke ukufriza amakholomu amaningana ahlukene endaweni ethile phakathi kwetafula. Ngakho-ke, ukuze usebenzise lolu hlelo lokusebenza, udinga ukwenza okulandelayo:

1. Ake sithi sidinga ukumisa amakholomu amathathu ngesikhathi esisodwa (imibhalo A, B, C), ngakho qala ngokukhetha yonke ikholomu D noma iseli D.

2. Ngemuva kwalokho, udinga ukuya kubha yamathuluzi bese ukhetha ithebhu ebizwa ngokuthi "Buka".
3. Kuyo, uzodinga ukusebenzisa inketho ethi "Freeze izindawo".

4. Ohlwini uzoba nemisebenzi eminingana, phakathi kwayo uzodinga ukukhetha "Izindawo zokumisa".
5. Uma konke kwenziwa ngendlela efanele, khona-ke amakholomu amathathu abonisiwe azolungiswa futhi angasetshenziswa njengomthombo wolwazi noma ukuqhathanisa.

Nakani! Udinga kuphela ukufriza amakholomu uma ebonakala esikrinini. Uma zifihliwe noma zidlula ukubonakala okubonakalayo, khona-ke inqubo yokulungisa ayinakwenzeka ukuphela ngempumelelo. Ngakho-ke, lapho wenza zonke izenzo, kufanele uqaphele kakhulu futhi uzame ukungenzi amaphutha.

Indlela yokufriza ikholomu nomugqa ngesikhathi esisodwa?

Kungase kube nesimo esinjalo sokuthi udinga ukumisa ikholomu ngesikhathi esisodwa kanye nomugqa oseduze, ukuze usebenzise ukufriza, udinga ukwenza lokhu okulandelayo:

1. Ekuqaleni, uzodinga ukusebenzisa iseli njengendawo eyisisekelo. Imfuneko eyinhloko kuleli cala ukuthi iseli kufanele libekwe ngokuqinile ezimpambanweni zomugqa nekholomu. Ekuqaleni, lokhu kungase kuzwakale kuyinkimbinkimbi, kodwa ngenxa yesithombe-skrini esinamathiselwe, ungakwazi ukuqonda ngokushesha ubunkimbinkimbi balesi sikhathi.
2. Iya kubha yamathuluzi bese usebenzisa ithebhu "Buka".
3. Kuyo udinga ukuthola into ethi "Freeze izindawo" bese uchofoza kuyo ngenkinobho yegundane kwesokunxele.
4. Kuhlu oluya phansi, vele ukhethe inketho ethi "Freeze izindawo".

Kungenzeka ukulungisa amaphaneli amaningana ngesikhathi esisodwa ukuze usetshenziswe ngokuqhubekayo. Isibonelo, uma udinga ukulungisa amakholomu amabili okuqala nemigqa emibili, khona-ke ukuze uthole umumo ocacile uzodinga ukukhetha iseli C3. Futhi uma udinga ukulungisa imigqa emithathu namakholomu amathathu ngesikhathi esisodwa, kulokhu uzodinga ukukhetha iseli D4 kakade. Futhi uma udinga isethi engeyona evamile, isibonelo, imigqa emibili namakholomu amathathu, uzodinga ukukhetha iseli D3 ukuze uyilungise. Ukudweba ukufana, ungabona isimiso sokulungisa futhi uyisebenzise ngesibindi kunoma yiliphi ithebula.

Ungazimisa kanjani izifunda ku-Excel?

Ngemuva kokuthi ulwazi oluvela kumakholomu aphiniwe lusetshenziswe ngokugcwele, kufanele ucabange ukuthi ungasusa kanjani ukuphina. Kunomsebenzi ohlukile waleli cala, futhi ukuze ulisebenzise, ​​udinga ukwenza okulandelayo:

1. Isinyathelo sokuqala siwukuqinisekisa ukuthi amakholomu aphiniwe awasadingeki emsebenzini wakho.
2. Manje yiya kubha yamathuluzi phezulu bese uye kuthebhu ethi "Buka".
3. Sebenzisa isici se-Freeze Regions.
4. Kuhlu lokudonsela phansi, khetha into ethi "Susa ukufriza".

Ngokushesha nje lapho konke kwenziwa, ukuphina kuzosuswa, futhi kuzokwazi ukusebenzisa ukubuka kwangempela kwetafula futhi.

Isiphetho

Njengoba ubona, ukusebenzisa umsebenzi wokuphina akunzima kangako, kwanele ukusebenzisa ngekhono zonke izenzo ezitholakalayo futhi ulandele ngokucophelela izincomo. Lo msebenzi ngokuqinisekile uzofika kahle, ngakho-ke kufanele ukhumbule isimiso sokusetshenziswa kwawo.