01 ka 01
Izinqamuleli zekhibhodi zokuhlehlisa, ukubuyisela noma ukuphinda ku-Excel
- Hlehlisa - uhlukanisa izinyathelo zamanje zakamuva kufomathi lokusebenzela - njengokususwa, izinguquko zokufometha, ukuhamba kwedatha, noma ukuhlelwa kwefomula .
- Ngokuzenzakalelayo, inkinobho Yokuhlehlisa isendaweni ye-Quick Access Toolbar, njengoba kuboniswe esithombeni ngenhla.
- Isinqamuleli sekhibhodi : Ctrl + z
- Phinda usebenzise kabusha noma uhlele lokho okushiwo nje. Uma ushintsha ingqondo yakho mayelana nezinguquko osuvele uzenze ekhasini lokusebenzela ngomyalo wokuhlehlisa , ungaphinda usebenzise eyodwa noma ngaphezulu izinguquko nge- Redo .
- Ngokuzenzakalelayo, inkinobho ye- Redo etholakala eceleni kwe- Hlela ku- Quick Access Toolbar.
- Isinqamuleli sekhibhodi : Ctrl + y
- Phinda - phinda isenzo sakho sokugcina - njengokusebenzisa ushintsho lokufometha kwamuva kakhulu kumaseli amaningi ngesikhathi esisodwa.
- Ukuphinda kuxhunyaniswe nomyalo we- Redo , ngakho-ke lezi zinsuku azikaze zisebenze ngesikhathi esifanayo
- Isinqamuleli sekhibhodi : Ctrl + y
- Inkinobho yokuphinda ayitholakali kwi- Quick Access Toolbar ngokuzenzakalela kodwa kumele ifakwe kubha yamathuluzi .
Ama-Undos amaningi noma ama-Redos
Ngokuya kwesinye salezi zithombe kwi- Quick Access Toolbar umcibisholo omncane ophansi. Ukuchofoza kulo mcibisholo kuvulwa imenyu ehlehlisayo ebonisa uhlu lwezinto ezingasuswa noma zenziwe kabusha.
Ngokugqamisa izinto eziningana kulolu hlu ungahlehlisa noma uphinde wenze izinyathelo eziningi ngesikhathi esisodwa.
Hlehlisa nemingcele ye-Redo
Izinguqulo zakamuva ze-Excel nazo zonke ezinye izinhlelo ze-Microsoft Office zenzeke ngokuzenzakalelayo / zenze kabusha izinyathelo eziphezulu ezingu-100. Ngaphambi kwe-Excel 2007, umkhawulo wokuhlehlisa wawuyi-16.
Kumakhompyutha asebenzisa uhlelo lwe - Windows , lo mkhawulo ungashintshwa ngokuhlela izilungiselelo zokubhalisa zesistimu yokusebenza.
Ukuhlehlisa nokuSebenza Kanjani
I-Excel isebenzisa ingxenye yememori ye-RAM yekhompuyutha ukuze ilondoloze uhlu noma isitoreji sezinguquko zamuva kuphepha lokusebenzela.
Inhlanganisela Yokuhlehlisa / Ukubuyiswa kwemithetho ikuvumela ukuthi uqhubekele phambili futhi ubuyele emgqeni ukuze ususe noma usebenzise kabusha lezo zinguquko ngomyalelo owenziwe kuqala.
Isibonelo - Uma uzama ukuhlehlisa izinguquko zamuva zokufometha, kodwa ngokungahambi ngenyathelo elilodwa ukude futhi uhlele okuthile ofuna ukukugcina, kunokuba uhambe ngezinyathelo zokufometha ezidingekayo ukuze uphinde ubuyeke, ukuchofoza inkinobho ye- Redo kuzoqhubeka i-stack phambili isinyathelo esisodwa sokubuyisela ukuthi ushintsho lwendlela yokugcina.
Phinda futhi u-Redo
Njengoba kukhonjisiwe, i- Redo ne- Repeat ixhunyanisiwe ukuze bobabili bahlangane ngokukhethekile, ngalokho uma umyalo we- Redo usebenza, Phinda futhi awukho futhi .
Isibonelo - Ukuguqula umbala wombhalo esitokisini se- A1 kuya obomvu kusebenze inkinobho yokuphinda kubha yamathuluzi okusheshayo , kodwa uvala i- Redo njengoba kuboniswa esithombeni ngenhla.
Lokhu kusho ukuthi lolu shintsho lokufometha lungabuyekezwa kokuqukethwe kwesinye iseli - njengeB1, kodwa ushintsho lombala ku-A1 alukwazi ukubuyiswa kabusha.
Ngakolunye uhlangothi, ukuguqula ukushintsha kombala ku-A1 kusebenze ku- Redo , kodwa kuvimbela Ukuphinda kusho ukuthi ukuguqulwa kombala "kungabuyiselwa" kuseli cell A1 kodwa ngeke kuphindwe kwenye iseli.
Uma inkinobho yokuphindaphindiwe ingeziwe kwi- Quick Access Toolbar, izoshintshela inkinobho ye- Redo uma kungekho sinyathelo esiteji esingaphindwa.
Hlehlisa, Ukunciphisa Ukunciphisa Kukhishwe
Ku-Excel 2003 nezinguqulo zangaphambilini zalolu hlelo, uma ibhuku lezincwadi ligcinwe, isitaki sokuhlehlisa sisusiwe, sikuvimbela ukuthi ungahlehlisi noma yikuphi okwenziwayo ngaphambi kokulondolozwa.
Kusuka ku-Excel 2007, lo mkhawulo ususiwe, uvumela abasebenzisi ukuthi balondoloze izinguquko njalo kodwa basakwazi ukulungisa / ukwenza kabusha izenzo zangaphambilini.