Maitiro ekuwedzera maseru muExcel. 3 Nzira dzekuwedzera Masero kuExcel Spreadsheet

Zvakachengeteka kutaura kuti vese vashandisi vanoziva kuwedzera sero nyowani muExcel tafura, asi haasi munhu wese anoziva nezvese sarudzo dzakakodzera dzekuita basa iri. Pakazara, 3 nzira dzakasiyana dzinozivikanwa, uchishandisa izvo zvinogoneka kuisa sero. Kazhinji kukurumidza kwekugadzirisa matambudziko kunoenderana nenzira inoshandiswa. Ngatitarisei zvakadzama nerubatsiro rwekuti ndedzipi nzira dzaungagone kuwedzera maseru patafura yeExcel.

Kuwedzera maseru patafura

Huwandu hukuru hwevashandisi vanotenda kuti vachiri kuwedzera maseru, nhamba yavo yese inowedzera sezvo chinhu chitsva chinoonekwa. Zvisinei, ichi hachisi chokwadi, nokuti nhamba yavo yose icharamba yakafanana. Muchokwadi, uku ndiko kutamiswa kwechimwe chinhu kubva kumagumo etafura kuenda kunzvimbo inodiwa nekubviswa kwedata resero rakatamiswa. Mukuona kweizvi, munhu anofanira kungwarira paanenge achifamba, sezvo zvichibvira kurasikirwa nemamwe mashoko.

Method 1: Kushandisa Masero Context Menu

Iyo inofungidzirwa nzira inoshandiswa kakawanda kupfuura vamwe, sezvo ichionekwa seyo nyore kushandisa. Kuwedzera maseru nenzira yakafanana, iwe unofanirwa kutevedzera inotevera algorithm yezviito:

1. Isu tinoisa iyo mbeva pointer mune chaiyo chikamu chegwaro kwaunoda kuwedzera chinhu. Mushure meizvozvo, tinodaidza menyu yemukati yechinhu chakasarudzwa nekudzvanya RMB uye sarudza "Isa ..." mune pop-up runyorwa rwemirairo.

1. Iwindo rine sarudzo richabuda pamonitor. Iye zvino iwe unofanirwa kutarisa bhokisi riri pedyo nekunyorwa "Masero". Pane nzira mbiri dzekuisa - nekuchinja kuenda kurudyi kana pasi. Sarudza iyo sarudzo inodiwa mune yako imwe kesi uye tinya OK.
2. Mushure meizvozvo, iwe unogona kuona kuti chinhu chitsva chichaonekwa pachinzvimbo chechakatanga, chakachinjirwa pasi pamwe chete nezvimwe.

Zvinokwanisika kuwedzera masero akawanda nenzira yakafanana:

1. Nhamba inodiwa yemasero inosarudzwa. Menyu yemamiriro ekunze inodaidzwa nekudzvanya-kurudyi pane yakatarwa uye kusarudza "Isa ...".

2. Mune zvingasarudzwa, sarudza iyo yaunoda uye tinya "OK".
3. Masero matsva achaonekwa pachinzvimbo cheakamisikidzwa, anochinjirwa kurudyi pamwe nemamwe.

Method 2: Kushandisa Special Tool muMain Menu

1. Sezvakaitika mune yakapfuura, iwe unofanirwa kutanga waisa iyo mbeva pointer munzvimbo iyo imwe sero ichagadzirwa. Zvadaro, mumenyu, unofanira kusarudza "Home" tab, mushure mokunge iwe unoda kuzarura chikamu che "Masero", kwaunonyora "Insert" chinyorwa.

2. Sero rinobva rawedzerwa panzvimbo yakanyorwa. Asi nenzira iyi yekuisa, kuchinja kunoitika pasi chete, kureva kuti, hazvizokwanisi kuisa sero nekuchinja kune rumwe rutivi rworudyi nenzira iri mubvunzo.

Nekufananidza neyekutanga nzira, pane sarudzo yekuwedzera akawanda maseru:

