Njira 3 zochotsera ma sheet mu Excel. Mndandanda wazinthu, zida zamapulogalamu, mapepala angapo nthawi imodzi

Pogwira ntchito ndi zikalata ku Excel, ogwiritsa ntchito amatha kupanga mapepala atsopano, omwe nthawi zambiri amakhala ofunikira kwambiri kuti athetse ntchitoyi. Komabe, nthawi zambiri pamafunika kuchotsa mapepala osafunika ndi chidziwitso chosafunika, chifukwa amatenga malo owonjezera mu kapamwamba kamkonzi, mwachitsanzo, pamene pali zambiri ndipo mukufuna kuti zikhale zosavuta kusinthana pakati pawo. Mu mkonzi, ndizotheka kuchotsa masamba onse a 1 ndi zina zambiri panthawi imodzi. Nkhaniyi ikufotokoza njira zomwe zingatheke kuchita izi.

Kuchotsa pepala mu Excel

Buku la Excel lili ndi mwayi wopanga masamba angapo. Komanso, magawo oyambirira amaikidwa m'njira yoti chikalatacho chili ndi mapepala a 3 panthawi yolenga. Komabe, pali zochitika pamene wogwiritsa ntchito ayenera kuchotsa masamba angapo ndi chidziwitso kapena opanda kanthu, chifukwa amasokoneza ntchito. Izi zikhoza kuchitika m'njira zingapo.

Kuchotsa pepala pogwiritsa ntchito menyu yankhani

Kugwiritsa ntchito menyu yankhani ndiyo njira yodziwika bwino komanso yosavuta yochotsera, makamaka, pakudina kawiri:

1. Pazifukwa izi, menyu yankhani imagwiritsidwa ntchito, yomwe imatchedwa ndikudina kumanja patsamba lomwe liyenera kuchotsedwa.
2. Pazenera lomwe likuwoneka, sankhani "Chotsani".
   

   

3. Pambuyo pake, tsamba losafunika lidzachotsedwa kwamuyaya m'buku.

Kuchotsa kudzera pazida zamapulogalamu

Njira yoganiziridwayo si yotchuka kwambiri, koma ingagwiritsidwenso ntchito mofanana ndi ena.

1. Poyamba, pepala loti lichotsedwe limasankhidwa.
2. Kenako muyenera kupita ku "Home" menyu, dinani batani la "Maselo", pamndandanda womwe umatsegulidwa, dinani kachidutswa kakang'ono pafupi ndi batani la "Chotsani".
   

   

3. Sankhani "Chotsani Mapepala" kuchokera ku menyu yoyambira.
   

   

4. Tsamba lotchulidwa lichotsedwa m'buku.

Zofunika! Pamene zenera lomwe lili ndi pulogalamuyo likutambasulidwa kwambiri, fungulo la "Chotsani" likuwonetsedwa mu "Home" menyu popanda kufunikira kudina "Maselo" pasadakhale.

Kuchotsa mapepala angapo nthawi imodzi

Njira yochotsera mapepala angapo m'buku ndi yofanana ndi njira zomwe tafotokozazi. Komabe, kuti muchotse masamba angapo, musanayambe kuchitapo kanthu, ndikofunikira kusankha mapepala onse osafunikira kuti achotsedwe kwa mkonzi.

1. Masamba owonjezera akakonzedwa motsatizana, amatha kusankhidwa motere: pepala la 1 likudinda, kenako batani la "Shift" limakanizidwa ndikugwiridwa ndipo tsamba lomaliza limasankhidwa, kenako mutha kumasula batani. Kusankhidwa kwa mapepalawa kungathe kuchitika motsatira ndondomeko - kuchokera kumtunda mpaka koyambirira.
   

   

2. Munthawi yomwe masamba oti achotsedwe sapezeka motsatana, amagawidwa mosiyana. Batani la "Ctrl" likanikizidwa, mukadina batani lakumanzere, mapepala onse ofunikira amasankhidwa, kenako batani limatulutsidwa.
   

   

3. Pamene masamba osafunika aperekedwa, ndizotheka kuyambitsa ndondomeko yochotsa mwa njira iliyonse yomwe ili pamwambayi.

Kubwezeretsa pepala lochotsedwa

