4 Nzira dzekuwedzera Nyowani Sheet muExcel

Kazhinji, vashandisi vanoshanda muExcel spreadsheet edhita vanofanirwa kuwedzera pepa rebasa idzva kugwaro respredishiti. Zvechokwadi, iwe unogona kugadzira gwaro idzva, asi zvinokurudzirwa kushandisa sarudzo iyi chete mumamiriro ezvinhu apo pasina chikonzero chekubatanidza ruzivo rwakasiyana kune mumwe nemumwe. Chirongwa chine nzira dzakati wandei dzinokutendera kuti uwedzere pepa kugwaro respredishiti. Ngatitarisei nzira dzese mune zvakadzama.

bhatani reExcel spreadsheet

Iyi nzira inoonekwa seyakareruka uye yakanyanya nyore kushandisa. Inoshandiswa nevakawanda vevashandisi vespredishiti mupepeti. Kuwanda kwepamusoro kweiyo nzira inotsanangurwa nekuti iyo algorithm yekuwedzera pepa rebasa idzva iri nyore uye inonzwisisika kunyange kune vashandisi vekutanga.

Iwe unofanirwa kudzvanya LMB pane chinhu chakakosha chinodaidzwa kuti "New Sheet", iri kurudyi kwemapepa ebasa aripo pazasi pespredishiti. Bhatani pacharo rinotaridzika sediki plus chiratidzo mumumvuri wakasviba. Zita rebasa idzva, richangobva kugadzirwa rinopihwa otomatiki. Musoro wepepa unogona kugadziriswa.

Detailed rairo pakugadzirisa zita ndeiyi:

1. Tinya kaviri LMB papepa rebasa ragadzirwa.
2. Isa zita raunoda kupa.
3. Mushure mekuita zvese manipulations, tinya bhatani rekuti "Enter" riri pane keyboard.

4. Ready! Zita rebasa idzva rachinja.

Uchishandisa yakakosha Excel mamiriro menyu

Menyu yemamiriro ekunze inokubvumira kuti uite maitiro ekuwedzera pepa rebasa idzva kugwaro respredishiti mumatanho mashoma ekukurumidza. Detailed mirairo yekuwedzera inoita seizvi:

1. Isu tinotarisa pasi peiyo spreadsheet interface uye tinowana rimwe remapepa aripo egwaro.
2. Isu tinodzvanya pairi RMB.
3. Menyu diki yemukati yakaratidzwa pachiratidziri. Isu tinowana chinhu chinonzi "Insert sheet" uye tinya pairi LMB.

4. Ready! Tawedzera bepa rebasa idzva pagwaro.

Iwe unogona kuona kuti iyi nzira, iyo inokubvumira kuti uwedzere pepa kugwaro uchishandisa menyu yemamiriro ezvinhu, iri nyore kushandisa senzira yakambokurukurwa. Pepa rekushanda rinowedzerwa nenzira iyi rinogona kugadziriswa nenzira imwechete.

Teerera!  Uchishandisa menyu yemukati, haugone kungoisa pepa rebasa idzva, asi zvakare kudzima iripo.

Murairo wakadzama wekudzima pepa rekushanda ndeuyu:

1. Isu tinowana rimwe remapepa aripo egwaro.
2. Dzvanya papepa nebhatani rekurudyi rembeva.
3. Menyu diki yezvinyorwa yakaonekwa pachiratidziri. Isu tinowana chinhu chinonzi "Delete", tinya pairi nebhatani rekuruboshwe.
4. Ready! Tabvisa pepa rebasa kubva mugwaro.

Uchishandisa menyu yemukati, unogona zvakare kupa zita, kufamba, kukopa uye kuchengetedza pepa rebasa.

Kuwedzera pepa rekushanda uchishandisa Tool Ribhoni

Iwe unogona kuwedzera pepa rebasa idzva kuExcel spreadsheet gwaro uchishandisa yakakosha multifunctional toolbar iri pamusoro peiyo interface. Detailed instructions ndeidzi:

1. Pakutanga, tinotamira kune chikamu che "Kumba". Kurutivi rwekurudyi rweribhoni rekushandisa, tinowana chinhu chinonzi "Masero" uye tinya kuruboshwe pane museve icon iri padivi payo. Rondedzero yemabhatani matatu "Isa", "Delete" uye "Format" yakaburitswa. Dzvanya bhatani rekuruboshwe rembeva pane mumwe museve uri padyo nebhatani rekuti “Isa”.

2. Imwe rondedzero diki yezvinhu zvina yakaburitswa. Tinoda chinhu chekupedzisira chinonzi "Isert Sheet". Isu tinodzvanya pairi LMB.

3. Ready! Taita maitiro ekuwedzera bepa rebasa idzva kugwaro respredishiti. Zvakakosha kucherechedza kuti, semune nzira dzakambokurukurwa, unogona kugadzirisa zita reakagadzirwa pepa rekushanda, pamwe nekuridzima.

Zvinokosha! Kana hwindo respredishiti richiwedzerwa kusvika pakukura kwayo, saka hapana chikonzero chekutsvaga "Cells" element. Muchiitiko ichi, bhatani re "Insert Sheet", riri mumutsara wekudonha we "Insert" element, inowanikwa pakarepo muchikamu chinonzi "Kumba".

Kushandisa Spreadsheet Hotkeys

Iyo Excel spreadsheet ine yayo yakakosha makiyi ekupisa, kushandiswa kwayo kunogona kuderedza zvakanyanya nguva inotora kuti uwane maturusi anodiwa mumenyu yepurogiramu.

Kuti uwedzere pepa rebasa idzva kugwaro respredishiti, unongoda kudzvanya kiyi musanganiswa "Shift + F11" pane keyboard. Mushure mekuwedzera pepa rebasa idzva nenzira iyi, isu tichakurumidza kuzviwana tiri munzvimbo yayo yekushanda. Mushure mekunge pepa rebasa idzva rawedzerwa kubhuku, zita raro rinogona kugadziriswa nenzira iri pamusoro.

mhedziso

Maitiro ekuwedzera pepa rebasa idzva kuExcel gwaro iri nyore kushanda, inova imwe yeakajairika uye inowanzoshandiswa nevashandisi vespredishiti. Kana mushandisi asingazivi maitiro ekuita iyi nzira, saka haazokwanisi kuita basa rake nemazvo uye nemazvo. Kukwanisa kuwedzera bepa rebasa idzva kubhuku rebasa inyanzvi yekutanga iyo mushandisi wese anoda kushanda nekukasira uye nemazvo muspredishiti anofanira kuva nawo.