Maitiro ekutsemura sero kuita akawanda maseru muExcel

Nekumisikidza, hapana chishandiso chingabatsira kupatsanura maseru muExcel. Nokudaro, kana pane chido chekugadzira musoro wetafura yakaoma, iwe uchafanirwa kushandisa maitiro mashomanana. Ivo vanozobatsira kuparadzanisa masero eExcel pasina kukanganisa ruzivo mumatafura. Nechinangwa ichi, tinoshandisa nzira dzakawanda.

Nzira yekutanga: kubatanidza kunoteverwa nekusiyanisa

Tisati tatanga hurongwa, ngatinyatso funga nezvechimiro chetafura. Zvinokurudzirwa kunyange kudhiza papepa. Zvino ngatitendeukire kune nhanho-ne-nhanho kugadzirisa kweExcel sheet:

1. Sarudza masero maviri kana matatu mumutsara wekutanga munzvimbo ichave netafura.

2. Enda kune "Kumba" tab, tsvaga iyo "Alignment" block, mairi tinya pane "Merge uye Center" chishandiso.

3. Tinoona kuti zvikamu muchidimbu zvakasarudzwa zvakanyangarika. Saka, hwindo rimwe rakasimba rakabuda. Kuti tione izvi zviri nani, ngatigadzirei miganhu yakajeka. Kuti uite izvi, mu "Font" block, shandisa "All Borders" tool.

4. Zvino sarudza makoramu pasi pemaseru akabatanidzwa uye isa mitsetse pamicheto yemasero nenzira imwecheteyo. Sezvaunogona kuona, masero akaparadzaniswa anowanikwa, uye chikamu chepamusoro, chakasarudzwa pasi pemusoro, hachichinje kuvimbika kwayo.

Saizvozvo, iwe unogona kugadzira iyo yakawanda-level musoro ine isingaverengeki nhamba yemasero akabatanidzwa munzvimbo dzakasiyana pane peji.

Nzira Yechipiri: Kupatsanura Atosanganiswa Masero

Ngatifungei kuti tafura yedu yatove nekujoinha mumahwindo eMicrosoft Excel. Asi tichazvibatanidza nguva pfupi isati yapatsanurwa kuti tinzwisise zviri nani muenzaniso werairo rakapihwa. Mushure mezvo, zvichave zvichibvira kuvaparadzanisa kuti vagadzire musoro wekugadzirisa tafura. Ngationei kuti izvi zvinoitwa sei mukuita:

1. Sarudza makoramu maviri asina chinhu muExcel. (Vanogona kuva vakawanda, zvichienderana nezvinodiwa). Wobva wadzvanya pane chishandiso "Sanganisa uye isa pakati", chiri mu "Alignment" block. Dzvanya "Batanidza Masero".

2. Mushure mekunge taisa miganhu nenzira yakajairika kwatiri (semuchikamu chakapfuura). Tinofanira kuwana tabular format. Kuti ichataridzika sei, iwe unogona kuona mune iyo skrini:

3. Kuti tigovane hwindo rakakura rinoita mumasero, isu tichashandisa imwechete Merge uye Center chishandiso. Ikozvino chete, nekudzvanya pabhokisi rekutarisa, tinosarudza "Unmerge Cells" - iri pekupedzisira mune runyorwa rwezvishandiso. Usakanganwa kufanosarudza huwandu mu e-bhuku rinoda kuganhurwa.

4. Tafura ichatora fomu yatinoda. Chete mutsara wakasarudzwa uchapatsanurwa nenhamba yemasero ayo aive asati abatanidzwa. Iwe haugone kuwedzera nhamba yavo.

Pane chinyorwa! Zvinoitika kuti pakuparadzanisa, hatitore hwindo rimwe, asi maviri akasiyana. Naizvozvo, kana uchipinda data kana, kunyanya, mafomula ekuita masvomhu, funga izvi.

Nzira yechitatu: kupatsanura masero diagonally

Diagonal division inoitwa nefomati. Iyi nheyo inosanganisira kupatsanurwa kwemasero akajairwa, maererano neiyo fomati isina kushandiswa.

1. Sarudza sero yaunoda muExcel sheet sheet, wobva wadzvanya-kurudyi pairi kuti uunze menyu yemukati. Mariri tinowana "Format Cells" tool.

2. Muhwindo rinovhurwa, enda ku "Border" tab. Kuruboshwe, sarudza diagonal mutsara, uye wobva wadzvanya bhatani OK. Kurudyi unogona kuwana mutsara wakafanana, asi mune zvakapesana.

3. Kuruboshwe, kune mamwe mafomati maturusi umo isu tinogona kusarudza rudzi rwemutsara kana kushandura mumvuri wemuganhu.

4. Maturusi aya anobatsira kugadzirisa mafomati.

Nekudaro, sero rakakamurwa nenzira iyi rinoramba riri chishandiso chimwe chete, saka, kuti uise data kubva pasi nepamusoro mukati maro, unofanira kutanga watambanudza sero uye wosarudza font yakakodzera kuti ikwane zvinyorwa zvakanaka.

Pane chinyorwa! Kana iwe ukatora sero uye woikwevera pasi, ipapo mamwe mahwindo mumitsara kana makoramu anozongotora iyo yakafanana fomati. Zvese zvinoenderana nekuti kutsvaira kuchaitwa kupi (pasi kana kudivi).

Nzira yechina: diagonal division nekupinza

Munzira iyi, tinokurudzira kushandisa nzira iyo inofanirwa kuisa maumbirwo ejometri. Kuti inoshanda sei, isu tinokurudzira kufunga mune ino bhuku.

1. Sarudza sero rimwe raunoda kuisa separator, wozoenda kune "Insert" tab, wobva wawana chikamu che "Mifananidzo", dzvanya pa "Shapes" kuwedzera.

2. Rondedzero yezvimiro zvinogona kushandiswa inovhura. Mariri tinowana chikamu che "Mitsetse" uye tinya pane diagonal line.

3. Tinobva tatara mutsetse uyu muchitokisi chatinoda. Nechekuita nazvo, tinogona kushandisa akasiyana mafomati sarudzo: shandura mumvuri, ukobvu, mhando yemutsara, isa mhedzisiro.

Mushure mekudhirowa mitsara, hazvizoite kunyora mavara kune chero divi reiyo diagonal mutsara. Naizvozvo, kuisa ruzivo rwemavara kana nhamba kunodiwa usati wadhirowa. Kuti mutsara uenderane gare gare uye kwete "kucheka" zvinyorwa, zvinodikanwa kushandisa nemazvo nzvimbo uye "Pinda".

Pane chinyorwa! Sarudzo yakanaka kugadzira tafura ine mhando dzinodiwa dzemasero muIzwi, wozoishandura kuExcel.

Kupfupisa

Kupatsanura maseru muMicrosoft Excel eBook inzira iri nyore uye inobatsira, asi iwe unofanirwa kufunga nezve kuti inonetsa kugadzirisa mushanduro yapera. Naizvozvo, isu tinokurudzira zvakasimba kuti iwe uise data pamberi pedanho rekushandura hwindo rimwe kuita maviri kana anopfuura. Zvakare, iwe unogona kungofometa iyo yaunoda renji setafura, mushure mekuimisa muchikamu chakakodzera. Imwe iri nani uye yakasununguka sarudzo ndeyekudhirowa miganhu nemaoko.