Kawirikawiri, vuto limakhalapo pamene, pamene akusindikiza chikalata, tsamba likudulidwa pamalo osayenera kwambiri. Mwachitsanzo, pa tsamba limodzi mukhoza kukhala mbali yaikulu pa tebulo, ndipo pa yachiwiri - mzere womaliza. Pankhaniyi, nkhaniyo imasuntha kapena kuchotsa mpata. Tiyeni tiwone momwe izi zingathere pamene mukugwira ntchito ndi zolemba mu procel spreadsheet.
Onaninso: Kodi mungachotse bwanji tsamba pa Excel
Mitundu ya pepala yothandizira ndi njira yochotsera
Choyamba, muyenera kudziwa kuti kusweka kwa tsamba kungakhale kosiyana siyana:
- Kulowetsedwa mwadongosolo ndi wogwiritsa ntchito;
- Inayikidwa mosavuta ndi pulogalamuyi.
Choncho, njira zothetsera mitundu iwiri ya dissection ndi zosiyana.
Yoyamba mwa iwo ikuwoneka muzomwekugwiritsidwa ntchito pokhapokha ngati wogwiritsa ntchitoyo mwiniyo akuwongolera pogwiritsira ntchito chida chapadera. Ikhoza kusuntha ndi kuchotsedwa. Mtundu wachiwiri wa dissection umalowetsedwa ndi pulogalamuyi. Sangathe kuchotsedwa, koma ikhoza kusunthidwa.
Kuti muwone komwe malo osokoneza mapepala akuyang'aniridwa, osasindikiza chikwangwani chomwecho, muyenera kusintha kusinthasintha tsamba. Izi zingatheke podutsa pazithunzi. "Tsamba"chomwe chiri chizindikiro cholondola pakati pa zithunzi zitatu zoyendetsa pakati pa tsamba kuwona. Zithunzi izi zili mu barre yazithunzi kumanzere kwa zojambulazo chida.
Ndiponso pa tsamba tsamba pali mwayi woti mupite kumeneko kupita ku tabu "Onani". Kumeneku muyenera kudina pa batani, omwe amatchedwa - "Mafilimu" ndipo atumizidwa pa tepi mu chipika "Zojambula Zamabuku".
Pambuyo pa kusinthasintha kwa tsamba, mabala adzaonekera. Zomwe mwazidzidzidzi zimapangidwira ndi pulogalamuyi zimasonyezedwa ndi mzere wazitali, ndipo iwo omwe amaikidwa mwawo ndi omwe akugwiritsa ntchito akuwonetsedwa ndi mzere wofiira wa buluu.
Tibwereranso kuntchito yogwira ntchito ndi chilembacho. Timakani pa chithunzi "Zachibadwa" pa barre ya udindo kapena chizindikiro chomwecho pa kavalo mu tab "Onani".
Pambuyo pa kusintha kwa machitidwe owonera mwachizolowezi kuchokera pa tsamba lolozera, kuperewera kwa mipata kudzawonekera pa pepala. Koma izi zidzachitika kokha ngati wogwiritsa ntchito asamukira ku tsamba lakuwonera chikalatacho. Ngati iye sanachite izi, ndiye mwa njira yachizolowezi, kupembedzera sikudzawoneka. Kotero, mu njira yozolowereka ya dissection, iwo amawonetsedwa pang'ono mosiyana. Zomwe mwazilengedwa pokhapokha pulogalamuyi zidzawonekera ngati mawonekedwe aling'ono, ndipo mwadongosolo umalengedwa ndi ogwiritsa ntchito - ngati mawonekedwe akuluakulu ophwanyika.
Kuti muwone momwe chidutswa "chatsekedwa" chidzawoneka ngati chindikizidwa, pitani ku tab "Foni". Kenako, pitani ku gawolo "Sakani". Pakati pazenera kumene mbali yazenera padzakhala malo oyang'ana. Mukhoza kuyang'ana chikalatacho poyendetsa mpukutuwo pansi ndi pansi.
Tsopano tiyeni tipeze momwe tingakonzere vuto ili.
Njira 1: chotsani zopuma zonse zolembedwa
Choyamba, tiyeni tiganizire za kuchotsa masamba osamalitsa.
- Pitani ku tabu "Tsamba la Tsamba". Timakani pa chithunzi pa khoni "Kuswa"adaikidwa mu chipika "Makhalidwe a Tsamba". Mndandanda wotsika pansi ukupezeka. Kuchokera pa zosankha za zomwe zikufotokozedwa mmenemo, sankhani "Bwezeretsani kusweka kwa tsamba".
- Zitatha izi, tsamba lonse likutsalira pa pepala la Excel lomwe liripo lokha lokha lokha ndilowetsedwa ndi ogwiritsa ntchito lidzachotsedwa. Tsopano, pamene akusindikiza, tsambalo lidzathetsedwa pomwe pulogalamuyo ikuwonetsedwa.
Njira 2: Chotsani mipata yomwe imayikidwa pamanja
Koma osati nthawi zonse ndikofunika kuchotsa zopuma zonse zomwe amagwiritsa ntchito pa pepala. Nthawi zina, mbali yocheka imayenera kuchoka, ndipo gawo lochotsa. Tiyeni tiwone momwe izi zingakhalire.
- Sankhani selo lirilonse lomwe liri pamunsi mwachitsime, chomwe chiyenera kuti chichotsedwe pa pepala. Ngati kusokonezeka kwake kuli chowongolera, ndiye kuti tikhoza kusankha choyenera. Pitani ku tabu "Tsamba la Tsamba" ndipo dinani pazithunzi "Kuswa". Nthawi ino kuchokera mundandanda wotsika pansi muyenera kusankha kusankha "Chotsani kuswa kwa tsamba".
- Pambuyo pachitachi, khungu lokha pamwamba pa selo losankhidwa lidzathetsedwa.
Ngati ndi kotheka, mutha kuchotsa zitsulo zotsalira pa pepala, pomwe palibe chosowa.
Njira 3: Chotsani zopuma zolemedwa mwadala pozisunthira
Ndiponso mapulogalamu ophatikizidwa pamanja angachotsedwe mwa kuwasuntha pamphepete mwa chikalatacho.
- Pitani ku tsamba tsamba la bukhuli. Ikani chithunzithunzi pa phuku lopangidwira lomwe liri ndi mzere wofiira wa buluu. Chotsegulacho chiyenera kusinthidwa kukhala mzere wodutsa. Lembani batani lakumanja lamanzere ndikukoka mzere wolimba kumphepete mwa pepala.
- Mukamaliza malire a fomu, tulutsani batani. Kusokonezeka uku kudzachotsedwa pa pepala laposachedwapa.
Njira 4: Sungani zopuma
Tsopano tiyeni tiwone momwe tsambali limasinthira pokhapokha pulogalamuyo ikhoza kukhala, ngati sichichotsedwe nkomwe, ndiye osasuntha ngati momwe akufunira.
- Kusunthira ku tsamba loyang'ana. Sungani chithunzithunzi padulidwa, chomwe chikuwonetsedwa ndi mzere wa masamba. Mtolowo umatembenuzidwa kukhala bwalo la bidirectional. Timapanga chithunzi cha batani lamanzere. Kuponyera mpata motsatira njira yomwe timaona kuti ndi yofunikira. Mwachitsanzo, kusokonezeka kungasunthire kumalire a pepala. Izi ndizo, timachita ndondomeko yofanana ndi yomwe inkachitidwa kale.
- Pachifukwa ichi, kupuma kothamanga kungasunthire kumalire a chilembo chonse, kapena kusamukira ku malo abwino kwa wogwiritsa ntchito. Pachifukwa chomalizacho, icho chasandulika kugawidwa kwadzidzidzi. Tsopano ili pamalo ano pamene kusindikiza tsamba lidzang'ambika.
Monga mukuonera, musanayambe ndondomeko yakuchotseratu mpata, muyenera kupeza mtundu wa zinthu zomwe zikutanthawuza: zowonjezera kapena zopangidwa ndi ogwiritsa ntchito. Kuchokera pa izi kudzadalira makamaka njira yakuchotsedwera. Kuwonjezera pamenepo, ndikofunika kumvetsetsa zomwe ziyenera kuchitidwa ndi izi: kuthetseratu kwathunthu kapena kungosunthira kumalo ena mu chilembacho. Mfundo ina yofunika ndi momwe gawo lochotsedwa likhudzana ndi mabala ena pa pepala. Ndipotu, ngati chinthu chimodzi chichotsedwa kapena chosunthidwa, malo pa pepala ndi mipata ina idzasintha. Choncho, izi ndizofunika kuziganizira mwamsanga musanayambe kuchotsa.
