Kugwira ntchito ndi ma cell mu Excel

Ogwiritsa ntchito ambiri a Excel amalakwitsa chimodzimodzi. Amasokoneza mitundu iwiri yosiyana ya machitidwe: mkati mwa selo ndi kumbuyo kwake. Koma kusiyana pakati pawo ndi kwakukulu.

Chowonadi ndi chakuti selo lililonse lili ndi zinthu zonse, zomwe ndi gawo lolowera lomwe lili ndi mwayi wambiri. Mafomula, manambala, malemba, ogwiritsira ntchito zomveka, ndi zina zotero zalowetsedwa kumeneko. Zolemba zokha zikhoza kulembedwa: kusintha kukula kwake ndi kalembedwe, komanso malo ake mkati mwa selo.

Mwachitsanzo, m’chithunzichi mukuona kuti mawu a mkati mwa selo ndi ofiira komanso amphamvu kwambiri.

Pankhaniyi, ndikofunikira kulabadira kuti selo lomwe likuwonetsedwa pachithunzichi liri mumayendedwe osintha. Kuti mumvetsetse momwe selo ilili mwa inu, mutha kugwiritsa ntchito cholozera chamkati. Koma ngakhale sizikuwoneka, selo likhoza kukhala mu edit mode. Mutha kumvetsetsa izi ndi kupezeka kwa mabatani omwe akugwira ntchito kutsimikizira ndi kuletsa zolowetsa. 

Chofunika kwambiri pamtunduwu ndikuti ndizosatheka kuchita zonse zomwe zingatheke ndi selo momwemo. Ngati muyang'ana pazitsulo za riboni, mudzawona kuti mabatani ambiri sakugwira ntchito. Apa ndi pamene cholakwika chachikulu chimasonyezedwa. Koma tiyeni tiyankhule za chirichonse mwadongosolo, kuyambira ndi zoyambira kwambiri ndiyeno tidzawonjezera kuchuluka kwa zovuta kuti aliyense aphunzirepo kanthu kothandiza.

Mfundo Zoyambira

Choncho, chinthu chachikulu pa tebulo ndi selo. Ili pa mphambano ya mzere ndi mzere, choncho ili ndi adiresi yake, yomwe ingagwiritsidwe ntchito muzolemba kuti iwonetsere, kupeza deta, ndi zina zotero. 

Mwachitsanzo, selo B3 ili ndi makonzedwe otsatirawa: mzere 3, ndime 2. Mutha kuziwona pakona yakumanzere, molunjika pansi pa menyu yoyendayenda. 

Lingaliro lachiwiri lofunikira ndi bukhu lantchito. Ichi ndi chikalata chotsegulidwa ndi wogwiritsa ntchito, chomwe chili ndi mndandanda wa mapepala, omwe amakhala ndi maselo. Chikalata chilichonse chatsopano sichikhala ndi chidziwitso chilichonse, ndipo m'munda wa vinyo wolingana ndi adilesi ya cell yomwe yasankhidwa.

Mayina amtundu ndi mizere amawonetsedwanso. Imodzi mwamaselo ikasankhidwa, zinthu zofananira mu bar yolumikizira zidzawonetsedwa mu lalanje.

Kuti mulowetse zambiri, m'pofunika, monga tafotokozera kale pamwambapa, kuti musinthe kusintha. Muyenera kusankha selo yoyenera ndi kumanzere kuwonekera pa izo, ndiyeno ingolowetsani deta. Mutha kuyendanso pakati pa ma cell osiyanasiyana pogwiritsa ntchito kiyibodi pogwiritsa ntchito mivi.

Ntchito Zoyambira Ma cell

Sankhani maselo mumtundu umodzi

Zidziwitso zamagulu mu Excel zimachitika motengera mtundu wapadera. Pankhaniyi, maselo angapo amasankhidwa nthawi imodzi, komanso mizere ndi mizati, motero. Ngati muwasankha, dera lonselo likuwonetsedwa, ndipo bar ya adiresi imapereka chidule cha maselo onse osankhidwa.

Kuphatikiza ma cell

