Izinqamuleli zekhibhodi ku-Excel ye-Mac: Sebenza njengochwepheshe

Isibuyekezo sokugcina: 22/05/2024
Umbhali: USebastian Vidal

Izinqamuleli zekhibhodi ku-Excel ye-Mac

Uma ungumsebenzisi we- I-Excel ku-Mac, izinqamuleli zekhibhodi ukwazi kungashintsha indlela osebenza ngayo ngamaspredishithi. Lezi zinqamuleli zikuvumela ukuthi wenze izenzo ngokushesha nangempumelelo, ugwema isidingo sokuhlala uzulazula kumamenyu namabha amathuluzi. Funda ukuthi ungathola kanjani okuningi ku-Excel futhi ukhuphule umkhiqizo wakho ezingeni elilandelayo.

Izinqamuleli ezibalulekile ku-Excel kubasebenzisi be-Mac

Ake siqale ngezinqamuleli ezibalulekile okufanele wonke umsebenzisi we-Excel ku-Mac azazi. Lezi zinhlanganisela ezibalulekile zizokuvumela ukuthi wenze imisebenzi evamile ngokuphazima kweso:

  • Umyalo + N: Dala ifayela elisha le-Excel.
  • Shift + Command + P: Dala ifayela elisha kusuka kusifanekiso noma itimu.
  • Umyalo + Inketho + R: Inweba noma inciphise iribhoni.
  • Umyalo + S: Londoloza noma vumelanisa ifayela lamanje.
  • Umyalo + P: Ivula ibhokisi lengxoxo yokuphrinta.
  • Umyalo + O: Vula ifayela elikhona.
  • Umyalo + W: Vala ifayela lamanje.
  • Umyalo + Q: Iphuma kuhlelo lokusebenza lwe-Excel.
  • Umyalo + Z: Ihlehlisa isenzo sokugcina esenziwe.
  • Umyalo + Y: Yenza futhi noma phinda isenzo sokugcina.

imisebenzi eyisisekelo ye-Excel ku-Mac

Ukukhetha nokuzulazula amaseli ngezinqamuleli zekhibhodi

Ukuhamba kumaseli nokwenza ukukhetha okunembayo kubalulekile ekusebenzeni kahle komsebenzi ku-Excel. Lezi zinqamuleli zizokusiza ukufeza lokhu ngaphandle kokusebenzisa igundane:

  • Shift + ukhiye womcibisholo: Nweba okukhethiwe iseli eyodwa ohlangothini olukhonjisiwe.
  • Shift + Command + ukhiye womcibisholo: Inweba okukhethiwe kuseli lokugcina elingenalutho kukholomu noma umugqa ofanayo.
  • I-Shift + Ikhaya o Shift + FN + Umcibisholo Wesokunxele: Nweba ukukhetha kuye ekuqaleni komugqa.
  • Lawula + Shift + Ikhaya o Lawula + Shift + FN + Umcibisholo Wesokunxele: Nweba ukukhetha kuye ekuqaleni kweshidi.
  • Lawula + Shift + End o Lawula + Shift + FN + Umcibisholo Wesokudla: Inweba ukukhetha kuseli lokugcina eshidini.
  • Ukulawula + Ibha Yesikhala: Khetha ikholomu yonke.
  • I-Shift + Ibha Yesikhala: Khetha umugqa wonke.
  • Umyalo + A: Khetha isifunda samanje noma lonke ishidi.
Okuqukethwe okukhethekile - Chofoza Lapha  I-Pokémon Hamba ayisebenzi: Izixazululo Nosizo

Thuthukisa amakhono akho efomula ku-Excel usebenzisa izinqamuleli eziwujuqu

Amafomula ayinhliziyo ye-Excel, futhi lezi zinqamuleli zizokuvumela ukuthi usebenze kahle kakhulu:

  • F2: Hlela iseli ekhethiwe.
  • Lawula + Shift + C: Inweba noma yenza inkontileka ibha yefomula.
  • Ngena: Iqedela ukufakwa kweseli.
  • I-Esc: Ikhansela okufakiwe kuseli noma ibha yefomula.
  • I-Shift + F3: Vula Umakhi Wefomula.
  • I-Shift + F9: Ibala ishidi elisebenzayo.
  • = (uphawu olulinganayo): Uqala ifomula.
  • Umyalo + T o F4: Iguqula phakathi kwereferensi yefomula ephelele, ehlobene nexubile.
  • Shift + Command + T: Faka ifomula ye-Autosum.