Nthawi zina zimachitika kuti wosuta molakwika fufutidwa mapepala mkonzi. Osati muzochitika zonse kudzakhala kotheka kubwezeretsa tsamba lochotsedwa. Palibe chidaliro chonse kuti tsambalo lidzabwezeretsedwa, komabe, muzochitika zingapo ndizotheka kupeza zotsatira zabwino.

Pamene cholakwika changwiro chinadziwika mu nthawi (musanayambe kusunga chikalata ndi zosintha), chirichonse chikhoza kukonzedwa. Muyenera kumaliza kugwira ntchito ndi mkonzi, dinani batani la mtanda kumanja kumanja kwa chikalatacho. Mu bokosi la zokambirana lomwe likuwoneka, sankhani "Osasunga" njira. Pambuyo pa kutsegulidwa kotsatira kwa chikalatacho, masamba onse adzakhalapo.

Zofunika! Ziyenera kukumbukiridwa kuti pokonzekera njira iyi yobwezeretsa, deta yomwe idalowetsedwa muzolemba pambuyo posungira komaliza (ngati pali kusintha kosintha) idzasowa. Pankhani imeneyi, wosuta adzakhala ndi kusankha zimene mfundo zofunika kwambiri kwa iye.

Ngati cholakwika chikupezeka pamene fayilo ikusungidwa, ndiye kuti mwayi wa zotsatira zabwino ndi wotsika kwambiri, koma muzochitika zotere pali mwayi wopambana.

1. Mwachitsanzo, mu mkonzi wa Excel 2010 komanso m'matembenuzidwe am'tsogolo, ndizotheka kutsegula "Fayilo" mumenyu yayikulu ndikusankha "Zambiri".
2. Pansi pakati pa polojekiti, mudzawona chipika cha "Mabaibulo", chomwe chili ndi mabuku osiyanasiyana. Iwo ali mmenemo chifukwa cha autosave, yomwe imachitika ndi mkonzi mwachisawawa mphindi 10 zilizonse (ngati wosuta sanalepheretse chinthu ichi).
   

   

3. Pambuyo pake, pamndandanda wamitundu, muyenera kupeza zaposachedwa ndi tsiku, ndikudina.
4. Pazenera lomwe limatsegulidwa, mutha kuwona buku losungidwa.
5. Kuti mumalize ndondomeko yobwezeretsa, dinani "Bwezerani" pamwamba pa tebulo.
6. Mkonzi akuganiza zosintha chikalata chosungidwa kale ndi wogwiritsa ndi mtundu uwu. Ngati mukufuna njira iyi, ndiye kuti muyenera dinani "Chabwino". Mukafuna kusunga njira iliyonse, muyenera kupatsa fayiloyo dzina losiyana.
   

   

Kukula kosasangalatsa kwa zochitika kungakhale njira yomwe chikalatacho sichinapulumutsidwe ndikutsekedwa. Wogwiritsa ntchito akazindikira kuti bukulo likusowa potsegulanso bukulo, mwayi wopeza chikalatacho ndi wotsika kwambiri. Mutha kuyesa kubwereza zomwe zachitika pachitsanzo cham'mbuyomu ndipo, mutatsegula zenera la "Version Control", sankhani "Bwezerani Mabuku Osapulumutsidwa". Ndizotheka kuti fayilo yofunikira ipezeka pamndandanda womwe umatsegulidwa.

Kuchotsa pepala lobisika

Pomaliza, ziyenera kunenedwa za njira yosavuta yochotsera pepala lomwe limabisidwa m'maso. Poyamba, iyenera kuwonetsedwa, yomwe batani lakumanja la mbewa likukanikiza pa chizindikiro chilichonse ndipo njira ya "Display" imatsegulidwa.

Tsamba lofunikira limasankhidwa pawindo, "Chabwino" ikanikiza. Njira yotsatila ndiyofanana.

Kutsiliza

Njira yochotsa mapepala osafunikira mu mkonzi ndiyosavuta komanso yosavuta. Komabe, nthawi yomweyo, nthawi zina ndizothandiza kwambiri "kutsitsa" buku ndikupangitsa kuti ntchito ikhale yosavuta. Pogwiritsa ntchito njira iliyonse yomwe ili pamwambayi, mukhoza kupeza zotsatira zabwino.