Maselo akasankhidwa, tsopano akhoza kuphatikizidwa. Musanachite izi, tikulimbikitsidwa kutengera mtundu womwe mwasankha ndikusindikiza makiyi a Ctrl + C ndikusunthira kumalo ena pogwiritsa ntchito makiyi a Ctrl + V. Mwanjira iyi mutha kusunga zosunga zobwezeretsera za data yanu. Izi ziyenera kuchitika, chifukwa maselo akaphatikizidwa, zonse zomwe zili mmenemo zimafufutidwa. Ndipo kuti mubwezeretse, muyenera kukhala ndi kopi yake.

Kenako, muyenera dinani batani lomwe likuwonetsedwa pazenera. Pali njira zingapo zophatikizira ma cell. Muyenera kusankha yomwe ikugwirizana ndi zomwe zikuchitika.

Kupeza batani lofunika. Pazosankha zowonera, pa tabu ya "Home", pezani batani lomwe lidalembedwa pazithunzi zam'mbuyomu ndikuwonetsa mndandanda wotsitsa. Tasankha Merge ndi Center. Ngati batani ili silikugwira ntchito, muyenera kusiya njira yosinthira. Izi zitha kuchitika mwa kukanikiza Enter key. 

Ngati mukufuna kusintha momwe malembawo alili mu selo lalikulu lotulukapo, mukhoza kutero pogwiritsa ntchito makonzedwe opezeka pa Home tab.

Kugawa ma cell

Iyi ndi njira yosavuta yomwe imabwereza ndime yapitayi:

1. Kusankha selo lomwe lidapangidwa kale pophatikiza ma cell ena angapo. Kulekana kwa ena sikutheka. 
2. Chida chophatikizidwa chikasankhidwa, kiyi yophatikiza idzawunikira. Pambuyo kuwonekera pa izo, maselo onse adzalekanitsidwa. Aliyense wa iwo adzalandira adiresi yake. Mizere ndi zigawo zidzawerengedwanso zokha. 

Kusaka Kwama cell

Ndikosavuta kunyalanyaza mfundo zofunika pamene muyenera kugwira ntchito ndi deta yambiri. Kuti muthane ndi vutoli, mutha kugwiritsa ntchito kufufuza. Komanso, mutha kusaka osati mawu okha, komanso ma formula, midadada yophatikizika, ndi chilichonse chomwe mungafune. Kuti muchite izi, muyenera kuchita izi:

1. Onetsetsani kuti tabu Yanyumba ndi yotseguka. Pali "Sinthani" malo mungapezeko "Pezani ndi Sankhani".
2. Pambuyo pake, bokosi la zokambirana lidzatsegulidwa ndi gawo lolowera momwe mungalowetse mtengo womwe mukufuna. Palinso mwayi wofotokozera zina zowonjezera. Mwachitsanzo, ngati mukufuna kupeza maselo ophatikizidwa, muyenera kudina "Zosankha" - "Format" - "Malumikizidwe", ndipo fufuzani bokosi pafupi ndi kufufuza kwa maselo ophatikizidwa.
3. Zofunikira zidzawonetsedwa pawindo lapadera.

Palinso gawo la "Pezani Zonse" kuti mufufuze ma cell onse ophatikizidwa.

Kugwira ntchito ndi zomwe zili m'ma cell a Excel

Apa tiwona ntchito zina zomwe zimakulolani kuti mugwiritse ntchito zolemba, ntchito kapena manambala, momwe mungakopere, kusuntha ndi kubwereza ntchito. Tiyeni tione chilichonse mwadongosolo.

