Njira 4 Zowonjezera Mapepala Atsopano mu Excel

Nthawi zambiri, ogwiritsa ntchito mu Excel spreadsheet mkonzi ayenera kuwonjezera tsamba latsopano pa chikalata cha spreadsheet. Zoonadi, mukhoza kupanga chikalata chatsopano, koma ndibwino kugwiritsa ntchito njirayi pokhapokha ngati palibe chifukwa chogwirizanitsa mauthenga osiyanasiyana kwa wina ndi mzake. Pulogalamuyi ili ndi njira zingapo zomwe zimakulolani kuti muwonjezere pepala ku chikalata cha spreadsheet. Tiyeni tione njira zonse mwatsatanetsatane.

batani la spreadsheet la Excel

Njirayi imatengedwa kuti ndiyosavuta komanso yosavuta kugwiritsa ntchito. Amagwiritsidwa ntchito ndi ambiri omwe amagwiritsa ntchito spreadsheet editor. Kukula kwakukulu kwa njirayi kumafotokozedwa ndi mfundo yakuti ndondomeko yowonjezera tsamba la ntchito yatsopano ndi yosavuta komanso yomveka ngakhale kwa ogwiritsa ntchito novice.

Muyenera dinani LMB pa chinthu chapadera chotchedwa "New Sheet", yomwe ili kumanja kwa mapepala omwe alipo pansi pa spreadsheet. Batani lokha limawoneka ngati chizindikiro chaching'ono chophatikiza mumthunzi wakuda. Dzina latsamba latsopano, lopangidwa kumene limaperekedwa mwachisawawa. Mutu wa pepala ukhoza kusinthidwa.

Malangizo atsatanetsatane okonzekera dzina ndi awa:

1. Dinani kawiri LMB patsamba lopangidwa.
2. Lowetsani dzina lomwe mukufuna kupereka.
3. Pambuyo pochita zosintha zonse, dinani batani la "Enter" lomwe lili pa kiyibodi.

4. Okonzeka! Dzina latsamba latsopanoli lasintha.

Pogwiritsa ntchito menyu yapadera ya Excel

Menyu yachidziwitso imakulolani kuti mugwiritse ntchito ndondomeko yowonjezeretsa tsamba latsopano ku chikalata cha spreadsheet mwamsanga. Malangizo atsatanetsatane owonjezera akuwoneka motere:

1. Timayang'ana pansi pa mawonekedwe a spreadsheet ndikupeza imodzi mwa mapepala omwe alipo a chikalatacho.
2. Timadina pa RMB.
3. Menyu yaying'ono yankhani idawonetsedwa pazenera. Timapeza chinthu chotchedwa "Insert sheet" ndikudina LMB.

4. Okonzeka! Tawonjeza tsamba lantchito latsopano ku chikalatachi.

Mutha kuwona kuti njira iyi, yomwe imakulolani kuti muwonjezere pepala ku chikalata pogwiritsa ntchito menyu yankhaniyo, ndiyosavuta kugwiritsa ntchito monga momwe tafotokozera kale. Tsamba lantchito lomwe lawonjezeredwa ndi njirayi litha kukonzedwanso chimodzimodzi.

Tcherani khutu!  Pogwiritsa ntchito mndandanda wazinthu, simungangoyika pepala latsopano, komanso kuchotsani zomwe zilipo kale.

Langizo latsatanetsatane lochotsa pepala logwirira ntchito ndi motere:

1. Timapeza imodzi mwa mapepala omwe alipo a chikalatacho.
2. Dinani pa pepala ndi batani lakumanja la mbewa.
3. Menyu yaying'ono yankhani idawonekera pazenera. Timapeza chinthu chotchedwa "Chotsani", dinani pa icho ndi batani lakumanzere.
4. Okonzeka! Tachotsa tsamba lantchito pachikalatacho.

Pogwiritsa ntchito menyu yankhaniyo, mutha kutchulanso, kusuntha, kukopera ndi kuteteza tsambalo.

Kuwonjezera Tsamba la Ntchito Pogwiritsa Ntchito Riboni ya Chida

Mutha kuwonjezera tsamba latsopano ku chikalata cha Excel spreadsheet pogwiritsa ntchito chida chapadera chamitundu ingapo chomwe chili pamwamba pa mawonekedwe. Malangizo atsatanetsatane ndi awa:

1. Poyamba, timapita ku gawo la "Home". Kumanja kwa riboni ya chida, timapeza chinthu chotchedwa "Maselo" ndikudina kumanzere pazithunzi zomwe zili pafupi ndi izo. Mndandanda wa mabatani atatu "Ikani", "Delete" ndi "Format" adawululidwa. Dinani batani lakumanzere la mbewa pa muvi wina womwe uli pafupi ndi batani la "Ikani".

2. Mndandanda wina waung'ono wa zinthu zinayi unawululidwa. Timafunikira chinthu chomaliza chotchedwa "Insert Sheet". Timadina pa LMB.

3. Okonzeka! Takhazikitsa ndondomeko yowonjezerera tsamba lantchito latsopano ku chikalata cha spreadsheet. Ndizofunikira kudziwa kuti, monga momwe tafotokozera kale, mutha kusintha dzina latsamba lomwe lapangidwa, ndikulichotsa.

Zofunika! Ngati zenera la spreadsheet likukulitsidwa mpaka kukula kwake, ndiye kuti palibe chifukwa choyang'ana chinthu cha "Maselo". Pachifukwa ichi, batani la "Insert Sheet", lomwe lili pamndandanda wotsikira pansi wa chinthu "Ikani", lili pomwepo pagawo lotchedwa "Home".

Kugwiritsa Ntchito Hotkeys Spreadsheet

Spreadsheet ya Excel ili ndi makiyi ake apadera otentha, kugwiritsa ntchito komwe kumatha kuchepetsa kwambiri nthawi yomwe imatenga kuti mupeze zida zofunika pamindandanda yapulogalamu.

Kuti muwonjezere tsamba lantchito yatsopano ku chikalata cha spreadsheet, muyenera kungodina batani "Shift + F11" pa kiyibodi. Pambuyo powonjezera tsamba latsopanoli motere, tidzipeza tokha pamalo ake ogwirira ntchito. Pambuyo powonjezera tsamba latsopano m'bukuli, dzina lake likhoza kusinthidwa motere.

Kutsiliza

Njira yowonjezerera tsamba latsopano ku chikalata cha Excel ndi ntchito yosavuta, yomwe ndi imodzi mwazofala komanso yomwe imagwiritsidwa ntchito ndi ogwiritsa ntchito spreadsheet. Ngati wogwiritsa ntchito sadziwa momwe angagwiritsire ntchito njirayi, ndiye kuti sangathe kugwiritsa ntchito bwino ntchito yake. Kukhoza kuwonjezera pepala latsopano ku bukhu la ntchito ndilofunika luso lomwe wogwiritsa ntchito aliyense amene akufuna kugwira ntchito mofulumira komanso molondola mu spreadsheet ayenera kukhala nawo.