Mukati
Kugadzirisa ndeimwe yenzira huru kana uchishanda nespredishiti. Nekushandisa mafomati, unogona kushandura kutaridzika kwetabular data, pamwe nekuseta maseru sarudzo. Zvakakosha kuti ukwanise kuishandisa nemazvo kuitira kuti uite basa rako muchirongwa nekukurumidza uye nemazvo. Kubva pane chinyorwa iwe uchadzidza maitiro ekugadzirisa tafura nenzira kwayo.
Table Formatting
Kugadzirisa igadziriro yezviito zvakakosha kugadzirisa kuonekwa kwetafura uye zviratidzo mukati maro. Iyi nzira inobvumidza iwe kugadzirisa saizi yefonti uye ruvara, saizi yesero, zadza, fomati, zvichingodaro. Ngationgororei chinhu chimwe nechimwe zvakadzama.
Auto-formating
Autoformatting inogona kuiswa kune zvachose chero huwandu hwemasero. Iyo spreadsheet processor ichazvimiririra kugadzirisa yakasarudzika siyana, ichishandisa iyo yakapihwa paramita kwairi. Walkthrough:
- Isu tinosarudza sero, huwandu hwemasero kana tafura yese.
- Enda kune "Kumba" chikamu uye tinya "Format seTafura". Iwe unogona kuwana chinhu ichi mu "Styles" block. Mushure mekudzvanya, hwindo rine zvese zvinogoneka-akagadzirwa masitayera rinoratidzwa. Iwe unogona kusarudza chero ipi zvayo yezvitaera. Dzvanya pane sarudzo yaunoda.
- Iwindo diki rakaratidzwa pachiratidziro, chinoda kusimbiswa kwechokwadi cheiyo yakapinda renji renji. Kana iwe ukaona kuti pane kukanganisa muhuwandu, unogona kugadzirisa data. Iwe unofanirwa kunyatso tarisa chinhu "Tafura ine misoro." Kana tafura iine misoro, saka iyi pfuma inofanirwa kuongororwa. Mushure mekuita zvese zvigadziriso, tinya "OK".
- Ready! Ndiro yatora chimiro chechimiro chawasarudza. Chero nguva, chimiro ichi chinogona kuchinjwa kune imwe.
Kuchinjira kufomati
Mikana yekugadzira otomatiki haikodzeri vese vashandisi vespredishiti processor. Izvo zvinokwanisika kugadzira nemaoko ndiro iyo uchishandisa yakakosha paramita. Unogona kugadzirisa chitarisiko uchishandisa menyu yemukati kana maturusi ari paribhoni. Walkthrough:
- Isu tinoita sarudzo yenzvimbo inodiwa yekugadzirisa. Dzvanya pairi RMB. Iyo menyu yemukati inoratidzwa pachiratidziri. Dzvanya pane "Format Cells..." chinhu.
- Bhokisi rakanzi "Format Cells" rinoonekwa pahwindo. Pano iwe unogona kuita akasiyana tabular data editing manipulations.
Chikamu cheKumba chine maturusi akasiyana ekufomatidza. Kuti uzviise kumasero ako, unofanirwa kuzvisarudza, wobva wadzvanya pane chero ipi zvayo.
Kuumba Dhata
Iyo sero fomati ndechimwe chezvinhu zvakakosha zvekufomatidza. Ichi chinhu hachingogadzirise chitarisiko chete, asi zvakare chinoudza spreadsheet processor maitiro ekugadzirisa sero. Semune nzira yapfuura, chiitiko ichi chinogona kuitwa kuburikidza nemenu yemamiriro kana maturusi ari mune yakakosha ribhoni yeKumba tebhu.
Nekuvhura hwindo re "Format Cells" uchishandisa menyu yemukati, unogona kugadzirisa iyo fomati kuburikidza nechikamu che "Nhamba Mafomati", chiri mu "Nhamba" block. Pano unogona kusarudza imwe yeanotevera mafomati:
- date;
- nguva;
- common;
- nhamba;
- zvinyorwa, nezvimwewo.
Mushure mekusarudza fomu inodiwa, tinya "OK".
Mukuwedzera, mamwe mafomati ane mamwe maitiro. Nekusarudza fomati yenhamba, unogona kugadzirisa nhamba yemanhamba mushure medesimali yenhamba dzezvikamu.
Nekuisa iyo "Date" fomati, unogona kusarudza kuti zuva richaratidzwa sei pachiratidziri. Iyo "Nguva" parameter ine zvigadziriso zvakafanana. Nekudzvanya pane "Yese mafomati" chinhu, unogona kuona ese angangoita subspecies ekugadzirisa data muchitokisi.
Nekuenda kuchikamu che "Kumba" uye nekuwedzera rondedzero iri mu "Nhamba" block, unogona zvakare kugadzirisa iyo fomati yesero kana huwandu hwemasero. Rondedzero iyi ine mafomati makuru ese.
Nekudzvanya pane chinhu "Mamwe mafomati enhamba ..." hwindo rinotozivikanwa "Format yemasero" richaratidzwa, umo iwe unogona kugadzira zvakadzama marongero efomati.
Kurongeka kwemukati
Nekuenda kubhokisi re "Format Cells", wozoenda kuchikamu che "Alignment", unogona kuita mamwe marongero ekuwedzera kuti kutaridzika kweplate kuonekwe. Iri hwindo rine nhamba huru yezvirongwa. Nekutarisa bhokisi riri padivi peimwe kana imwe parameter, unogona kubatanidza maseru, kuputira mavara nemashoko, uye zvakare kuita otomatiki hupamhi kusarudzwa.
Mukuwedzera, muchikamu chino, unogona kushandisa nzvimbo yezvinyorwa mukati mesero. Pane kusarudzwa kwemavara akatwasuka uye akachinjika.
Muchikamu che "Oriental", unogona kugadzirisa nzvimbo yekumisikidza yeruzivo rwemavara mukati mesero.
Muchikamu che "Home" pane bhuroka yezvishandiso "Alignment". Pano, sepahwindo re "Format Cells", pane zvigadziriso zvekugadzirisa data, asi mune imwe fomu yakasimwa.
Kurongwa kwemavara
Chikamu che "Font" chinokutendera kuti uite seti yakakura yezviito kugadzirisa ruzivo musero rakasarudzwa kana huwandu hwemasero. Pano unogona kugadzirisa zvinotevera:
- mhando;
- kukura;
- Ruvara;
- style, etc.
Paribhoni yakakosha pane bhuroka yezvishandiso "Font", iyo inobvumidza iwe kuita shanduko dzakafanana.
Miganhu nemitsetse
Muchikamu che "Border" chewindo re "Format Cells", unogona kugadzirisa mhando dzemitsara, pamwe nekuisa ruvara rwaunoda. Pano iwe unogonawo kusarudza mararamiro emuganhu: kunze kana mukati. Zvinokwanisika kubvisa zvachose muganhu kana zvisingadiwi mutafura.
Nehurombo, hapana maturusi ekugadzirisa tafura miganhu pamusoro peribhoni, asi pane chinhu chidiki chiri mu "Font" block.
Kuzadza masero
Muchikamu che "Zadza" chebhokisi re "Format Cells", unogona kugadzirisa ruvara rwemasero etafura. Pane imwezve mukana wekuratidza maitiro akasiyana.
Sezviri muchikamu chakapfuura, pane bhatani rimwe chete pabhari rekushandisa, iro riri mu "Font" block.
Izvo zvinoitika kuti mushandisi haana akakwana akajairwa shades kuti ashande neruzivo rwetabular. Mune ino kesi, iwe unofanirwa kuenda kune "Mamwe mavara ..." chikamu kuburikidza nebhatani riri mu "Font" block. Mushure mekudzvanya, hwindo rinoratidzwa rinokubvumira kuti usarudze rumwe ruvara.
Zvitaera zvemasero
Iwe haugone chete kuseta iyo cell style iwe pachako, asi zvakare sarudza kubva kune iyo yakabatanidzwa mune spreadsheet pachayo. Raibhurari yezvitaera yakakura, saka mushandisi wega wega achakwanisa kuzvisarudzira maitiro akakodzera.
Kufamba:
- Sarudza masero anodiwa kuti uise maitiro akapedzwa.
- Enda kune "Kumba" chikamu.
- Dzvanya "Cell Styles".
- Sarudza chimiro chaunofarira.
Kudzivirirwa kwemashoko
Dziviriro zvakare ndeyenzvimbo yefomati. Muwindo rinozivikanwa re "Format Cells", pane chikamu chinonzi "Protection". Pano unogona kuseta sarudzo dzedziviriro dzinorambidza kugadzirisa yakasarudzwa masero. Uye zvakare pano iwe unogona kugonesa kuviga mafomula.
Paribhoni rekushandisa reChikamu cheKumba, muBrokodzi yeMasero, pane Format element inokutendera kuti uite shanduko dzakafanana. Nekudzvanya pa "Format", iyo skrini icharatidza runyorwa umo "Kudzivirirwa" chinhu chiripo. Nekudzvanya pa "Chengetedza pepa ...", unogona kurambidza kugadzirisa pepa rose regwaro raunoda.
Madingindira etafura
Mune spreadsheet Excel, pamwe nezwi processor Shoko, unogona kusarudza dingindira regwaro.
Kufamba:
- Enda kune "Peji Layout" tab.
- Dzvanya pane "Themes" chinhu.
- Sarudza imwe yezvinyorwa zvakagadzirirwa.
Shanduko kuita "Smart Tafura"
Tafura ye "smart" imhando yakakosha yefomati, mushure meiyo sero array inogamuchira zvimwe zvinobatsira zvivakwa zvinoita kuti zvive nyore kushanda neakawanda data. Mushure mekutendeuka, huwandu hwemasero hunotariswa nechirongwa sechinhu chose. Kushandisa basa iri kunoponesa vashandisi kubva pakudzokorora mafomula mushure mekuwedzera mitsetse mitsva patafura. Uye zvakare, iyo "Smart" tafura ine yakakosha mabhatani mumisoro inobvumidza iwe kusefa iyo data. Basa racho rinopa kukwanisa kupinza musoro wetafura kumusoro kwepepa. Shanduko kuita "Smart Tafura" inoitwa sezvizvi:
- Sarudza nzvimbo inodiwa yekugadzirisa. Pamusoro peturusi, sarudza chinhu che "Styles" uye tinya "Format seTafura".
- Iyo skrini inoratidza rondedzero yeakagadzirira-akagadzirwa masitaera ane preset paramita. Dzvanya pane sarudzo yaunoda.
- Iwindo rekubatsira rakaonekwa riine marongero emhando uye kuratidzwa kwemazita. Isu tinoseta ese anodiwa paramita uye tinya bhatani "OK".
- Mushure mekuita zvigadziriso izvi, piritsi redu rakashanduka kuita Smart Tafura, iri nyore kwazvo kushanda nayo.
Tafura Formatting Muenzaniso
Ngatitorei muenzaniso wakapfava wekugadzira tafura nhanho nenhanho. Semuenzaniso, takagadzira tafura seizvi:
Zvino ngatienderere mberi kune yakadzama kugadzirisa:
- Ngatitange nemusoro. Sarudza iyo A1 ... E1, uye tinya pakanzi "Batanidza uye uende pakati." Ichi chinhu chiri muchikamu che "Formatting". Masero anobatanidzwa uye mavara emukati anorongedzwa nepakati. Isa iyo font ku "Arial", saizi kusvika "16", "Bold", "Underlined", mumvuri wefonti ku "Purple".
- Ngatienderere mberi nekufomatidza misoro yekoromo. Sarudza masero A2 uye B2 uye tinya "Batanidza Masero". Isu tinoita zviito zvakafanana nemasero A7 uye B7. Isu tinoisa iyo inotevera data: font - "Arial Black", saizi - "12", alignment - "Kuruboshwe", font shade - "Purple".
- Isu tinosarudza C2 ... E2, tichibata "Ctrl", tinoita sarudzo yeC7 ... E7. Pano tinogadzirisa mitemo inotevera: font - "Arial Black", saizi - "8", kurongeka - "Centered", font color - "Purple".
- Ngatienderere mberi nekugadzirisa zvinyorwa. Isu tinosarudza zviratidzo zvikuru zvetafura - aya masero A3 ... E6 uye A8 ... E8. Isu tinoisa zvinotevera parameters: font - "Arial", "11", "Bold", "Centered", "Blue".
- Gadzirisa kumucheto wekuruboshwe B3 ... B6, pamwe neB8.
- Isu tinoburitsa ruvara rutsvuku muA8 ... E8.
- Isu tinosarudza D3 ... D6 uye tinya RMB. Dzvanya "Format Cells ...". Muhwindo rinoonekwa, sarudza rudzi rwe data data. Isu tinoita zviito zvakafanana nesero D8 uye tinoisa manhamba matatu mushure meiyo decimal point.
- Ngatienderere mberi nekugadzirisa miganhu. Isu tinoita sarudzo yeA8 ... E8 uye tinya "All Border". Zvino sarudza "Thick Outer Border". Tevere, tinoita sarudzo yeA2 ... E2 uye zvakare sarudza "Muganho wakakora wekunze". Nenzira imwecheteyo, isu tinogadzira A7 ... E7.
- Isu tinoita color setting. Sarudza D3…D6 uye isa chiedza cheturquoise hue. Isu tinoita sarudzo yeD8 uye tinoisa yakareruka yero tint.
- Tinoenderera mberi nekuiswa kwekudzivirira pane gwaro. Isu tinosarudza cell D8, tinya-kurudyi pairi uye tinya "Format Cells". Pano tinosarudza chinhu che "Protection" uye toisa cheki padivi pe "Protected cell" element.
- Isu tinotamira kumenyu huru yespredishiti processor uye enda kuchikamu che "Service". Zvadaro tinoenda ku "Kudzivirira", kwatinosarudza chinhu "Chengetedza Sheet". Kuseta password chinhu chaungasarudze, asi unogona kuchiisa kana uchida. Zvino sero iri harigone kupepetwa.
Mumuenzaniso uyu, takaongorora zvakadzama maitiro aungaita tafura muspredishiti nhanho nhanho. Mhedzisiro yefomati inoita seizvi:
Sezvatinoona, chiratidzo chakachinja zvakanyanya kubva kunze. Chitarisiko chake chawedzera kugadzikana uye kutaridzika. Nezviito zvakafanana, iwe unogona kufomati zvachose chero tafura uye kuisa dziviriro pairi kubva netsaona editing. Iyo yemanyorero yekufometa nzira inoshanda zvakanyanya pane kushandisa yakafanotsanangurwa masitaera, sezvo iwe uchigona kuseta maparamita akasiyana kune chero mhando yetafura.
mhedziso
Iyo spreadsheet processor ine nhamba huru yezvirongwa zvinokutendera kuti ufomate data. Iyo purogiramu ine yakanakira yakavakirwa-yakagadzirira-yakagadzirwa masitaera ine yakagadzika mafomati sarudzo, uye kuburikidza ne "Format Cells" hwindo, unogona kuita yako pachako marongero.