Maitiro ekugadzirisa iyo tafura musoro muExcel. Kuvhara mutsara wepamusoro, wakasarudzika cap

Anonim

Paunenge uchishanda nematafura akareba asina kuiswa pachiratidziro uye kuve nehuwandu hwekoramu, kukosha kwekupururudza skrini kuti ubudise mutsara wepamusoro pamwe nemusoro zvichaitika nguva nenguva. Kuti uwane nyore muhurongwa hwekuwedzera, zvinokwanisika kugadzirisa iyo tafura yezvipata kumusoro kwechiratidzo kwenguva yese kusvikira iyo faira yakavhurika. Pazasi pane sarudzo dzekuita izvi.

Izvo zvinodikanwa kuchengetedza tambo imwe chete yepamusoro.

Maitiro ekugadzirisa iyo tafura musoro muExcel. Kuvhara mutsara wepamusoro, wakasarudzika cap 19746_1
Kutevedzana kwezviito kuchengetedza tambo
  1. Muchikepe chepamusoro chechirongwa, iwe unofanirwa kuenda ku "maonero" tab.
  2. Muchikamu "hwindo" (mazita ekuparadzanisa akanyorwa pazasi pe tepi) kuti awane icho chinhu "chimisa nzvimbo" uye tinya pane iyo trangerle mune chairo chikamu.
  3. Mune rondedzero iyo inovhura, sarudza "chengetedza tambo yepamusoro" nekudzvanya bhatani rekuruboshwe mbeva. Mhedzisiro yacho ichave inovapo isingagumi patafura yemusoro wetambo, akaponeswa uye mushure mekuvhara iyo faira.

Kugadzirira CAPS mumitsetse yakati wandei

Kana mitsara mizhinji inodikanwa, woita chiito chakasiyana:
  1. Mune yakanyanya kuruboshwe yetafura, tinya pachiteshi chechitambo chekutanga chisiri chikamu che cap. Mune ino kesi, ichi chisero che3.

  2. Enda kune "maonero" tab, tinya pane "gadzirisa nzvimbo" uye mune yekuregerera rondedzero sarudza iyo yakaonekwa chinhu kuti "simbisa nzvimbo". Nekuda kweizvozvo, mitsara yese iri pamusoro peiyo iyo iyo isiriyo sero rakasarudzwa rakanyorwa pamusoro pechidzitiro.

"Smart tafura" - imwe sarudzo yekutsikisa ngowani

Iye anoziva matafura akangwara excel anogona kutora mukana weimwe nzira inoshanda yekubatanidzwa. Chokwadi, iyi sarudzo inoshanda chete mune imwe nyaya yeimwe-mutsara ngowani.

Maitiro ekugadzirisa iyo tafura musoro muExcel. Kuvhara mutsara wepamusoro, wakasarudzika cap 19746_2
Zviito zvekugadzira "tafura yakangwara"
  1. PaRibbon Tab "Imba" Simbisai tafura yese.
  2. Mu "masitaera" (pazasi pe tepi), tinya pane iyo "fomati seyata" chinhu. Hwindo rinovhura neine seti ye tafura yetafura. Inoda kudzvanya pane yakakodzera sarudzo.

  3. Iyo "Tafura ye" Window Pow Pops kumusoro, umo miganhu yeafura yemangwana inoratidzwa, uye bhokisi rekutarisa "tafura ine misoro" iri. Iwe unofanirwa kuve nechokwadi chekuti yekupedzisira ibwe.
  4. Vhara hwindo nekutsikirira iyo "OK" bhatani.

Gadzira tafura yakangwara neimwe nzira:

  1. Mushure mekusarudza nzvimbo yaunoda, enda kune iyo ribhoni tabu uye tinya pane "Tafura" chinhu.
  2. Mune iyo pop-up rondedzero, tinya pane "tafura".
  3. Mushure mekuonekwa kwe "kugadzira tafura" hwindo rinowoneka neiyo zvirimo zvakafanana ne "fomati tafura" Window, iwe unofanirwa kuita zviito zvakafanana nezvakataurwa pamusoro apa. Mukupedzisira, iyo "Smart tafura" ichaonekwa neiyo cap yakagadziriswa kumusoro.

Maitiro ekudhinda tafura ine cap pane peji rega rega

Paunenge uchidhindisa tafura uchigara mapeji akati wandei, zvinobatsira kuve nemusoro wake pane rimwe nerimwe peji. Izvi zvinokutendera kuti ushande nepeji rakadhindwa zvakasiyana. Muchirongwa cheEncel, chimiro ichi chinopihwa uye chakaitwa seinotevera.

  1. Enda kuRibbon Tape Tab yePeji Peji uye mune peji peji "(Muzasi retsvimbo yetsvimbo) Dzvanya pahwindo nemuseve kurudyi rwechiratidzo.

  2. Mu "Peji Paramende" hwindo rinovhura, enda ku "pepa" tab.
  3. Dzvanya pane iyo "lick mitsara" hwindo (yechipiri pamusoro).
  4. Dzokera patafura uye, kufambisa iyo inotarisa iyo museve mutema wakarairwa kurudyi, pamutsetse une nhamba yemutsara, simbisa tambo kana tambo iyo iyo iyo tafura iyo ngowani inowanikwa.

  5. Pane izvi zviito zvese zvinopedzwa, zvisinei, mhedzisiro yavo haina kuratidzwa pachiratidziri.

Maitiro ekugadzirisa iyo tafura musoro muExcel. Kuvhara mutsara wepamusoro, wakasarudzika cap 19746_3
Wona Window Ruzivo rwegwaro rakadhindwa - Peji 1 ne cap

Pano nekutsikirira matatu matatu pazasi pewindows kana kupurudzira vhiri remagetsi, kana iyo yekuvhara yakaiswa pane tafura peji, unogona kutarisa mapeji ese kuti utarise hanzi pane imwe neimwe yadzo.

Maitiro ekugadzirisa iyo tafura musoro muExcel. Kuvhara mutsara wepamusoro, wakasarudzika cap 19746_4
Preview Window Pamberi pekudhinda Gwaro - Peji 2 ine ngowani

Mhedziso

MuBudiki, pane nzira mbiri dzekugara dzichiratidza patafura yemaputi e tafura. Mumwe wavo anosanganisira kushandiswa kwekusimbisa kwedunhu, wechipiri ndewekutendeuke patafura mu "Smart" uchishandisa chimiro chenzvimbo yakasarudzwa yekuisa mairi. Nzira mbiri idzi dzinobvumidzwa kugadzirisa mutsara mumwe, asi chete yekutanga inobvumidza kuita nekapu inosanganisira yakawanda mitsara. Excel ine zvimwe nyore - kugona kudhinda gwaro ne cap pane peji rega rega, iyo, inowedzera kushanda kwekushanda nayo.

Meseji maitiro ekugadzirisa iyo tafura musoro muExcel. Kugadzirisa mutsara wekumusoro, hat yakaomarara yakaonekwa yekutanga kune tekinoroji yeruzivo.

Verenga zvimwe