Kuwedzera chinyorwa chitsva muExcel

Wese munhu anotanga kushanda muExcel, kutanga pane zvese, anofanira kudzidza kuwedzera mamwe makoramu patafura yakarongwa. Pasina ruzivo urwu, zvichave zvakanyanya kuoma kana kutotadza kuramba uchishanda netabular data uye nekuwedzera ruzivo rutsva kubhuku.

Kuwedzera chikamu chitsva

Excel inopa akati wandei nzira dzekuisa imwe koramu munzvimbo yebasa. Dzakawanda dzeidzi nzira hadzizokonzerese matambudziko, asi anotanga anovhura chirongwa kekutanga achafanira kupedza nguva shoma kuti aone zvese. Naizvozvo, ngatitarisei kutevedzana kwezviito kune imwe neimwe nzira.

Method 1. Kuisa mbiru kuburikidza nebhara rekubatanidza

Iyi nzira inoonekwa seyakareruka pakuwedzera zvese zviri zviviri koromo uye mutsara patafura. Hezvino izvo zvaunofanira kuita kune izvi:

1. Pane yakachinjika coordinate panel, tinya pazita rekoramu kuruboshwe kwaunoronga kuwedzera imwe nyowani. Kana yaitwa nemazvo, koramu yese ichasarudzwa pamwe chete nemusoro wayo.
2. Iye zvino tinya-kurudyi pane chero nzvimbo munzvimbo yakasarudzwa, menyu yemukati inovhura, umo isu tinosarudza murairo “Isert”.
3. Izvi zvichawedzera koramu itsva isina chinhu kuruboshwe kweiyo yatakasarudza munhanho yekutanga.

Method 2: Kuwedzera Column Uchishandisa Sero's Context Menu

Pano iwe uchazodawo kushandisa menyu yemukati, asi mune ino kesi, kwete iyo yose yakasarudzwa koramu, asi sero rimwe chete.

1. Enda kuchitokisi (tinya pairi kana kushandisa miseve pa keyboard), kuruboshwe kwatinoronga kuisa koromo itsva.
2. Tinya-kurudyi pane iyi sero, uye mune yemukati menyu inovhura, tinya pane kuraira “Isa…”.
3. Iwindo diki rekubatsira rinovhurika, kwauchazoda kusarudza izvo chaizvo zvinoda kuiswa mutafura: maseru, mutsara kana koramu. Maererano nebasa redu, tinoisa chiratidzo pamberi pechinhu "Column" uye simbisa chiito nekudzvanya bhatani OK.
4. Koramu isina chinhu ichaonekwa kuruboshwe kwesero yakasarudzwa, uye tinogona kutanga kuizadza nedata rinodiwa.

Method 3: Namira uchishandisa maturusi ari paribhoni

Pane bhatani rakakosha paribhoni guru reExcel rinokutendera kuti uise imwe mbiru mutafura.

1. Sezvakaitwa nenzira yapfuura, sarudza sero yaunoda. Koramu itsva mushure mekutevera matanho ari pasi apa ichaonekwa kuruboshwe kwayo.
2. Dzvanya pachiratidzo chine mufananidzo wegonyo rakatenderedzwa padivi pebhatani “Isert”, ari mu tab "Kumba". Mune yekudonhedza pasi, tinya pane iyo sarudzo “Isa makoramu pabepa”.
3. Zvese zvagadzirira. Koramu itsva inowedzerwa kuruboshwe rwesero rakasarudzwa, sezvinodiwa.

Method 4. Hotkeys yekuisa mbiru itsva

Imwe nzira inozivikanwa kwazvo, kunyanya pakati pevashandisi vane ruzivo, kudzvanya hotkeys. Iyi nzira ine maitiro maviri:

