Maitiro ekuwedzera mutsara mutsva muExcel. Mukati uye pamagumo etafura, mu "smart table"

Munguva dzakasiyana-siyana manipulations ane ruzivo rwetabular, zvinowanzova zvakakosha kuwedzera mitsetse mitsva. Maitiro ekuwedzera ari nyore uye anokurumidza, asi vashandisi vazhinji vane dambudziko panguva iyi. Muchinyorwa chacho, tichatarisa nzira dzose dzinokubvumira kuti uwedzere mutsara mutsva mundiro, uye uwanewo zvinhu zvose zvebasa iri.

Nzira yekuisa mutsara mutsva

Maitiro ekuwedzera mitsara mitsva kune yekutanga ndiro yakafanana kune ese mavhezheni epepeti yespredishiti. Hongu, kune misiyano midiki, asi haina kukosha. Detailed mirairo inoita seizvi:

1. Pakutanga, tinoita kuwanikwa kana kugadzira piritsi. Isu tinosarudza sero remutsara wepamusoro watinoronga kuisa mutsara mutsva. Dzvanya bhatani rekurudyi rembeva pane yakasarudzwa sero. Menyu diki yemamiriro ekunze yabuda, yaunofanirwa kuwana iyo "Isa ..." chinhu uye tinya pairi nebhatani rekuruboshwe. Imwe sarudzo ndeye kushandisa kiyi musanganiswa "Ctrl" uye "+".

2. Iyo purogiramu yakaunza hwindo rakanzi "Insert". Kuburikidza nehwindo iri, unogona kuita kuwedzera kwemutsara, koramu kana sero. Tinoisa fadhi pedyo nechinyorwa "Mutsetse". Dzvanya pane "OK" chinhu kuchengetedza shanduko dzako.

3. Ready! Mutsara mutsva wakawedzerwa patafura. Ndokumbira utarise kuti kana uchiwedzera mutsara mutsva, zvinotora ese mafomati marongero kubva pamutsetse uri pamusoro.

Zvinokosha! Pane imwe nzira inokubvumira kuti uwedzere mutsara mutsva. Isu tinodzvanya RMB pane serial nhamba yemutsara, uyezve mune yemukati menyu inovhura, tinya pane chinyorwa "Insert".

Maitiro ekuisa mutsara mutsva kumagumo etafura

Zvinowanzoitika kuti mushandisi anoda kushandisa kuwedzera mutsara pakupera kwetabular data. Detailed mirairo inoita seizvi:

1. Pakutanga, tinosarudza mutsara wose wakanyanyisa weplate nekutsikirira bhatani rekuruboshwe pane nhamba ye serial. Fambisa chinongedzo kuzasi kurudyi kwemutsara. Iyo cursor inofanira kutora kutaridzika kwediki dema plus chiratidzo.

2. Isu tinobata iyi plus sign nebhatani rekuruboshwe regonzo uye toikwevera pasi, nenhamba yemitsara yatinoronga kuisa. Pakupedzisira, sunungura LMB.

3. Tinocherechedza kuti mitsara yose yakawedzerwa yakazadzwa yakazvimiririra nemashoko kubva muchitokisi chakasarudzwa. Mafomati ekutanga asarawo. Kuti ubvise maseru akazadzwa, unofanirwa kuita maitiro ekusarudza mitsetse mitsva, wobva wadzvanya pakanzi "Delete" pane keyboard. Imwe sarudzo ndeyekudzvanya-kurudyi paminda yakasarudzwa, uye wobva wasarudza chinhu Bvisa Zviri mukati mune yakakosha menyu menyu inovhura.

4. Ready! Isu takave nechokwadi chekuti mitsetse ichangobva kuwedzerwa yakabviswa ruzivo rusina basa. Iye zvino tinogona kuwedzera iyo data inodiwa ipapo isu pachedu.

Zvinokosha! Iyi nzira inokodzera chete munguva idzodzo apo pasi pasi haina kushandiswa mu "Total" maonero, uyewo haiwedzere mitsetse iri pamusoro.

Maitiro ekugadzira tafura yakangwara

"Smart" matafura anoshandiswa kuitira kuti mushandisi ashande zvinobudirira nehuwandu hwakawanda hweruzivo. Ndiro yerudzi urwu inowedzerwa nyore, zvinoreva kuti mitsva mitsva inogona kuiswa chero nguva yakakodzera. Detailed mirairo inoita seizvi:

1. Isu tinoita sarudzo yenzvimbo yebasa yatinoronga kushandura kuita "smart" ndiro. Isu tinoenda kuchikamu che "Kumba", tobva tawana chinhu chinonzi "Format setafura." Isu tinoburitsa runyoro rurefu rwemaplate akarongwa. Sarudza chimiro chaunoda zvakanyanya uye tinya pachiri nebhatani rekuruboshwe.

