Kusinthanso masamba mu Excel

Popanga chikalata chatsopano ku Excel, timatha kuwona tabu imodzi kapena zingapo pansi, zomwe zimatchedwa mapepala a mabuku. M'kati mwa ntchito, tikhoza kusinthana pakati pawo, kupanga zatsopano, kuchotsa zosafunikira, ndi zina zotero. Pulogalamuyi imangopereka mayina a template ndi manambala otsatizana ku mapepala: "Sheet1", "Sheet2", "Sheet3", ndi zina zotero. ndi ochepa chabe, si ofunika kwambiri. Koma mukayenera kugwira ntchito ndi mapepala ambiri, kuti zikhale zosavuta kuyendamo, mukhoza kuwatchulanso. Tiyeni tiwone momwe izi zimachitikira mu Excel.

Kusintha dzina la pepala

Dzina latsambalo silingakhale ndi zilembo 31, koma lisakhalenso lopanda kanthu. Itha kugwiritsa ntchito zilembo zochokera m'chinenero chilichonse, manambala, malo, ndi zizindikiro, kupatula izi: "?”, “/”, “”, “:”, “*”, “[]”.

Ngati pazifukwa zina dzinalo siliyenera, Excel silingalole kuti mumalize kusinthiranso.

Tsopano tiyeni tipite mwachindunji ku njira zomwe mungathe kutchulanso mapepala.

Njira 1: Kugwiritsa Ntchito Menyu Yapakatikati

Njira iyi ndi imodzi mwazodziwika kwambiri pakati pa ogwiritsa ntchito. Imayendetsedwa motere:

1. Dinani kumanja pa pepala lolemba, ndiyeno mumenyu yankhani yomwe imatsegulidwa, sankhani lamulo "Rename".
2. Njira yosinthira dzina lashiti imayatsidwa.
3. Lowetsani dzina lomwe mukufuna ndikudina Lowaniizo zisunge izo.

Njira 2: dinani kawiri pa chizindikiro cha pepala

Ngakhale njira yomwe tafotokozayi ndi yosavuta, pali njira yosavuta komanso yachangu.

1. Dinani kawiri pa pepala lolemba ndi batani lakumanzere la mbewa.
2. Dzinalo liyamba kugwira ntchito ndipo titha kuyamba kulikonza.

Njira 3: Kugwiritsa Ntchito Riboni

Njirayi imagwiritsidwa ntchito mocheperapo kuposa ziwiri zoyambirira.

1. Posankha pepala lomwe mukufuna pa tabu "Pofikira" dinani batani "Mtundu" (block of tools "Maselo").
2. Pamndandanda umene ukutsegulidwa, sankhani lamulo "Rename Sheet".
3. Kenako, lowetsani dzina latsopano ndikulisunga.

Zindikirani: Mukafuna kutchulanso dzina limodzi, koma masamba ambiri nthawi imodzi, mutha kugwiritsa ntchito ma macros apadera ndi zowonjezera zomwe zidalembedwa ndi opanga chipani chachitatu. Koma popeza kuti kachitidwe kotere kakufunika nthawi zina, sitidzakambirana mwatsatanetsatane mwatsatanetsatane m'bukuli.

Kutsiliza

Chifukwa chake, omwe akupanga pulogalamu ya Excel apereka njira zingapo nthawi imodzi, pogwiritsa ntchito zomwe mutha kutchulanso mapepala mubuku lantchito. Ndizosavuta kwambiri, zomwe zikutanthauza kuti kuti muzitha kuzikumbukira bwino, muyenera kuchita izi kangapo.