Iifomathi zitshintsho ezenziwe kwiifomethe ze-Excel ukwenzela ukuphucula ukubonakala kwazo kunye / okanye ukugxila kwingqalelo ethile kwiphepha lokusebenzela.
Ukufomathiza ukutshintsha ukubonakala kwedata, kodwa ayitshintshi idatha yangempela kwiseli, nto ingabalulekile ukuba loo datha isetyenziswe kwizibalo. Ngokomzekelo, ukufomatha amanani ukubonisa kuphela ezimbini iindawo ezidlulileyo azifinyezi okanye ixabiso elijikelezayo ngeendawo ezimbini ezidlulileyo.
Ukutshintsha ngokuqinisekileyo amanani ngale ndlela, idatha iya kufuneka idibeneyo isebenze enye yemisebenzi yokujikeleza ye-Excel.
01 ngo 04
Ukufometha amanani kwi-Excel
Ukufometha kwamanani kwi-Excel kusetyenziswa ukutshintsha ukubukeka kwenani okanye inani kwieseli kwiphepha lokusebenzela.
Ukufometha kwenani kuqhotyoshelwe kwiseli kwaye kungabi nakwixabiso kwiseli. Ngamanye amagama, ukufometha kwamanani alitshintshi inombolo ekhoyo kwiseli, kodwa nje ngendlela ebonakala ngayo.
Umzekelo, ukhethe iseli efomathiweyo ngeenombolo ezimbi, ezizodwa okanye ezide kunye nenombolo ecacileyo kunokuba inombolo efomathiweyo iboniswe kwibha yefomula ngaphezu kwephepha lokusebenzela.
Izindlela ezigqityiweyo zokutshintsha ifomathi ziquka:
- izitshixo ezimfutshane kwikhibhodi;
- ukufometha iimpawu kwi- ribbon ;
- Ibhokisi yencoko yebhokisi yencoko .
Ukufometha kwamanani kungasetyenziswa kwiseli enye, iikholomu ezipheleleyo okanye imigqa, uluhlu lweefayile olukhethiweyo, okanye iphepha elipheleleyo lomsebenzi.
Ifomathi engapheliyo yamaseli aqulethe yonke idatha yindlela eqhelekileyo. Le ndlela ayinayo ifomathi ethile kwaye, ngokuzenzakalelayo, ibonisa iinombolo ezingenazo iimpawu zeedola okanye ama-commas kunye namanani adibeneyo - amanani aqukethe icandelo elincinci - alinganiselwe kwinani elithile leendawo zokugqibela.
02 we 04
Ukusebenzisa ukuFometha kweNombolo
Inhlanganisela ebalulekileyo engasetyenziselwa ukufometha kwenombolo kwidatha yile:
Ctrl + Shift + ! (isikhalazo)Iifom ezenzelwe idatha yeenkcukacha ezikhethiweyo usebenzisa izitshixo zokusondeza zi:
- indawo ezimbini zokugqibela
- i-comma njenge-separator yewaka (,)
Ukufaka ifomathi yokufomatha kwiedatha usebenzisa izitshixo zokufutshane:
- Gqamisa iiseli ezineenkcukacha ezifomathiweyo
- Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi
- Cinezela ukhulule iqhosha lokumangalisa (!) - elisezantsi kwinombolo 1 - kwibhodibhodi ngaphandle kokukhulula izicwangciso zeCtrl kunye neShift
- Ukukhupha ii-Ctrl kunye neShift
- Xa kufanelekile, amanani kumaseli akhethiweyo aya kufomathiweyo ukuze abonise ifomathi ezikhankanywe ngasentla
- Ukuqakraza nayiphi na iseli ibonisa inani elingenakutshintshwa kwinombolo yefom ephezulu kwiphepha lokusebenzela
Qaphela: kuba manani anesibini kwiindawo ezidlulileyo kuphela ezikwindawo zokugqibela ezidlulileyo eziboniswayo, ezinye azisuswanga kwaye ziya kusetyenziswa ekubaleni ezibandakanya ezi xabiso.
Faka isicelo sokufometha kweenombolo usebenzisa i-Ribbon Options
Nangona iifom ezimbalwa eziqhelekileyo ezisetyenzisiweyo ziyafumaneka njengemifanekiso nganye kwikhaya lasekhaya lebhanethi, njengoko kuboniswe kumfanekiso ongentla, iifom zeenombolo ezininzi zisekhohlwini lokuhlahla lwefomathi yeNombolo -ebonisa jikelele njengefomathi epheleleyo yamaseli Ukusebenzisa okukhethwa kukho uluhlu:
- Gqamisa iiseli zedatha ukuba zifomathiwe
- Cofa kwinqolo engezantsi kweNombolo yefomathi yefowuni ukuvula uluhlu lokuhlahla
- Cofa kwiNombolo yokukhetha kwoluhlu usebenzise olu khetho kwiiseli ezikhethiweyo zedatha
Inombolo ifomathiweyo kwiindawo ezimbini ezidlulileyo njengendlela yebhodi yekhefu ngasentla, kodwa i-comma separator ayisetyenzisiwe ngale ndlela.
Faka isicelo sokufometha kweenombolo kwiBhokisi yoLwazi lweefayile zefayile
Zonke iindlela zokufometha kweenombolo zifumaneka kwibhokisi yencoko yebhokisi yefomathi .
Kukho iindlela ezimbini zokuvula ibhokisi yencoko:
- Cofa kwibhokisi yebhokisi yencoko yebhokisi yencoko - umncinci omncinci ongezantsi ukuya kwicala lasekunene leqela leqela le icon kwibhande
- Cinezela Ctrl + 1 kwikhibhodi
Izinketho zokufometha kweseli kwibhokisi yencoko yababini zihlanganiswe ndawonye kwiintlu ezithethiweyo kunye neefomati zeenombolo eziphantsi kweTebhu yeNombolo .
Kule ithebhu, ifomathi ezikhoyo zihlulwe kwiindidi kwiwindow. Cofa kwikhetho kwifestile kunye neempawu kunye nesampuli yolu khetho luboniswa ngakwesokudla.
Ukucofa kwiNombolo kwiwindow yokunxele ibonisa iimpawu ezingalungiswa
- inani leendawo zokugqibela eziboniswe
- ukusetyenziswa kwe-comma separator ngamawaka
- ukubonisa iinketho ngamanani amaninzi
03 we 04
Faka isicelo sokufometha kwemali
Ukusebenzisa Ukufometha Kwemali Ukusebenzisa iiNqakraza zeNqamlezo
Inhlanganisela ebalulekileyo engasetyenziselwa ukufomatha ukufomatha kwemali kwidatha:
- Ctrl + Shift + idola (uphawu lweedola)
Iifomati zemali ezingagqibekanga ezisetyenzisiweyo kwidatha ekhethiweyo usebenzisa izitshixo zokusondeza zi:
- uphawu lwe dola
- indawo ezimbini zokugqibela
- i-comma njengabahluli bamawaka (,)
Amanyathelo okuSebenzisa ukuFometha kweMali ngokusebenzisa iiNqamlezo ezifutshane
Ukufaka ukufometha kwemali kwiedatha usebenzisa izitshixo ezifutshane:
- Gqamisa iiseli ezineenkcukacha ezifomathiweyo
- Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi
- Cinezela kwaye ukhulule ikhidi yesignali yedola (i-$) - ekho ngaphezu kwenombolo 4 - kwikhibhodi ngaphandle kokukhipha iifayile zeCtrl kunye ne- Shift
- Ukukhupha ii-Ctrl kunye neShift
- Iiseli ezikhethiweyo ziya kufomelwa ngemali kwaye, xa kufanelekile, zibonise ifomathi ezikhankanywe ngasentla
- Ukuqakraza nayiphi na iseli ibonisa inani elingenakutshintshwa kwinombolo yefom ephezulu kwiphepha lokusebenzela.
Faka isicelo sokufometha kwemali usebenzisa i-Ribbon Options
Ifomati yemali ingasetyenziselwa idatha ngokukhetha ukhetho lwemali kwiluhlu lokuhla lweNombolo yeFom.
I - icon ye dola (i $) ekhoyo kwiqela leqela kwithebhu yaseKhaya yebhebhoni, akuyiyo ifomati yemali kodwa ifomathi ye- Akhawunti njengoko kuboniswe kumfanekiso ongentla.
Uhlobo oluphambili phakathi kwezi zibini kukuba ifomathi ye- Akhawunti ihambelana nomqondiso weli dola kwicala lasekhohlo leseli ngelixa lilungele idatha ngokwayo.
Faka isicelo sokufometha kweeMali kwiBhokisi yoLwazi lweeNethwekisi
Ifomathi yemali kwibhokisi yencoko yefayile yefayile ifana kakhulu nefomati yenombolo, ngaphandle kwekhetho lokukhetha uphawu olukhethiweyo lwemali ukusuka kwisibonakaliso seDola.
Ibhokisi yefayile yebhokisi yencoko yababini ingavulwa enye yeendlela ezimbini:
- Cofa kwibhokisi yebhokisi yencoko yebhokisi yencoko - umncinci omncinci ongezantsi ukuya kwicala lasekunene leqela leqela le icon kwibhande
- Cinezela Ctrl + 1 kwikhibhodi
Kwibhokisi yencoko, nqakraza kwiMali kwiluhlu lweqela kwicala lasekhohlo ukujonga okanye utshintshe izicwangciso zangoku.
04 we 04
Faka isicelo sokufometha kweepesenti
Qinisekisa ukuba idatha iboniswe kwifom yepesenti efakwe kwifom ye-decimal - efana ne-0.33 - leyo, xa ifomathiweyo yeepesenti, iya kubonisa ngokuchanekileyo njenge-33%.
Ngaphandle kwenombolo 1, iinombolo ezipheleleyo-ezingenaso isahlulo esiphezulu - azifomathi ngokuqhelekileyo ngeepesenti njengoko ixabiso lokuboniswa linyuswa ngumlinganiselo we-100.
Ngokomzekelo, xa ifomathiweyo yepesenti:
- Inombolo 1 iya kuboniswa njenge-100%;
- inani 33 liza kuboniswa njenge-3300%.
Faka isicelo sokufometha kwamaPhesenti usebenzisa iiNqamlezo ezifutshane
Inhlanganisela ebalulekileyo engasetyenziselwa ukufometha kwenombolo kwidatha yile:
Ctrl + Shift + % (uphawu lwepesenti)Iifom ezenzelwe idatha yeenkcukacha ezikhethiweyo usebenzisa izitshixo zokusondeza zi:
- 0 iindawo zokugqibela
- uphawu lwepesenti luyongezwa
Amanyathelo okufaka iifomenti zeepesenti ngokusebenzisa i-shortcut Keys
Ukufaka ifomenti yokufomatha kwiedatha usebenzisa izitshixo ezifutshane:
- Gqamisa iiseli ezineenkcukacha ezifomathiweyo
- Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi
- Cinezela kwaye ukhulule ikhefu yecatshulwa yecatshulwa (%) - ekho ngaphezu kwenombolo 5 - kwibhodibhodi ngaphandle kokukhulula izicwangciso zeCtrl kunye neShift
- Ukukhupha ii-Ctrl kunye neShift
- Amanani kwiiseli ezikhethiweyo aya kufomathiweyo ukuze abonise uphawu lwepesenti
- Ukuchofoza kuyo nayiphi na iseli efomathiweyo ibonisa inani elingenakuqhathaniswa nenombolo kwibha yefomula ngaphezu kwephepha lokusebenzela
Faka isicelo sokufometha kweepesenti usebenzisa i-Ribbon Options
Ifomathi yeepesenti ingasetyenziselwa kudatha ngokusebenzisa ikhefu yeposenti ekhoyo kwiqela leqela kwithebhu yaseKhaya yebhebhoni, njengoko kuboniswe kumfanekiso ongentla, okanye ngokukhetha inketho yepesenti ukusuka kuludwe lokuhla lweNombolo yeNombolo .
Umehluko kuphela phakathi kwembini kukuba i-icon ibhenqo, njengendlela yokuncinci yebhodi yebhodi ngasentla, ibonisa indawo zedesimali ngelixa uluhlu lokuhlula phansi lubonisa indawo ephakamileyo. Umzekelo, njengoko kuboniswe kumfanekiso ongentla, inombolo 0.3256 iboniswa njenge:
- 33% xa ifomathiwe usebenzisa i-icon yerbbon
- 32.56% xa ifomathiweyo usebenzisa uluhlu lokuhlula phantsi
Inombolo ifomathiweyo kwiindawo ezimbini ezidlulileyo njengendlela yebhodi yekhefu ngasentla, kodwa i-comma separator ayisetyenzisiwe ngale ndlela.
Faka ipesenti usebenzisa Iifayile zeeNowuni zeeNdiya
Ukuqwalasela inani lezinyathelo ezifunekayo ukufikelela kwikhefu yefom yebhokisi yencoko yeefomathi, kukho amaxesha ambalwa xa olu khetho lufuneka lusetyenziswe endaweni yesinye seendlela ezikhankanywe ngasentla.
Isizathu esisodwa sokukhetha ukusebenzisa olu khetho luya kuguqula inani leendawo zokugqibela eziboniswe kunye neenombolo ezifomathiweyo zeepesenti - kwibhokisi yencoko inani leendawo zokugqibela ezibonisiweyo zingasetwa ukusuka kwi-zero ukuya kwi-30.
Ibhokisi yefayile yebhokisi yencoko yababini ingavulwa enye yeendlela ezimbini:
- Cofa kwibhokisi yebhokisi yencoko yebhokisi yencoko - umncinci omncinci ongezantsi ukuya kwicala lasekunene leqela leqela le icon kwibhande
- Cinezela Ctrl + 1 kwikhibhodi