2. Hwindo reFormat Table rinoonekwa pachiratidziri. Pano, kero yepiritsi yepakutanga yakagoverwa yakapinda. Kana macoordinates asingakukodzeri, unogona kuzvigadzirisa mubhokisi rebhokisi iri. Dzvanya pakanzi "Zvakanaka" kuti usimbise ese akaitwa. Zvinokosha kucherechedza kuti pedyo nechinyorwa "Tafura ine misoro" inofanira kuongororwa.

3. Ready! Isu takaita kugadzirwa kwe "smart" ndiro uye ikozvino tinogona kuita mamwe manipulations nayo.

Maitiro ekuisa mutsara mutsva mune smart tafura

Kuti uite maitiro ekuwedzera mutsara mutsva kune "smart" ndiro, unogona kushandisa nzira dziri pamusoro apa. Detailed mirairo inoita seizvi:

1. Kurudyi tinya pane chero sero. Mune yakakosha menyu inovhura, tsvaga iyo "Insert" chinhu uye uvhure. Muchinyorwa chinooneka, tinya "Table Rows Pamusoro".

2. Imwe nzira yekuwedzera mutsara mutsva ndeye kushandisa musanganiswa wemakiyi ekupisa "Ctrl" uye "+". Kushandiswa kwehotkeys kunoderedza zvakanyanya nguva yakashandiswa pane nzira yekuwedzera mitsva mundiro.

Maitiro ekuisa mutsara mutsva pakupera kwetafura yakangwara

Pane nzira nhatu dzinokubvumira kuti uwedzere mutsara mutsva kusvika kumagumo e "smart" plate. Mirayiridzo yakadzama yekuwedzera mutsara mutsva kumagumo e "smart" plate inoita seizvi:

1. Dhonza chikamu chepasi chekurudyi chendiro nebhatani rekuruboshwe. Mushure mekuita uku, ndiro ichawedzera pachayo. Ichawedzera chaizvo mitsetse yakawanda sezvinodiwa nemushandisi.

2. Pano, maseru akawedzerwa haazozadzirwe otomatiki neruzivo rwekutanga. Mafomula chete ndiwo acharamba ari munzvimbo dzawo. Nokudaro, hapana chikonzero chekujekesa zviri mukati memasero, sezvo atova asina chinhu.

3. Imwe sarudzo ndeyekunyora data nyowani mumutsara uri pasi peiyo yekutanga "smart" ndiro. Kana iwe ukaita maitiro aya, ipapo mutsara mutsva unozoshanduka kuita chinhu che "smart" plate.

4. Nzira yechitatu ndeyekuenda kumucheto wezasi wekurudyi kwesero re "smart" ndiro uye tinya bhatani re "Tab" riri pa keyboard.

5. Mushure mekuita kwechiito ichi, mutsara wakaiswa unozowedzerwa otomatiki kutafura ye "smart" ine yekutanga fomati yakachengetedzwa.

Kuwedzera Multiple Blank Rows kuExcel Spreadsheet

Kuti uite maitiro ekuwedzera maviri kana anopfuura mitsara isina chinhu kune tabular data, unofanirwa kuita mashoma mashoma matanho. Murairo wakadzama wekuwedzera mitsetse isina chinhu inoita seizvi:

1. Tichishandisa bhatani rekuruboshwe, tinosarudza mutsara watinoronga kuwedzera mitsva, uye ipapo, pasina kusunungura LMB, sarudza nhamba yemitsara yatinoda kuwedzera kune gwaro respredishiti.
2. Kusarudzwa kwemitsara yose inodiwa kunoitwa zvinobudirira. Iye zvino iwe unofanirwa kudzvanya-kurudyi chero kupi munzvimbo yakasarudzwa yekushandira.
3. Menyu diki yakakosha yemenu yakavhurwa, umo iwe unofanirwa kutsvaga chinhu chine zita rekuti "Isa" uye tinya pairi nebhatani rekuruboshwe. Imwe sarudzo ndeye kushandisa zvishandiso zviri pane yakakosha ribhoni iri pamusoro peiyo spreadsheet editor interface.
4. Ready! Taita maitiro ekuwedzera mitsetse yakati wandei isina chinhu kune yekutanga ndiro.

Maitiro ekuisa / kuwedzera nhamba yakapihwa isina chinhu / mitsva panzvimbo dzakati?

Ichi chiitiko chinogona kuitwa uchishandisa VBA zvishandiso. Iwe unogona kudzidza zvakawanda nezve maitiro aya nekuona vhidhiyo inotevera:

Kubva pavhidhiyo iri pamusoro, iwe uchadzidza zvese zvekushandisa zvekuwedzera, kushandisa macros uye mamwe maficha anobatsira aripo muExcel spreadsheet edhita.

Kupinza nhamba yakasiyana yemitsara isina chinhu

Semuenzaniso, isu tine tafura inotevera ine ruzivo rwakakosha:

Murairo wakadzama wekuisa nhamba yakasiyana yemitsara yemhando isina chinhu inoita seizvi:

