Bisani ndikugwirizanitsa Pepala la Ntchito mu Excel

01 ya 05

Pa Zofalitsa Zobisika Zomwe Zabisika

Pulogalamu ya Excel ndi spreadsheet imodzi yomwe ili ndi maselo. Selo lirilonse lingathe kugwira malemba, chiwerengero, kapangidwe kake, ndipo selo iliyonse ikhoza kutanthauzira selo losiyana pa tsamba limodzi, buku lomwelo, kapena buku losiyana.

Buku la Excel lili ndi tsamba limodzi kapena ambiri. Mwachinsinsi, mabuku onse ogwiritsidwa ntchito otseguka amaonetsa ma tabu a ntchito pamsana wa ntchito pansi pazenera, koma mukhoza kuwabisa kapena kuwawonetsa ngati mukufunikira. Pepala limodzi la ntchito liyenera kuwonetsedwa nthawi zonse.

Pali njira zambiri zobisala ndi kutsegula masamba a Excel. Mutha:

• Gwiritsani ntchito ndondomeko yoyenera yowunikira.
• Gwiritsani ntchito zomwe mungasankhe pa Tsamba la Home la Riboni .

Deta Gwiritsani Ntchito Zolemba Zobisika

Deta yomwe ili m'mabuku ochotsedwa sakuchotsedwa, ndipo ikhozanso kufotokozedwa mu malemba ndi masamba omwe ali pamabuku ena kapena mabuku ena ogwira ntchito .

Mafomu obisika omwe ali ndi mafotokozedwe a maselo akusinthabe ngati deta mu maselo ofotokozedwa akusintha.

02 ya 05

Bisani Pulogalamu Yopangira Excel Pogwiritsa Ntchito Mndandanda wa Contextual

Zosankha zomwe zilipo mndandanda wa masewera-kapena pindani pomwepo-menyu-kusintha malingana ndi chinthu chomwe chasankhidwa pamene menyu yatsegulidwa.

Ngati Chinsinsi chobisala sichigwira ntchito kapena chatsekedwa, bukhuli labukhuli liri ndi tsamba limodzi lokha. Excel amachititsa kuti Bisani chisankho cha zolembera zamabuku amodzi chifukwa nthawi zonse ziyenera kukhala ndi tsamba limodzi lowonetseredwa mu bukhuli.

Kubisa Lamulo Lokha Lokha

1. Dinani pa tabu lamasewera la pepala kuti mubisankhire kuti mulisankhe.
2. Dinani pakhonde pa tsamba la ntchito kuti mutsegule mndandanda wa masewero.
3. Mu menyu, dinani pa Bisani njira yoti mubisala tsamba lomwe mwasankha.

Kubisa Masamba Ambiri Ambiri

1. Dinani pa tabu la tsamba loyamba kuti mubisankhire.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Dinani pamabuku a malemba ena kuti muwasankhe.
4. Dinani pamanja pa tsamba limodzi lamasamba kuti mutsegule mndandanda wamakono.
5. Mu menyu, dinani pa Bisani njira yoti mubise ma tsamba onse osankhidwa.

03 a 05

Bisani Zolemba Zolemba Pogwiritsa Ntchito Mphutsi

Excel alibe njira yachinsinsi yobisa mapepala, koma mukhoza kugwiritsa ntchito riboni kuti mugwire ntchitoyo.

1. Sankhani tabu lamasamba pamunsi pa fayilo ya Excel.
2. Dinani kabukhu Kakang'ono pa kaboni ndikusankha zithunzi za Maselo .
3. Sankhani Maonekedwe mu menyu otsika omwe akuwonekera.
4. Dinani kubisala ndi kusokoneza .
5. Sankhani Kisani Mapepala .

04 ya 05

Yambani Pulogalamu Yophatikiza Pogwiritsa Ntchito Mndandanda wa Contextual

Zosankha zomwe zilipo mndandanda wa masewera-kapena pindani pomwepo-menyu-kusintha malingana ndi chinthu chomwe chasankhidwa pamene menyu yatsegulidwa.

Kuphatikizira Pulogalamu Yoyamba Yokha

1. Dinani pa tabu lamasewera kuti mutsegule bokosi lachikumbutso la Unhide , lomwe likuwonetsera mapepala onse omwe ali pano.
2. Dinani pa pepala kuti musokonezeke.
3. Dinani OK kuti mutseke pepala losankhidwa ndi kutsegula bokosi.

05 ya 05

Kambiranani Tsamba Labwino Pogwiritsa Ntchito Mphutsi

Mofanana ndi kubisala mapepala, Excel alibe njira yachinsinsi yokonzera tsamba, koma mungagwiritse ntchito riboni kuti mupeze ndi kusokoneza mapepala obisika.

1. Sankhani tabu lamasamba pamunsi pa fayilo ya Excel.
2. Dinani kabukhu Kakang'ono pa kaboni ndikusankha zithunzi za Maselo .
3. Sankhani Maonekedwe mu menyu otsika omwe akuwonekera.
4. Dinani kubisala ndi kusokoneza .
5. Sankhani Khadi Lopatulika .
6. Onani mndandanda wa mafayela obisika omwe akuwonekera. Dinani pa fayilo yomwe mukufuna kuti muiyike.
7. Dinani OK .