Izinqamuleli zekhibhodi zokusebenza ngamashadi, izihlungi, nezinhlaka

I-Excel ayigcini nje ngezinombolo, kodwa futhi imayelana nokubonwa kwedatha. Lezi zinqamuleli zizokusiza ukuthi udale futhi ulawule amashadi, izihlungi, nezinhlaka kalula:

  • F11: Faka ishidi elisha leshadi.
  • Okhiye beziqondiso: Zungeza ukukhethwa kwento yeshadi.
  • Umyalo + Shift + F o Lawula + Shift + L: Engeza noma khipha okokuhlunga.
  • Ukulawula + 8: Ibonisa noma ifihla izimpawu zohlelo.
  • Ukulawula + 9: Ifihla imigqa ekhethiwe.
  • Lawula + Shift + (: Ibonisa imigqa ekhethiwe.
  • Ukulawula + 0: Ifihla amakholomu akhethiwe.
  • Lawula + Shift + ): Ibonisa amakholomu akhethiwe.
Okuqukethwe okukhethekile - Chofoza Lapha  Isikrini seselula asivali

amafomula anezinqamuleli zekhibhodi i-Excel ye-Mac

 Imisebenzi ethuthukisiwe ngokhiye F ku-Excel ye-Mac

Okhiye bomsebenzi (F1 ukuya ku-F12) nabo banezenzo ezihlotshaniswayo ku-Excel ye-Mac Nazi ezinye eziwusizo kakhulu:

  • F1: Ivula iwindi losizo le-Excel.
  • F2: Hlela iseli ekhethiwe.
  • I-Shift + F2: Faka inothi noma vula bese uhlela inothi yeseli.
  • Umyalo + Shift + F2: Faka amazwana anentambo noma vula bese uphendula amazwana akhona.
  • F5: Ibonisa ibhokisi lengxoxo elithi “Yiya ku-”.
  • I-Shift + F9: Ibala ishidi elisebenzayo.
  • F11: Faka ishidi elisha leshadi.
  • F12: Ibonisa ibhokisi lengxoxo elithi “Londoloza Njenge”.

Yenza ngokwezifiso izinqamuleli zakho zekhibhodi ku-Excel ye-Mac

Ubuwazi ukuthi ungakwazi dala izinqamuleli zakho zekhibhodi ku-Excel ye-Mac? Landela lezi zinyathelo ukuze wenze kube ngokwakho ukuzizwisa kwakho:

  1. Vula i-Excel bese uya kubha yemenyu phezulu esikrinini.
  2. Chofoza "Amathuluzi" bese ukhetha "Yenza ngokwezifiso Ikhibhodi."
  3. Efasiteleni le-pop-up, khetha isigaba nomyalo ofuna ukuwuhlobanisa nesinqamuleli.
  4. Chofoza inkambu ethi “Cindezela isinqamuleli sekhibhodi esisha” bese ufaka inhlanganisela yokhiye oyifunayo.
  5. Chofoza okuthi “Engeza” ukuze ulondoloze isinqamuleli sangokwezifiso esisha.
Okuqukethwe okukhethekile - Chofoza Lapha  Imodi engathembekile ye-WhatsApp: Uyenza isebenze kanjani

Uma isinqamuleli osikhethayo sesivele sabelwe omunye umsebenzi, i-Excel izokwazisa. Ungakhetha ukufaka esikhundleni somsebenzi ozokwenziwa wangaphambilini noma ukhethe inhlanganisela ehlukile.

Uchwepheshe izinqamuleli zekhibhodi ku-Excel ye-Mac ikwenza umpetha wespredishithi wangempela. Ngokuzijwayeza, uzokwazi ukwenza imisebenzi eyinkimbinkimbi endabeni yemizuzwana, wandise yakho ukusebenza kahle kanye nokukhiqiza. Ungesabi ukumba futhi wenze ngendlela oyifisayo izinqamuleli ngokwezidingo zakho.