Zamkatimu
Mu phunziro ili, tiphunzira zofunikira za Microsoft Excel monga kukulunga malemba pamizere ndi kuphatikiza maselo angapo kukhala amodzi. Pogwiritsa ntchito izi, mutha kukulunga zolemba pamizere ingapo, kupanga mitu yamatebulo, kuyika zolemba zazitali pamzere umodzi popanda kuwonjezera kukula kwa mizati, ndi zina zambiri.
Nthawi zambiri, zomwe zili sizingawonetsedwe kwathunthu mu cell, chifukwa. m’lifupi mwake sikokwanira. Zikatero, mutha kusankha chimodzi mwazinthu ziwiri: kukulunga mawu pamizere kapena kuphatikiza ma cell angapo kukhala amodzi osasintha makulidwe ake.
Monga momwe malemba akumangidwira, kutalika kwa mzere kumangosintha, kulola zomwe zili pamizere ingapo. Kuphatikiza ma cell kumakupatsani mwayi wopanga selo limodzi lalikulu ndikuphatikiza angapo oyandikana nawo.
Manga mawu mu Excel
Muchitsanzo chotsatirachi, tigwiritsa ntchito kukulunga mizere pagawo la D.
- Sankhani ma cell omwe mukufuna kuwonetsa mawu pamizere ingapo. Mu chitsanzo chathu, tiwonetsa ma cell omwe ali mugawo la D.
- Sankhani gulu Sunthani mawu tsamba Kunyumba.
- Mawuwo adzakulunga mzere ndi mzere.
Kankhani lamulo Sunthani mawu kachiwiri kuletsa kusamutsa.
Kuphatikiza ma cell mu Excel
Maselo awiri kapena angapo akaphatikizidwa, selo lomwe limachokera limatenga malo a selo lophatikizidwa, koma deta siiwonjezeredwa palimodzi. Mukhoza kuphatikiza aliyense moyandikana osiyanasiyana, ndipo ngakhale maselo onse pa pepala, ndi zambiri mu maselo onse kupatula pamwamba kumanzere adzakhala zichotsedwa.
Muchitsanzo chomwe chili pansipa, tiphatikiza mitundu A1:E1 kuti tipange mutu watsamba lathu.
- Sankhani ma cell omwe mukufuna kuphatikiza.
- Kankhani lamulo Phatikizani ndikuyika pakati tsamba Kunyumba.
- Maselo osankhidwa adzaphatikizidwa kukhala amodzi, ndipo malembawo adzayikidwa pakati.
batani Phatikizani ndikuyika pakati amachita ngati chosinthira, mwachitsanzo, kuwonekeranso kudzaletsa kuphatikiza. Deta fufutidwa sichidzabwezedwanso.
Zosankha Zambiri Zophatikiza Maselo mu Excel
Kuti mupeze zina zowonjezera pakuphatikiza ma cell, dinani muvi womwe uli pafupi ndi chizindikiro cha lamulo Phatikizani ndikuyika pakati. Menyu yotsitsa idzawonekera, ndi malamulo awa:
- Kuphatikiza ndi Center: Amaphatikiza maselo osankhidwa kukhala amodzi ndikuyika zomwe zili pakati.
- Gwirizanitsani ndi mizere: Amaphatikiza ma cell ndi mzere, mwachitsanzo, selo losiyana limapangidwa pamzere uliwonse wamtundu womwe wasankhidwa.
- Phatikizani ma cell: Amaphatikiza ma cell kukhala amodzi osayika zomwe zili pakati.
- Chotsani ma cell: Ikuletsa mgwirizano.