Makoramu akavanzika muExcel. 3 Nzira dzekuratidza Akavanzika Makoramu muExcel

Kazhinji kana uchishandisa spreadsheet editor, pane dzimwe nguva pazvinenge zvakakodzera kuti makoramu chaiwo etafura avanzwe. Nekuda kwezviito izvi, makoramu anodiwa akavanzwa, uye haasisiri kuonekwa mugwaro respredishiti. Nekudaro, kune zvakare inverse mashandiro - kuwedzera makoramu. Muchinyorwa ichi, isu tichatarisa zvakadzama nzira dzinoverengeka dzekuita maitiro aya mupepeti yespredishiti.

Kuratidza Makoramu Akavanzwa muTable Editor

Kuviga makoramu chishandiso chinoshanda chinokutendera kuti ugone kumisa zvinhu panzvimbo yebasa yegwaro respredishiti. Ichi chiito chinowanzoshandiswa muzviitiko zvinotevera:

1. Mushandisi anoda kuenzanisa makoramu maviri akapatsanurwa nemamwe makoramu. Semuenzaniso, iwe unofanirwa kuenzanisa koramu A uye column Z. Muchiitiko ichi, zvichave zviri nyore kuita maitiro ekuviga makoramu anopindira.
2. Mushandisi anoda kuvanza mamwe makoramu ekuwedzera ane maverengero uye mafomula anomutadzisa kushanda zviri nyore neruzivo rwunowanikwa munzvimbo yebasa yegwaro respredishiti.
3. Mushandisi anoda kuvanza mamwe makoramu egwaro respredishiti kuti asakanganise nekuona kweruzivo rwetabular nevamwe vashandisi vachashanda mugwaro iri.

Zvino ngatitaure nezve maitiro ekuita kuvhurwa kwemakoramu akavanzika muExcel spreadsheet editor.

Pakutanga, iwe unofanirwa kuve neshuwa kuti pane zvakavanzika makoramu mundiro, uye wobva waona nzvimbo yavo. Iyi nzira inoshandiswa nyore nyore uchishandisa horizontal coordinate bar yemupepeti wespredishiti. Izvo zvinodikanwa kunyatsotarisa kutevedzana kwemazita, kana ikaputswa, ipapo munzvimbo ino pane yakavanzika mbiru kana akati wandei makoramu.

Mushure mekunge taona kuti pane zvikamu zvakavanzika mugwaro respredishiti, zvinodikanwa kuita nzira yekuburitsa kwavo. Iyi nzira inogona kuitwa nenzira dzakawanda.

Nzira yekutanga: kufambisa miganhu yesero

Mirayiridzo yakadzama yekufambisa miganhu yesero mugwaro respredishiti inoita seizvi:

1. Fambisa chinongedzo kumuganhu wembiru. Chiratidzo chinotora chimiro chemutsara mutema une miseve inonongedza kwakapesana. Nekubata pasi bhatani rekuruboshwe, tinokwevera miganhu munzira inodiwa.

2. Iyi nzira iri nyore inokubvumira kuita kuti koramu yakanyorwa "C" ionekwe. Ready!

Zvinokosha! Iyi nzira iri nyore kwazvo kushandisa, asi kana paine akawandisa makoramu akavanzika mugwaro respredishiti, zvino maitiro aya anozoda kuitwa kanoverengeka, izvo zvisiri nyore, mune izvo zvinonyanya kukosha kushandisa. nzira dzatichakurukura gare gare.

Yechipiri nzira: kushandisa yakakosha mamiriro menyu

Iyi nzira ndiyo inonyanya kushandiswa pakati pevashandisi vespredishiti. Iyo, senge iri pamusoro, inobvumidza iwe kuita kuburitswa kwemakoramu akavanzika. Mirayiridzo yakadzama yekushandisa yakakosha menyu mugwaro respredishiti inoita seizvi:

1. Nekubata pasi bhatani rekuruboshwe rembeva, isu tinosarudza huwandu hwemakoramu pane iyo coordinate panel. Iwe unofanirwa kusarudza iwo maseru mune akavanzika makoramu aripo. Unogona kusarudza nzvimbo yese yebasa uchishandisa Ctrl + A bhatani musanganiswa.

2. Tinya-kurudyi kwese kwese muchikamu chakasarudzwa. Rondedzero yakakura yakaonekwa pachiratidziri, ichikubvumidza iwe kuita shanduko dzakasiyana munzvimbo yakasarudzwa. Isu tinowana chinhu chine zita rekuti "Show", uye tinya pairi nebhatani rekuruboshwe.

3. Nekuda kweizvozvo, makoramu ese akavanzika mumutsara wakasarudzwa acharatidzwa mugwaro respredishiti. Ready!

Nzira yechitatu: kushandisa zvinhu paribhoni yakakosha

Iyi nzira inosanganisira kushandiswa kweribhoni yakakosha iyo maturusi epepeti epepeti anowanikwa. Mirayiridzo yakadzama yekushandisa maturusi ari paribhoni yakakosha yemupepeti wespredishiti inoita seizvi:

1. Nekubata pasi bhatani rekuruboshwe rembeva, isu tinosarudza huwandu hwemakoramu pane iyo coordinate panel. Iwe unofanirwa kusarudza iwo maseru mune akavanzika makoramu aripo.
2. Unogona kusarudza nzvimbo yese yebasa uchishandisa Ctrl + A musanganiswa.
3. Isu tinoenda kuchikamu che "Kumba", tsvaga "Masero" block yezvinhu ipapo, wobva wadzvanya bhatani rekuruboshwe pa "Format". Rondedzero shoma yakazaruka, umo iwe unofanirwa kusarudza "Viga kana kuratidza" chinhu, icho chiri mu "Visibility" block. Muchinyorwa chinotevera, sarudza chinhu "Ratidza makoramu" nebhatani rekuruboshwe.

4. Ready! Makoramu akavanzika anoratidzwa zvakare munzvimbo yebasa respredishiti.

Mhedziso uye mhedziso nezve kuratidzwa kwemakoramu akavanzika mupepeti yespredishiti

Kuviga makoramu chinhu chinobatsira chinokutendera kuti uvanze kwenguva pfupi ruzivo kubva kuspredishiti gwaro rekushanda. Iyi nzira inokutendera iwe kuti uite gwaro respredishiti rive nyore uye rakasununguka kushandisa, kunyanya mune zviitiko apo gwaro rine huwandu hukuru hweruzivo. Nekudaro, havasi vese vanoziva maitiro ekuita maitiro ekuburitsa zvakavanzika makoramu mugwaro respredishiti. Isu takaongorora zvakadzama nzira nhatu dzekushandisa kuratidzwa kwezvinhu zvakavanzika zvenzvimbo yebasa yegwaro respredishiti, kuitira kuti mushandisi wega wega azvisarudzire nzira yakanakira iye.