Lattice panzvimbo yenhamba muExcel. Zvekuita kana ma lattice achiratidzwa pachinzvimbo chenhamba muExcel

Zvinowanzoitika kuti paunopinda data muMicrosoft Excel, mavara anokosha, akadai sezviratidzo zvepaundi, anoratidzwa panzvimbo yedzimwe nhamba. Mamiriro ezvinhu aya anodzivirira kushanda kwakajairika kwegwaro remagetsi, saka unofanirwa kuziva kugadzirisa dambudziko iri. Ichi chinyorwa chinopa nzira dzinoverengeka dzinoshanda dzekukurumidza kugadzirisa dambudziko.

Zvikonzero zvekuonekwa kwema lattices

Masero eLattice anooneka kana nhamba yemavara apinzwa maari ikadarika muganhu. Panguva imwecheteyo, chirongwa chinorangarira iyo data yawakaisa, asi haizoaratidze nenzira kwayo kudzamara iyo yakawedzera nhamba yemavara yabviswa. Kana pakupinda manhamba muchitokisi Excel 2003 yakapfuura nhamba ye255 units, icharatidza octothorp panzvimbo yenhamba. Izvi ndizvo zvinonzi lattice mumutauro wepurogiramu.

Nenzira imwecheteyo, chinyorwa chinozviratidza kana iwe ukachiisa musero yeshanduro yazvino. Nhamba yepamusoro yetsamba inobvumirwa mumunda weExcel 2007 i1024. Izvi zvinowanzoitika kune zvigadzirwa zveExcel zvisati zvaitika 2010. Shanduro itsva hadzichapi muganhu. Uyezve, zvikonzero zvinogona kuva:

• kuvapo kwezvikanganiso zvegirama muzvinyorwa kana mavara asina kukodzera;
• uwandu hwakaverengerwa zvisizvo;
• kushandiswa kusiri iko kwemafomula uye kuverenga kwakashata mumaseru;
• kukundikana padanho rechirongwa (izvi zvinotemerwa nenzira inotevera: kana iwe ukatenderera pamusoro pesero, zvese zvinoratidzwa nenzira kwayo, uye kana ukadzvanya "Enter", kukosha kunoshanduka kuita octotorp, ichiri imwe nhamba yemavara. )

Teerera! Kuonekwa kwemabhawa muExcel minda inogona kunge iri mhedzisiro yekusetwa zvisirizvo keyboard marongero.

Zvakare, dambudziko rakafanana rinogona kuoneka kana mazita emasero asiri iwo akasarudzwa kupfupisa data. Iwe unogona kugadzirisa dambudziko nekuratidzira data rako pachako uchishandisa nzira dzinoverengeka dzinoshanda.

Iyo mhinduro

Kungodzima nhamba yemamwe mavara hakuna kukwana. Iwe uchafanirwa kushandisa nzira dzinoita kuti mavara asiri iwo anyangarika. Ngatibvei kubva nyore kuenda kune yakaoma.

Method 1: manually kuwedzera miganhu

Kuti uwedzere miganhu muMicrosoft Excel, zvakakwana kutambanudza nemaoko. Iyi inzira yakavimbika uye yakapusa inozobatsira kugadzirisa dambudziko kunyangwe kune vanotanga vakatanga kushandisa mashandiro ehofisi application.. Tevera mirairo:

1. Muhwindo reMicrosoft Excel rinovhurwa, tinya pane sero umo mabhawa akaonekwa.
2. Fambisa cursor kumuganhu wekurudyi, uko zita resero rakaiswa. Miganhu yesero inogona zvakare kutambanudzwa kuruboshwe, asi munzira iyi, maseru ari kumberi anozochinjika.

3. Isu takamirira kuti cursor itore chimiro chemuseve wakapetwa kaviri. Wobva wadzvanya pamuganho wokweva kusvika chinzvimbo kusvika mavara ese aonekwa.
4. Pakupera kwekuita, ma lattice ese acharatidzwa muchimiro chenhamba dzakambopinda.

