Maitiro ekuchinjanisa mitsetse muExcel

Paunenge uchishanda mupepeti yespredishiti, zvinowanzove zvakakosha kuti uchinje mitsetse mugwaro respredishiti. Kuti uite iyi nzira iri nyore, kune nzira dzakawanda dzakasiyana. Muchinyorwa ichi, tichaongorora zvakadzama nzira dzese dzinotitendera kuita maitiro ekushandura chinzvimbo chemitsara mugwaro reExcel spreadsheet.

Nzira yekutanga: kufambisa mitsetse nekukopa

Kuwedzera mutsara unobatsira usina chinhu, umo data kubva kune chimwe chinhu chinozoiswa gare gare, ndiyo imwe yedzakareruka nzira. Pasinei nekureruka kwayo, haisi iyo inokurumidza kushandisa. Detailed mirairo inoita seizvi:

1. Isu tinoita sarudzo yeimwe sero mumutsara, pamusoro payo isu tinoronga kuita kusimudza kweimwe mutsara. Dzvanya bhatani rekurudyi rembeva. Pane diki yakakosha menyu yakaonekwa pachiratidziro. Isu tinowana bhatani "Isa ..." uye tinya pairi LMB.

2. Hwindo diki rakaonekwa pachiratidziri, rinonzi "Add Cells". Pane zvakawanda zvingasarudzwa zvekuwedzera zvinhu. Tinoisa chiratidzo pedyo nechinyorwa "mutsara". Dzvanya LMB pane "Zvakanaka" chinhu kuratidza shanduko yakaitwa.

3. Mutsara usina chinhu waonekwa muruzivo rwetabular. Isu tinosarudza mutsara watinoronga kukwira kumusoro. Unofanira kuisarudza yose. Isu tinoenda kuchikamu che "Kumba", tsvaga "Clipboard" chishandiso uye tinya LMB pane chinhu chinonzi "Copy". Imwe sarudzo inobvumidza iwe kuita iyi maitiro ndeye kushandisa yakakosha kiyi musanganiswa "Ctrl + C" pane keyboard.

4. Fambisa chinongedzo kumunda wekutanga wemutsara usina chinhu wakawedzerwa matanho mashoma apfuura. Isu tinoenda kuchikamu che "Kumba", tsvaga "Clipboard" dhizaini uye tinya kuruboshwe pane chinhu chinonzi "Namira". Imwe sarudzo inobvumidza iwe kuita iyi maitiro ndeye kushandisa yakakosha kiyi musanganiswa "Ctrl +V” pa keyboard.

5. Mutsara unodiwa wawedzerwa. Tinofanira kudzima mutsara wekutanga. Dzvanya bhatani rekurudyi rembeva pane chero chinhu chemutsara uyu. Pane diki yakakosha menyu yakaonekwa pachiratidziro. Isu tinowana bhatani re "Delete ..." uye tinya pairi LMB.

6. Iwindo diki rakaonekwa pachiratidziri zvakare, iro rava nezita rekuti "Delete Cells". Pane akawanda ekubvisa sarudzo pano. Tinoisa chiratidzo pedyo nechinyorwa "mutsara". Dzvanya bhatani rekuruboshwe mbeva pane "OK" chinhu kuti usimbise shanduko yakaitwa.

7. Chinhu chakasarudzwa chabviswa. Isu takaita kubvumidzwa kwemitsara yegwaro respredishiti. Ready!

Yechipiri Nzira: Kushandisa Nzira yekunamira

Nzira iri pamusoro apa inosanganisira kuita nhamba huru yezviito. Kushandiswa kwayo kunokurudzirwa chete mumamiriro ezvinhu apo zvakakosha kuchinjana mitsetse miviri. Kana iwe uchida kuita maitiro akadaro kune yakawanda data, saka zviri nani kushandisa dzimwe nzira. Murairo wakadzama wemumwe wavo unotaridzika seizvi:

1. Dzvanya bhatani rekuruboshwe rembeva pane serial nhamba yemutsara, iri papanera remakonisheni emhando yakatwasuka. Mutsara wose wasarudzwa. Isu tinoenda kuchikamu che "Kumba", tsvaga "Clipboard" tool block uye tinya LMB pane chinhu chine zita rekuti "Cheka".

2. Tinya-kurudyi pane coordinate bar. Menyu diki yakakosha yemenu yakaonekwa pachiratidziro, mune iyo inofanirwa kusarudza chinhu chine zita rekuti "Isa akachekwa maseru" uchishandisa LMB.

3. Mushure mekuita manipulations aya, takazviita kuti mutsara wekucheka wawedzerwe panzvimbo yakatarwa. Ready!

Yetatu Nzira: Kuchinjanisa neMouse

Iyo tafura mupepeti inobvumidza iwe kushandisa mutsara wemvumo nenzira yakatokurumidza. Iyi nzira inosanganisira kufambisa mitsetse uchishandisa komputa mouse uye keyboard. Iyo toolbar, edhita mabasa, uye mamiriro emukati haashandiswe mune ino kesi. Detailed mirairo inoita seizvi:

1. Isu tinosarudza serial nhamba yemutsara pane iyo coordinate panel yatinoronga kufamba.

2. Fambisa chinongedzo chembeva kuenda kumusoro kwemutsetse uyu. Inoshandurwa kuita chiratidzo muchimiro chemiseve mina inonongedza kwakasiyana. Bata pasi "Shift" uye fambisa mutsara kunzvimbo yatinoronga kuifambisa.

3. Ready! Mumatanho mashoma, takaita kufambisa mutsara kunzvimbo yaidiwa tichishandisa komputa chete.

Mhedziso uye mhedziso pamusoro pekuchinja nzvimbo yemitsara

Takaona kuti spreadsheet editor ine nzira dzakawanda dzinoshandura nzvimbo yemitsara mugwaro. Wese mushandisi achakwanisa kuzvisarudzira akazvimirira nzira yekufamba. Mukupfupisa, tinogona kutaura kuti nzira inosanganisira kushandiswa kwekombuta yekombuta ndiyo inokurumidza uye iri nyore nzira yekushandisa nzira yekushandura chinzvimbo chemitsara mugwaro respredishiti.