Dala ishadi ku-Excel usebenzisa izinqamuleli zezinqamuleli

Uma udinga ishadi ngokusheshisa noma ufuna nje ukuhlola izitayela ezithile kudatha yakho, ungakha ishadi ku-Excel nge-keystroke eyodwa.

Esinye sezici zeshadi elingaziwa ngaphansi kwe-Excel ukuthi uhlelo lunehlobo leshadi elizenzakalelayo elingasetshenziswa ngokusebenzisa izinkinobho zokunqamulela kwekhibhodi.

Leli shidi elizenzakalelayo livumela abasebenzisi ukuba bafake ngokushesha ishadi elisetshenziswe kakhulu kumsebenzi wamanje wamanje noma ukwengeza ishadi kumaphepha okusebenzela ahlukile encwadini yokusebenza yamanje.

Izinyathelo ezimbili zokwenza lokhu yizi:

1. Khetha idatha ofuna ukuyisebenzisa eshadini
2. Cindezela ukhiye we- F11 ekhibhodi

Ishadi elisebenzisa zonke izilungiselelo ezizenzakalelayo zamanje lidalwe futhi lengezwe ephepheni lokusebenzela elihlukile ebhokisini lamanje.

Uma izilungiselelo ezizenzakalelayo zefektri azishintshiwe, ishadi elidalwe ngokucindezela i-F11 yishadi lesikholomu .

01 ngo-04

Ukungeza ishadi elizenzakalelayo kwi-Worksheet yamanje ne-Alt + F1

Kanye nokwengeza ikhophi yeshadi elizenzakalelayo kwiphepha lokusebenzela elihlukile, lelo shidi lingangeniswa ephepheni lokusebenzela yamanje - iphepha lokusebenzela lapho idatha yeshadi itholakala - ngokusebenzisa izinkinobho zokunqamulela zekhibhodi ezahlukene.

1. Khetha idatha ofuna ukuyisebenzisa eshadini;
2. Cindezela bese ubamba ikhi Alt ekhibhodi;
3. Cindezela bese ukhulula ukhiye we- F1 ekhibhodi;
4. Ishadi elizenzakalelayo lengezwe ephepheni lomsebenzi wamanje.

02 ka 04

Ukushintsha Uhlobo lweKhadi elizenzakalelayo le-Excel

Uma ucindezela u-F11 noma u-Alt + F1 ukhiqiza ishadi elingelona ukuthanda kwakho, udinga ukushintsha uhlobo lwezhadi elizenzakalelayo.

Uhlobo olusha lweshadi elizenzakalelayo kufanele likhethwe kusuka kufolda yamathempulethi yangokwezifiso ku-Excel ephethe izifanekiso kuphela ozidalile.

Indlela elula yokushintsha uhlobo lwezhadi elizenzakalelayo ku-Excel yi:

1. Chofoza ngakwesokudla eshadini ekhona ukuze uvule imenyu yomongo wokuchofoza ngakwesokudla ;
2. Khetha Uhlobo Lweshadi Lokushintsha kusuka kumenyu yokuqukethwe ukuze uvule ibhokisi lokubhalwa kohlobo lwethegi ;
3. Chofoza kuzibonisi ngakwesobunxele besandla sesobhokisi;
4. Chofoza ngakwesokudla kusibonelo seshadi ngakwesokunene Iphoyinti lami lezithombe;
5. Khetha "Setha njengeshadi elizenzakalelayo" kwimenyu yesimo.

03 ka 04

Ukudala nokulondoloza izifanekiso zeshadi

Uma ungakakali isifanekiso esingasetshenziswa njengehlobo leshadi elizenzakalelayo, indlela elula yokwenza lokhu yilezi:

1. Shintsha ishadi elikhona ukuze ufake zonke izinketho zokufometha - njengombala wangemuva, izilungiselelo zesilinganiso se-X ne-Y, kanye nohlobo lwefonti - kuthempulethi entsha;
2. Chofoza ngakwesokudla eshadini;
3. Khetha "Londoloza njengesifanekiso ..." kusukela kumenyu yokuqukethwe njengoba kuboniswe esithombeni ngenhla, ukuvula ibhokisi lebhokisi le-Isitoreji se- Isitoreji Sokugcina;
4. Qamba isifanekiso;
5. Chofoza inkinobho yokulondoloza ukuze ulondoloze ithempulethi bese uvale ibhokisi lengxoxo.

Qaphela: Ifayela ligcinwa njengefayela le- .crtx endaweni elandelayo:

C: \ Amadokhumenti nezilungiselelo \ igama lomsebenzisi \ AppData \ Roaming \ Microsoft \ Izifanekiso \ Amashadi

04 ka 04

Ukususa Isifanekiso Seshadi

Indlela elula yokususa ithempulethi yeshadi langokwezifiso ku-Excel yile:

1. Chofoza ngakwesokudla eshadini elikhona ukuze uvule imenyu yokuchofoza okukwesokudla;
2. Khetha "Thayipha Uhlobo Lweshadi" kusuka kumenyu yokuqukethwe ukuze uvule ibhokisi lokubhalwa kweThi leThiphu lokuTshintsha;
3. Chofoza kuzibonisi ngakwesobunxele besandla sesobhokisi;
4. Chofoza inkinobho Yokuphatha Izifanekiso engxenyeni engezansi engakwesokunxele yebhokisi lengxoxo ukuze uvule ifolda yezifanekiso zeshadi;
5. Chofoza ngakwesokudla kuthempulethi ukuthi ususwe bese ukhetha Susa kwimenyu yokuqukethwe - ibhokisi lebhokisi lefayela lefayela lizovula lizokucela ukuthi uqinisekise ukususwa kwefayela;
6. Chofoza ku- Yebo ebhokisini lengxoxo ukususa ithempulethi bese uvale ibhokisi lengxoxo.