Iyi nzira inoshanda kune ese mavhezheni eExcel.

Nzira 2: Kuderedza Font

Mhinduro yekutanga kune dambudziko inonyanya kukodzera kune izvo zviitiko kana 2-3 makoramu chete akagarwa papepa uye pasina data rakawanda. Asi kuti ugadzirise mavara akakosha mu-e-bhuku pamwero mukuru, unofanirwa kushandisa mirairo iri pasi apa.

1. Isu tinosarudza sero kana mutsara wemaseru umo tinoda kuona data yenhamba.

2. Isu tinoita shuwa kuti tiri mu "Kumba" tebhu, kana zvisiri, tinya pairi kumusoro kwepeji. Muchikamu che "Font", tinowana hukuru hwayo uye tinoideredza kusvikira nhamba inodiwa yezvinyorwa inoratidzwa mumasero mune inodiwa digital format. Kuti uchinje font, unogona kungoisa iyo inofungidzirwa saizi mundima yakakodzera.

Pane chinyorwa! Paunenge uchigadzirisa font uye uchichinja fomati, sero rinotora pahupamhi hunoenderana nehurefu hwenhamba hunokosha hwakanyorwa mukati maro.

Nzira 3: autowidth

Kushandura font mumaseru kunowanikwawo nenzira inotsanangurwa pazasi. Zvinosanganisira kusarudza hupamhi uchishandisa akavakirwa-mukati maturusi eMicrosoft Excel.

1. Iwe unofanirwa kuratidza huwandu hwemasero anoda fomati (kureva, ayo ane mavara asina kukodzera pane manhamba). Tevere, tinya-kurudyi pachimedu chakasarudzwa uye pahwindo repop-up tsvaga iyo Format Cells chishandiso. Mune shanduro dzekutanga dzeExcel, menyu inogona kuchinja nzvimbo yezvishandiso.

2. Muhwindo rinoonekwa, sarudza chikamu che "Alignment". Tichashanda nayo mune ramangwana, toisa tiki pamberi pekupinda "Auto-fit width". Inowanikwa pazasi mu "Display" block. Pakupedzisira, tinya bhatani "OK". Mushure mezviito zvakatorwa, kukosha kunodzikira uye kuwana fomati inoenderana nehukuru hwehwindo mu-e-bhuku.

Iyi tekinoroji yakanyanya nyore uye inosiyaniswa nekubudirira kwayo. Iwe unogona kugadzira pepa reExcel nemazvo mune imwe nyaya yemasekonzi.

Teerera! Nzira dzese dzekugadzirisa dzinoshanda chete kana iwe uri munyori wefaira kana kuti rakavhurika kuti rigadziriswe.

Method 4: Kuchinja nhamba format

Iyi nzira yakakodzera chete kune avo vanoshandisa shanduro yekare yeMicrosoft Excel. Chokwadi ndechokuti pane muganhu pakusuma nhamba, sezvataurwa kwokutanga kwechinyorwa. Funga nezvekugadzirisa nhanho nhanho:

1. Sarudza sero kana huwandu hwemasero anoda kufomatidzwa. Tevere, tinya-kurudyi pavari. Mune rondedzero yemabasa anooneka, tsvaga "Format Cells" chishandiso, tinya pairi.
2. Mushure mekunge tadzvanya pane "Nhamba" tab, tinoona kuti iyo "Text" fomati yakaiswa ipapo. Chinja kuti ive "General" muchikamu che "Nhamba Mafomati". Kuti uite izvi, tinya pane yekupedzisira uye simbisa chiito chako nekudzvanya bhatani rekuti "OK" pazasi pehwindo rekufomatidza.

Teerera! Mushanduro dzakagadziridzwa dzeExcel, iyo General fomati inosetwa neyakagadzika.

Mushure mekunge chirambidzo ichi chabviswa, nhamba dzese dzicharatidzwa mune yaunoda fomati. Mushure mekuita manipulation, unogona kuchengetedza faira. Mushure mekuvhurwa, maseru ese anozoratidzwa mune iyo fomu chaiyo.

