Thuthukisa ukufunda nokugcina isikhathi nge-AutoFormat
Enye indlela yokwenza kube lula umsebenzi wokufometha ishidi lokusebenzela ku-Excel ukusebenzisa i-AutoFormat inketho.
Ukufometha akukwenziwe nje ukwenza ishidi lokusebenza libukeka lihle. Ukukhetha umbala wangemuva, isitayela sefonti, usayizi wefonti, nezinye izinketho zokufometha kungenza idatha ifundeke kalula, futhi imininingwane ebaluleke kakhulu kuspredishithi ilula ukubona, sonke ngenkathi inikeza ispredishithi ukubukeka kobuchwepheshe ..
Amafomu Okufometha Okuyinhloko
Kunezindlela ezingu-17 ze-AutoFormat ezitholakalayo ku-Excel. Lezi zindlela zithinta izindawo eziyisithupha zokufometha:
- Ukufometha kwenombolo
- Imingcele
- Amafonti
- Amaphethini nombala wangemuva
- Ukuqondanisa
- Ikholomu nobukhulu bomugqa
Indlela Yokufaka i-AutoFormat kwi-Quick Access Toolbar
Nakuba kufinyeleleka ngokusebenzisa okukhethwa kukho kwemenyu kuzihumusho zangaphambilini, i-AutoFormat ayitholakali kunoma yimaphi amathebhu we- Ribbon kusukela ku-Excel 2007.
Ukuze usebenzise i-AutoFormat, engeza isithonjana se-AutoFormat kwi-Quick Access Toolbar ukuze ifinyeleleke uma kudingeka.
Lena ukusebenza kwesikhathi esisodwa. Ngemva kokungezwa, isithonjana sihlala kwi-Quick Access Toolbar.
- Chofoza umcibisholo ophansi ekupheleni kweThuluzi lokuFinyelela okusheshayo ukuvula imenyu yokudonsa.
- Khetha Imiyalo Engaphezulu ohlwini ukuze uvule ngokwezifiso ibhokisi lengxoxo ye -Quick Access Toolbar .
- Chofoza phansi phansi komcibisholo ekupheleni kweMilayezo yokukhetha kusuka emgqeni ukuvula imenyu yokudonsa.
- Khetha Yonke Imiyalo ohlwini ukuze ubone yonke imiyalo etholakalayo ku-Excel ngakwesokunxele kwesokunxele.
- Pheqa ngalolu hlu lwama-alfabhethi ukuthola umyalo we- AutoFormat .
- Chofoza inkinobho yokufaka phakathi kwe-panes yomyalo ukwengeza inkinobho ye-AutoFormat kwi-Quick Access Toolbar.
- Chofoza OK ukuze uqedele ukufaka.
Ukusebenzisa isitayela se-AutoFormat
Ukusebenzisa isitayela se-AutoFormat:
- Qinisekisa idatha ekhasini lokusebenzela ofuna ukulifometha.
- Chofoza inkinobho ye- AutoFormat kwi- Quick Access Toolbar ukuletha ibhokisi lengxoxo yesici.
- Chofoza kwesinye sezitayela ezitholakalayo.
- Chofoza OK ukusebenzisa isitayela bese uvale ibhokisi lengxoxo.
Shintsha isitayela se-AutoFormat ngaphambi kokufaka isicelo
Uma kungekho namathekisthi atholakalayo afisa ukuthanda kwakho, angaguqulwa ngaphambi noma ngemuva kokuthi asetshenziswe ephepheni lokusebenzela.
Shintsha isitayela se-AutoFormat Ngaphambi kokuyisebenzisa
- Chofoza inkinobho yezinketho ngezansi ebhokisini lengxoxo ye- AutoFormat .
- Khetha noma yiziphi izindawo eziyisithupha zokufometha njengefonti, imingcele, noma ukuvumelanisa ukususa lezi zindlela zokufometha kuzo zonke izitayela ezitholakalayo.
- Izibonelo ezisebukhosini zebhokisi lebhokisi lezingxoxo ukuze zibonise izinguquko.
- Chofoza OK ukusebenzisa isitayela sokuguqulwa.
Shintsha isitayela se-AutoFormat Ngemuva kokuSebenzisa
Uma isetshenzisiwe, isitayela singashintshwa kabusha ngokusebenzisa izinketho zokufometha ezivamile ze-Excel ezikhona-ikakhulukazi kuthebhu yasekhaya yebhande.
Isitayela se-AutoFormat eshintshiwe singahle sigcinwe njengesitayela esingokwezifiso, okwenza kube lula ukusebenzisa kabusha ngamashidi okusebenza.