Njira zazifupi za kiyibodi mu Excel for Mac: Gwirani ntchito ngati katswiri

Kusintha komaliza: 22/05/2024
Author: Sebastian Vidal

Njira zazifupi za kiyibodi mu Excel for Mac

Ngati mukugwiritsa ntchito Excel pa Mac, kudziwa njira zazifupi za kiyibodi kumatha kusintha momwe mumagwirira ntchito ndi maspredishiti. Njira zazifupizi zimakupatsani mwayi wochita zinthu mwachangu komanso moyenera, kupewa kufunikira koyenda nthawi zonse pamindandanda yazakudya ndi zida. Phunzirani momwe mungapindulire ndi Excel ndikutenga zokolola zanu kupita pamlingo wina.

Njira zazifupi zofunika mu Excel kwa ogwiritsa ntchito a Mac

Tiyeni tiyambe ndi njira zazifupi zomwe aliyense wogwiritsa ntchito Excel pa Mac ayenera kudziwa. Kuphatikizika kofunikira uku kumakupatsani mwayi wochita ntchito zomwe wamba m'kuphethira kwa diso:

  • Lamulo + AKAZI: Pangani fayilo yatsopano ya Excel.
  • Shift + Command + P: Pangani fayilo yatsopano kuchokera ku template kapena mutu.
  • Lamulo + Yankho + R: Imakulitsa kapena kuchepetsa riboni.
  • Cmd+S: Sungani kapena kulunzanitsa fayilo yomwe ilipo.
  • Cmd + P: Amatsegula bokosi losindikiza.
  • Lamulo + O: Tsegulani fayilo yomwe ilipo.
  • Command+W: Tsekani fayilo yomwe ilipo.
  • Lamulo + Q: Yatuluka mu Excel application.
  • Lamulo + Z: Imatsegula zomwe zachitika komaliza.
  • Lamulo + Y: Bwerezani kapena bwerezani zomwe zamaliza.

Basic Excel ntchito pa Mac

Kusankha ndikuyenda ma cell okhala ndi njira zazifupi za kiyibodi

Kuyenda m'maselo ndikupanga zisankho zolondola ndikofunikira kuti mugwire bwino ntchito mu Excel. Njira zazifupizi zidzakuthandizani kukwaniritsa izi popanda kugwiritsa ntchito mbewa:

  • Shift + arrow key: Imakulitsa kusankha kwa selo limodzi mbali yomwe yasonyezedwa.
  • Shift + Command + arrow key: Imakulitsa kusankha ku selo lomaliza lopanda kanthu mugawo kapena mzere womwewo.
  • Shift + Kunyumba o Shift + FN + Muvi Wakumanzere: Imakulitsa kusankha mpaka koyambirira kwa mzere.
  • Control + Shift + Kunyumba o Control + Shift + FN + Left Arrow: Imakulitsa kusankha mpaka kumayambiriro kwa pepala.
  • Control + Shift + End o Control + Shift + FN + Right Arrow: Imakulitsa kusankha ku selo yomaliza papepala.
  • Control + Space bar: Sankhani gawo lonse.
  • Shift + Spacebar: Sankhani mzere wonse.
  • Lamulo + A: Sankhani chigawo chapano kapena pepala lonse.
Zapadera - Dinani apa  Mafunso osadziwika pa Instagram: amagwira ntchito bwanji?

Limbikitsani luso lanu la formula mu Excel pogwiritsa ntchito njira zazifupi

Mafomuwa ndiye mtima wa Excel, ndipo njira zazifupizi zimakupatsani mwayi wogwira nawo ntchito bwino:

  • F2: Sinthani selo losankhidwa.
  • Control + Shift + C: Imakulitsa kapena kugulitsa formula bar.
  • Lowani: Imamaliza kulowa mu cell.
  • Esc: Imaletsa kulowa mu cell kapena formula bar.
  • Kuloza + F3: Tsegulani Formula Builder.
  • Kuloza + F9: Kuwerengera pepala logwira ntchito.
  • = (chizindikiro chofanana): Ayambitsa chilinganizo.
  • Lamula + T. o F4: Imasinthasintha pakati pa maumboni amtheradi, achibale ndi osakanikirana.
  • Shift + Command + T: Ikani fomula ya Autosum.

