Ogwiritsa ntchito ambiri adazindikira kuti mukamagwira ntchito Microsoft Excel, pamakhala zochitika pomwe m'malo manambala mumaselo mukalowa deta, zithunzi zomwe zimakhala mu mawonekedwe a trellises zimawonekera (#) Mwachilengedwe, ndizosatheka kugwira ntchito ndi chidziwitso mu mawonekedwe awa. Tiyeni tiwone zomwe zimayambitsa vutoli ndikupeza yankho lake.
Kuthetsa mavuto
Chizindikiro cha mapaundi (#) kapena, monga momwe limatchulidwira moyenera, octotorp amawonekera mu maselo amenewo pa pepala la Excel pomwe deta yake sikupezeka m'malire. Chifukwa chake, amasinthidwa mowoneka ndi zizindikiro izi, ngakhale zili choncho, powerengera, pulogalamuyi imagwirabe ntchito ndi zenizeni, osati ndi zomwe zimawonetsedwa pazenera. Ngakhale izi, kwa wogwiritsa ntchito, deta imakhalabe yosadziwika, zomwe zikutanthauza kuti nkhani yothetsera vutoli ndiyothandiza. Zachidziwikire, mutha kuwona ndikuyendetsa deta yeniyeni kudzera pamizere yantchito, koma kwa ogwiritsa ntchito ambiri siyankho.
Kuphatikiza apo, m'matembenuzidwe akale a mwambowu, zokhutira zidawoneka ngati panali anthu opitilira 1024 mu chipangizochi pogwiritsa ntchito mawonekedwe a foni. Koma kuyambira pa mtundu wa Excel 2010, izi zidachotsedwa.
Tiyeni tiwone momwe tingathetse vuto lawonetsedwa.
Njira 1: kukulitsa malire
Njira yosavuta komanso yodziwika bwino kwa ogwiritsa ntchito ambiri kukulitsa malire a maselo, ndipo, chifukwa chake, kuthana ndi vuto lowonetsera ma grid m'malo mwa manambala, ndiko kukoka pamalire pamalire a msanjawo.
Izi zimachitika mosavuta. Tikuyika cholozera pamalire pakati pazipilala zomwe zikugwirizana. Timadikirira mpaka pomwe tembeyo isandulika kukhala muvi wa mbali ziwiri. Timadina batani lakumanzere ndikuligwira, ndikukokera m'malire mpaka muwone kuti deta yonse ikukwanira.
Mukamaliza njirayi, khungu liziwonjezeka, ndipo m'malo mwa mipiringidzo, manambala adzawonetsedwa.
Njira 2: kuchepetsa font
Zachidziwikire, ngati pali gawo limodzi kapena awiri omwe sanasungidwe mu maselo, zinthu zimakhala zosavuta kuwongolera mwanjira yomwe tafotokozayi. Koma choti achite ngati pali zambiri za mizati yotere. Pankhaniyi, mutha kugwiritsa ntchito kuchepetsa font kuti muthane ndi vutoli.
- Sankhani dera lomwe tikufuna kuchepetsa font.
- Kukhala mu tabu "Pofikira" pa tepi mu bokosi la chida Font tsegulani mawonekedwe osintha. Timayika chizindikiro chocheperako kuposa chomwe chikuwonetsedwa pano. Ngati zosungazo sizikugwirizana m'maselo, ndiye kuti timayika zocheperako mpaka zotsatira zomwe mukufuna zitheke.
Njira 3: Kukula kwa Auto Fit
Pali njira inanso yosinthira mawonekedwe mu maselo. Zimachitika pochita makonzedwe. Poterepa, kukula kwa zilembo sikungafanane ndi gawo lonse, ndipo mzere uliwonse ukhale ndi phindu lake kuti likhale ndi zomwe zili mu cell.
- Timasankha magulu omwe adzagwire ntchitoyo. Dinani kumanja. Pazosankha zofanizira, sankhani phindu "Mtundu wamtundu ...".
- Tsamba losintha likutsegulidwa. Pitani ku tabu Kuphatikiza. Khazikitsani mbalame pafupi ndi paramayo "Kukula Kwazoyenda". Kuti musinthe masinthidwe, dinani batani "Zabwino".
Monga mukuwonera, zitatha izi mawonekedwe mu maselo adatsika mokwanira kuti zigwirizane ndi zomwezo.
Njira 4: sinthani mawonekedwe
Poyambirira, panali zokambirana kuti m'mitundu yakale ya Excel panali malire pa chiwerengero cha zilembo zomwe zimakhala ndi foni imodzi polemba mtundu. Popeza ogwiritsa ntchito ambiri akupitiliza kugwiritsa ntchito pulogalamuyi, tiyeni tilingalire yankho lavutoli. Pofuna kuzungulira izi, muyenera kusintha mtundu kuchokera palemba kupita wamba.
- Sankhani mawonekedwe. Dinani kumanja. Pazosankha zomwe zimawonekera, dinani chinthucho "Mtundu wamtundu ...".
- Pazenera lopangidwe, pitani ku tabu "Chiwerengero". Pamagawo "Mawerengero Amanambala" sinthani mtengo wake "Zolemba" pa "General". Dinani batani "Zabwino".
Tsopano ziletso zimachotsedwa ndipo chiwerengero chilichonse cha zilembo chikuwonetsedwa bwino mchipindamu.
Mutha kusinthanso mawonekedwe pa riboni patsamba "Pofikira" mu bokosi la zida "Chiwerengero"posankha mtengo woyenera pawindo lapadera.
Monga mukuwonera, kusintha octotorp ndi manambala kapena deta yolondola mu Microsoft Excel sikovuta. Kuti muchite izi, pitani kukulitsa mizati kapena muchepetse mawonekedwe. Kwa mitundu yakale yamapulogalamuwo, kusintha mtundu wamakalata kukhala wamba kumakhala koyenera.
