Lapho usujwayele izinqamuleli zekhibhodi, kunzima kakhulu ukuphila ngaphandle kwazo. Ngenxa yalezi zinhlanganisela eziyisihluthulelo, inqobo nje uma kunendlela enqamulelayo etholakalayo yomsebenzi ojwayele ukuwusebenzisa, sigwema ukubheka kude esikrinini, umkhiqizo wakho awuthinteki.
Ezinsukwini ezimbalwa ezedlule, ngishicilele i-athikili lapho ngikukhombise khona uchungechunge lwe izinqamuleli zokusebenza ngamashidi we-Excel. Namuhla sekuwukujika kolunye uchungechunge lwezinqamuleli, kulokhu, izinqamuleli ezihlobene ne- Ukufomatha amaseli nalapho kwakhiwa amafomula.
Izinqamuleli ze-Excel zokufometha amaseli
- Faka noma susa okugqamile: Command + B
- Faka noma ususe omalukeke: Command + I
- Faka noma susa umdwebo: Command + U
- Faka noma susa ukudlikiza: Command + Shift + X
- Sebenzisa ifomethi yemali: Lawula + Shift + E (Euro)
- Sebenzisa ifomethi yamaphesenti: Lawula + Shift + Iphesenti uphawu (%)
- Sebenzisa ifomethi yosuku (usuku, inyanga, unyaka): Lawula + uphawu lwenombolo (#)
- Sebenzisa ifomethi yesikhathi (ihora nomzuzu ngo-AM noma u-PM): Lawula + Shift + Esithombeni (@)
- Faka isixhumanisi: Command + K noma Control + K
- Faka ukuhlukana komugqa ngaphakathi kweseli: Command + Option + Return or Control + Option + Return
- Faka izinhlamvu ezikhethekile: Lawula + Command + Spacebar
- Qondanisa Isikhungo: Command + E
- Qondanisa Kwesobunxele: Command + L
- Khombisa ibhokisi leseli lamafomethi: Command + 1
- Khombisa ibhokisi lengxoxo le-Modify Cell Style: Command + Shift + L
- Faka umngcele kumaseli akhethiwe: Command + Option + 0 (zero)
- Susa imingcele yohlaka: Command + Option + Dash (-)
Izinqamuleli ze-Excel zokusebenza ngamafomula
- Nweba noma goqa i-Formula Bar: Control + Shift + U
- Khombisa umakhi wefomula: Shift + F3
- Khombisa umakhi wefomula (ngemuva kokungeza igama lomsebenzi): Control + A
- Qala ifomula: Uphawu olulinganayo (=)
- Faka ifomula njengefomula yamalungu afanayo: Command + Shift + Return or Control + Shift + Return
- Bala ishidi elisebenzayo: I-Offset + F9
- Faka ifomula ye-AutoSum: Command + Shift + T
- Faka idethi yamanje: Control + Semicolon (;)
- Faka isikhathi samanje: Command + Semicolon (;)
- Khansela ukungena kuseli noma kubha yefomula: Ukhiye we-Escape