Ukuphucula ukufunda nokugcina ixesha nge-AutoFormat
Enye indlela yokwenza lula umsebenzi wokufometha ishidi lomsebenzi kwi-Excel kukusebenzisa i-AutoFormat ukhetho.
Ukufometha akukwenziwe nje ukwenza iphepha lokusebenzela libukeke lihle. Ukukhethwa kombala wesiqhelo, isitayela sefonti, ubungakanani befonti, kunye nezinye iindlela zokufometha zingenza ukuba idatha ilula ukuyifunda, kwaye inkcazelo ebaluleke kakhulu kwi-spreadsheet ibonakala kulula ukuyibona, ngelixa ihambisa ispredishithi ubukeka bebugcisa.
IiNdawo eziPhambili zokuFometha
Kukho i-AutoFormat izitayela ezifumaneka kwi-Excel. Ezi zintsi zithintela indawo ezintandathu zokufomatha:
- Ukufometha kwamanani
- Imida
- Iifowuni
- Iipateni nombala wesiqhelo
- Ulungelelaniso
- Ikholomu nobukhulu bomqolo
Indlela yokwenza i-AutoFormat kwiBar Tool Tool Quick
Nangona kufinyeleleka kwizinto ezikhethiweyo kwimenyu kwiinguqu zokuqala, i-AutoFormat ayifumanekanga kwiyiphi na iithebhu zebhoni ukusuka kwi-Excel 2007.
Ukusebenzisa i-AutoFormat, faka i-AutoFormat icon kwiBar Toolbar yokuFumana ngokukhawuleza ukuze ifikeleleke xa ifunekayo.
Le yindlela yesikhathi esisodwa. Emva kokuba yongezwa, uphawu luhlala kwiBar Tool Tool Quick.
- Cofa kwinqolo engezantsi ekupheleni kweBar Toolbar yokuFikelela ukuvula imenyu ehlayo.
- Khetha iMigaqo Engaphezulu kwiluhlu ukuvula Yenza ibhokisi yencoko yebhokisi yencoko ye -Quick Access .
- Cofa phantsi kweentolo ekupheleni kwe- Khetha umyalelo ukusuka kumgca ukuvula imenyu ehlayo.
- Khetha Zonke Iimfuno ezisuka kuhlu ukuze ubone yonke imiyalelo ekhoyo kwi-Excel kwicala lokushiya.
- Skrolela ngeloluhlu lwealfabhethi ukufumana umyalelo we- AutoFormat .
- Cofa kwi Hlaziya iqhosha phakathi kweengcango zomyalelo ukufaka inkinobho ye-AutoFormat kwiBar Tool Tool Quick.
- Cofa u- OK ugcwalise ukongeza.
Ukusebenzisa i-AutoFormat Style
Ukusebenzisa isitayela se-AutoFormat:
- Khankanya idatha kwiphepha lokusebenzela ofuna ukulifometha.
- Cofa kwiqhosha lase- AutoFormat kwiBar yeTrafti ye- Quick Access ukukhupha ibhokisi yencoko yencoko.
- Cofa kwenye yeendlela ezikhoyo.
- Cofa Kulungile ukusebenzisa ifayile uze uvale ibhokisi yencoko.
Shintsha i-AutoFormat Style ngaphambi kokufaka isicelo
Ukuba akukho zindlela ezikhoyo zifana nokuthanda kwakho, zinokuguqulwa phambi okanye emva kokuba zifakwe kwishidi lokusebenzela.
Shintsha i-AutoFormat Style ngaphambi kokuba uyisebenzise
- Cofa kwiqhosha leenketho phantsi kwebhokisi yencoko ye- AutoFormat .
- Ungakhethi naluphi na indawo ezintandathu zokufomathiza ezifana nefonti, imida, okanye ulungelelaniso ukususa ezo ndlela zokufomathiza kuzo zonke izitayela ezikhoyo.
- Imizekelo kwibhokisi yebhokisi yencoko yababini ukuhlaziya ukutshintsha.
- Cofa Kulungile ukusebenzisa ifayili eguquliwe.
Shintsha i-AutoFormat Style emva kokuba uyiSebenzise
Xa isetyenzisiwe, isitawu sinokuguqulwa kwakhona ngokusetyenziswa kweefayile zokufometha eziqhelekileyo ezikuyo-inxalenye enkulu kwiTable yasekhaya yerbhoni.
Isitayela se-AutoFormat esitshintshileyo singagcinwa njengesitayela esiqhelekileyo, esenza kube lula ukuphinda sisebenzise ngamaphepha angeziwe.