Vazhinji vashandisi vakacherekedza kuti kana vachishanda muMicrosoft Excel, pane zviitiko kana mumasero panguva yemaseti yedata panzvimbo yehuwandu, zvifananidzo zvinoratidzika muchimiro chegratings (#). Nomuzvarirwo, hazvigoneke kushanda neruzivo mune iyi fomu. Ngatitorei nezvikonzero zvechinetso chakataurwa towana mhinduro yaro.
Mhinduro
Chikwangwani cheLatice (#) kana, sei kuda kuzvidaidza zvakanyatsoitika, iyo octotorp inoonekwa mumasero iwayo pabepa rinokosha, umo data harienderane nemiganhu. Naizvozvo, ivo vanoona zvinoratidzwa nezviratidzo izvi, kunyangwe muchokwadi panguva yekuverenga chirongwa ichi vachishanda mushure metsika dzakafanana, uye kwete izvo zvinoratidzira pachiratidziri. Pasinei neizvi, iyo data yemushandisi inoramba isingazivikanwe, asi, zvinoreva kuti dambudziko rekubvisa dambudziko racho rakakodzera. Ehezve, iwe unogona kuona iyo chaiyo data uye ita mashandiro pamwe navo kuburikidza neiyo formula tambo, asi kune vazhinji vashandisi hazvisi zvekubuda.
Uye zvakare, iyo shanduro dzekare dzechirongwa cheLatsion zvakaratidzika kana paine mavara anopfuura gumi nemashanu mune cell texturu mune yegumi nemakumi matanhatu nemashanu, kutanga kubva muzana.
Ngatitsvage nzira yekugadzirisa dambudziko redambudziko nechiratidziro.
Maitiro 1: Manual Kuwedzera Kwemiganhu
Nzira iri nyore uye intuitive kune vazhinji vashandisi kuti vawedzere miganhu yemasero, uye, zvinoreva, uye kugadzirisa dambudziko nedare rekuratidzira panzvimbo yenhamba, rinodonha miganhu yemuchadenga.
Zvinoitwa zviri nyore kwazvo. Isu tinogadza iyo inotsemura kumuganhu pakati pemakoramu pane iyo cordinate panel. Isu takamirira iyo yekukanda kwete kushandura museve kuita mafambiro maviri. Neiyo kuruboshwe bhatani uye, kuvhara, kudhonza miganhu kusvikira waona kuti data rese rine.
Mushure mekuita izvi, sero rinowedzera, uye panzvimbo yematanda, manhamba achaonekwa.
Nzira 2: Font Restoction
Ehezve, kana paine chete makoramu kana maviri, umo iyo data haina kukwana mumasero, mamiriro acho ari akangosarudzika nenzira yakatsanangurwa pamusoro apa. Asi zvekuita kana paine akawanda makoramu akadaro. Mune ino kesi, kugadzirisa dambudziko, unogona kushandisa kuderera kweiyo font.
- Isu tinoratidza nzvimbo yatinoda kuderedza font.
- Ndichiri mu "imba" tab iri patepi mune font chishandiso block, vhura fomu rekuchinja kweFont. Isu tinoisa chiratidzo chakaderera pane icho chiri chataurwa izvozvi. Kana iyo data isingaverengeke vese vari mumasero, iwe unoisa paramita kana zvakaderera kusvikira mhedzisiro yaunoda yasvika.
Nzira 3: Upamhi
Pane imwe nzira yekuchinja font mumasero. Izvo zvinoitwa kuburikidza nekugadzira. Hukuru hwevatambi hazvizove zvakafanana kune huwandu hwese, uye mutsara wega wega uchave uine kukosha kwakaringana kuti ugone kugadzirisa data muchitokisi.
- Sarudza huwandu hwe data pamusoro pezvatichabereka kuvhiya. Tinya kurudyi mbeva bhatani. MuChamati Menyu, sarudza kukosha "cell form ...".
- Iyo windo rinoratidzira rinovhura. Enda ku "Kugadziriswa" tab. Isa shiri padyo ne "upamhi" paramende. Kuchengetedza shanduko, tinya pane "OK" bhatani.
Sezvauri kuona, mushure meizvi, iyo font mumasero yakadzikira chaizvo kuti iyo data mavari vachigara zvizere.
Nzira 4: Shanduko yehuwandu hwehuwandu
Pakutanga, pakanga paine hurukuro iyo mune shanduro yekare yeEkunyorera muganho pane huwandu hwevanhu mune imwe sero panguva yekuiswa kwechimiro chemavara chakatangwa. Sezvo nhamba yakakura kwazvo yevashandisi vanoramba vachishanda software iyi, tichamira nekugadzirisa dambudziko rakataurwa. Kuti udzikiswe ichi chinongedzo, iwe uchafanirwa kushandura chimiro chacho chine mavara pane chakajairika.
- Sarudza nzvimbo yakatarwa. Tinya kurudyi mbeva bhatani. Mune menyu inoonekwa, tinya pane chinhu "cell fomati ...".
- Mune hwindo rekufananidza, enda ku "nhamba" tab. Mu "nhamba yemafungiro" paramende, tinochinja "zvinyorwa" ku "zvakajairika". Dzvanya pane "OK" bhatani.
Zvino kurambidzwa kunobviswa uye muchitokisi kucharatidzwa nenzira kwayo chero nhamba yeavo mavara.
Iwe unogona zvakare kushandura chimiro pane tepi iri muTab yewebhu mu "nhamba" yekutonga nekusarudza kukosha kunoenderana muhwindo rakakosha.
Sezvauri kuona, dzorera octiotorp muhuwandu kana imwe data chaiyo muMicrosoft Excel chirongwa haina kuoma. Kuti uite izvi, iwe unofanirwa kuwedzera iwo makoramu, kana kuderedza font. Kune shanduro dzekare dzechirongwa, chimiro chechinyakare chakakodzera.