Hlala ekulandeleni lapho ukhona kuspredishithi
Lapho usebenza ngama- spreadsheet amakhulu kakhulu, izihloko ezisezingeni eliphezulu futhi phansi phansi ngakwesokunxele kwephepha lokusebenzela ngokuvamile zanyamalala uma upheqela kude kakhulu ngakwesokudla noma kude kakhulu. Ukuze ugweme le nkinga, sebenzisa isici se-Excel sokuqhafaza . Ikhulula noma ikhiye amakholomu athile noma imigqa yesikhwama sokusebenzela ukuze bahlale bebonakala ngaso sonke isikhathi.
Ngaphandle kwezihloko, kunzima ukugcina ithrekhi yikholomu noma umugqa wedatha oyifunayo.
Izinketho ezahlukene zokufaka amafenisi amafayili yi:
- Faka umugqa ophezulu wephepha lokusebenzela
- Sula ikholomu yokuqala yephepha lokusebenzela
- Sula inombolo yomsebenzisi echazwe ngamakholomu nemigqa
- Vula ama-columns nemigqa
01 ngo-04
Ukuqhwaza nje Umzila Ophezulu Wephepha Lomsebenzi
- Vula ishidi lokusebenzela eliqukethe imigqa eminingi namakholomu wedatha.
- Chofoza kuthebhu Buka yebhebhoni .
- Chofoza inketho ye- Freeze Panes endaweni yangaphakathi yebhebhoni ukuze uvule imenyu ye-efrijini yehlisa imenyu.
- Chofoza ku- Freeze Top Row inketho kwimenyu.
- Umngcele omnyama kufanele ubonakale ngaphansi komugqa 1 kushidi lokusebenzela elibonisa ukuthi indawo engaphezulu komugqa ifriziwe .
- Skrolela phansi ngephepha lokusebenzela. Uma upheqa ngokwanele, imigqa engezansi irowu 1 izoqala ukunyamalala ngenkathi irowu 1 lizohlala esibukweni.
02 ka 04
Vala Ikholomu Yokuqala Yekhasi Lokusebenza
- Chofoza kuthebhu Buka yebhebhoni .
- Chofoza kuma- Panel ye-Freeze phakathi kwebhebhoni ukuze uvule uhlu olwehlisiwe.
- Chofoza ku- Freeze First Column ukhetho ohlwini.
- Umngcele omnyama kufanele ubonakale ngakwesokudla kwekholomu A kuphepha lokusebenzela elibonisa ukuthi indawo ngakwesokudla komugqa ifakwe efriziwe.
- Skrolela ngakwesokudla ekhasini lokusebenzela. Uma upheqa ngokwanele, amakholomu ngakwesokudla kwekholomu A uzoqala ukunyamalala ngenkathi ikholomu A lizohlala esibukweni.
03 ka 04
Sula amaKholamu womabili kanye nemigqa yephepha lokusebenzela
Inketho ye-Freeze Panes igxuma yonke imigqa ngenhla kweseli esebenzayo nawo wonke amakholomu ngakwesobunxele beselula esebenzayo.
Ukufometha kuphela lezo kholomu kanye nemigqa ofuna ukuhlala esikrinini, chofoza eseli ngakwesokudla kwamakholomu futhi ngezansi kwemigqa ofuna ukuhlala esibukweni.
Isibonelo sezinkinobho zokuqhaqhaza usebenzisa i-Cell Active
Ukugcina imigqa 1, 2, no-3 esikrinini namakholomu A no-B:
- Chofoza kuseli C4 ngegundane ukuze wenze iseli esebenzayo.
- Chofoza kuthebhu Buka yebhebhoni .
- Chofoza kuma- Panel ye-Freeze phakathi kwebhebhoni ukuze uvule uhlu olwehlisiwe.
- Cindezela inketho ye- Freeze Panes ohlwini ukuze ufeze kokubili amakholomu nemigqa.
- Umngcele omnyama kufanele ubonakale ngakwesokudla sekholomu B ekhasini lokusebenzela nangaphansi komugqa wesi-3 obonisa ukuthi izindawo ezingenhla nangakwesokudla kwemigqa ziye zaqhwa.
- Skrolela ngakwesokudla ekhasini lokusebenzela. Uma upheqa ngokwanele, amakholomu ngakwesokudla kwekholomu B azoqala ukunyamalala ngenkathi amakholomu A neB behlala esibukweni.
- Skrolela phansi ngephepha lokusebenzela. Uma uphenya okwanele, imigqa engezansi irowu 3 izoqala ukunyamalala ngenkathi imigqa engu-1, 2, no-3 izohlala esibukweni.
04 ka 04
Ukukhipha konke ama-Columns kanye nemigqa yeshidi lokusebenzela
- Chofoza kuthebhu Buka yebhebhoni.
- Chofoza ku-I- Freeze Panes icon ku- Ribbon ukuvula uhlu lwe- efriji ye-efrijini.
- Chofoza ku- Unfreeze Panes inketho kwimenyu.
- Umngcele omnyama obonisa amakholomu afriziwe nemigqa kumele inqabe kusuka ephepheni lokusebenzela .
- Uma upheqela ngakwesokudla noma phansi ekhasini lokusebenzela, izihloko ezigciniwe eziphezulu nakumakholomu amaningi angakwesokunxele ziyanyamalala esikrinini.