Nje ukuba uqhele iindlela ezimfutshane zekhibhodi, kunzima kakhulu ukuhlala ngaphandle kwazo. Enkosi kwezi zinto zidityanisiweyo, ukuba nje kukho indlela emfutshane efumanekayo yokusebenza oqhele ukuyisebenzisa, siyakuphepha ukujonga kude kwiscreen, ke imveliso yakho ayichaphazeleki.
Kwiintsuku ezimbalwa ezidlulileyo, ndapapasha inqaku apho ndikubonise uthotho lwe iindlela ezimfutshane zokusebenza ngamaxwebhu e-Excel. Namhlanje kukujika kolunye uthotho lweendlela ezimfutshane, ngeli xesha, iindlela ezimfutshane ezinxulumene ne Ukufomatha iseli naxa kusenziwa iifomula.
Iindlela ezimfutshane ze-Excel zokufomatha iiseli
- Yongeza okanye ususe isibindi: Myalelo + B
- Yongeza okanye susa oonobumba: Myalela + mna
- Yongeza okanye ususe umgca ngaphantsi: Command + U
- Yongeza okanye ususe uqhankqalazo: Command + Shift + X
- Faka isicelo sefomathi yemali: Ulawulo + Shift + E (Euro)
- Faka ifomathi yepesenti: Lawula + Shift + Ipesenti yomqondiso (%)
- Sebenzisa ifomathi yomhla (usuku, inyanga, unyaka): Ulawulo + uphawu lweenombolo (#)
- Faka isicelo sefomathi yexesha (iyure kunye nomzuzu nge-AM okanye nge-PM): Ulawulo + Shift + Kwi (@) uphawu
- Faka i-hyperlink: Command + K okanye uLawulo + K
- Faka ulwaphulo lomgca ngaphakathi kweseli: Yalela + uKhetho + Ukubuyela okanye ukuLawula + uKhetho + Ukubuyela
- Faka abalinganiswa abakhethekileyo: Lawula + Umyalelo + Ibha yendawo
- Lungelelanisa iZiko: Myalelo + E
- Lungelelanisa Ekhohlo: Umyalelo + L
- Bonisa ifomathi yencoko yababini beeseli: Umyalelo + 1
- Veza ibhokisi yencoko yababini yokuguqula isitayile seseli: Command + Shift + L
- Yongeza umda kwiiseli ezikhethiweyo: Lawula + Ukhetho + 0 (zero)
- Susa umda wesishwankathelo: Command + Option + Dash (-)
Iindlela ezimfutshane ze-Excel zokusebenza neefomula
- Yandisa okanye ugoqe iBar yeFomula: Ulawulo + Shift + U
- Bonisa umakhi wefomyula: Shift + F3
- Bonisa umakhi wefomyula (emva kokongeza igama lomsebenzi): Ulawulo + A
- Qala ifomula: Uphawu olulinganayo (=)
- Faka ifomula njengefomula yoluhlu: Command + Shift + Return okanye Control + Shift + Return
- Bala iphepha elisebenzayo: I-Offset + F9
- Faka ifomula ye-AutoSum: Command + Shift + T.
- Faka umhla okhoyo ngoku: Ulawulo + lweSemicolon (;)
- Faka ixesha langoku: Command + Semicolon (;)
- Rhoxisa ukungena kwiseli okanye kwifom yefomula: Iqhosha lokubaleka