Maitiro ekuchinja sero fomati muExcel. Kuburikidza nemenu yemukati, zvishandiso uye hotkeys

Rimwe nerimwe remasero rine chimiro chayo chinokubvumira kugadzirisa ruzivo mune imwe nzira kana imwe. Izvo zvakakosha kuti uzviise nenzira kwayo kuitira kuti masvomhu ese anodiwa aitwe nemazvo. Kubva kuchinyorwa iwe uchadzidza maitiro ekushandura fomati yemasero muExcel spreadsheet.

Iwo makuru marudzi efomati uye shanduko yavo

Kune gumi mafomati ekutanga muhuwandu:

1. Zvakajairika.
2. Mari.
3. Numerical.
4. Zvemari.
5. Text.
6. Zuva.
7. Nguva.
8. Diki.
9. muzana.
10. zvakawedzerwa

Mamwe mafomati ane awo ekuwedzera subspecies. Pane nzira dzakawanda dzekushandura fomati. Ngationgororei imwe neimwe zvakadzama.

Nzira 1: menyu yemamiriro ezvinhu

Kushandisa menyu yemukati kugadzirisa fomati ndiyo imwe yenzira dzinonyanya kushandiswa. Kufamba:

1. Iwe unofanirwa kusarudza iwo maseru ane fomati yaunoda kugadzirisa. Tinodzvanya pavari nebhatani rekurudyi rembeva. Menyu yakakosha yemamiriro ekunze yavhurwa. Dzvanya pane chinhu "Format Cells ...".

2. Bhokisi refomati richaonekwa pachiratidziri. Tinoenda kune chikamu chinonzi "Nhamba". Teerera kune block "Nhamba mafomati". Heano ese aripo mafomati akapihwa pamusoro. Isu tinodzvanya pafomati inoenderana nerudzi rweruzivo rwunopihwa musero kana huwandu hwemasero. Kurudyi kwefomati block ndiyo subview setting. Mushure mekuita zvese zvigadziriso, tinya "OK".

3. Ready. Kugadzirisa fomati kwabudirira.

Method 2: Nhamba bhokisi rekushandisa paribhoni

Iyo ribhoni yekushandisa ine zvakakosha zvinhu zvinokutendera iwe kuti uchinje fomati yemasero. Kushandisa nzira iyi inokurumidza kupfuura yapfuura. Walkthrough:

1. Isu tinoita shanduko kune chikamu "Kumba". Tevere, sarudza sero yaunoda kana huwandu hwemasero uye vhura bhokisi rekusarudza mu "Nhamba" block.

2. Iyo huru fomati sarudzo dzakaratidzwa. Sarudza iyo yaunoda munzvimbo yakasarudzwa. Mafomati achinja.

3. Zvinofanira kunzwisiswa kuti rondedzero iyi ine chete mafomu makuru. Kuti uwedzere runyorwa rwese, unofanirwa kudzvanya "Mamwe mafomati enhamba".

4. Mushure mekudzvanya pane ichi chinhu, hwindo rinozivikanwa richaonekwa rine zvese zvinogoneka mafomati sarudzo (yekutanga uye yekuwedzera).

Nzira 3: "Masero" bhokisi rekushandisa

Iyo inotevera fomati yekugadzirisa nzira inoitwa kuburikidza ne "Masero" block. Walkthrough:

1. Isu tinosarudza sero kana huwandu hwemasero ayo maitiro atinoda kuchinja. Isu tinotamira kuchikamu che "Kumba", tinya pane chinyorwa "Format". Ichi chinhu chiri mu "Cells" block. Muchinyorwa chekudonhedza, tinya pakanzi "Format Cells ...".

2. Mushure mekuita uku, hwindo rekufomatidza rakajairwa rakaonekwa. Isu tinoita zviito zvese zvinodiwa, tichisarudza fomu yaunoda uye nekudzvanya "OK".

Nzira 4: hotkeys

