Mukati
Paunenge uchishanda muExcel, zvinowanzodikanwa kuparadzanisa ruzivo. Iwe unogona kuita izvi sepapepa rimwe chete, kana kuwedzera rimwe idzva. Ehe, pane sarudzo yakadai sekugadzira gwaro idzva, asi rinoshanda chete kana isu tisingadi kubatanidza data pamwechete.
Pane nzira dzakati wandei dzekuwedzera pepa idzva kuExcel workbook. Pazasi isu tichakurukura zvakasiyana mumwe nemumwe wavo.
gutsikana
Bhatani Idzva rePepa
Kusvika kure, iyi ndiyo nzira iri nyore uye inokwanisika, inogona kushandiswa nevazhinji vashandisi vechirongwa. Zvese ndezvekureruka kwakanyanya kwemaitiro ekuwedzera - unongoda kudzvanya bhatani rakakosha re "New Sheet" (muchimiro chekuwedzera), iro riri kurudyi kwemashiti aripo pazasi pehwindo rechirongwa. .
Pepa idzva richapihwa zita rega. Kuti uchinje, unofanirwa kudzvanya pairi nebhatani rekuruboshwe, nyora zita raunoda, wobva wadzvanya Enter.
Iwe unogona kuwedzera pepa idzva mubhuku uchishandisa menyu yemukati. Kuti uite izvi, tinya-kurudyi pane chero mapepa agara aripo mugwaro. Menyu ichavhura, iyo yaunofanira kusarudza chinhu "Isert Sheet".
Sezvauri kuona, nzira yacho iri nyore seyakatsanangurwa pamusoro apa.
Maitiro ekuwedzera pepa kuburikidza nechirongwa ribhoni
Ehe, basa rekuwedzera pepa idzva rinogona kuwanikwa zvakare pakati pezvishandiso zviri muExcel ribhoni.
- Enda kune "Kumba" tebhu, tinya pane "Masero" chishandiso, wozoenda pane diki pasi museve padivi pebhatani re "Insert".
- Zviri nyore kufungidzira zvaunoda kusarudza kubva pane rondedzero inooneka - iyi ndiyo "Insert sheet" chinhu.
- Ndizvo chete, bepa idzva rawedzerwa kugwaro
Cherechedza: mune zvimwe zviitiko, kana saizi yehwindo yechirongwa yakatambanudzwa zvakakwana, haufanirwe kutsvaga chishandiso che "Masero", nekuti bhatani rekuti "Isert" rinobva raratidzwa mu "Home" tab.
Kushandisa hotkeys
Kufanana nemamwe mapurogiramu akawanda, Excel ine, kushandiswa kwayo kunogona kuderedza nguva yekutsvaga mabasa akafanana mumenyu.
Kuti uwedzere pepa idzva mubhuku rekushanda, ingo dzvanya nzira yekudimbudzira keyboard Shift + F11.
mhedziso
Kuwedzera pepa idzva kuExcel ndiro basa rakareruka, iro rinogona kunge riri rimwe reanonyanya kufarirwa uye anonyanya kushandiswa. Mune zvimwe zviitiko, pasina kugona kuita izvi, zvichave zvakaoma kana kutotadza kuita basa nemazvo. Naizvozvo, uhwu ndihwo humwe hunyanzvi hunyanzvi hunofanirwa kuitwa nemunhu wese anoronga kushanda nemazvo muchirongwa.