1. Zolowetsa. Zonse ndi zophweka apa. Muyenera kusankha ankafuna selo ndi kungoyamba kulemba.
2. Kuchotsa zambiri. Kuti muchite izi, mutha kugwiritsa ntchito kiyi ya Chotsani ndi Backspace. Mukhozanso kugwiritsa ntchito kiyi chofufutira mu Editing panel.
3. Koperani. Ndikosavuta kuchita izi pogwiritsa ntchito makiyi otentha a Ctrl + C ndikumata zomwe mwakopera pamalo omwe mukufuna pogwiritsa ntchito kuphatikiza Ctrl + V. Mwanjira iyi, kuchulukitsa kwachangu kwa data kumatha kuchitika. Itha kugwiritsidwa ntchito osati mu Excel, komanso pafupifupi pulogalamu iliyonse yomwe ikuyenda ndi Windows. Ngati cholakwika chidachitika (mwachitsanzo, mawu olakwika adayikidwa), mutha kubweza ndikukanikiza kuphatikiza Ctrl + Z.
4. Kudula. Imachitika pogwiritsa ntchito kuphatikiza kwa Ctrl + X, pambuyo pake muyenera kuyika deta pamalo oyenera pogwiritsa ntchito makiyi otentha omwewo Ctrl + V. Kusiyana pakati pa kudula ndi kukopera ndikuti ndi chomaliza, deta imasungidwa mu malo oyamba, pamene chidutswa chodulidwa chimangokhala pamalo pomwe chinayikidwa. 
5. Kukonza. Maselo amatha kusinthidwa kunja ndi mkati. Kufikira magawo onse ofunikira atha kupezeka podina kumanja pa cell yofunikira. Menyu yankhani idzawoneka ndi zokonda zonse.

Ntchito zowerengera

Excel kwenikweni ndi chowerengera chogwira ntchito chomwe chimakulolani kuwerengera magulu angapo. Izi ndizothandiza makamaka pakuwerengera ndalama. Pulogalamuyi imakupatsani mwayi wochita ntchito zonse zomwe mungaganizire komanso zomwe simungaganize ndi manambala. Choncho, muyenera kumvetsetsa momwe ntchito zosiyanasiyana ndi zilembo zomwe zingalembedwe ku selo zimagwirira ntchito.

Choyamba, muyenera kumvetsetsa zolemba zomwe zikuwonetsa ntchito ya masamu:

1. + - Zowonjezera.
2. - - kuchotsa.
3. * - kuchulukitsa.
4. / - kugawanika.
5. ^ - kutanthauzira.
6. % ndi peresenti. 

Yambani kuyika fomula mu selo yokhala ndi chizindikiro chofanana. Mwachitsanzo, 

= 7 + 6

Mukasindikiza batani la "ENTER", deta imawerengedwa yokha ndipo zotsatira zake zimawonetsedwa mu cell. Ngati chifukwa cha mawerengedwe akupezeka kuti pali chiwerengero chachikulu cha manambala pambuyo pa decimal, ndiye kuti mukhoza kuchepetsa kuya pang'ono pogwiritsa ntchito batani lapadera pa tabu "Home" mu gawo la "Nambala".

Kugwiritsa ntchito Fomula mu Excel

Ngati kuli kofunikira kujambula malire omaliza, ndiye kuti kuwonjezera kokha sikukwanira. Kupatula apo, imakhala ndi kuchuluka kwakukulu kwa data. Pachifukwa ichi, matekinoloje apangidwa kuti azitha kupanga tebulo ndikungodina pang'ono.

Kuti timveke bwino, tiyeni tipange tebulo losavuta lokhala ndi data, pomwe muyenera kuwerengera zikhalidwe zingapo nthawi imodzi.

Kuti mupeze zotsatira zomaliza, ingofotokozani mwachidule zachinthu chilichonse m'milungu iwiri yoyambirira. Izi n'zosavuta chifukwa mukhoza pamanja kulowa pang'ono deta. Koma bwanji, komanso manja kulandira ndalama? Zoyenera kuchita kuti zidziwitso zomwe zilipo zikhazikitsidwe mwadongosolo?

Ngati mugwiritsa ntchito fomula mu cell, mutha kuwerengera zovuta kwambiri, komanso kukonza chikalata chanu kuti chichite chilichonse chomwe mukufuna.

Kuphatikiza apo, chilinganizocho chikhoza kusankhidwa mwachindunji kuchokera pamenyu, yomwe imatchedwa ndikukanikiza batani la fx. Tasankha ntchito ya SUM mu bokosi la zokambirana. Kuti mutsimikizire zomwe zachitika, muyenera kukanikiza batani la "Enter". Musanagwiritse ntchito ntchitoyi, tikulimbikitsidwa kuti muyesetse pang'ono mu sandbox. Ndiko kuti, pangani chikalata choyesera, pomwe mutha kupanga ma formula angapo pang'ono ndikuwona momwe amagwirira ntchito. 

