Momwe mungachotsere kuchuluka kwa masamba

Anonim

Chotsani manambala a masamba mu Microsoft Excel

Kuwerengera masamba ndi chida chothandiza kwambiri, chomwe chimakhala chosavuta kulinganiza chikalata chosindikiza. Inde, ma sheet owerengedwa ndiwosavuta kwambiri kuwola. Inde, ndipo mwina akasakanikirana mwadzidzidzi mtsogolo, mutha kupinda molingana ndi ziwerengero zawo. Koma nthawi zina zimafunikira kuchotsa izi pambuyo poikidwa mu chikalatacho. Tiyeni tichitepo ndi momwe zingachitikire.

Malonda a tsamba ndi olumala mu Microsoft Excel

Palinso kusiyana kwa kusintha kwa kusintha pogwiritsa ntchito zida za tepi.

  1. Timasamukira ku "kuwona".
  2. Kusintha ku Microsoft Excel TAB

  3. Pa tepi mu gawo la "BUKU LAPANSI", dinani batani "labwinobwino" kapena "chizindikiro cha patsamba"

Kutembenuza Tsamba logwiritsa ntchito mabatani pa tepi mu Microsoft Excel

Pambuyo pake, mtundu wa tsamba udzakhala wolumala, ndipo zowerengera zakumbuyo zidzatha.

Phunziro: Momwe Mungachotsere patsambalo 1 Kuyambiranso

Njira 2: kuyeretsa

Palinso zochitika zina pogwira ntchito ndi tebulo pomwepo, zomwe zikuwerengetsa siziwoneka, koma zimawoneka pakusindikiza chikalata. Komanso, imatha kuwoneka pawindo lachiwonetsero la chikalatacho. Kuti mupite kumeneko, muyenera kusamukira ku tabu ya "fayilo", kenako mumenyu ya kumanzere, sankhani "zolemba". Kumbali yakumanja kwa zenera lomwe limatsegula malo owonetseratu chikalatacho. Ndizomwe zingawoneke ngati tsamba lomwe likusindikiza lidzawerengedwa kapena ayi. Zipinda zimatha kukhala pamwamba pa pepalalo, pansi kapena m'mizere yonseyi nthawi yomweyo.

Kulemba pawindo lachiwonetsero mu Microsoft Excel

Mtundu wamtunduwu umachitika pogwiritsa ntchito oyenda maulendo. Awa ndi minda yobisika, deta yomwe imawoneka yosindikiza. Amagwiritsidwa ntchito powerengera, kuyika zolemba zosiyanasiyana, etc. Nthawi yomweyo, lembani tsambalo, simuyenera kupanga nambala iliyonse patsamba lililonse. Zokwanira pa tsamba limodzi, kukhala munjira yofananira, lembani ku gawo lililonse lapamwamba kapena zitatu. Mawu:

& [Patsamba]

