Gadzira Chati mu Excel uchishandisa Shortcut Keys

Kana iwe uchida kutora chati muchikurumidza kana iwe unongoda kutarisa pane dzimwe tsika mumatare ako, unogona kugadzira chati muExcel nekiki imwe chete.

Mumwe weExcel muduku anozivikanwa chati chati ndeyekuti purogiramu ine chirongwa chisiri chechati chinogona kuitwa chinoshandiswa uchishandisa makii ekutsinhanisa keyboard.

Ichi chati chakanaka chinobvumira vashandisi kukurumidza kuwedzera chati inoshandiswa kare kumashandiro epasizvino kana kuwedzera chati pane rimwe pepa pepaji riri mubhuku rino rekubasa .

Izvo zviviri zvinoita kuti uite izvi ndezvi:

1. Sarudza data yaunoda kushandisa mu chati
2. Dhinda fai yeF11 pane keyboard

Bhora rinoshandisa zvose zvisiri izvo zvisiri izvo zvinogadziriswa zvakasikwa uye kuwedzerwa pane rimwe pepa pepaji riri mubhuku rino rekushandisa.

Kana iyo fekitari isina kugadziriswa isati yashandurwa, chati yakasimbiswa nekufambisa F11 ishizha chinyorwa .

01 ye 04

Kuwedzera Chati Chakaratidzira kuNhemba Yemazuva Ano ne Alt + F1

Kuwedzera nekuwedzera kopi yechati chaipo kushandiswa pane rimwe pepa pepaji, chati ichocho chinogona kuwedzerwa pane pepa rekushandira riripo - pepa rekushandira apo dhidhi data iripo - nekushandisa mamwe maikorodho ekutsinhanisa keyboard.

1. Sarudza dhesi raunoda kushandisa muchati;
2. Dhinda uye ubatisise Alt kiyi pane keyboard;
3. Dhinda nekusunungura f1 F1 pane keyboard;
4. Icho chinyorwa chisina kukwana chinowedzerwa pane pepa rekushandira remazuva ano.

02 of 04

Kuchinja Excel Default Chart Type

Kana kuomesa F11 kana Alt + F1 inobereka chati isiri iyo yaunofarira, unoda kuchinja mhando yechati yechati.

A new default chart type inofanira kusarudzwa kubva pane zvinyorwa zvema templates mu Excel iyo inobata ma templates chete awakasika.

Nzira iyo iri nyore yekushandura mhando yechati iri mu Excel ndeyekuti:

1. Kumbofa chinyorwa pane chati iripo kuti uzarure mamiriro ekukodzera yemenu menu;
2. Sarudza Chishanduko Chete Mutauro kubva mumenyu yezvakakosha kuti uzarure Bhokisi reKushandura Bhokisi rekutaurirana ;
3. Dzvanya paMatura ari muruoko rworuboshwe pane yebhokisi rebhokisi;
4. Kurudyi pfupa pane chidimbu chemuti muruoko rworudyi Zviratidzo zvangu pane;
5. Sarudza "Isa sechishandiso chati" mumutauro wakatarisana.

03 of 04

Kuumba nekuchengetedza Chati Zvifananidzo

Kana iwe usati wasika template iyo inogona kushandiswa sechinhu chisina chakanaka chati, nzira iri nyore kuita izvi ndeyikuti:

1. Shandura chati chaivepo kuti uise zvose zvingasarudzwa zvekufambisa - zvakadai semuvara wemuvara, X uye Y zvidzidzo zvekuita, uye fomu yepafaira - yei template itsva;
2. Kona pakarurama pane chati;
3. Sarudza "Chengetedza se Template ..." kubva pane mamiriro ekutenderera sezvinoratidzwa mumufananidzo uri pamusoro, kuti uzarure bhokisi rekuchengetedza rekuchengetedzwa kweGurati reKuratidza;
4. Zita template;
5. Dzvanya Bhokisi reKachengetedza kuti uchengetedze template uye uvhare bhokisi rebhokisi.

Cherechedza: Faira inoponeswa sefaira .crtx kunzvimbo inotevera:

C: \ Zvinyorwa uye Zvirongwa \ username \ AppData \ Roaming \ Microsoft \ Templates \ Charts

04 we 04

Kuchenesa Chati Template

Nzira yakareruka yekubvisa tsika yechikwereti che template mu Excel ndeyekuti:

1. Kungofa-kanda pane chati iripo kuti uzarure mamiriro ekukodzera yemenu menu;
2. Sarudza "Tsika yeTeti yeTrasi" kubva mumenyu yezvakakosheta kuti uzarure Bhokisi reKushandura Bhokisi reKubhokisi;
3. Dzvanya paMatura ari muruoko rworuboshwe pane yebhokisi rebhokisi;
4. Dzvanya paGadzirisa Zviratidzo bhokisi muzasi kwekona yakasara rebhokisi rebhokisi kuti uzarure folisi dzema template;
5. Kurudyi-kanda pane template kuti ibviswe uye sarudza Delete mumutauro wekukomberedza - Delete file dialog box ichazarura kukumbira kuti uone faira kubviswa;
6. Dzvanya paIyo mubhokisi rebhokisi kuti ubvise template uye uvhare bhokisi rebhokisi.