Momwe Mungasinthire Mizati Yambiri mu Excel

Kutha kuyimitsa mizati mu Excel ndi gawo lothandiza pa pulogalamu yomwe imakulolani kuti muyimitse malo kuti chidziwitso chiwonekere. Ndizothandiza pogwira ntchito ndi matebulo akuluakulu, mwachitsanzo, pamene mukufunikira kufananitsa. Ndizotheka kuzizira ndime imodzi kapena kutenga angapo nthawi imodzi, zomwe tidzakambirana mwatsatanetsatane pansipa.

Momwe mungasinthire gawo loyamba mu Excel?

Kuti muwongolere mzere umodzi, muyenera kuchita izi:

1. Tsegulani fayilo ya tebulo yomwe mukufuna kusintha.
2. Pitani ku toolbar mu gawo la "View".
3. Pezani zomwe mukufuna kuchita "Lock areas".
4. Pamndandanda wotsikira pansi, sankhani "Ikani ndime yoyamba".

Mukamaliza masitepewo, mudzawona kuti malirewo asintha pang'ono, atakhala akuda komanso ochepa kwambiri, kutanthauza kuti akhazikika, ndipo pophunzira tebulo, chidziwitso cha gawo loyamba sichidzatha ndipo, kwenikweni, zidzakhazikika m'maso.

Momwe mungasinthire magawo angapo mu Excel?

Kuti mukonze mizati ingapo nthawi imodzi, muyenera kuchita zingapo zowonjezera. Chinthu chachikulu kukumbukira ndi chakuti zipilala zimawerengedwa kuchokera kumanzere kwambiri, kuyambira ndi A. Chifukwa chake, sikutheka kuzizira mizati ingapo yosiyana kwinakwake pakati pa tebulo. Chifukwa chake, kuti mugwiritse ntchito ntchitoyi, muyenera kuchita izi:

1. Tiyerekeze kuti tikufunika kuzizira mizati itatu nthawi imodzi (matchulidwe A, B, C), ndiye choyamba sankhani gawo lonse D kapena selo D.

2. Pambuyo pake, muyenera kupita ku toolbar ndikusankha tabu yotchedwa "View".
3. M'menemo, muyenera kugwiritsa ntchito njira "Imaundana madera".

4. Pamndandanda mudzakhala ndi ntchito zingapo, pakati pawo muyenera kusankha "Ikani madera".
5. Ngati zonse zachitika molondola, ndiye kuti mizati itatu yosonyezedwayo idzakhazikika ndipo ingagwiritsidwe ntchito ngati gwero la chidziwitso kapena kufananitsa.

Tcherani khutu! Muyenera kungoyimitsa zipilala ngati zikuwonekera pazenera. Ngati iwo abisika kapena amapita kupyola kuwonekera kowonekera, ndiye kuti ndondomeko yokonzekera sizingatheke kutha bwino. Chifukwa chake, pochita zinthu zonse, muyenera kusamala kwambiri ndikuyesera kuti musalakwitse.

Momwe mungasinthire mzere ndi mzere nthawi imodzi?

Pakhoza kukhala zinthu zotere kuti muyenera kuyimitsa ndime nthawi imodzi pamodzi ndi mzere wapafupi, kuti mugwiritse ntchito kuzizira, muyenera kuchita izi:

1. Poyamba, muyenera kugwiritsa ntchito selo ngati maziko. Chofunikira chachikulu pankhaniyi ndikuti selo liyenera kukhala mosamalitsa pamzere wa mzere ndi mzere. Poyamba, izi zitha kumveka zovuta, koma chifukwa cha chithunzi chojambulidwa, mutha kumvetsetsa zovuta za mphindi ino.
2. Pitani ku Toolbar ndi ntchito "View" tabu.
3. M'menemo muyenera kupeza chinthu "Ikani madera" ndikudina pa izo ndi kumanzere mbewa batani.
4. Kuchokera pamndandanda wotsitsa, ingosankhani njira ya "Ikani madera".

Ndizotheka kukonza mapanelo angapo nthawi imodzi kuti mugwiritsenso ntchito. Mwachitsanzo, ngati mukufuna kukonza mizati iwiri yoyambirira ndi mizere iwiri, ndiye kuti muyang'ane bwino muyenera kusankha selo C3. Ndipo ngati mukufuna kukonza mizere itatu ndi mizati itatu mwakamodzi, chifukwa cha ichi muyenera kusankha selo D4 kale. Ndipo ngati mukufuna seti yopanda muyezo, mwachitsanzo, mizere iwiri ndi mizati itatu, ndiye kuti muyenera kusankha selo D3 kuti mukonze. Kujambula kufanana, mukhoza kuona mfundo yokonza ndikuigwiritsa ntchito molimba mtima patebulo lililonse.

Momwe mungasinthire zigawo mu Excel?

Pambuyo pazidziwitso zochokera pamzati zokhomedwa zagwiritsidwa ntchito mokwanira, muyenera kuganizira momwe mungachotsere pinning. Pali ntchito yapadera pankhaniyi, ndipo kuti mugwiritse ntchito, muyenera kuchita izi:

1. Gawo loyamba ndikuwonetsetsa kuti mizati yokhonidwa sikufunikanso pa ntchito yanu.
2. Tsopano pitani ku toolbar pamwamba ndi kupita ku "View" tabu.
3. Gwiritsani ntchito mawonekedwe a Freeze Regions.
4. Kuchokera pamndandanda wotsikira pansi, sankhani chinthu cha "Unfreeze regions".

Zonse zikangochitika, pinning idzachotsedwa, ndipo zidzatheka kugwiritsa ntchito mawonekedwe oyambirira a tebulo kachiwiri.

Kutsiliza

Monga mukuonera, kugwiritsa ntchito pinning sikovuta kwambiri, ndikokwanira kugwiritsa ntchito mwaluso zonse zomwe zilipo ndikutsatira mosamala malangizowo. Ntchitoyi ndi yotsimikizika kubwera imathandiza, kotero muyenera kukumbukira mfundo ntchito yake.