Chengetedza Column uye Row Headings Pa Screen ne Freeze Panes

Ramba uri munzira uye iwe uri kupi pane pepanheti

Paunenge uchishanda nema- spreadsheet makuru kwazvo, misoro iri kumusoro uye pasi kuruboshwe rwebasa rinowanzopera kana iwe ukapukunyuka kure kure kurudyi kana kure kure. Kuti udzivise dambudziko iri, shandisa Excel kufambisa panes pane. Inosunungura kana kuvhara mahwendefa chaiwo kana mitsetse yebasa rekushanda kuitira kuti varambe vachionekwa nguva dzose.

Pasina zvinyorwa, zvakaoma kuchengeta nhamba ye column kana mutsara we data iwe uri kutarisa.

Zvisarudzo zvakasiyana-siyana zvekukanda zvipfeko ndezvi:

01 ye 04

Kusunungura Icho Chete Chapamusoro chePepa Rokushanda

Kunyorera Icho Chete Row. © Ted French
  1. Vhura pepa rekushandisa raiva nemitsara yakawanda uye mapoka e data.
  2. Dzvanya paZviona tab yebhoni .
  3. Dzvanyira pa Freeze Panes sarudzo mukati mepakati penhibhoni kuti uzarure ganda rinopisa rinodonha pasi menyu.
  4. Dzvanya pa Freeze Top Row sarudzo mumenyu.
  5. Rutivi rwakasvibirira runofanira kuoneka pasi pemutsara 1 mubasa rekushanda rinoratidza kuti nzvimbo iri pamusoro pemuganhu yave yakaoma .
  6. Tora pasi pasi uchishanda. Kana iwe ukapeta zvakakwana, mitsara iri pasi pemutsara 1 inotanga kuparara kana rutsanga 1 ruchagara pahwindo.

02 of 04

Kusunungura Iro Rokutanga Rokutanga reShizha Rokushanda

Kusunungura Rutsigiro Rwekutanga Rwokushanda. © Ted French
  1. Dzvanya paZviona tab yebhoni .
  2. Dzvanya pa Freeze Panes pakati pebhoni kuitira kuti uzarure pasi.
  3. Dzvanya pa Freeze First Column chokutora mune urongwa.
  4. Rutivi rwakasvibirira runofanira kuonekwa kurudyi rwekoropu A mune pepa rekushandura rinoratidza kuti nzvimbo kuenda kurudyi rwetambo yave yakaoma.
  5. Bhura kurudyi mune pepa rekushanda. Kana iwe ukapupurira zvakakwana, mapuranga kurudyi rwekoropu A inotanga kuparara apo chinyorwa A chichagara pahwindo.

03 of 04

Kusunungura Mahwendefa maviri neMirairo yePepa Rokushanda

Kusunungura Mahwendefa maviri neMirairo yePepa Rokushanda. © Ted French

The Freeze Panes sarudzo inosvibisa mitsetse yose pamusoro peiyo sero inoshandiswa uye dzose dziri kumativi kuruboshwe rwebasa rinoshanda.

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

Muenzaniso weZvipfeko Zvinoshandiswa Kushandisa Active Cell

Kuchengeta mitsetse 1, 2, uye 3 pachikona uye mapurumiti A uye B:

  1. Dzvanya muchitokisi C4 ine mouse kuitira kuti iite sero rinoshanda.
  2. Dzvanya paZviona tab yebhoni .
  3. Dzvanya pa Freeze Panes pakati pebhoni kuitira kuti uzarure pasi.
  4. Dzvanya pa Freeze Panes sarudzo mune urongwa kuisa mazamu maviri nemitsetse.
  5. Muganhu wepakati unofanira kuonekwa kune kodzero yekhomu B mune pepa rekushanda uye pasi pemutsara wechitatu unoratidza kuti nzvimbo dziri pamusoro uye kurudyi kwemiganhu dzave dzakanyanyiswa.
  6. Bhura kurudyi mune pepa rekushanda. Kana iwe ukapeta zvakakwana, mapuranga kurudyi rwekomba B ichatanga kuparara apo mapuranga A uye B vacharamba vari pahwindo.
  7. Tora pasi pasi uchishanda. Kana iwe ukapeta zvakakwana, mitsara iri pasi pemutsara wechitatu ichatanga kuparara kana mitsetse 1, 2, uye 3 dzichagara pahwindo.

04 we 04

Unfreezing All Columns uye Rows of Worksheet

Unfreezing All Columns and Rows. © Ted French
  1. Dzvanya paZviona tab yebhoni.
  2. Dzvanya pa Freeze Panes icon pane ribhoni kuti uzarure ganda rinopisa ruka pasi.
  3. Dzvanya pane Unfreeze Panes sarudzo mumenyu.
  4. Iyo miganhu yakasviba (s) inoratidza mazamu akaomeswa nemitsetse inofanira kupera kubva pamushandi webasa .
  5. Paunopfuurira kurudyi kana pasi pasi pebasa rekushanda, misoro iri mumigwagwa yepamusoro uye kuruboshwe yakawanda yakawanda inonyangarika pavharo.