Bvisa Panes muExcel 2003

01 ye 05

Chengetedza Ma Columns uye Row muExcel ne Freeze Panes

Dzimwe nguva zvakaoma kuverenga uye kunzwisisa mahwendefa makuru zvikuru. Paunopfuurira kure nechokurudyi kana pasi, iwe unorasikirwa nemisoro iyo iri kumusoro uye pasi kuruboshwe rwebasa . Pasina zvinyorwa, zvakaoma kuchengeta nhamba ye column kana mutsara we data iwe uri kutarisa.

Kuti udzivise dambudziko iri, shandisa mazhenje akaiswa mu Microsoft Excel. Iko inokubvumira "kuisa" dzimwe nzvimbo kana mapepa epaspiritsi kuitira kuti varambe vachionekwa nguva dzose kana vachipukunyuka kurudyi kana pasi. Kuchengetedza misoro pachikona kunoita kuti zvive nyore kuverenga data yako muparadzira rose.

Related tutorial: Excel 2007/2010 Freeze Panes .

02 of 05

Kusunungura Nzvimbo Dzakashandisa Using Active Cell

Paunoshandisa Freeze Panes muExcel, mitsetse yose pamusoro pemasare anoshandiswa uye dzose dziri kumativi kuruboshwe rwebasa rinoshandiswa rinova rakaoma.

Kuti usununguze chete zvinyorwa uye mitsetse iwe unoda kuramba uri pahwindo, tsvaga pachitokisi kuenda kurudyi rwema column uye pasi pemirara yaunoda kuramba uri pahwindo.

Semuenzaniso - kuchengetedza mitsetse 1,2, uye 3 pahwindo uye mapurumiti A neB, tsanangurira muchitsetse C4 ne mouse. Zvadaro sarudza Window> Fungira Nhengo kubva mumenyu, sezvinoratidzwa mumufananidzo uri pamusoro.

Unoda mamwe rubatsiro here?

Zvadaro, danho rfupi pfupi nemuenzaniso wekutsvaga rinokuratidza kuti ungashandisa sei kuisa mu Microsoft Excel.

03 of 05

Uchishandisa Excel Auto Fill

Kuita kuti firiji yedu ive pane kuratidza zvishoma zvinoshamisa, tichakurumidza kuisa imwe data tichishandisa Auto Fill kuitira kuti mamiriro ekugadzira zvipfeko zvive nyore kuona.

Cherechedza: Dzidzo Yokugadzira Excel Auto Kuzadza inokuratidza kuti ungawedzera sei mazita kuDzadza Kuzadza.

1. Tora "January" muchitokisi D3 uye shandisa ENTER key pabhodi.
2. Sarudza sero D3 uye shandisa gadziriro yekuzadza muzasi yekona yekona yekamuri D3 kuti gwaro rizadze mwedzi yegore inopera munaOctober muchitokisi M3.
3. Tora "Muvhuro" muchikamu C4 uye shandisa ENTER key.
4. Sarudza sero C4 uye shandisa chigadziro chokuzadza kumotokari kuzadza mazuva evhiki ichipera neChishanu muchitokisi C12.
5. Tora nhamba "1" muchitokisi D4 uye "2" muchitokisi D5.
6. Sarudza zvose masero D4 uye D5.
7. Shandisa chigadziro chokuzadza muchitokisi D5 kusvika pamoto chizadza muchitokisi D12
8. Bvisa mutsara.
9. Shandisa chigadziro chokuzadza muchitokisi D12 kusvika pamotokari chizadza kune imwe cell M12.

Nhamba dza1 kusvika ku9 dzinofanira kuzadza mapurumendi D kusvika kunaM.

04 of 05

Kusunungura mapoka

Iye zvino nokuda kwechikamu chakareruka:

1. Dzvanya pane cell D4
2. Sarudza Window> Sungai Mahedheni kubva kumenyu

Mutsara wakajeka wepakati uchaonekwa pakati pemakoronike C uye D uye mutsetse wakarurama pakati pemiganhu 3 ne4.

Mitsara 1 kusvika ku3 uye mapuranga A kusvika kuC ndiyo nzvimbo dzakanyanyisa zvechando.

05 of 05

Tarisa mhinduro

Shandisa miseve yemipumburu kuti uone kusviba kwemazhenje echando pachiparashiro.

Bhura pasi

• Shandisa mutsara wokupenya muExcel kuti upe pasi pasi. Mitsara 1 kusvika ku3 inofanira kuramba iri pachivharo, kusanganisira mwedzi yegore apo nhamba 1 kusvika ku 9 dzinopera pa peji repasiteti.

Dzokera kusero D4

1. Dzvanya paZita Razita riri pamusoro pe column A
2. Tora D4 muZita reBhokisi uye shandisa ENTER key pane keyboard. Inoshandiswa seki inova D4 zvakare zvakare.

Mipumburu Yese

• Shandisa museve wepumburu wakareba kuti upindure kurudyi. Column A inofanira kuramba iri pachikona, kusanganisira nhamba, apo mwedzi yegore inopera peji pepaji.