1. Isu tinotamira kubhokisi rebhokisi rinonzi "Isert Blank Rows by Default".
2. Mu "Column number ine nhamba yemitsara" munda, tsanangura kukosha kwatinoda.
3. Zvakakosha kuziva kuti kana tikatarisa bhokisi riri padivi pe "Nhamba yakasiyana yemitsara isina chinhu yekuisa", ipapo mutsara une nhamba yemitsara yekuisa ichachinja kune nhamba ye ordinal yekoromo umo data yerudzi rwenhamba. zvakatsanangurwa.

4. Pakupedzisira, basa racho richasarudza zvakasununguka nhamba yemutsara inoenderana nemaitiro anotsanangurwa nevashandisi. Ichaisa mitsara yakawanda isina chinhu sezvakatsanangurwa mumutsara wakapihwa wekoramu yakatarwa.

Kubvisa mitsetse isina chinhu

Pane nzira dzakawanda dzekubvisa mitsetse isina chinhu. Ngatitarisei nyaya iyi zvakadzama, tichifunga nezvemienzaniso chaiyo. Ngatitii tine tafura inotevera inoratidza mamakisi evadzidzi muzvidzidzo zvakasiyana:

Sarudzo yekutanga yekubvisa mitsetse isina chinhu inoita seizvi:

1. Kushandiswa kwekuronga ruzivo kunoratidzwa. Tinosarudza zvachose ndiro yose. Isu tinotamira kuchikamu che "Data" uye mu "Sort and Filter" command block, tinya pa "Sort". Imwe sarudzo ndeye kudzvanya-kurudyi pane yakasarudzwa uye tinya pane chinhu "kubva paushoma kusvika pahukuru".
2. Somugumisiro wezviito zvakatorwa, mitsetse isina chinhu yatinoda yakatamira kuzasi kweplate yepakutanga. Iye zvino isu tinokwanisa kudzima zviri nyore mitsara iyi isina chinhu tichishandisa kiyi ye "Delete", takambovasarudza panzvimbo yebasa tichishandisa LMB.

Yechipiri sarudzo yekubvisa mitsara isina chinhu inoita seizvi:

1. Kushandiswa kwesefa kunorehwa. Isu tinoita kusarudzwa kwe "cap" yeplate.
2. Isu tinotamira kuchikamu che "Data", uye ipapo tinya kuruboshwe pane "Filter" chinhu, chiri mu "Sort and Filter" tool block.
3. Zvino, kurudyi kwezita rekoramu yega yega, museve mudiki unoratidzwa, unonongedza pasi. Dzvanya pairi kuti uvhure hwindo rekusefa.
4. Bvisa bhokisi riri pedyo ne "(Empty)".

5. Ready! Iyi nzira yakaita kuti zvibvirire kubvisa yesero isina chinhu kubva pamutsetse.

Sarudzo yechitatu yekubvisa mitsetse isina chinhu inoita seizvi:

1. Zvinoreva kushandiswa kwekusarudzwa kweboka remasero. Pakutanga, tinosarudza tafura yose.
2. Enda kune iyo "Editing" sarudzo uye tinya pane "Tsvaga uye sarudza" chinhu. Muchinyorwa chinovhura, tinya pakanzi "Sarudza boka remasero".

3. Muhwindo rinoonekwa pasi pezita rokuti "Sarudza boka remasero" isa fadhi padivi pechinyorwa "masero asina chinhu" nebhatani rekuruboshwe.

4. Mupepeti wespredishiti aita zvekumaka nzvimbo dzisina chinhu. Muchikamu chikuru chepurogiramu, tinya pa "Masero" parameter nebhatani rekuruboshwe, uye sarudza chinhu che "Delete".

5. Ready! Iyi nzira yakaita kuti zvibvirire kubvisa yesero isina chinhu kubva pamutsetse.

Kana mitsetse yadzimwa, mamwe maseru anosimuka. Izvi zvinogona kukonzera kuvhiringidzika, kunyanya kana uchibata nehuwandu hwemashoko. Naizvozvo, nzira iyi haina kukodzera matafura ane nhamba huru yemitsara nemakoramu.

Kurudziro! Uchishandisa kiyi yekubatanidza "CTRL" + "-", iyo inobvumidza iwe kudzima mutsara wakasarudzwa, ichamhanyisa zvakanyanya maitiro ekushanda neruzivo muExcel spreadsheet editor. Iwe unogona kusarudza mutsara waunoda uchishandisa inopisa kiyi musanganiswa "SHIFT + SPACE".

mhedziso

Kubva pane chinyorwa, takadzidza kuti mupepeti yetafura kune nzira dzakawanda dzinokubvumira kuti uwedzere mutsara mutsva kune data retafura. Iyo yakanakisa sarudzo ndeye kushandisa "smart" ndiro, sezvo inosunungura vashandisi vematambudziko mukuwedzera kushanda neruzivo. Zvisinei, mumwe nomumwe mushandisi achakwanisa kuzvisarudzira nzira yakanakisisa iyo inokubvumira kuti uwedzere mutsara mutsva kune gwaro respredishiti.