Iyo sero fomati inogona kugadziridzwa uchishandisa yakakosha spreadsheet hotkeys. Kutanga iwe unofanirwa kusarudza masero anodiwa, uye wobva wadzvanya kiyi musanganiswa Ctrl + 1. Mushure mekuita manipulations, iyo inozivikanwa fomati yekuchinja hwindo ichavhurwa. Sezvaiitwa nenzira dzakapfuura, sarudza iyo yaunoda fomati uye tinya "OK". Pamusoro pezvo, kune mamwe mapfupi ekhibhodi anotendera iwe kugadzirisa iyo sero fomati pasina kuratidza iyo fomati bhokisi:

• Ctrl+Shift+- - general.
• Ctrl+Shift+1 - nhamba dzine koma.
• Ctrl+Shift+2 - nguva.
• Ctrl+Shift+3 - zuva.
• Ctrl + Shift + 4 - mari.
• Ctrl+Shift+5 - muzana.
• Ctrl+Shift+6 – O.OOE+00 fomati.

Date fomati ine nguva muExcel uye 2 kuratidza masisitimu

Iyo date fomati inogona kurongeka zvakare uchishandisa maturusi espredishiti. Semuenzaniso, tine iyi tablet ine ruzivo. Isu tinofanirwa kuve nechokwadi chekuti zviratidzo mumitsara zvinounzwa kune fomu inoratidzwa mumazita emakoramu.

Muchikamu chekutanga, chimiro chinotangwa nenzira kwayo. Ngatitarisei pachikamu chechipiri. Sarudza ese maseru ezviratidzo zvekoramu yechipiri, dzvanya kiyi musanganiswa CTRL + 1, muchikamu che "Nhamba", sarudza nguva, uye mu "Type" tab, sarudza nzira yekuratidzira inoenderana nemufananidzo unotevera:

Isu tinoita zviito zvakafanana nekoramu yechitatu neyechina. Isu tinoseta iwo mafomati uye nemhando dzekuratidzira dzinoenderana neakaziviswa mazita emakoramu. Pane 2 date kuratidza masisitimu muspredishiti:

1. Nhamba 1 ndiNdira 1, 1900.
2. Nhamba 0 ndiNdira 1, 1904, uye nhamba 1 ndeye 02.01.1904/XNUMX/XNUMX.

Kuchinja kuratidzwa kwemazuva kunoitwa sezvinotevera:

1. Ngatiende ku "Faira".
2. Dzvanya "Sarudzo" uye enda kune "Advanced" chikamu.
3. Mu "Paunenge uchiverenga bhuku rino" block, sarudza "Shandisa iyo 1904 date system" sarudzo.

Alignment Tab

Uchishandisa iyo "Alignment" tebhu, unogona kuseta nzvimbo yekukosha mukati mesero nematanho akati wandei:

• towards;
• horizontally;
• vertically;
• hama nechepakati;
• zvichingoenda zvakadaro.

Nekumisikidza, iyo nhamba yataipa muchitokisi yakanangana-kurudyi, uye ruzivo rwemavara rwakaiswa kuruboshwe. Mu "Alignment" block, iyo "Kumba" tebhu, unogona kuwana zvakakosha mafomati zvinhu.

Nerubatsiro rwezvinhu zveribhoni, unogona kugadzirisa font, kuseta miganhu uye kushandura kuzadza. Iwe unongoda kusarudza sero kana huwandu hwemasero uye shandisa iyo yepamusoro bhari yekuseta ese anodiwa marongero.

Ndiri kugadzirisa zvinyorwa

Ngatitarisei nzira dzinoverengeka dzekugadzirisa zvinyorwa mumaseru kuita kuti matafura ane ruzivo averengeke sezvinobvira.

Maitiro ekushandura iyo Excel font

Ngatitarisei nzira dzinoverengeka dzekushandura font:

1. Nzira imwe. Sarudza sero, enda kuchikamu che "Kumba" uye sarudza chinhu che "Font". Rondedzero inovhura iyo mushandisi wega wega anogona kuzvisarudzira font yakakodzera ivo.

