Momwe mungachotsere zolembedwa "Page 1" mu Excel

Excel ndi pulogalamu yapadziko lonse lapansi ndipo imakhala ndi mazana amitundu yosiyanasiyana yomwe imapangitsa kuti ikhale yosavuta kugwira ntchito ndi chikalata, kufulumizitsa kukonza zidziwitso, komanso ngakhale kupanga mapangidwe atsamba la data. Zowona, chifukwa cha kuchuluka kwa ntchito zosiyanasiyana, ogwiritsa ntchito ambiri akukumana ndi vuto loyang'ana chikalata, ndipo nthawi zina zinthu zosiyanasiyana zimatha kuyambitsa chibwibwi. Nkhaniyi idzasanthula momwe zinthu zilili pamene, potsegula chikalata, masamba angapo amawonekera nthawi imodzi kapena zolemba za "Page 1" zimasokoneza.

Kodi mawonekedwe a chikalata china ndi chiyani?

Musanayambe kuthana ndi vutoli, muyenera kuliphunzira mosamala. Si chinsinsi kuti mafayilo okhala ndi Excel yowonjezera amatha kusungidwa m'mitundu yosiyanasiyana. Mwachitsanzo, muyezo ndi "Regular Format", yomwe imapereka tebulo lathunthu ndi chidziwitso komanso kuthekera kosintha momasuka.

Chotsatira pakubwera "Mawonekedwe a Tsamba", izi ndizomwe zidzakambidwe. Nthawi zambiri amapulumutsidwa ndi wogwiritsa ntchito yemwe wakonza zomwe zili ndikusintha mawonekedwe a tebulo kuti asindikizidwe pambuyo pake. M'malo mwake, palibe chodetsa nkhawa, chifukwa mtundu wopulumutsa woterewu ndi zotsatira za kuyesa kusintha chikalatacho ngati chofunikira kuti muwonekere.

Palinso "Page mode", yomwe cholinga chake ndi kungophunzira zambiri mumtundu wa "chandamale" chokwanira. Ndiko kuti, munjira iyi, zambiri zosafunikira ndi ma cell opanda kanthu amatha patebulo, malo okhawo omwe amadzazidwa kwathunthu amatsalira.

Momwe mungachotsere zolemba patsamba 1 mu Excel
Zolemba "Page 1" mu Excel

Mitundu yonseyi imapangidwira kwa wogwiritsa ntchito yemwe akufuna kuwongolera chilichonse ndikugwiritsa ntchito mokwanira zomwe zilipo. Ngati nthawi zambiri mumayenera kugwira ntchito ndi matebulo, ndiye kuti pafupifupi mitundu yonseyi idzagwiritsidwa ntchito mwachangu osati pophunzira mosamala zonse, komanso pokonzekera matebulo osindikiza.

Njira yoyamba kusintha chikalata mtundu

Tsopano tiyeni tiwone njira yoyamba yosinthira mawonekedwe a chikalata, chomwe ndi chosavuta komanso chowongoka momwe tingathere. Idzakulolani kuti musinthe mawonekedwe a tebulo mumphindi zochepa kuti musasokonezedwe ndi zochita zina ndikuyamba kugwira ntchito ndi deta. Kuti muchite izi, muyenera kuchita izi:

  1. Yambitsani Excel ndikutsegula fayilo yomwe ili ndi mawonekedwe a tebulo lachilendo.
  2. Mukatsegula chikalatacho, tcherani khutu kumunsi kumanja kwa gulu, komwe kuwongolera kukula kwa mafonti nthawi zambiri kumakhala. Tsopano, kuwonjezera pa ntchito yosinthira makulitsidwe, pali zithunzi zina zitatu: tebulo, tsamba, ndi kuyika konsekonse.
  3. Ngati mukukumana ndi fayilo yomwe ili ndi masamba angapo kapena "Tsamba 1" lakumbuyo, ndiye kuti "Mapangidwe a Tsamba" imatsegulidwa ndipo imayimiridwa ngati chithunzi chachiwiri kuchokera kumanzere.
  4. Dinani kumanzere pa chithunzi choyamba cha "Regular Format", ndipo muwona kuti mawonekedwe a tebulo asintha.
  5. Mutha kusintha zomwe zilipo kapena kusintha tebulo lonse.
Momwe mungachotsere zolemba patsamba 1 mu Excel
Kugwiritsa ntchito njira yoyamba

Mwanjira imeneyi, mutha kusintha mwachangu mawonekedwe a chikalatacho ndikuwona momwe ogwiritsa ntchito ambiri amazolowera. Iyi ndiye njira yosavuta komanso yachangu kwambiri yomwe yapezeka m'mitundu yatsopano ya Excel.

Njira yachiwiri yosinthira mawonekedwe a chikalata

Tsopano ganizirani njira yachiwiri yosinthira chikalatacho, chomwe chingakuthandizeni kupeza mtundu womwe mukufuna kuti mugwiritse ntchito kapena kusintha. Muyenera kuchita izi:

  1. Tsegulani pulogalamu ya Excel.
  2. Tsegulani chikalata chokhala ndi mawonekedwe olakwika.
  3. Pitani ku bar yogwira ntchito.
  4. Sankhani View tabu.
  5. Ndikofunikira kusankha mtundu wa chikalatacho.

Njirayi imatenga nthawi yochulukirapo, koma ndi yapadziko lonse lapansi komanso yothandiza, Pambuyo pake, mosasamala kanthu za mtundu wa pulogalamuyo, mutha kupitako ndikuyambitsa mtundu womwe mukufuna.

Momwe mungachotsere zolemba patsamba 1 mu Excel
Kugwiritsa ntchito njira yachiwiri yowonera

Mawuwo

Tikukulimbikitsani kugwiritsa ntchito njira iliyonse yomwe ilipo, chifukwa iliyonse ndi yothandiza komanso yotsika mtengo. Chifukwa cha izi, mutha kusintha mwachangu mawonekedwe a chikalata kuti mugwiritse ntchito zambiri. Gwiritsani ntchito maupangiri ndikusintha luso lanu ngati wogwiritsa ntchito wapamwamba wa Excel.

Siyani Mumakonda