1. Sarudza nhamba yaunoda yemasero mumutsara (yakatwasuka). Zvadaro, tinya pane chinyorwa "Insert".

2. Mushure meizvozvo, mamwe maseru anozowedzerwa pamwe nezvinhu zvakasarudzwa zvinodzikiswa pasi pamwe chete nezvimwe.

Tevere, funga zvinoitika kana ukasarudza kwete mutsara une maseru, asi koramu:

1. Izvo zvinodikanwa kuti usarudze maseru emutsara wakatwasuka uye tinya zvakanyorwa "Isa" mune iyo huru tab.
2. Mumamiriro ezvinhu akadaro, maseru anozowedzerwa nekuchinja kune kurudyi kweiyo yakamaka renji uye zvinhu izvo zvaive zvekutanga kurudyi kwayo.

Izvo zvakakoshawo kutarisa nezve nzira yekuwedzera huwandu hwemasero anosanganisira akateedzana akamira uye akachinjika zvinhu:

1. Mushure mekusarudza chiyero chinodiwa, zviito zvakajairika zvinoitwa, ndiko kuti, mu "Home" tab, unofanirwa kudzvanya pane "Insert" kunyorwa.
2. Iye zvino iwe unogona kuona kuti izvo zvakawedzerwa zvinhu zvinodzikiswa pasi.

Paunenge uchiwedzera huwandu hwemasero, huwandu hwemitsara nemakoramu zvauri hunoita basa rekuita:

• Kana renji iine mitsetse yakawanda yakatwasuka pane yakachinjika mitsetse, mamwe maseru anodzikiswa pasi kana awedzerwa.
• Kana renji iine mitsetse yakawanda yakachinjika kupfuura mitsetse yakatwasuka, maseru anochinjirwa kurudyi kana awedzerwa.

Paunenge uchida kutsanangura pachine nguva kuti sero rinoiswa sei, rinofanira kuitwa seizvi:

1. Nzvimbo iyo sero (kana akati wandei) ichaiswa inosimbiswa. Zvadaro unofanira kusarudza "Masero" chikamu uye tinya inverted yegonyo pikicha pedyo "namira". Mune iyo pop-up menyu, tinya pakanzi "Isa maseru ...".
2. Zvadaro, hwindo rine zvingasarudzwa rinoonekwa. Iye zvino iwe unofanirwa kusarudza iyo yakakodzera sarudzo uye tinya "OK".

Nzira 3: Namira Masero Uchishandisa Hotkeys

Vashandisi vepamberi vezvirongwa zvakasiyana vanokwirisa maitiro vachishandisa makiyi masanganiswa akagadzirirwa chinangwa ichi. В Excel zvakare ine akati wandei mapfupi ekibhodhi ayo anobvumidza iwe kuita nhamba yakakura yekushanda kana kushandisa akasiyana maturusi. Rondedzero iyi inosanganisirawo nzira yekudimbudzira kiibhodhi yekuisa mamwe maseru.

1. Kutanga iwe unoda kuenda kunzvimbo yaunoronga kuisa sero (range). Tevere, wobva wadzvanya "Ctrl + Shift + =" mabhatani.

2. Hwindo rinozivikanwa rinoonekwa rine sarudzo dzekunamira. Tevere, iwe unofanirwa kusarudza iyo yaunoda sarudzo. Mushure meizvozvo, zvinosara chete kudzvanya "OK" kuti mamwe maseru aoneke.

mhedziso

Chinyorwa chakakurukura marudzi ese enzira dzekuisa mamwe maseru muExcel spreadsheet. Imwe neimwe yeiyi yakafanana nedzimwe maererano nenzira yekushandiswa uye chigumisiro chakawanikwa, asi ndeipi yenzira dzekushandisa dzinofanira kusarudzwa zvichienderana nemamiriro ezvinhu. Iyo yakanyanya nyore nzira ndiyo inosanganisira kushandisa iyo keyboard nzira yekudimbudzira yakagadzirirwa kuiswa, zvisinei, muchokwadi, vashandisi vazhinji vanowanzo shandisa menyu yemukati.