Mukati
Kuratidzwa kwegwaro zvakananga kunoenderana nekuti data rakagadzirwa sei. Iwe unogona kubatsira kuronga iyo data nenzira yakanaka uye yakanakira nekuigadzira mumatafura muExcel, izvo zvisingagone kushanda nazvo pasina akasiyana mashandiro ane maseru. Shanduko kumaseru, mitsetse uye makoramu anobatsira kuita kuti tafura iverengeke uye yakanaka, kupatsanura maseru ndiyo imwe sarudzo yakadaro. Kune akati wandei akapusa akakurumbira nzira dzekutsemura maseru, ayo achakurukurwa pazasi.
Method 1: Kubatanidza Multiple Adjacent Masero
Sero riri patafura ndicho chikamu chidiki chekuyera uye nokudaro chinhu chisingagadzike. Mushandisi anogona kuigadzirisa, kuisanganisa nevavakidzani, asi kwete kuipatsanura. Nekudaro, nerubatsiro rwemamwe manomano, iwe unogona kuita iyo yekuona kupatsanurwa yakatwasuka, yakatwasuka uye diagonal mutsara. Uchishandisa nzira iyi, unogona kupatsanura maseru muExcel nekubatanidza maseru ari padyo. Iyo algorithm ndiyo inotevera:
- Tsvaga maseru achapatsanurwa. Mumuenzaniso uyu, kupatsanurwa kuita zvikamu zviviri kuchatariswa.
- Sarudza masero maviri ari padyo, tinya "Merge uye Center" mu "Alignment" tab.
- Ita zvimwe chete kune mamwe masero ari mumutsara.
Saizvozvo, iwe unogona kuita kupatsanura mune imwe nhamba yezvikamu kunze kwembiri. Kupfuurirazve, uchishandisa zviito zvakajairwa, unogona kugadzirisa hukuru hwemasero, makoramu nemitsara. Nekuda kweizvozvo, makoramu ari pasi pesero achapatsanurwa nepakati nepakati, uye ruzivo kubva patafura ichave iri pakati pesero.
Nzira 2: kupatsanura masero akabatanidzwa
Iyo nzira inoshandiswa kupatsanura mamwe maseru mutafura chero mugwaro. Iwe unofanirwa kuita nhanho dzinotevera:
- Sarudza makoramu kana mitsara mune inoronga mapaneru pachange paine maseru akapatsanuka. Mumuenzaniso uyu, pachava nekupatsanurwa nemakoramu.
- Dzvanya museve mubhara rekushandisa padivi peMerge uye Center icon uye sarudza Merge By Rows.
- Kubva pa2 columns zvinoonekwa imwe ichabuda. Tevere, iwe unofanirwa kuwana izvo zvichakamurwa kuita zvikamu zviviri, tinya pazviri uye sarudza "Batanidza uye isa pakati."
Nenzira imwecheteyo, iwe unogona kupatsanura kuita zvimwe zvikamu, asi iwe uchafanirwa kubatanidza imwe neimwe column zvakasiyana. Nenzira iyi, masero akasarudzwa achabatanidzwa mune rimwe chete, uye zvinyorwa zvichange zviri pakati.
Zvakakosha kuziva kuti kupatsanura masero hakusi kunobatsira nguva dzose. Zviri nani kuishandisa kana iwe uchingoda kuparadzanisa sero. Kana kurongedza uye mamwe mashandisirwo akaiswa mugwaro, izvo zvakapatsanurwa zvinoregwa.
Nzira 3: Diagonal cell division
Matafura mazhinji angangoda kupatsanurwa kwete kwakatwasuka uye kwakachinjika, asi diagonally. Iwe unogona kugadzira diagonal division uchishandisa yakavakirwa-muExcel maturusi. Nokuda kweizvi, unoda:
- Tinya-kurudyi pane chinhu panodiwa diagonal division, isa mavara mairi mumitsara miviri.
- Sarudza "Format Cells".
- Muhwindo rinoonekwa, sarudza "Border" tab. Tevere, ma icons maviri ane diagonal division achaonekwa, iwe unofanirwa kusarudza yakakodzera. Line parameters inogona kugadziriswa sezvinodiwa.
- Dzvanya zvakare pabhatani rine diagonal line.
- Dhinda OK.
Teerera! Sero richave rakakamurwa nemeso, asi chirongwa chinozviona sese.
Method 4: Dhirowa divider neShapes tool
Basa rekuisa chimiro rinogona kushandiswawo ku graphic division nekudhirowa mutsara. Iyo algorithm ndiyo inotevera:
- Sarudza chinhu chekupatsanura.
- Enda ku "Insert" tab uye tinya "Shapes".
- Sarudza mhando yemutsara wakakodzera kubva pane zvakarongwa sarudzo.
- Shandisa bhatani reruboshwe kudhirowa chinoparadzanisa.
Zano! Mu "Format" tab, unogona kunyatso-tuta mutsara wakadhonzwa.
mhedziso
Kuverengeka ndechimwe chezvinonyanya kudiwa kune chero data yakarongeka. Kana tafura yacho ichizove nekutarisa kwakaoma nemasero akabatanidzwa kana akabatanidzwa, mitsetse kana makoramu, iwe unozofanirwa kuita mashandiro akakodzera. Kunyangwe sero chiri chinhu chidiki patafura, maturusi akavakirwa muExcel anotendera iwe kuti uitsemure nemeso kuita 2, 3 kana zvimwe zvikamu chero kupi patafura uchishandisa nzira dziri pamusoro.