Makonda masanjidwewo a masamba ku Excel ndi chida chothandiza kwambiri pomwepo mutha kuwona momwe zinthu zimawonekera patsamba posindikiza ndikusintha iwo pomwepo. Kuphatikiza apo, mumachitidwe awa, owonera otsatsa amapezeka - zolemba zapadera kumtunda ndi pansi pamasamba omwe sawoneka muzochitika. Koma, komabe, kugwira ntchito nthawi zonse m'malo otere ndikofunikira kwa onse ogwiritsa ntchito. Komanso, wogwiritsa ntchito akatembenukira ku magwiridwe antchito, adzazindikira kuti ngakhale mizere yosemayo idatsalirabe yomwe ikuwonetsa malire a tsambali.
Chotsani m'mbuyo
Tiyeni tiwone momwe mungatsegulitsire njira yosinthira masamba ndikuchotsa mawonekedwe owoneka pamalire pa pepalalo.
Njira 1: thimitsani mawonekedwe patsamba
Njira yosavuta yotumizira njira yosinthira masamba ndikuisintha kudzera pa icon pazida.
Mabatani atatu mu mawonekedwe azithunzi zosinthira mawonekedwe awonekera ali kudzanja lamanja la batani lamanzere kumanzere kwa zowongolera. Kugwiritsa ntchito, mutha kusintha njira zotsatirazi:
- wamba;
- tsamba;
- kapangidwe kazithunzi.
M'mitundu iwiri yomaliza, pepalali linagawidwa magawo awiri. Kuti muchotse kusiyana uku, ingodinani pachizindikiro "Zachizolowezi". Njira zimasintha.
Njirayi ndiyabwino chifukwa imatha kugwiritsidwa ntchito pakanema kamodzi, kukhala pawebhu iliyonse ya pulogalamuyi.
Njira 2: Onani Tab
Mutha kusinthanso mitundu yogwiritsira ntchito ntchito ku Excel pogwiritsa ntchito mabatani omwe ali pakatipa "Onani".
- Pitani ku tabu "Onani". Pa nthiti yomwe ili m'bokosi la chida Mitundu Yowonera dinani batani "Zachizolowezi".
- Pambuyo pake, pulogalamuyo idzasinthidwa kuchoka pamayendedwe akugwira ntchito molowera kukhala yokhazikika.
Njirayi, mosiyana ndi yoyamba ija, imaphatikizapo zojambula zowonjezera zomwe zimakhudzana ndikusinthira ku tabu ina, koma, komabe, ogwiritsa ntchito ena amakonda kuzigwiritsa ntchito.
Njira 3: chotsani mzere wowonongeka
Koma, ngakhale mutasintha kuchokera patsamba kapena mawonekedwe osintha tsamba kukhala achizolowezi, mzere wowongoka wokhala ndi mizere yayifupi, wosemphana ndi zidutswa, udutsabe. Pa dzanja limodzi, zimathandizira kuwona ngati zomwe zili mufayilo zidzakwanira mu pepala losindikizidwa. Komabe, sikuti aliyense wogwiritsa ntchito pepalalo, angasinthe chidwi chake. Kuphatikiza apo, sikuti cholembedwa chilichonse chimapangidwira osindikizidwa, zomwe zikutanthauza kuti ntchito yotereyi imangokhala yopanda ntchito.
Tiyenera kudziwa kuti nthawi yomweyo njira yosavuta yochotsera zingwe zazifupi ndizokhazikitsa fayilo.
- Musanatseke zenera, musaiwale kusunga zotsatira za kusintha mwa kuwonekera pazithunzi mu mawonekedwe a diskette pakona yakumanzere kumanzere.
- Pambuyo pake, dinani pazithunzi mu mawonekedwe a mtanda Woyera wolemba lalikulu kiyi pakona yakumanja ya zenera, ndiye kuti dinani batani loyandikira pafupi. Sikoyenera kutseka mawindo onse a Excel ngati muli ndi mafayilo angapo nthawi imodzi, chifukwa ndikokwanira kumaliza kugwira ntchito mu chikalata chomwe mzere womwe udalipo ulipo.
- Chikalatacho chidzatsekedwa, ndipo mukachiyambitsanso, mizere yachidule yomwe ikuswa chikalaponso sichidzakhalakonso.
Njira 4: chotsani masamba
Kuphatikiza apo, tsamba lothandizira la Excel lingathenso kuikidwa chizindikiro ndi mizere yayitali yopanda. Kudutsa kumeneku kumatchedwa kuswa masamba. Ikhoza kutsegulidwa pamanja, kotero kuti muimitse muyenera kuchita zowonera zina mu pulogalamuyo. Zomata zoterezi zimaphatikizidwa ngati mukufuna kusindikiza zigawo zina za chikalatacho mosiyana ndi thupi lalikulu. Koma, kusoweka kotereku sikumakhalapo nthawi zonse, kuphatikiza apo, ntchitoyi imatha kutseguliridwa mosasamala, ndipo mosiyana ndi mawonekedwe osavuta a masamba, owonekera kokha kuchokera pachithunzithunzi chowunikira, mipata iyi imapatula chikalatacho posindikiza, zomwe nthawi zambiri sizovomerezeka. . Kenako nkhani yakulepheretsa izi ndiyofunika.
- Pitani ku tabu Kupita. Pa nthiti yomwe ili m'bokosi la chida Zikhazikiko Tsamba dinani batani Zophulika. Menyu yotsitsa imatsegulidwa. Pitani ku chinthucho Kubwezeretsanso Kusweka. Ngati mungodina pachinthucho "Fufutani tsamba", ndiye chinthu chimodzi chokha chimachotsedwa, ndipo zina zonse ndizikhala pamapepala.
- Zitatha izi, mipata ya mizere yayitali yochotsedwa idzachotsedwa. Koma mizere yaying'ono ya zilembo zidzaoneka. Iwo, ngati mukuwona kuti ndikofunikira, amatha kuchotsedwa, monga momwe tafotokozera kale.
Monga mukuwonera, kuletsa masanjidwe amatsamba ndikosavuta. Kuti muchite izi, muyenera kungosintha ndikudina batani lolingana mu pulogalamuyo. Kuti muchotse madilesi omwe ali ndi madotolo, ngati akusokoneza wosuta, muyenera kuyambiranso pulogalamuyo. Kuchotsa kwa mawonekedwe osapindika kwa mizere yokhala ndi mzere wautali wopangidwira kumatha kuchitika kudzera mwa batani lomwe limasulidwa. Chifukwa chake, kuchotsa chinthu chilichonse chazopanga, pali ukadaulo wapadera.