2. Nzira yechipiri. Sarudza sero, tinya-kurudyi pairi. Menyu yemamiriro ekunze inoratidzwa, uye pazasi payo pane hwindo diki rinokutendera kuti ufomati iyo font.

3. Nzira yechitatu. Sarudza sero uye shandisa kiyi musanganiswa Ctrl + 1 kudaidza "Format Masero". Muhwindo rinoonekwa, sarudza chikamu che "Font" uye ita zvese zvinodiwa.

Maitiro ekusarudza Excel Styles

Zvitaera zvakashinga, zvakatsvuka, uye zvepasi pasi zvinoshandiswa kuratidza ruzivo rwakakosha mumatafura. Kuti uchinje chimiro chesero yese, unofanirwa kudzvanya pairi nebhatani rekuruboshwe. Kuti uchinje chikamu chesero chete, unofanirwa kudzvanya kaviri pasero, wobva wasarudza chikamu chaunoda pakufomatidza. Mushure mekusarudza, shandura chimiro uchishandisa imwe yeinotevera nzira:

1. Kushandisa zvakakosha kusanganisa:

• Ctrl+B - yakashinga;
• Ctrl+I - italic;
• Ctrl+U - yakatsikiswa;
• Ctrl + 5 - yakayambuka;
• Ctrl+= - subscript;
• Ctrl+Shift++ - superscript.

2. Kushandisa maturusi ari mu "Font" block ye "Home" tab.

3. Kushandisa Format Cells bhokisi. Pano unogona kuseta zvirongwa zvaunoda muzvikamu zve "Modify" uye "Inscription".

Kubatanidza mavara mumaseru

Kurongeka kwemavara mumasero kunoitwa nenzira dzinotevera:

• Enda kune "Alignment" chikamu che "Kumba" chikamu. Pano, nerubatsiro rwezvidhori, unogona kurongedza data.

• Mubhokisi re "Format Cells", enda kuchikamu che "Alignment". Pano iwe unogona zvakare kusarudza ese aripo marudzi ekugadzirisa.

Auto-format zvinyorwa muExcel

Teerera! Mavara marefu apinzwa musero anogona kusakwana mariri uye anobva aratidzwa zvisiri izvo. Pane auto-formating chimiro kudzivirira dambudziko iri.

Nzira mbiri dze autoformating:

1. Kushandisa kuputira izwi. Sarudza maseru aunoda, enda kuchikamu che "Kumba", wozoenda ku "Alignment" block uye sarudza "Move Text". Kugonesa iyi ficha inobvumidza iwe kuti uite otomatiki kuputira mazwi uye kuwedzera urefu hwemutsara.
2. Kushandisa iyo AutoFit basa. Enda kubhokisi re "Format Cells", uye "Alignment" uye tarisa bhokisi riri pedyo ne "AutoFit Width".

Maitiro ekubatanidza maseru muExcel

Kazhinji, kana uchishanda nematafura, zvinova zvakafanira kubatanidza masero. Izvi zvinogona kuitwa uchishandisa bhatani re "Merge and Center", iro riri mu "Alignment" block ye "Home" chikamu. Kushandisa sarudzo iyi kuchabatanidza maseru akasarudzwa. Mitemo yemukati memasero inofananidzwa nepakati.

Kuchinja Maonero uye Mafambiro eChinyorwa

Kutungamira kwemavara uye kutaridzika maviri akasiyana marongero ayo vamwe vashandisi vanovhiringidza mumwe nemumwe. Mumufananidzo uyu, koramu yekutanga inoshandisa basa rekutarisisa, uye koramu yechipiri inoshandisa gwara:

Nekuenda kuchikamu che "Kumba", iyo "Alignment" block uye iyo "Oriental" chinhu, unogona kushandisa aya maviri paramita.

Kushanda neExcel Cell Formatting Styles

Kushandisa masitayipi ekufomatidza kunogona kukurumidzira zvakanyanya maitiro ekufomatisa tafura uye nekuipa kutaridzika kwakanaka.

Nei Zvitaera Zvinonzi Zvichidikanwa

Zvinangwa zvikuru zvekushandisa masitayera:

