Maitiro ekugadzirisa nzvimbo yacho muExcel

Paunenge uchishanda uine nhamba yakakosha yedata pane pepa reSprejheet, iwe unofanirwa kugara uchiongorora mamwe ma paramita. Asi kana kune vazhinji vavo, uye nharaunda yavo inopfuura kupfuura miganhu yechidzitiro, gara uchifambisa bara remurumbidze rinokanganisa. Vaunotumira vanogadzira vachangoda kuriritira vashandisi, vachisuma muchirongwa ichi mukana wekushandira nzvimbo dzekushandisa. Ngatitsvagei kuti chimiro ichi chinoitwa sei uye kushandisa maitiro eMicrosoft Excel chirongwa.

Kusimbirira iyo nharaunda muExcel

Mhinduro yebasa redu razvino icharatidzwa pane iyo muenzaniso chirongwa cheMicrosoft Office 365 package, asi mumatanho ekutanga kana matanho matsva, matanho akakosha ekugadzirisa nzvimbo yacho anoitwa mune zvakafanana nzira.

Sarudzo 1: Nzvimbo yetambo

Kazhinji kazhinji muE-Tafura Mukuru, inodikanwa kugadzirisa nzvimbo kubva kune akati wandei mitsara yepamusoro, ayo ari anonzi cap. Izvi zvinoitwa zvinotevera:

1. Kutarisa pane nhamba yemutsara padivi (kuruboshwe) chirongwa cheProf, sarudza bhatani rekuruboshwe nekudzvanya bhatani rekuruboshwe bhatani (LKM) zvinoenderana nemutsara, iyo ichave inotevera yeiyo yakatarwa renji. Muenzaniso wedu, tichasimbisa mitsara mitatu yekutanga, ndiko kuti, inofanirwa kugovera mune ino nyaya yechina.



2. Enda kune "maonero" tab uye mu "hwindo" Toolbar, Wedzera menyu ye "nzvimbo yakachengetedzwa" chinhu.



3. Mune yakaratidzwa runyorwa rwezvisarudzo zviripo, sarudza chete sarudzo yakakodzera nekuda kwezvinangwa zvedu - "Simbisa nzvimbo".



Aya ndiwo maitiro ekuti iwe ungagadzirisa sei nzvimbo yakatwasuka inosanganisira akati wandei mitsara, mune yeExcel yemagetsi tafura.

Sarudzo yechipiri: Nzvimbo yemakoramu

Izvo zvakare zvinoitika kuti zvinodikanwa kuti usimbise pamusoro petafura, asi divi, ndiko kuti, iyo mbiru iri kuruboshwe. Iyo algorithm yezvakaitwa mune ino nyaya yakafanana, asi nekugadziriswa kwenguva pfupi.

1. Simbisa iyo ikholamu inotevera iyo huwandu hweavo kuronga kugadzirisa. Mumwe muenzaniso wedu, iyo clumn ndeye, kureva kuti, isu tichagadzirisa huwandu a-b.



2. Vhura iyo maonero tab uye shandisa iyo "yakachengetedzwa iyo nzvimbo" chinhu.



3. Sarudza yekutanga sarudzo kubva pane iyo rondedzero iyo inodzora zita rechinhu chikuru uye yakataurwa nesu mune yapfuura chikamu.



Kubva panguva ino, iyo nharaunda yakasarudzwa (kuruboshwe) Dunhu richatemwa, uye kana richikanda tafura munzira yakatwasuka, ichagara iri munzvimbo yacho.

Sarudzo 3: Nzvimbo yemitsara uye makoramu

Zvichida pane iyo ruzivo rwuri mumasero, iyo inowanzodiwa kuti irambe iri pamberi pemaziso, inogona kushamisika nemakwenzi ekumusoro, hazvishamise kuti iyo Excel Toolkit inokutendera iwe kugadzirisa zvese yekutanga neyechipiri. Nekuda kweizvi:

1. Kukwikwidza nekudzvanya lcm iyo sero iyo iri pazasi pemitsara uye kurudyi kwemakoramu aunoda kugadzirisa, uye woenda ku "maonero" tab.

   

   Muenzaniso: Kuti ugadzirise mitsara miviri yekutanga (12) uye column (A, b) , sarudza iyo foni nekero C3.

   .

2. Mumunda we "Window" zvishandiso tabo, shandisa chinhu "chinomhanyisa nzvimbo"

   

   Uye mune rondedzero iyo inovhura, sarudza iyo imwecheteyo sarudzo.



3. Zvino, nekuputika kwemarara kwetafura, mitsara yakatarwa icharamba iri munzvimbo,

   

   Uye nemakoronga yakatwasuka icharamba iripo.



Iyo vhezheni yechiitiko ichi ichionekwa muchikamu ichi ndicho chinonyanya kududzirwa chaiko mutsara "unosanganisira nzvimbo yacho". Gadzira rombo renji kubva mumitsara uye mhuru dzinogona kudikanwa apo chikamu chepamusoro cheExcel SprejEhheet is a ngowani, semuenzaniso, nhamba dzekuteedzana uye zita rizere revashandi.

Sarudzo 4: imwe column kana mutsara mumwe

Kana pasi pekubatanidzwa kwedunhu, iwe unoreva kugadziriswa kwechinhu chimwe chete petafura, ndiko kuti, imwe yemutsara wayo kana imwe ikoramu, zvese zvinoitwa zviri nyore. Iwe unongoratidza chikamu chaunoda chikamu, uye wobva wasarudza chinhu chinoenderana nebasa rako mune "kuchengetedza nzvimbo" bhatani ". Neimwe nzira, iwe haugone kugovera chero chinhu zvachose, uye kungozvisarudzira imwe yesarudzo dzakakodzera - "chengetedza tambo yepamusoro" kana "simbisa iyo ikhoramu", zvichienderana nebasa ripi riri pamberi pako. Maitiro aya, pamwe neiyo nuinces inogona kureva kuita kwayo, yaionekwa nesu muzvinyorwa zvakasiyana, uye tinokukurudzira kuzviwanza.

Verenga Zvimwe: Maitiro ekuchengetedza mutsara mumwe kana imwe ikholamu

Kuraswa kwenzvimbo yakasarudzika

Muchiitiko icho chinodiwa chekubatanidza nharaunda (tambo, makoramu kana yakasanganiswa renji haina mhosva) yakanyangarika, ichave yakakodzera kuita chokwadi, sekutanga kwakatariswa pamusoro apa. Musiyano chete ndewekuti "Gadzira nzvimbo" menyu inofanira kusarudza yekutanga uye chinhu chiri pachena kwazvo mune iyi mamiriro ezvinhu kuti "bvisa matunhu ekuchengetedza".

Mhedziso

Snap tambo, columns kana kukurisa huwandu hwavo muMicrosoft Excel Sprejheet iri nyore. Chinhu chikuru mune ino kesi nzwisisi nzwisisi kuti chinhu cheiye tafura chinofanira kugoverwa, uye isu takaudza zvakadzama munyaya yanhasi.