01 ngo 01
UkuFometha kweMeko yeMeko
Uhlolo oluPhezulu lokuFometha
Ukongeza ifomathi emiselweyo kwi-Excel ikuvumela ukuba wenze iindlela ezahlukeneyo zokufomatha kwisisele okanye uluhlu lweeseli ezidibana neemeko ezithile ozibekayo.
Izinketho zokufomatha zisetyenziswa kuphela xa iiseli ezikhethiweyo zidibana nale miqathango.
Izinketho zokufomatha ezingasetyenziswa ziquka iinguqu kunye neenguqu zemibala yangaphandle, izitayela zefonti, imida yeseli, kunye nokongeza ifomathi yokufomatha kwiedatha.
Ukususela kwi-Excel 2007, i-Excel ineenombolo ezimbalwa zendlela yokufomathiza enemiqathango yokusetyenziswa kweemeko eziqhelekileyo ezisetyenziswayo ezifana nokufumana amanani amakhulu kunawo okanye ngaphantsi kwexabiso elithile okanye ukufumana amanani angaphezulu okanye ngaphantsi kwexabiso eliphakathi .
Fumana iziPhumo zoFomathi oluMiselweyo
Enye into okanye i-Excel eyakhelwe ngaphambili kukufumana nokufomatha idatha ephindwe ngokufomathiweyo enomxholo-nokuba ngaba idatha yombhalo ibe yombhalo, amanani, imihla, iifomula, okanye iirekhodi ezipheleleyo okanye iirekhodi .
Ukufomathika kwemiqathango kusetyenziswa idatha eyongeziweyo emva kokuba ifomathi enemeko isetyenziswe kwimiba yedatha, ngoko kulula ukukhetha idatha ephindwe kabini njengoko ifakwe kwiphepha lokusebenzela.
Susa iiDuplicates Data kwi-Excel
Ukuba umnqweno ukususa idatha ephindiweyo kungekhona nje ukuyifumana - nokuba ingaba iiseli ezingatshatanga okanye iirekhodi zeenkcukacha ezipheleleyo, endaweni yokusebenzisa ifomathi engqinelanayo, i-Excel inikeza enye inketho eyaziwayo, akumangalisi, njengeSusa iziPhumo .
Esi sixhobo sedata singasetyenziselwa ukufumana nokususa iirekhodi zedatha ngokukhawuleza okanye ngokukhawuleza kwiphepha lokusebenzela.
Fumana iziPhumo kunye neFoming Formatting Example
Ngezantsi zidweliswe amanyathelo asetyenziswa ukufumana iincindi zeeseli zedatha kwi-E1 ukuya ku-E6 (ukufometha okuluhlaza) kubonwe kumfanekiso ongentla.
- Gqamisa iiseli E1 ukuya kwi-E6 kwiphepha lokusebenzela.
- Cofa kwiThebhu yasekhaya yerbhoni
- Cofa kwi icon Yokwenza Umoya kwi-Ribbon ukuvula imenyu ehlayo
- Khetha iMigaqo yeeNgcaciso zeeNgcaciso> Uphindaphinda iMilinganiselo ... ukuvula ibhokisi yencoko yefayile yencoko yefayile
- Khetha Ukugcwalisa okuGqabileyo kunye neZibhalo eziMnyama eziMnyama ukusuka kuhlu lweenketho zokufometha kwangaphambili
- Cofa u- OK ukwamkela ukhetho kwaye vala ibhokisi yencoko
- Iiselula ze-E1, i-E4 kunye ne-E6 kufuneka zifomathiweyo ngombala ohlaza obumbala obumnyama kunye nombhalo obumnyama obumnyama kuba zonke ezintathu ziqukethe idatha ephindwe kabini - ngenyanga kaJanuwari
Fumana iDatha eYodwa kunye nokufometha komqathango
Enye inketho enefomathi enemiqathango kukuba ungayifumani imithombo yeedatha, kodwa iinkalo ezikhethekileyo - ezo ziqulethe idatha ezivela kuphela kwibala ekhethiweyo - njengoko kuboniswe kwinqanaba elingaphantsi kweeseli (ukufometha okubomvu) kumfanekiso ongentla.
Olu khetho luncedo kulao meko apho kulindeleke ukuba idatha yedatha - njengokuba abasebenzi kulindeleke ukuba bangenise iingxelo okanye iifom eziqhelekileyo okanye abafundi bathumele izabelo ezininzi-ezilandelwa kwiphepha lokusebenzela. Ukufumana indawo ekhethekileyo kwenza kube lula ukucacisa xa ukuthunyelwa okunjalo kungekho.
Ukufumana indawo ekhethekileyo yedatha khetha inketho ekhethekileyo ukusuka kwiifomathi zefomathi eziqulethwe: uluhlu lwehla phantsi njengoko kuboniswe kumfanekiso ongentla.
Ngezantsi zidweliswe amanyathelo asetyenzisiweyo ukufumana iiseli eziyingqayizivele yedatha kwinqanaba F6 ukuya kwiF11 (ukufometha okubomvu) kubonwe kumfanekiso ongentla.
- Gqamisa iiseli F6 ukuya kwi-F11 kwiphepha lokusebenzela
- Cofa kwiThebhu yasekhaya yerbhoni
- Cofa kwi icon Yokwenza Umoya kwi-Ribbon ukuvula imenyu ehlayo
- Khetha iMigaqo yeeNgcaciso zeeNgcaciso> Uphindaphinda iMilinganiselo ... ukuvula ibhokisi yencoko yefayile yencoko yefayile
- Cofa kwitolo eliphantsi phantsi kweefomathi zefomathi eziqulethe: inketho yokuvula uluhlu lokuhlahla - Ukuphindaphinda kuyimimiselo engagqibekanga
- Khetha ukhetho olulodwa kwiluhlu
- Khetha Uluhlu Olubomvu Gcwalisa kunye nombhalo obomvu oluhlaza oluhlu lweenketho zokufometha kwangaphambili
- Cofa u- OK ukwamkela ukhetho kwaye vala ibhokisi yencoko.
- Iiselingi ze-E7 kunye ne-E9 mazifomathiweyo ngombala obomvu obomvu kunye nombhalo obomvu obomvu kuba ziphela kuphela iiseli eziyingqayizivele yedatha kwinqanaba