Hlela ama-Panes ku-Excel 2003

01 ka 05

Vala Amakholomu Nemizila ku-Excel nama-Freeze Panes

Ngezinye izikhathi kunzima ukufunda nokuqonda amaspredishithi amakhulu kakhulu. Uma upheqa kude kakhulu ngakwesokudla noma phansi, ulahlekelwa izihloko ezitholakala phezulu futhi phansi phansi ngakwesokunxele kwephepha lokusebenzela . Ngaphandle kwezihloko, kunzima ukugcina ithrekhi yikholomu noma umugqa wedatha oyifunayo.

Ukuze ugweme le nkinga sebenzisa ama- panels efrijini e-Microsoft Excel. Ikuvumela ukuba "imise" izindawo ezithile noma amaphasethi wespredishithi ukuze bahlale bebonakala ngaso sonke isikhathi lapho bepheqela ngakwesokudla noma phansi. Ukugcina izihloko esikrinini kwenza kube lula ukufunda idatha yakho kuwo wonke amaspredishithi.

Ukufundisa okuhlobene: I- Excel 2007/2010 I-Freeze Panes .

02 ka 05

Yenza ama-Panes asebenze ngokusebenzisa i-Active Cell

Uma usebenze ama- Freeze Panes ku-Excel, yonke imigqa engaphezu kweseli esebenzayo nawo wonke amakholomu ngakwesobunxele beseli esebenzayo iba seqhwa.

Ukufometha kuphela lezo kholomu kanye nemigqa ofuna ukuhlala esikrinini, chofoza eseli ngakwesokudla kwamakholomu futhi ngezansi kwemigqa ofuna ukuhlala esibukweni.

Isibonelo - ukugcina imigqa engu-1,2, no-3 kusikrini namakholomu A no-B, chofoza ku-cell C4 negundane. Bese ukhetha I- Window> Hlela ama-Panes kusuka kwimenyu, njengoba kuboniswe esithombeni ngenhla.

Ufuna olunye usizo?

Okulandelayo, isinyathelo esifushane ngesibonelo sesinyathelo esibonisa indlela yokusebenzisa isici sokuqhwala ku-Microsoft Excel.

03 ka 05

Ukusebenzisa i-Excel Auto Gcwalisa

Ukwenza ukuboniswa kwefriji yethu ibonakaliswe ngokuphawulekayo, sizofaka ngokushesha idatha ethile besebenzisa ukugcwalisa ngokuzenzekelayo ukuze kube lula ukubuka ama-panee amaqhwa.

Qaphela: Ukufundisa ngokwezifiso Ukugcwalisa ngokuzenzakalela kwe-Excel kukubonisa indlela ongeza ngayo uhlu lwakho lokugcwalisa ngokuzenzakalela.

1. Thayipha "uJanuwari" kuseli D3 bese ucindezela inkinobho ENTER ekhibhodi.
2. Khetha iselula D3 bese usebenzisa isibambo sokugcwalisa ekhoneni elingezansi elingakwesokudla le-cell D3 ukuze ugcwalise ngokuzenzakalela izinyanga zonyaka ophela ngo-Okthoba esitokisini M3.
3. Thayipha "ngoMsombuluko" kuseli C4 bese ucindezela inkinobho ENTER .
4. Khetha iseli C4 bese usebenzisa isibambo sokugcwalisa ukuze ugcwalise ngokuzenzakalela izinsuku zeviki ephela ngoLwesibili kuseli C12.
5. Thayipha inombolo "1" kuseli D4 futhi "2" kuseli D5.
6. Khetha kokubili amaseli D4 no-D5.
7. Sebenzisa isibambo sokugcwalisa esitokisini se-D5 ukuze ugcwalise ngokuzenzakalelayo esitokisini D12
8. Khipha inkinobho yegundane.
9. Sebenzisa isibambo sokugcwalisa esitokisini D12 ukuze ugcwalise ngokuzenzakalela ku-cell M12.

Izinombolo 1 kuya ku-9 kufanele zigcwalise amakholomu D kuya ku-M

04 ka 05

Ipholisa ama-Panes

Manje yingxenye elula:

1. Chofoza kuseli D4
2. Khetha Iwindi> Hlela ama-Panes kusuka kumenyu

Umzila omnyama ozobonakala uzovela phakathi kwamakholomu C no-D nomugqa oqondile phakathi kwemigqa 3 no-4.

Imigqa 1 kuya kwezingu-3 kanye namakholomu A kuya ku-C yizindawo ezifriziwe zesikrini.

05 ka 05

Hlola imiphumela

Sebenzisa imicibisholo yokupheqa ukuze ubone umphumela wezinhlaka zokuqandisa kwi-spreadsheet.

Skrolela phansi

• Sebenzisa umcibisholo wokupheqa oqondile ku-Excel ukuze upheqa phansi. Imigqa engu-1 kuya kwezingu-3 kufanele ihlale esibukweni, kufaka phakathi nezinyanga zonyaka kuyilapho izinombolo 1 kuya ku-9 zinyamalale ekhasini lesipredishithi.

Buyela esitokisini D4

1. Chofoza ebhokisini legama ngaphezulu kwekholomu A
2. Thayipha i-D4 ebhokisini legama bese ucindezela inkinobho ENTER ekhibhodi. Iseli esebenzayo iba ngu-D4 futhi.

Skrolela Phansi

• Sebenzisa umcibisholo wokupheqa oqondile ukupheqela ngakwesokudla. Ikholomu A kufanele ihlale esibukweni, kufaka phakathi izinombolo, ngenkathi izinyanga zonyaka zinyamalale ikhasi lesipredishithi.