Chidzidzo chekusarudza tafura muExcel

Chirongwa cheExcel chakagadzirirwa kuita akasiyana masvomhu kuverenga, kugadzira matafura, magirafu uye machati. Kuti uite chero zviito netafura, unofanirwa kukwanisa kuisarudza nemazvo.

Zvichienderana nehukuru hwematafura, kuvapo kwechero kukosha munzvimbo dzakavakidzana, pane 3 sarudzo dzekusarudza matafura muExcel. Kuti usarudze zvakanyanya kugamuchirwa, zvakakosha kufunga nezvemumwe nemumwe wavo zvakadzama.

Sarudzo yekutanga: kuratidza tafura negonzo

Nzira yacho ndiyo yakapfava uye yakajairika. Zvakanakira zvaro, hongu, zviri nyore uye zvinonzwisisika kune nhamba huru yevashandisi. Izvo zvakaderera ndezvekuti iyi sarudzo haina kukodzera kugovera tafura huru, asi, zvisinei, inoshanda.

Saka, kuti usarudze tafura nenzira iyi, unoda kudzvanya bhatani rekuruboshwe, uye uchibata, sarudza nzvimbo yose yetafura kubva kumusoro kwekona yekuruboshwe kusvika kukona yekurudyi.

Uyezve, unogona kutanga kusarudza nekufambisa mbeva zvese kubva kumusoro kuruboshwe uye kubva pakona yekurudyi, uchisarudza iyo diametric yakatarisana neimwe seyo yekupedzisira. Kubva pakusarudza kwekutanga uye kwekupedzisira mapoinzi, hapazovi nemusiyano mumhedzisiro.

Sarudzo 2: hotkeys yekusarudza

Kuti usarudze matafura mahombe, zviri nyore kushandisa nzira yekudimbudzira yekhibhodi "CTRL + A" ("Cmd + A" - yeMacOS). Nenzira, iyi nzira inoshanda kwete muExcel chete, asiwo mune mamwe mapurogiramu.

Ndapota cherechedza kuti kusarudza tafura uchishandisa nzira iyi, pane nuance duku - panguva iyo makiyi anopisa anotsikirirwa, mutsara we mouse unofanirwa kuiswa muchitokisi chiri chikamu chetafura. Avo. kuti ubudirire kusarudza nzvimbo yese yetafura, unofanirwa kudzvanya pane chero sero mutafura uye wodzvanya kiyi musanganiswa "Ctrl + A" pane keyboard.

Kudzvanya makiyi anopisa mamwe zvakare kuchasarudza shiti rese.

Kana iyo cursor ikaiswa kunze kwetafura, kudzvanya Ctrl + A kuchasarudza shiti rese pamwe netafura.

Sarudzo 3: Sarudza neShift Key

Munzira iyi, matambudziko semunzira yechipiri haafaniri kumuka. Kunyangwe iyi sarudzo yakarebesa maererano nekuita pane kushandisa hotkeys, inonyanya kufarirwa mune dzimwe nguva, uye zvakare iri nyore kupfuura yekutanga sarudzo, umo matafura anosarudzwa uchishandisa mbeva.

Kuti usarudze tafura nenzira iyi, unofanirwa kutevedzera nzira inotevera:

1. Isa chitubu musero rekuruboshwe retafura.
2. Bata pasi Shift kiyi uye tinya pazasi kurudyi sero. Iwe unogona ipapo kusunungura kiyi yeShift.
3. Kana tafura yacho yakakurisa kuti ikwane pachiratidziri, tanga waisa cursor pasero rekutanga, wobva wapfuura nepatafura, tsvaga panoperera, wotevera matanho ari pamusoro.

Nokudaro, tafura yose ichasarudzwa. Inogona kucherechedzwa uchishandisa iyi tekinoroji zvese zviri pamusoro apa uye mune yakapesana. Avo. pachinzvimbo chepamusoro kuruboshwe sero, unogona kusarudza pasi kurudyi senzvimbo yekutanga, mushure mezvo iwe unofanirwa kudzvanya kumusoro kuruboshwe.

mhedziso

Pakati pezvitatu zvingasarudzwa zvekusarudza tafura muExcel yakatsanangurwa pamusoro, unogona kushandisa ese ari matatu. Uye pakusarudza imwe nzira, zvakakosha kufungisisa, kutanga kune zvose, ukuru hwetafura. Nzira yekutanga ndiyo yakapfava uye inonzwisisika, asi iri nani uye iri nyore kuishandisa pamatafura madiki. Sezvo kusarudzwa kwenzvimbo yose yetafura negonzo kuchave kwakaoma zvikuru kana tafura ine nhamba yakawanda yemitsara, nekuda kwekuti iwe uchafanirwa kubata pasi bhatani rekuruboshwe kwenguva refu. Yechipiri sarudzo ine hotkeys ndiyo inokurumidza, asi nuances yayo inogona kukonzera mamwe matambudziko kumushandisi. Nzira yechitatu inodzivirira matambudziko aya, asi inotora nguva yakati rebei pane kushandisa bhatani musanganiswa wakarongwa mune yechipiri sarudzo.