01 na 01
Mažallan Ƙananan Maɓalli don Rufewa, Redo ko Maimaita a Excel
- Cire - kawar da wasu ayyuka na kwanan nan a cikin takardun aiki - kamar su maye gurbin, canje-canjen tsarawa, motsawar bayanai, ko gyare-gyaren dabarar .
- Ta hanyar tsoho, maɓallin Undo yana samuwa a kan Toolbar Quick Access, kamar yadda aka nuna a cikin hoto a sama.
- Hanyar hanyar keyboard : Ctrl + z
- Redo - sake yin amfani ko gyara abin da ba ku sani ba. Idan ka canza tunaninka game da canje-canje da ka yi kawai zuwa takardar aiki tare da umurnin Undo , zaka iya sake yin amfani da ɗaya ko fiye da canje-canje tare da Redo .
- Ta hanyar tsoho, maɓallin Redo wanda ke kusa da Ƙaddamarwa a kan Toolbar Quick Access.
- Hanyar hanyar keyboard : Ctrl + y
- Maimaita - sake maimaita aikinka na ƙarshe - irin su yin amfani da sauyewar tsarin tsarawa zuwa ƙwayoyin sel sau ɗaya a lokaci guda.
- Maimaita an haɗa shi da umurnin Redo , don haka waɗannan biyu ba su aiki ba a lokaci guda
- Hanyar hanyar keyboard : Ctrl + y
- Maimaita maɓallin ba'a samuwa a kan Toolbar Quick Access ta tsoho amma dole ne a kara zuwa kayan aiki .
Ƙari Ayyuka ko Redos
Kusa da kowane ɗayan waɗannan gumaka a kan Toolbar Quick Access shi ne ƙananan arrow. Danna kan wannan arrow yana buɗe jerin menu na saukewa da nuna jerin abubuwan da za a iya sokewa ko sakewa.
Ta hanyar nuna alama da dama abubuwa a cikin wannan jerin zaka iya gyara ko sake sauya matakai a lokaci ɗaya.
Rufewa da Redo Ƙayyadaddun
Kwanan nan na Excel da duk sauran shirye-shiryen Microsoft Office suna da cikakkiyar gyara / redo iyakar 100 ayyuka. Kafin Excel 2007, ƙayyadaddun iyaka yana da shekaru 16.
Domin kwakwalwa ke gudana da tsarin tsarin Windows , wannan iyaka za a iya canzawa ta hanyar gyara tsarin tsarin aiki na saitunan.
Ta yaya Zubar da Ayyukan Redo
Excel yana amfani da wani ɓangare na ƙwaƙwalwar RAM ta kwamfutar don kula da jerin ko tari na canje-canje kwanan nan zuwa wata takarda.
Kashewa / Saukewa da umarnin yana ba ka damar motsawa gaba da baya ta wurin tari don cirewa ko sake yin amfani da waɗannan canje-canje a cikin tsari da aka fara sanya su.
Alal misali - Idan kuna kokarin warware wasu canje-canje na tsarin kwanan nan, amma ba zato ba tsammani je mataki daya da nisa kuma gyara abin da kuke son ci gaba, maimakon ci gaba ta hanyar matakan tsara matakan don dawowa, danna kan maɓallin Redo zai ci gaba mataki na farko da aka saka a matsayi wanda ya dawo da canji na karshe.
Maimaitawa da Redo
Kamar yadda aka ambata, Redoo da Maimaitawa suna haɗuwa don haka ɗayan ɗayan biyu, a yayin da umurnin Redo yake aiki, Maimaita ba haka ba ne.
Misali - Canja launi na rubutu a cikin salula A1 zuwa ja kunna maɓallin Maimaita a kan Toolbar Quick Access , amma ya kashe Redo kamar yadda aka nuna a cikin hoto a sama.
Wannan yana nufin cewa za a iya sake sauya wannan canji akan abun ciki na wani cell - irin su B1, amma launi canzawa a A1 ba za'a iya sakewa ba.
Sabanin haka, kawar da launin launi a A1 kunna Redo , amma ya kashe Maimaita ma'anar cewa canjin launi zai iya "sakewa" a cikin salula A1 amma baza a sake maimaita shi a cikin wani cell ba.
Idan an ƙara maɓallin Maimaitawa zuwa Toolbar Quick Access, zai canza zuwa button Redo lokacin da babu wani aiki a tari wanda za'a iya maimaita.
Cirewa, An kawar da ƙayyadaddun ƙaddamarwa
A cikin Excel 2003 da kuma sassan farko na wannan shirin, da zarar an ajiye littafin, an katse tari din, ya hana ka daga duk wani aiki da aka aikata kafin ka sami ceto.
Tun da Excel 2007, an cire wannan taƙaitaccen izini, ba da damar masu amfani su ajiye canje-canje akai-akai amma har yanzu suna iya gyara / sake aikata ayyukan da suka gabata.