Kutumidzazve mapepa muExcel

Paunenge uchigadzira gwaro idzva muExcel, tinogona kuona tabu imwe kana anopfuura pazasi, ayo anonzi mashizha ebhuku. Mukufamba kwebasa, tinogona kuchinja pakati pavo, kugadzira zvitsva, kubvisa zvisingakoshi, nezvimwewo. Purogiramu inongopa mazita etemplate ane nhamba dzakatevedzana kune mapepa: "Sheet1", "Sheet2", "Sheet3", nezvimwewo. vashoma chete vavo, hazvina kunyanya kukosha. Asi kana iwe uchifanira kushanda nenhamba huru yemashizha, kuti zvive nyore kufamba mazviri, unogona kuzvitumidza zvakare. Ngationei kuti izvi zvinoitwa sei muExcel.

Kutumidzazve pepa

Iro zita harigoni kuva nemabhii anodarika makumi matatu nerimwe, asi harifanire kunge risina chinhu zvakare. Inogona kushandisa mavara kubva kune chero mutauro, nhamba, nzvimbo, uye zviratidzo, kunze kwezvinotevera: “?”, “/”, “”, “:”, “*”, “[]”.

Kana nekuda kwechimwe chikonzero zita risingakodzeri, Excel haingakubvumiri kuti upedze iyo yekupa zita.

Iye zvino ngatiendei zvakananga kune nzira dzaunoshandisa iwe unogona kutumidzazve mapepa.

Method 1: Kushandisa Context Menu

Iyi nzira ndeimwe yeanonyanya kufarirwa pakati pevashandisi. Inoitwa sezvinotevera:

1. Tinya-kurudyi pane pepa label, uye ipapo mune yemukati menyu inovhura, sarudza iwo rairo "Rename".
2. Iyo shizha zita rekugadzirisa modhi yakavhurwa.
3. Isa zita raunoda wodzvanya pindaizvo zvichengetedze.

Method 2: tinya kaviri pane sheet label

Kunyangwe iyo nzira yakatsanangurwa pamusoro iri nyore, pane yakatove nyore uye nekukurumidza sarudzo.

1. Tinya kaviri papepa rabel nebhatani rekuruboshwe.
2. Iro zita rinozoshanda uye tinogona kutanga kurigadzirisa.

Nzira 3: Kushandisa Ribhoni Tool

Iyi sarudzo inoshandiswa zvishoma kazhinji pane maviri ekutanga.

1. Nekusarudza pepa raunoda mune iyo tab "Kumba" tinya pane bhatani "Fomati" (block of tools "Masero").
2. Muchinyorwa chinovhurwa, sarudza murairo "Rename Sheet".
3. Tevere, isa zita idzva worichengeta.

Cherechedza: Paunenge uchida kutumidza zita kwete rimwe chete, asi nhamba huru yemashiti kamwechete, unogona kushandisa akakosha macros uye ekuwedzera akanyorwa nevechitatu-bato vanogadzira. Asi sezvo rudzi urwu rwekushanda ruchidiwa muzviitiko zvisingawanzoitiki, hatingagari pairi zvakadzama mukati megadziriro yebhuku rino.

mhedziso

Saka, vanogadzira chirongwa cheExcel vakapa nzira dzakati wandei kamwechete, vachishandisa iyo yaunogona kupa zita remapepa mubhuku rebasa. Iwo akareruka zvakanyanya, zvinoreva kuti kuti ugone uye uyeuke iwo, iwe unofanirwa kuita nhanho idzi kashoma.