Zolakwika polowetsa fomula mu selo

Chifukwa cholowetsa fomula, zolakwika zingapo zitha kuchitika:

1. ##### - Vutoli limaponyedwa ngati mtengo wochepera ziro ukupezeka polowa tsiku kapena nthawi. Itha kuwonetsedwanso ngati mulibe malo okwanira mu selo kuti mutengere deta yonse. 
2. #N / A - cholakwika ichi chikuwoneka ngati sikungatheke kudziwa deta, komanso ngati dongosolo lolowa mkangano wa ntchito likuphwanyidwa.
3. #KULUMIKIZANA! Pankhaniyi, Excel ikunena kuti gawo lolakwika kapena adilesi ya mzere idatchulidwa. 
4. #ZOCHITA! Cholakwika chikuwonetsedwa ngati ntchito ya masamu idamangidwa molakwika.
5. #NUMBER! Ngati chiwerengerocho ndi chochepa kwambiri kapena chachikulu.
6. #VALUE! Zikuwonetsa kuti mtundu wa data wosagwiritsidwa ntchito ukugwiritsidwa ntchito. Izi zitha kuchitika ngati selo limodzi lomwe limagwiritsidwa ntchito popanga fomulo lili ndi mawu, ndipo linalo liri ndi manambala. Pankhaniyi, mitundu ya data sagwirizana ndipo Excel imayamba kulumbira.
7. #DIV/0! - zosatheka kugawa ndi ziro.
8. #DZINA? - dzina lantchito silingadziwike. Mwachitsanzo, pali cholakwika.

Bakuman

Ma hotkeys amapangitsa moyo kukhala wosavuta, makamaka ngati mukuyenera kubwereza zomwezo nthawi zambiri. Ma hotkey otchuka kwambiri ndi awa:

1. CTRL + muvi pa kiyibodi - sankhani maselo onse omwe ali mumzere wolingana kapena mzere.
2. CTRL + SHIFT + "+" - ikani nthawi yomwe ili pa koloko pakali pano.
3. CTRL +; - ikani tsiku lomwe lili ndi ntchito yosefera yokhazikika malinga ndi malamulo a Excel.
4. CTRL + A - sankhani ma cell onse.

Mawonekedwe a cell

Mapangidwe a cell osankhidwa bwino amakulolani kuti mukhale owoneka bwino, komanso osiyanasiyana - osavuta kuwerenga. Pali zosankha zingapo zama cell zomwe mungathe kusintha.

Malire

Kusiyanasiyana kwa mawonekedwe a spreadsheet kumaphatikizaponso zoikamo malire. Kuti muchite izi, dinani ma cell omwe mukufuna ndikutsegula tabu ya "Home", pomwe mumadina muvi womwe uli kumanja kwa batani la "Border". Pambuyo pake, menyu idzawonekera momwe mungakhazikitsire zofunikira zamalire.

Malire akhoza kukokedwa. Kuti muchite izi, muyenera kupeza chinthucho "Jambulani Malire", chomwe chili patsamba lino.

Lembani mtundu

Choyamba muyenera kusankha maselo amene ayenera kudzazidwa ndi mtundu winawake. Pambuyo pake, pa "Home" tabu, pezani muvi womwe uli kumanja kwa chinthu "Dzazani mtundu". Menyu ya pop-up idzawoneka ndi mndandanda wamitundu. Mwachidule kusankha ankafuna mthunzi, ndi selo adzakhala basi kudzazidwa.

Moyo kuthyolako: ngati inu kusuntha pa mitundu yosiyanasiyana, inu mukhoza kuwona mmene maonekedwe a selo adzakhala atadzazidwa ndi mtundu winawake.

Mitundu yama cell

Masitayilo a ma cell ndi njira zopangira zokonzeka zomwe zitha kuwonjezeredwa ndikudina pang'ono. Mutha kupeza menyu mu tabu ya "Home" mugawo la "ma cell styles".