1. Gadzira masitaera akasiyana ekugadzirisa misoro, misoro midiki, zvinyorwa, nezvimwe.
2. Kushandisa maitiro akagadzirwa.
3. Automation yebasa nedata, kubva uchishandisa chimiro, unogona kufomatidza zvachose data rese mune yakasarudzwa renji.

Kushandisa masitaera kumaseru epepa rebasa

Kune huwandu hukuru hweakasanganiswa akagadzirira-akagadzirwa masitayipi muspredishiti processor. Nhanho nenhanho gwara rekushandisa masitayera:

1. Enda kune "Kumba" tab, tsvaga "Cell Styles" block.

2. Raibhurari yezvitaera zvakagadzirirwa inoratidzwa pachiratidziri.
3. Sarudza sero yaunoda uye tinya pane maitiro aunoda.
4. Manyorerwo akaiswa pachitokisi. Kana iwe ukangotenderedza mbeva yako pamusoro pemaitiro akakurudzirwa, asi usadzvanya pairi, unogona kuona kuti ichataridzika sei.

Kugadzira Zvitaera Zvitsva

Kazhinji, vashandisi havana kukwana akagadzirira-akagadzirwa masitayipi, uye vanotendeukira kukugadzira yavo. Iwe unogona kugadzira yako yakasarudzika maitiro seanotevera:

1. Sarudza chero sero uye gadzira iyo. Tichagadzira chimiro chinoenderana nefomati iyi.
2. Enda kuchikamu che "Kumba" uye enda ku "Cell Styles" block. Dzvanya "Gadzira Cell Style". Hwindo rinonzi "Style" rinovhura.

3. Pinda chero "Zita reChimiro".
4. Isu tinoseta ese anodiwa ma paramita aunoda kuisa kune yakasikwa maitiro.
5. Tinya "OK".
6. Iye zvino chimiro chako chakasiyana chakawedzerwa kune raibhurari yemaitiro, iyo inogona kushandiswa mugwaro iri.

Kuchinja Maitiro Aripo

Yakagadzirirwa-yakagadzirwa masitaera ari muraibhurari anogona kuchinjwa akazvimirira. Walkthrough:

1. Enda kune "Kumba" chikamu uye sarudza "Sero Styles".
2. Tinya-kurudyi pane chimiro chaunoda kugadzirisa uye tinya Edit.
3. Hwindo reSitairi rinovhurwa.
4. Dzvanya "Format" uye pahwindo rinoratidzwa "Format Cells" gadzirisa mafomati. Mushure mekuita zvese manipulations, tinya "OK".
5. Dzvanya OK zvakare kuvhara iyo Style bhokisi. Kugadziriswa kwechimiro chakapedzwa kwapera, ikozvino inogona kushandiswa kune zvinyorwa zvinyorwa.

Kuendesa Zvitaera kune Rimwe Bhuku

Zvinokosha! Chimiro chakasikwa chinogona kungoshandiswa mugwaro rayakagadzirwa, asi pane chinhu chakakosha chinokutendera kuendesa masitayipi kune mamwe magwaro.

Kufamba:

1. Isu tinobvarura gwaro umo masitaera akagadzirwa aripo.
2. Pamusoro pezvo, vhura rimwe gwaro ratinoda kuendesa maitiro akagadzirwa.
3. Mugwaro rine zvitaera, enda kune "Kumba" tebhu uye tsvaga iyo "Sero Sitaira" block.
4. Dzvanya "Sanganisa". Hwindo rakanzi "Batanidza Zvitaera" rakabuda.
5. Iri hwindo rine runyoro rwemagwaro ese akavhurwa espredishiti. Sarudza gwaro raunoda kuendesa iyo yakagadzirwa maitiro uye tinya bhatani rekuti "OK". Ready!

mhedziso

Kune huwandu hukuru hwenzira dzinokutendera iwe kugadzirisa iyo sero fomati muspredishiti. Nekuda kweizvi, munhu wese anoshanda muchirongwa anogona kuzvisarudzira nzira iri nyore yekugadzirisa mamwe matambudziko.