Izinketho zokufomathiza ezinemeko ye-Excel zivumela ukuba usebenzise iindlela ezahlukeneyo zokufomatha, ezifana nombala wangemvelaphi, imida, okanye ukufometha kwefonti kwi-data ehlangabezana nezimo ezithile. Umhla wokugqibela, umzekelo, unokufomathiweyo ukubonisa imvelaphi ebomvu okanye umbala wefonti oluhlaza okanye zombini.
Ukufomatha komqathango kusetyenziswa kwelinye okanye ngaphezulu kweeseli kwaye, xa idatha kulawo maseli ihlangabezana nemeko okanye iimeko ezimiselweyo, ifomathi ezikhethiweyo ziyasetyenziswa. Ukuqala nge- Excel 2007 , i-Excel inomlinganiselo weendlela zokufomathiza ezisemgangathweni ezisetyenziswe kuqala ezenza kube lula ukusebenzisa izimo eziqhelekileyo ezisetyenziselwa idatha. Ezi zikhetho ezikhethiweyo ziquka ukufumana amanani angentla okanye ngaphantsi kwexabiso eliqhelekileyo kwibala leenkcukacha ezikhethiweyo.
Ukufumana ngaphezulu kweMilinganiselo yeMilinganiselo neFomation Format
Lo mzekelo uhlanganisa amanyathelo okulandelwayo ukufumana amanani angaphezulu kwesilinganiso kwibala elikhethiweyo. Amanyathelo afanayo angasetyenziselwa ukufumana ixabiso langaphantsi.
Iimfundiso zeTutorial
- Faka idatha elandelayo kwiiseli A1 ukuya ku-A7:
- 8, 12, 16, 13, 17, 15, 24
- Khanyisa iiseli A1 ukuya ku-A7
- Cofa kwiTebhu yeKhaya
- Cofa kwi icon Yokwenza Umoya kwi- Ribbon ukuvula imenyu ehlayo
- Khetha Imimiselo ephezulu / engaphantsi> Ephezulu Kwinqanaba ... ukuvula ibhokisi yencoko yencoko yefomathi
- Ibhokisi yencoko iqulethe uluhlu lwezinto zokufometha zangaphambili ezisetyenziselwa ukusetyenziswa kwifayile ekhethiweyo
- Cofa kwitolo eliphantsi kwicala lokunene loluhlu lokuhla ukuze uluvule
- Khetha indlela yokwenza ifomathi yedatha - lo mzekelo usebenzise ukuKhanya okuBomvu ngokuKhanya okuMnyama
- Ukuba awuyithandi nayiphi na indlela yokukhethwa kwangaphambili, sebenzisa inketho yangokwezifiso phantsi kwoluhlu ukukhetha zakho zokhetho zokufometha
- Emva kokuba ukhethe inketho yokwenza ifomathi, nqakraza Kulungile ukwamkela utshintsho uze ubuyele kwiphepha lokusebenzela
- Amaseli A3, A5, kunye ne-A7 kwiphepha lokusebenzela kufuneka ngoku lifomathiwe ngeendlela ezikhethiweyo zokufometha
- Ixabiso eliqhelekileyo leenkcukacha li- 15 , ngoko ke, inani kuphela kule maseli amathathu linamanani angaphezulu kweyonke
Qaphela Ukufometha kwakungasetyenziswanga kwiseli A6 kuba inani eliseli seleni lilingana nexabiso eliqhelekileyo kwaye lingekho ngaphezu kwayo.
Ukufumana ngaphantsi kweMilinganiselo yeeMilinganiselo kunye nokuFometha kwemiqathango
Ukufumana amanani aphantsi angaphantsi, kwinqanaba lesi-5 ngasentla, khetha ikhetho elingezantsi.