Yenza i-Chart kwi-Excel usebenzisa i-Shortcut Keys

Ukuba ufune ishadi ngokukhawuleza okanye ufuna nje ukujonga iindlela ezithile zedata yakho, unokwenza ishadi kwi-Excel kunye nesicatshulwa esisodwa.

Enye yeefayile ze-Excel ezincinci eziyaziwayo kukuba inkqubo inokwakheka kwetshathi engagqibekanga enokusetyenziswa ngokusebenzisa izitshixo zokuncinci zekhibhodi.

Ishadi elidibeneyo livumela abasebenzisi ukuba bancede ngokukhawuleza isati eqhelekileyo esetyenziswayo kwiphepha lokusebenzela okanye ukufaka ishati kwiphepha lokusebenzela elithile kwincwadi yokusebenza yangoku.

Amanyathelo amabini okukwenza oku:

1. Khetha idatha ofuna ukuyisebenzisa kwitshathi
2. Cinezela iqhosha le- F11 kwikhibhodi

Isatriki esebenzisa zonke izicwangciso zokungagqibekanga zangoku zenziwe kwaye zongezwa kwiphepha lokusebenzela elithile kwincwadi yokusebenza yangoku.

Ukuba izicwangciso zendalo ezingaguqukanga zitshintshiwe, ishati edalwe ngokucindezela i-F11 yintanga yekholomu .

01 ngo 04

Ukongeza i-Chart Default kwi-Worksheet yangoku kunye ne-Alt + F1

Kanye nokongeza ikopi yetshathi engagqibekanga kwiphepha lokusebenzela elihlukile, loo tsatshi iya kufakwa kwiphepha lokusebenzela elikhoyo-iphepha lokusebenzela apho idatha yetshathi ifumaneka - ngokusebenzisa iifayile ezifutshane zokuncinci zekhibhodi.

1. Khetha idatha ofuna ukuyisebenzisa kwitshathi;
2. Cinezela kwaye ubambe iqhosha lase Alt kwikhibhodi;
3. Cinezela kwaye ukhulule iqhosha le- F1 kwikhibhodi;
4. Isatifiketi esingagqibekanga songezwa kwiphepha lokusebenzela langoku.

02 we 04

Ukutshintsha i-Excel Uhlobo lweTyati ekhethiweyo

Ukuba ucinezela i-F11 okanye i-Alt + F1 ivelisa ishati engayithandiyo, kufuneka utshintshe uhlobo lwetshathi olungagqibekanga.

Uhlobo olutsha lwesatriki olukhethiweyo kufuneka lukhethwe kwifolda yesikhokelo kwi-Excel ephethe kuphela iithemplethi ozidalileyo.

Indlela elula yokutshintsha uhlobo lwetshathi olungagqibekanga kwi-Excel kukuba:

1. Nqakraza ngakwesokudla kwitshati ekhoyo ukuze uvule imenyu yokunqakraza imenu;
2. Khetha Uhlobo lweThirati yeTshintsho ukusuka kwimenyu yomxholo ukuvula ibhokisi yencoko yohlobo lwebhokisi yeTyhuthi ;
3. Cofa kwiZimboniselo kwicala lasekhohlo lebhokisi yencoko;
4. Ukucofa ngakwesokudla kumzekelo wesiteti esandleni sokunene kwikhompyutheni yam Izifanekiso ;
5. Khetha "Beka njengetshathi echanekileyo" kwimenyu yomongo.

03 we 04

Ukudala nokugcina izifanekiso zeTyrtti

Ukuba awukakali i template engasetyenziselwa njengoluhlobo olukhethiweyo lwetshathi, indlela elula yokwenza oku kukuba:

1. Shintsha ishati ekhoyo ukuba ufake zonke iindlela zokwenza ifomathi - njengombala ongasemva, izicwangciso zezinga le-X kunye ne-type yohlobo lwefayile - kwi template entsha;
2. Chofoza ngokuchanekileyo kwitshathi;
3. Khetha "Gcina njengeSetekisi ..." kwimenyu yomongo njengoko kuboniswe kumfanekiso ongentla, ukuvula ibhokisi yencoko yebhokisi yebhokisi ye- Chart yokugcina ;
4. Yithi ithemplate;
5. Cofa iqhosha lokugcina ukugcina ithemplate kwaye vala ibhokisi yencoko.

Qaphela: Ifayile igcinwa njengefayile ye .crtx kwindawo elandelayo:

C: \ Amaphepha kunye nezicwangciso \ igama lomsebenzisi \ AppData \ Roaming \ Microsoft \ Templates \ Charts

04 we 04

Ukususa i-Template yeStrt

Indlela elula yokucima itemplate yetshathi yangokwezifiso kwi-Excel kukuba:

1. Nqakraza ngakwesokudla kwitshathi ekhoyo ukuze uvule imenyu yokunqakraza imenyu;
2. Khetha "Utshintshi uhlobo lweTyati" ukusuka kwimenyu yomxholo ukuvula ibhokisi yencoko yohlobo lwebhokisi yeTshintsho ;
3. Cofa kwiZimboniselo kwicala lasekhohlo lebhokisi yencoko;
4. Cofa kwi-Inkinobho yokulawula Iimpawu kwizantsi yekhohlo yebhokisi yencoko yababini ukuvula ifolda yeedatkthi zefayile;
5. Ukucofa kwesokudla kwi template ukuba ususwe kwaye ukhethe Cima kwimenyu yomxholo - ibhokisi yencoko yebhokisi yencoko yababini iya kuvula ukucela ukuba uqinisekise ukukhishwa kwefayili;
6. Cofa kuEwe kwibhokisi yencoko yo kucima itemplate uze uvale ibhokisi yencoko.