Mapepala obisika mu Microsoft Excel

Pin
Send
Share
Send

Pulogalamu ya Excel imakupatsani mwayi wopanga ma worksheets angapo mufayilo limodzi. Nthawi zina muyenera kubisa zina za izo. Zomwe zimachitika izi zitha kukhala zosiyana kwathunthu, kuyambira pakukakamira kwa wakunja kutenga chinsinsi chomwe chili pa iwo, ndikumaliza ndikulakalaka kodzitetezera ku kuchotsedwa kwazinthuzi. Tiyeni tiwone momwe tingabisire pepala ku Excel.

Njira zobisira

Pali njira ziwiri zazikulu zobisika. Kuphatikiza apo, pali njira inanso yomwe mungagwiritsire ntchito izi pazinthu zingapo nthawi imodzi.

Njira 1: mndandanda wanthawi zonse

Choyambirira, ndikofunika kukhazikika munjira yobisala pogwiritsa ntchito menyu.

Dinani dzina la pepalalo kuti tikufuna kubisa. Mu mndandanda wazinthu zomwe mwasankha, sankhani Bisani.

Pambuyo pake, chinthu chosankhidwa chidzabisika kwa anthu ogwiritsa ntchito.

Njira 2: batani la mawonekedwe

Njira ina pakugwiritsa ntchito njirayi ndikugwiritsa ntchito batani "Fomu" pa tepi.

  1. Pitani ku pepala lomwe liyenera kubisika.
  2. Pitani ku tabu "Pofikira"ngati tili wina. Dinani batani. "Fomu"adakhala ndi bokosi lazida "Maselo". Pamndandanda wotsitsa mu gulu la makonda "Kuwoneka" sitepe ndi sitepe Bisani kapena onetsani ndi "Bisani pepala".

Pambuyo pake, chinthu chomwe chikufunidwa chidzabisika.

Njira 3: kubisa zinthu zingapo

Kuti abise zinthu zingapo, ayenera kusankhidwa kaye. Ngati mukufuna kusankha ma sheet okonzedwa, ndiye dinani pa mayina oyamba komanso otsiriza a mndandanda womwe wapanikizidwa batani Shift.

Ngati mukufuna kusankha mapepala omwe palibe pafupi, dinani aliyense waiwo ndi batani lomwe limakanikizidwa Ctrl.

Mukasankha, pitani ku njira yobisa kudzera mumenyu yazakudyera kapena kudzera pa batani "Fomu"monga tafotokozera pamwambapa.

Monga mukuwonera, kubisa mapepala ku Excel ndikosavuta. Nthawi yomweyo, njirayi imatha kuchitika m'njira zingapo.

Pin
Send
Share
Send