Mukasindikiza chikalata cha Excel, kaŵirikaŵiri zimakhala choncho kuti spreadsheet silingagwirizane ndi pepala lokhazikika. Choncho, zonse zomwe zimapitirira malire awa, osindikiza amajambula pamapepala ena. Koma, nthawi zambiri, mkhalidwewu ukhoza kukonzedwa mwa kusintha kusintha kwa chilembedwecho kuchokera ku bukhu loyamba, limene laikidwa ndi chosasintha, ku malo amodzi. Tiyeni tione momwe tingachitire izi pogwiritsa ntchito njira zosiyanasiyana mu Excel.
Phunziro: Momwe mungapangire pepala loyang'ana malo ku Microsoft Word
Tsamba likufalitsidwa
Mu ntchito ya Excel pali njira ziwiri zomwe mungakwaniritsire mapepala mukasindikiza: chithunzi ndi malo. Yoyamba ndi yosasintha. Izi zikutanthauza kuti ngati simunagwiritse ntchito malingaliro amenewa, mukhoza kusindikizidwa mukamasindikizidwa mu zithunzi. Kusiyanitsa kwakukulu pakati pa mitundu iwiriyi ya malo ndikuti ndi chithunzicho chimatsogolera kutalika kwa tsamba ndi chachikulu kuposa kukula, ndipo ndi malo amodzi - mosiyana.
Ndipotu, mapulogalamu a tsambali amatha kufalikira kuchokera kumalo ojambula zithunzi kupita ku malo omwe ali mu pulogalamu ya Excel ndi imodzi yokha, koma ikhoza kuyambitsidwa pogwiritsira ntchito chimodzi mwazinthu zingapo. Pankhaniyi, pa tsamba lirilonse la bukhuli, mungagwiritse ntchito malo anu enieni. Pa nthawi yomweyi, mkati mwa pepala limodzi, parameter iyi silingasinthe kwazigawo zake (mapepala).
Choyamba, muyenera kudziwa ngati mutatembenuzidwa. Pachifukwa ichi, mungagwiritse ntchito chithunzi. Kuti muchite izi, pitani ku tabu "Foni"Pitani ku gawo "Sakani". Kumanzere kwawindo pali chisonyezero cha chikalatacho, chomwe chidzawoneka ngati kusindikizidwa. Ngati ndege yopanda malire imagawidwa m'masamba angapo, izi zikutanthauza kuti tebulo silikugwirizana pa pepala.
Ngati zitatha izi tibwerera ku tabu "Kunyumba" ndiye tidzawona mzere wochepa wolekanitsa. Pachilumbacho mutatsegula tebulo m'magawo ena, ichi ndi umboni wowonjezera kuti pamene kusindikiza mizati yonse pa tsamba limodzi sikugwira ntchito.
Poona izi, ndibwino kusintha ndondomeko ya zolembazo ku malo.
Njira 1: Zida Zopanga
Kawirikawiri, ogwiritsa ntchito zidazi muzokonzedwa kusindikiza tsamba.
- Pitani ku tabu "Foni" (Mu Excel 2007, mmalo mwake, dinani pa Microsoft Office logo kumtunda wapamwamba kumanzere pawindo).
- Pitani ku gawo "Sakani".
- Malo owonetserako kale omwe tidziwa kale amayamba. Koma nthawi ino sichidzatikondweretsa. Mu chipika "Kuyika" dinani pa batani "Kuwerenga Buku".
- Kuchokera pamndandanda wotsika pansi, sankhani chinthucho "Maonekedwe a malo".
- Pambuyo pake, malingaliro a masamba a Active Excel pepala adzasinthidwa kukhala malo, omwe angakhoze kuwonetsedwa pawindo kuti ayang'anire chithunzicho.
Njira 2: Tab ya Tsamba la Tsamba
Pali njira yosavuta yosinthira chiyambi cha pepala. Icho chikhoza kuchitika mu tabu "Tsamba la Tsamba".
- Pitani ku tabu "Tsamba la Tsamba". Dinani pa batani "Malingaliro"yomwe ili mu chida chogwiritsa ntchito "Makhalidwe a Tsamba". Kuchokera pamndandanda wotsika pansi, sankhani chinthucho "Malo".
- Pambuyo pake, malingaliro a pepala lamakono adzasinthidwa kukhala malo.
Njira 3: Sinthani kutsogolo kwa mapepala ambiri panthawi yomweyo
Mukamagwiritsira ntchito njira zomwe tazitchula pamwambapa, pepala lokha limasintha. Panthawi imodzimodziyo, n'zotheka kugwiritsa ntchito parameteryi kuzinthu zingapo zofanana pa nthawi yomweyo.
- Ngati mapepala omwe mukufuna kugwiritsa ntchito gululo ali pafupi ndi wina ndi mzake, kenaka tekani batani Shift pa kambokosi ndipo, popanda kumasula, dinani pa lemba yoyamba ili kumunsi kumanzere kwawindo pamwamba pa barreti. Kenaka dinani pa lemba lomaliza la zosiyana. Motero, lonse lonse lidzakambidwa.
Ngati mukufunikira kusinthanso ma tsamba pamasamba angapo, malemba omwe sali pambali pa wina ndi mzake, ndiye kusintha kwa zochita ndi kosiyana kwambiri. Sambani batani Ctrl pabokosilo ndipo dinani njira iliyonse yomwe mukufuna kuchita, ndi batani lamanzere. Choncho, zinthu zofunika zidzakambidwe.
- Pambuyo chisankhocho chitapangidwa, chitani zomwe tidziwa kale. Pitani ku tabu "Tsamba la Tsamba". Timakanikiza batani pa tepiyi "Malingaliro"ili mu gulu la zida "Makhalidwe a Tsamba". Kuchokera pamndandanda wotsika pansi, sankhani chinthucho "Malo".
Pambuyo pake, mapepala onse osankhidwa adzakhala ndi chitsogozo cha pamwamba.
Monga mukuonera, pali njira zingapo zosinthira zojambulajambula ku malo. Njira ziwiri zoyankhulidwa ndi ife zimagwiritsidwa ntchito posintha magawo a pepala lamakono. Kuonjezerapo, pali njira ina yomwe ingakuthandizeni kusintha maulendo angapo panthawi imodzi.
