Mukamagwira ntchito ndi matebulo, nthawi zambiri amafunika kuwerengera zipilala. Zoonadi, izi zikhoza kuchitidwa pamanja, podutsa nambala yanu pa ndime iliyonse kuchokera ku makina. Ngati pali ndondomeko zambiri mu tebulo, zimatenga nthawi yochuluka. Mu Excel pali zipangizo zamtengo wapatali zomwe zimalola kuwerengetsa mofulumira. Tiyeni tiwone momwe amagwirira ntchito.
Njira Zowerengera
Pali zina zambiri zomwe mungachite kuti muzitha kuwerengera pa Excel. Zina mwazo ndi zosavuta komanso zomveka, zina ndizovuta kumvetsa. Tiyeni tiyang'ane payekha mwachindunji kuti tipeze njira yomwe tingagwiritse ntchito mogwira mtima pa nthawi inayake.
Njira 1: Lembani Malipiro
Njira yodziwika kwambiri yolemba ma columns ndi, ndithudi, kugwiritsa ntchito chizindikiro chodzaza.
- Tsegulani tebulo. Onjezerani mzere kwa iwo, momwe chiwerengero cha zikhomo zidzaikidwa. Kuti muchite izi, sankhani selo iliyonse ya mzere yomwe ingakhale pansi pa chiwerengero, dinani pomwe, ndikuyitanitsa mndandanda. Mndandanda uwu, sankhani chinthucho "Sakani ...".
- Kanyumba kakang'ono kotsegula kakatsegula. Sinthani kusinthana kuti mukhale malo "Onjezani mzere". Timakanikiza batani "Chabwino".
- Ikani chiwerengero mu selo yoyamba ya mzere wowonjezera "1". Kenaka sutsani cholozeracho kumbali ya kumanja ya selo ili. Tsitsilo limasanduka mtanda. Amatchedwa marker filling. Panthawi imodzimodziyo gwiritsani batani lamanzere ndi fungulo Ctrl pabokosi. Kokani chotsani chodzaza kumanja mpaka kumapeto kwa tebulo.
- Monga mukuonera, mzere umene tikufunikira umadzazidwa ndi manambala mu dongosolo. Izi ndizo, zikhozo zawerengedwa.
Mukhozanso kuchita zosiyana. Lembani maselo awiri oyambirira a mzere wowonjezera ndi manambala. "1" ndi "2". Sankhani maselo onsewa. Ikani chithunzithunzi m'makona a kumanja a kumanja. Ndi bokosi la phokoso lomwe limagwiritsidwa ntchito pansi, timakokera chogwiritsira ntchito kumapeto kwa gome, koma nthawi ino pafungulo Ctrl palibe chifukwa cholimbikira. Zotsatira zidzakhala zofanana.
Ngakhale kuti njira yoyamba ya njirayi ikuwonekera kukhala yophweka, koma, komabe, ogwiritsa ntchito ambiri amasankha kugwiritsa ntchito yachiwiri.
Pali njira ina yogwiritsira ntchito chizindikiro chodzaza.
- Mu selo yoyamba, lembani nambala "1". Pogwiritsa ntchito chikhomo cha chizindikiro cha zomwe zili kumanja. Pa nthawi yomweyo ndi batani Ctrl palibe chifukwa chogwedeza.
- Pambuyo pake, tawona kuti mzera wonse wodzazidwa ndi nambala "1". Koma tikufunikira kuwerengera mwatsatanetsatane. Dinani pa chithunzi chomwe chinayang'ana pafupi ndi selo yodzazidwa posachedwapa. Mndandanda wa zochitika zikuwonekera. Timayika chosinthira ku malo "Lembani".
Pambuyo pake, maselo onse a osankhidwawo adzadzazidwa ndi manambala mu dongosolo.
Phunziro: Momwe mungapangire autocomplete mu Excel
Njira 2: Kuwerengera ndi botani "Lembani" pa ndodo
Njira ina yowerengera zikhomo mu Microsoft Excel ikuphatikizapo kugwiritsa ntchito batani "Lembani" pa tepi.
- Mzerewu utatha kuwonjezeredwa kuwerengera zipilala, lowetsani nambala mu selo yoyamba "1". Sankhani mzere wonse wa tebulo. Pamene muli mu tabu la "Home", dinani batani pa ndodo. "Lembani"yomwe ili mu chida chogwiritsa ntchito Kusintha. Masamba otsika pansi akuwonekera. M'menemo, sankhani chinthucho "Kupita patsogolo ...".
- Mawindo owonetsera mapulogalamu akuyamba. Zigawo zonsezi ziyenera kuti zakhala zikukonzedwa mosavuta monga momwe tikufunira. Komabe, sizingakhale zodabwitsa kuti muwone momwe alili. Mu chipika "Malo" chosinthika chiyenera kukhazikitsidwa kuti chikhalepo "M'mizere". Muyeso Lembani " mtengo uyenera kusankhidwa "Masamu". Kufufuza kwazomwekuyenera kukulepheretsani. Izi sizikutanthauza kuti nkhupakuyi ikhale pafupi ndi dzina lofanana. Kumunda "Khwerero" onani kuti nambalayo inali "1". Munda "Pezani mtengo" iyenera kukhala yopanda kanthu. Ngati chinthu chilichonse sichigwirizana ndi malo omwe ali pamwambapa, ndiye chitani malingana ndi malangizowo. Mutatha kuonetsetsa kuti zonsezi zikudzala bwino, dinani pa batani. "Chabwino".
Pambuyo pake, zikho za tebulo zidzawerengedwa.
Simungakhoze ngakhale kusankha mzere wonse, koma ingoikani nambala mu selo yoyamba "1". Kenaka itanani mawindo azowonjezera zomwe zikuchitika pamwambapa. Zigawo zonse ziyenera kufanana ndi omwe tinkakambirana kale, kupatula munda "Pezani mtengo". Iyenera kuyika chiwerengero cha zipilala patebulo. Kenaka dinani pa batani "Chabwino".
Kudza kudzachitika. Njira yomalizira ndi yabwino kwa matebulo okhala ndi zipilala zambiri, chifukwa pamene mukugwiritsa ntchito, mtolowo suyenera kukokedwa kulikonse.
Njira 3: COLUMN ntchito
Mukhozanso kulembera zipilala pogwiritsa ntchito ntchito yapadera, yomwe imatchedwa COLUMN.
- Sankhani selo limene chiwerengerocho chiyenera kukhala "1" mu chiwerengero cha mndandanda. Dinani pa batani "Ikani ntchito"anaikidwa kumanzere kwa bar.
- Kutsegulidwa Mlaliki Wachipangizo. Lili ndi mndandanda wa ntchito zosiyanasiyana za Excel. Ife tikuyang'ana dzina "ZOCHITA"sankhani ndipo dinani pa batani "Chabwino".
- Ntchito yotsutsana yenera ikutsegula. Kumunda "Lumikizanani" Muyenera kupereka chiyanjano kwa selo iliyonse m'kalembedwe koyamba la pepala. Panthawiyi, ndikofunika kwambiri kumvetsera, makamaka ngati chigawo choyamba cha tebulo silo chigawo choyamba cha pepala. Adilesi ya kulumikizana ikhoza kulowetsedwa. Koma ndi zophweka kwambiri kuchita izi poika chithunzithunzi m'munda. "Lumikizanani"ndiyeno ndikudalira pa selo lofunidwa. Monga mukuonera, pambuyo pake, makonzedwe ake akuwonetsedwa mmunda. Timakanikiza batani "Chabwino".
- Zitatha izi, nambala ikuwoneka mu selo losankhidwa. "1". Kuti tilembere zipilala zonse, timakhala kumbali yake ya kumanja ndikuitanitsa chikhomo chodzaza. Monga momwe kale, timakokera kumanja kumapeto kwa tebulo. Dinani fungulo Ctrl palibe chosowa, kodinani kokha pakani botani yoyenera.
Mukamaliza kuchita zonsezi, zigawo zonse za tebulo zidzawerengedwa.
Phunziro: Wowonjezera Wogwira Ntchito
Monga mukuonera, chiwerengero cha zikhomo mu Excel ndizotheka m'njira zingapo. Chodziwika kwambiri mwa izi ndizogwiritsa ntchito chizindikiro chodzaza. M'masamba ochuluka kwambiri, n'zomveka kugwiritsa ntchito batani. "Lembani" ndi kusintha kwa machitidwe opita patsogolo. Njira iyi siimaphatikizapo kugwiritsira ntchito ndondomeko kupyolera mu ndege yonse ya pepala. Komanso, pali ntchito yapadera COLUMN. Koma chifukwa cha zovuta za kugwiritsira ntchito ndi luntha, njirayi siitchuka ngakhale pakati pa ogwiritsa ntchito. Inde, ndipo ndondomekoyi imatenga nthawi yambiri kusiyana ndi kawirikawiri kugwiritsa ntchito chizindikiro chodzaza.
