01 ka 01
Ukufometha Kwemibandela Ye-Excel
Ukufometha kokufometha okunemibandela
Ukwengeza ukufometha okunemibandela ku-Excel kukuvumela ukuba usebenzise okukhethwa kukho kokufometha okuhlukile kuseli noma ububanzi bamaseli ahlangabezana nezimo ezithile ozibekayo.
Izinketho zokufometha zisetshenziswa kuphela uma amaseli akhethiwe ehlangabezana nalezi zimo ezibekiwe.
Izinketho zokufomatha ezingasetshenziswa zifaka izinguquko zombala wefonti nesimo sangemuva, izitayela zefonti, imingcele yamaseli, nokwengeza ukufometha kwenombolo yedatha.
Kusuka ku-Excel 2007, i-Excel inezinombolo eziningi zokubeka ifomathi ezilungiselelwe ngaphambilini ezenzelwe izimo ezifana nokuthola izinombolo ezinkulu kunazo zonke noma ezingaphansi kwenani elithile noma ukuthola izinombolo ezingenhla noma ngezansi kwenani elilinganiselwe .
Thola okubhaliwe ngokufometha okunemibandela
Okunye okukhethwa kukho noma okukhethwa kukho kwe-Excel ukuthola ukuthola nokufometha idatha ephindaphindiwe ngokufometha okunemibandela - kungakhathaliseki ukuthi idatha ephindaphindiwe ibe umbhalo, izinombolo, izinsuku, amafomula, noma amarekhodi wonke noma amarekhodi wedatha .
Ukufometha okunemibandela kuphinde kusebenze idatha eyongezwe emva kokufometha okunemibandela isetshenziswe kuluhlu lwemininingwane, ngakho kulula ukukhetha idatha ephindaphindiwe njengoba ingeziwe ekhasini lokusebenzela.
Susa Ukuphindwa kwedatha ku-Excel
Uma umgomo ukususa idatha ephindaphindiwe hhayi nje ukuthola - kungakhathaliseki ukuthi kungamaseli angashadile noma wonke amarekhodi wedatha, esikhundleni sokusebenzisa ukufometha okunemibandela, i-Excel inikeza enye inketho eyaziwayo, akumangazi, njenge- Susa Iziqu .
Leli thuluzi lwedatha lingasetshenziselwa ukuthola nokukhipha amarekhodi wedatha ngokulinganayo noma ngokuphelele aphuma ekhasini lokusebenzela.
Thola Okubhalwe Ngomfanekiso Wokufometha Okumisiwe
Ngezansi kubalwa izinyathelo ezisetshenziselwa ukuthola amaseli aphindaphindiwe yedatha ebangeni elingu-E1 kuya ku-E6 (ukufometha okuluhlaza) obonwe esithombeni ngenhla.
- Gqamisa amaseli E1 kuya ku-E6 ekhasini lokusebenzela.
- Chofoza kuthebhu yaseKhaya ye- ribbon
- Chofoza kusithonjana sokufometha okunemibandela kwi-ribbon ukuvula imenyu yehla
- Khetha Imithetho Yezinhlamvu Ezigqamile> Ihlanganisa Amanani ... ukuvula ibhokisi lengxoxo lokufometha yamagugu
- Khetha Ukugcwalisa OkuGcwele Ngombhalo Omnyama Olubomvu kusuka ohlwini lwezinketho zokufometha kwangaphambili
- Chofoza Kulungile ukwamukela ukhetho bese uvale ibhokisi lengxoxo
- Amaseli e-E1, E4, no-E6 kufanele afakwe ngombala obala ohlaza okombala kanye nombhalo omnyama obumnyama kusukela zonke ezintathu ziqukethe idatha ephindaphindiwe - ngenyanga kaJanuwari
Thola Idatha Eyingqayizivele ngokufometha okunemibandela
Enye indlela yokufometha okunemibandela ukungatholi izinkambu zedatha, kodwa izinkambu eziyingqayizivele - lezo eziqukethe idatha ezivela kanye kuphela ebangeni elikhethiwe - njengoba kuboniswe ebangeni elingezansi lamaseli (ukufometha okubomvu) esithombeni ngenhla.
Lolu khetho luwusizo kulawo mazinga lapho kulindeleke khona idatha ephindaphindiwe - njengokuthi abasebenzi kulindeleke ukuthi bathumele imibiko ejwayelekile noma amafomu noma abafundi balethe izabelo eziningi - ezilandelwa kushidi lokusebenzela. Ukuthola amasimu ayingqayizivele kwenza kube lula ukunquma ukuthi ukuthunyelwa okunjalo kulahlekile.
Ukuthola izinkambu ezihlukile kuphela zedatha khetha ukhetho oluyingqayizivele kusuka kumafomathi Okufomathi aqukethe: uhlu lwehla phansi njengoba kuboniswe esithombeni ngenhla.
Ngezansi kubalwe izinyathelo ezisetshenziselwa ukuthola amaseli ahlukile wedatha ebangeni F6 kuya F11 (ukufometha okubomvu) okubonwe esithombeni ngenhla.
- Gqamisa amaseli F6 kuya ku-F11 ekhasini lokusebenzela
- Chofoza kuthebhu yaseKhaya ye-ribbon
- Chofoza kusithonjana sokufometha okunemibandela kwi-ribbon ukuvula imenyu yehla
- Khetha Imithetho Yezinhlamvu Ezigqamile> Ihlanganisa Amanani ... ukuvula ibhokisi lengxoxo lokufometha yamagugu
- Chofoza umcibisholo ophansi ngaphansi kwamafomathi Okufomatha aqukethe: inketho yokuvula uhlu lokudonsa - Ukuphindaphindiwe yisilungiselelo esizenzakalelayo
- Khetha inketho ehlukile ohlwini
- Khetha Ukugcwalisa Okubomvu Okukhanyayo Ngombhalo Omnyama Olubomvu kusuka ohlwini lwezinketho zokufometha kwangaphambili
- Chofoza Kulungile ukwamukela ukhetho bese uvale ibhokisi lengxoxo.
- Amaseli e-E7 no-E9 kufanele afomethiwe ngombala obomvu obomvu nombhalo omnyama obomvu ngoba yiwo kuphela amaseli ayingqayizivele yedatha ebubanzi