Njira zazifupi za kiyibodi pogwira ntchito ndi ma chart, zosefera, ndi maulalo

Excel sikuti imangokhala manambala, komanso kuwonetsa ma data. Njira zazifupizi zikuthandizani kupanga ndikusintha ma chart, zosefera, ndi ma autilaini mosavuta:

  • F11: Ikani tchati chatsopano.
  • Makiyi amivi: Yendani mozungulira posankha chinthu.
  • Command + Shift + F o Control + Shift + L: Onjezani kapena chotsani fyuluta.
  • Kuwongolera + 8: Imawonetsa kapena kubisa zilembo zamakonzedwe.
  • Kuwongolera + 9: Imabisa mizere yosankhidwa.
  • Control + Shift + (: Imawonetsa mizere yosankhidwa.
  • Kuwongolera + 0: Imabisa mizati yosankhidwa.
  • Control + Shift +): Imawonetsa mizati yosankhidwa.
Zapadera - Dinani apa  Turtonator

Mafomu okhala ndi njira zazifupi za kiyibodi Excel for Mac

 Ntchito zapamwamba ndi makiyi a F mu Excel for Mac

Mafungulo ogwiritsira ntchito (F1 mpaka F12) alinso ndi zochita zogwirizana mu Excel for Mac Nazi zina mwazofunikira kwambiri:

  • F1: Imatsegula zenera lothandizira la Excel.
  • F2: Sinthani selo losankhidwa.
  • Kuloza + F2: Ikani cholemba kapena tsegulani ndikusintha foni yam'manja.
  • Lamulo + Shift + F2: Ikani ndemanga ya ulusi kapena tsegulani ndikuyankha ndemanga yomwe ilipo.
  • F5: Imawonetsa bokosi la "Pitani ku".
  • Kuloza + F9: Kuwerengera pepala logwira ntchito.
  • F11: Ikani tchati chatsopano.
  • F12: Imawonetsa bokosi la "Save As".

Sinthani njira zazifupi zanu za kiyibodi mu Excel for Mac

Kodi mumadziwa kuti mungathe pangani njira zazifupi za kiyibodi yanu mu Excel kwa Mac? Tsatirani izi kuti musinthe zomwe mwakumana nazo:

  1. Tsegulani Excel ndikupita ku menyu omwe ali pamwamba pazenera.
  2. Dinani "Zida" ndiyeno sankhani "Sinthani Kiyibodi".
  3. Pazenera la pop-up, sankhani gulu ndi lamulo lomwe mukufuna kugwirizanitsa ndi njira yachidule.
  4. Dinani "Dinani njira yachidule ya kiyibodi" ndikulowetsa makiyi omwe mukufuna.
  5. Dinani "Add" kuti musunge njira yachidule yatsopano.
Zapadera - Dinani apa  Imelo yogwiritsa ntchito kwakanthawi: Dziwani masamba abwino kwambiri opangira akaunti

Ngati njira yachidule yomwe mwasankha yaperekedwa kale ku ntchito ina, Excel idzakudziwitsani. Mutha kusankha kusintha zomwe mwapatsidwa kale kapena kusankha kuphatikiza kosiyana.

Master ndi Njira zazifupi za kiyibodi mu Excel for Mac zimakupangani kukhala mbuye weniweni wa spreadsheet. Ndi kuchita, mudzatha kuchita ntchito zovuta mu nkhani ya masekondi, kuwonjezera wanu bwino ndi zokolola. Osachita mantha kukumba ndikusintha njira zazifupi kuti zigwirizane ndi zosowa zanu.