Iwe unogona kushandura iyo nhamba fomati neimwe nzira iri nyore:

1. Kuti uite izvi, pinda iyo Excel spreadsheet faira, apo nhamba dzenhamba dzinoratidzwa zvisizvo, enda ku "Kumba" tab kune "Nhamba" chikamu.
2. Dzvanya pamuseve kuti uunze rondedzero yekudonhedza uye shandura iyo set modhi kubva ku "Text" kuenda ku "General".
3. Iwe unogona kufometa imwe yemasero, umo mune akati wandei magridi, mune imwechete kurongeka, pasina kushandisa kusarudza mafomati epepa rese. Kuti uite izvi, tinya pahwindo raunoda, tinya bhatani rekurudyi.
4. Muhwindo rinobuda, tsvaga Delimited Format tool, tinya pairi.
5. Kupfuurirazve, ese ma paramita anofanirwa kuchinjwa sezvakatsanangurwa mune yapfuura nzira.

Pane chinyorwa! Kuti uchinje nekukurumidza kumafomati esero, ingoshandisa kiyi yekubatanidza "CTRL + 1". Zviri nyore kuita shanduko pano, zvese kune imwe chaiyo sero uye yehuwandu hwese.

Kuti uve nechokwadi chekuti zviito zvaitwa ndezvechokwadi, tinokurudzira kuti uise mavara kana manhamba mavara munhamba huru. Kana, mushure mokunge muganhu wapera, magirasi haana kuonekwa, maererano, iwe wakaita zvose zvakanaka.

Nzira 5: Shandura sero fomati

Zvinogoneka kushandura fomati yesero yekuratidzira kwakaringana kwemavara uchishandisa akati wandei maturusi anoshandiswa nekusarudzika muMicrosoft Excel spreadsheet. Ngatitarisei nzira iyi mune zvakadzama:

1. Kutanga, sarudza sero rine dambudziko, wobva wadzvanya-kurudyi pairi. Menyu inobuda yaunoda kudzvanya "Format Cells". Kugadzirisa masero kunoitwa chete mu "Numeric" fomu, kana bhuku rekushanda rine nhamba.

2. Mu "Nhamba" block inovhura, kubva pane iyo rondedzero, sarudza iyo fomati iyo yakapinda kukosha mumasero ichaenderana nayo. Mumuenzaniso uyu, chimiro che "Mari" chinoonekwa. Mushure mekusarudza, tinosimbisa zviito zvedu nekudzvanya bhatani rekuti "OK" pazasi pehwindo rezvirongwa. Kana iwe uchida kuti comma ioneke munhamba, iwe unofanirwa kudzvanya pane "Financial" fomati sarudzo.

3. Kana iwe ukasawana yakakodzera fomati sarudzo murondedzero, edza kudzokera kuKumba peji uye kuenda kuchikamu cheNhamba. Pano iwe unofanirwa kuvhura rondedzero nemafomati, uye pazasi chaipo tinya "Mamwe mafomati enhamba", sezvakaratidzwa mumufananidzo. Nekutanga iyi sarudzo, iwe unoenda kune yakatojairika marongero ekuchinja sero fomati.

Kana pasina imwe yenzira dzakabatsira, unogona kuedza kuisa kukosha kwete muchitokisi, asi mumutsetse uri pasi pekutonga kwebhuku reMicrosoft Excel e-book. Ingofa pairi uye tanga kuisa data inodiwa.

mhedziso

Kazhinji, kuratidza magidhi panzvimbo yenhamba kana alfabheti mataurirwo muMicrosoft Excel masero hakusi kukanganisa. Chaizvoizvo, kuratidzwa kwakadaro kwemavara kunoenderana chete nezviito zvevashandisi, saka zvakakosha kuti utarise kutevedzera muganhu paunenge uchishandisa shanduro dzekare dzespredishiti.