Pambuyo pake, kudzera pamasamba onse adzachitidwa. Chifukwa chake, kuti muchotse izi, mungoyenera kuyeretsa mutuwo kuchokera pazomwe zili, ndikusunga chikalatacho.

  1. Choyamba, kukwaniritsa ntchito yathu yomwe mukufuna kupita kumiyendo. Izi zitha kuchitika mothandizidwa ndi zosankha zingapo. Timasamukira ku "kuyika" ndikudina batani la "wofananira", lomwe limapezeka pa tepiyo m'thupi.

    Pitani kunjira yolowera mu Inb Tob mu Microsoft Excel

    Kuphatikiza apo, mutha kuona otsikirako, ndikusunthira mu mtundu wa Tsamba la Tsamba, kudzera pachizindikiro kutichidziwa kale kwa ife pa bar. Kuti muchite izi, dinani pa chithunzi chapakati cha mitundu yomwe ikuwonera, yomwe imatchedwa "patsamba lolemba".

    Sinthanitsani ku Tsamba la Tsamba la Tsamba Via Via pa bar ya Microsoft Excel

    Njira ina imapereka mwayi wosinthana ndi "Onani" tabu. Payenera kuyikidwa pa batani la "Tsamba la Tsamba" pa tepi pa "buku la Buku Loona" Chida.

  2. Sinthani ku Tsamba la Tsamba la Tsamba kudzera pa batani pa tepi mu Microsoft Excel

  3. Mulimonse momwe mungasankhidwira, muwona zomwe zili patsamba. Kwa ife, nambala ya masamba ili kumanzere kumanzere ndikumanzere kumanzere.
  4. Kulemba masamba oyenda m'microsoft Excel

  5. Ingokhazikitsa cholembera mu gawo lolingana ndikudina batani la Delete pa kiyibodi.
  6. Chotsani kujambula mumunda wa Microsoft Excel

  7. Monga mukuwonera, zitatha izi, kuchuluka kwa manambala sikungoyang'ana pakona yakumanzere kwa tsamba pomwe wotsatsa wotsika amachotsedwa, komanso pazinthu zina zonse za chikalatacho pamalo omwewo. Momwemonso, fufutani zomwe zili patsamba. Timakhazikitsa chotemberero ndi dongo pa batani lochotsa.
  8. Kuchotsa wofinya mu Microsoft Excel

  9. Tsopano izi zonse m'mayendedwe zimachotsedwa, titha kusinthana ndi ntchito wamba. Kuti muchite izi, kaya mu "kuwona" tabu podina batani "labwinobwino", kapena mu bar, dinani batani ndi dzina lomweli.
  10. Pitani ku ntchito wamba ku Microsoft Excel

  11. Musaiwale kuyankha chikalatacho. Kuti muchite izi, ndikokwanira kutsekedwa pachizindikiro chomwe chili ndi diskette mawonekedwe ndipo ili pakona yakumanzere ya pazenera.
  12. Kusunga chikalata ku Microsoft Excel

  13. Pofuna kuonetsetsa kuti zipindazo zidazimiririka ndipo sizimawoneka pa Zisindikizo, timasunthira ku "fayilo" tabu.
  14. Pitani ku fayilo ya fayilo ku Microsoft Excel

  15. Pazenera lomwe limatsegula, pitani ku gawo la "chosindikizira" kudzera mumenyu. Monga mukuwonera, m'dera lomwe limadziwika kale kuti likuwonera masamba omwe ali mu chikalatacho sichinakhalepo. Izi zikutanthauza kuti ngati titayamba kusindikiza buku, ndiye kuti tidzapeza ma sheeti osawerengera, zomwe zikuyenera kuchitika.

Mndandanda osawerengera mu Microsoft Excel

Kuphatikiza apo, mutha kuyimitsa mapazi.

  1. Pitani ku "fayilo" tabu. Pitani ku "kusindikiza". Mu gawo lalikulu la zenera, zosindikizira zimayikidwa. Pansi pa chipika ichi, timadina pa "zolemba za masamba".
  2. Sinthani ku makonda a Tsamba mu Microsoft Excel

  3. Zenera lokhazikika la Tsamba limayamba. Mumunda "Wapamwamba" ndi "wofatsa" kuchokera pamndandanda wotsika, sankhani njira "(Ayi)". Pambuyo pake, timadina batani la "OK" pansi pazenera.
  4. Zenera lokhazikika pa Tsamba la Microsoft Excel

  5. Monga momwe mungayang'anire m'deralo lowonetsera, kuchuluka kwa mapepala kumatha.

Palibe mapepala owerengera mu Microsoft Excel

Phunziro: Momwe Mungachotsere Mafashoni Abwino

Monga mukuwonera, kusankha kwa njira yobwezeretsera tsamba kumatengera ndendende momwe kuchuluka kwa manambala kumaonjezera. Ngati zikuwonetsedwa kokha pa chophimba cholozera, ndikokwanira kusintha mawonekedwe. Ngati ziwerengero zikuwonetsedwa, ndiye kuti muoneni mu izi muyenera kuchotsa zomwe zili patsamba laolowera.

Werengani zambiri