Nzira Yekushandisa Kushandura, Kudzorera, uye Kudzokorora mu Excel

01 ye 01

Keyboard Shortcuts for Rendered, Redo or Repeat in Excel

Dzokorora uye Dzorera Zvokushandisa pane Quick Access Toolbar. © Ted French

Multiple Undos kana Redos

Muchikamu chimwe nechimwe chezvifananidzo izvi pa Quick Access Toolbar mune zvishoma zvishoma museve. Kushandura mutsara uyu kunovhura dhetani pasi menyu kuratidza urongwa hwezvinhu zvinogona kushandiswa kana kuregwa.

Nekusimbisa zvimwe zvezvinhu zviri murongwa urwu unogona kugadzirisa kana kudzorerazve matanho akawanda panguva imwechete.

Rondedzera uye Redo mipaka

Shanduro dzekare dzeExcel nedzimwe nhepfenyuro dzeMicrosoft Office dzinotadza kushandura / kutora zvigadziriro zvitanhatu. Pamberi peEcelcel 2007, kuderedzwa kwekodzero yaiva 16.

Kwemakombiyuta ari kushandisa Windows operating system, uyu muganhu unogona kuchinjwa nekugadzirisa zvirongwa zvekushandura zvekushandura.

Nzira Yokududzira uye Kudzorera Kushanda

Excel inoshandisa chikamu chekombiyuta RAM yekombiyuta kuchengetedza urongwa kana huwandu hwekuchinja kwechangobva kuitwa kune rimwe pepaji.

Iyo Dudziro / Kudzorera kuwirirana kwemirairo kunokubvumira kuti uende mberi uye kumashure kuburikidza nepakavhara kuti ubvise kana zvakare kushandisa zvishandiso izvi mukuronga kwavakaitwa pakutanga.

Muenzaniso - Kana uri kuedza kugadzirisa mamwe maitiro ekugadzirisa kwemazuva ano, asi pangozi enda kune imwe danho kure kure uye gadzirisa chimwe chinhu chaunoda kuichengeta, pane kuti upinde nematanho ekufambisa anodiwa kuti uwanezve, pakudhinda bhodzi reRock kuenderera mberi iyo yakavhara mberi imwe danho rinodzosa zvakare kuti yekupedzisira mafomu achinje.

Dzokorora uye Dzorera

Sezvakataurwa, Kudzosera uye Kudzokorora kwakabatanidzwa kuitira kuti izvo zviviri zviwirirane, mune izvo kana murairo weRoodo uri kushanda, Dzokorora haisi uye pamwe chete.

Muenzaniso - Kuchinja ruvara rwemashoko muchitokisi A1 kusvika kune tsvuku rinoshandisa bhodhi Repeat pa Quick Access Toolbar , asi inobvisa Kudzorera sezvinoratidzwa mumufananidzo uri pamusoro.

Izvi zvinoreva kuti kuchinja kwekugadzirisa kunogona kudzokororwa pane zviri mune imwe sero - zvakadai seB1, asi kuchinja kwemavara muA1 hakugone kuvezve.

Mukutaura, kushandura kuchinja kwemavara muA1 inobatsira Redo , asi inogadzirisa Kudzokorora zvinoreva kuti kuchinja kwemavara kunogona "kuonekwa" muchitokisi A1 asi haikwanise kudzokororwa mune imwe sero.

Kana Bhota Repeat yange yawedzerwa ku Quick Access Toolbar, ichashandura kuBhoo reRood kana pasina chiito muhomwe iyo inogona kudzokororwa.

Dzosa, Kudzosera Mhedzisiro Yakabviswa

MuExcel 2003 uye mapeji ekutanga epurogiramu yacho, kamwe bhuku rebhuku rakachengetedzwa, danda rekudzosa rakabviswa, richikudzivisa kuti urege kugadzirisa chero zviito zvakaitwa musati waponesa.

Kubvira paExcel 2007, kupera uku kwave kubviswa, zvichibvumira vashandi kuchengetedza kuchinja nguva dzose asi vachikwanisa kugadzirisa / kutora zviito zvekare.