1. Dzvanya pazita rekoramu pane coordinate panel. Senguva dzose, yeuka kuti mbiru itsva ichaiswa kuruboshwe kweyakasarudzwa. Tevere, dzvanya nzira yekudimbudzira kiibhodhi Ctrl + "+". Mushure meizvozvo, iyo nyowani nyowani inowedzerwa pakarepo patafura.
2. Isu tinodzvanya pane chero sero, tisingakanganwe chokwadi chekuti nyowani nyowani ichaonekwa kuruboshwe kwayo. Wobva wadzvanya nzira yekudimbudzira keyboard Ctrl + "+".Iwindo rinozivikanwa richaonekwa paunoda kusarudza rudzi rwekuisa (sero, mutsara kana koramu). Sezvakaita yechipiri nzira, unofanira kusarudza chinhu "column" wobva wasimbisa chiito nekudzvanya pabhatani OK.

Kupinza makoramu maviri kana anopfuura

Basa rekuisa mamwe makoramu akawanda mutafura rinofanirwa kutariswa zvakanyanya. Nekuda kwekushanda kweExcel, hapana chikonzero chekuwedzera makoramu rimwe nerimwe, nekuti mune iyi kesi pane imwe inoshanda sarudzo:

1. Chokutanga pane zvose, tinosarudza masero akawanda akaenzana (hazvina basa, mutafura pachayo kana pachikwata chekubatanidza), sezvo makoramu matsva akawanda akarongwa kuiswa.
2. Zvichienderana nekuita kwatakaita sarudzo, tinoita matanho akasara ekuwedzera makoramu, achitungamirirwa nemaitiro 1-4 anotsanangurwa pamusoro apa. Semuenzaniso, kwatiri isu takaita sarudzo pane yekubatanidza pani, uye ikozvino tinowedzera makoramu matsva kuburikidza nemenu yemukati nekusarudza chinhu chakakodzera mairi.
3. Nekuda kwezviito zvedu, takakwanisa kupinza makoramu matsva akati wandei mutafura kuruboshwe rwekutanga renji yatakasarudza.

Isa koramu kumagumo kwetafura

Zvose zvakatsanangurwa pamusoro apa zvakakodzera kuwedzera mbiru itsva kana makoramu akawanda pakutanga kana pakati petafura huru. Zvechokwadi, kana iwe uchida kuwedzera koromo kubva kumagumo, unogona kushandisa nzira dzakafanana kana uchida. Asi ipapo iwe unofanirwa kushandisa imwe nguva yekufometa izvo zvakawedzerwa zvinhu.

Kuti uise mbiru itsva uye udzivise mamwe mafomati, zvinodikanwa kugadzira "smart" tafura kubva patafura yenguva dzose. Izvi ndizvo zvatinoitira izvi:

1. Sarudza maseru ese ematafura. Nzira yekuita izvi - verenga nyaya yedu "".
2. Chinja kune tab "Kumba" uye tinya bhatani "Format as table", iyo iri muchikamu che "Styles".
3. Mune rondedzero inoonekwa, sarudza yakakodzera dhizaini dhizaini yeramangwana "smart table" uye tinya pairi.
4. Iwindo duku richaonekwa umo iwe unoda kunatsa miganhu yenzvimbo yakasarudzwa. Kana isu takanyatso sarudza tafura mudanho rekutanga, hapana chinoda kubatwa pano (kana zvichidikanwa, tinogona kugadzirisa iyo data). Kuita shuwa kuti pane cheki padivi pechinhu chacho “Tafura ine misoro” dzvanya bhatani OK.
5. Somugumisiro, tafura yedu yepakutanga yakashandurwa kuva "smart" imwe.
6. Iye zvino, kuti uwedzere koromo itsva kumagumo etafura, ingozadza chero sero kurudyi rwenzvimbo yetafura nedata rinodiwa. Iyo column yakazadzwa inozongoita chikamu che "smart tafura" ine fomati yakachengetedzwa.

mhedziso

Microsoft Excel inopa nzira dzakawanda dzaunogona kuwedzera koromo itsva chero kupi patafura (kutanga, pakati, kana kupera). Pakati pavo, nzvimbo yakakosha inogarwa nekugadzirwa kwe "smart tafura", iyo inokutendera iwe kuti uise makoramu matsva mutafura pasina kudikanwa kwekuwedzera fomati kuitira kuti uuye nawo kune yakajairika fomu, iyo inochengetedza nguva pane imwe. mamwe mabasa akakosha.