Pamene mukugwira ntchito ku Excel, nthawi zambiri zimatheka kuti mukumane ndi vuto pamene gawo lalikulu la pepalali limagwiritsidwa ntchito powerengera ndipo sanyamula katundu wothandizira kwa wogwiritsa ntchito. Deta yotereyi imangochitika ndipo imasokoneza chidwi. Kuonjezerapo, ngati wogwiritsa ntchito mwachisawawa akuphwanya dongosolo lawo, ndiye kuti izi zingayambitse kuphwanya zonse zomwe akulembazo. Choncho, ndibwino kubisala mizere kapena maselo ena. Kuphatikizanso, mukhoza kubisa deta zomwe sizingatheke panthawi yake kuti zisasokoneze. Tiyeni tione momwe izi zingathere.
Ndondomeko yachinsinsi
Mukhoza kubisa maselo mu Excel m'njira zosiyanasiyana. Tiloleni tidziwe mwatsatanetsatane payekha, kotero kuti wogwiritsa ntchitoyo amvetse m'mene zingakhalire bwino kuti agwiritse ntchito njira yapadera.
Njira 1: Kugawa
Imodzi mwa njira zodziwika kwambiri kubisa zinthu ndi kuzigululira.
- Sankhani mizere ya pepala, yomwe iyenera kugawidwa, kenako ikani. Sikofunika kusankha mzere wonse, koma mukhoza kusindikiza selo limodzi m'mitsinje yonse. Chotsatira, pitani ku tabu "Deta". Mu chipika "Chikhalidwe"yomwe ili pamakina a zipangizo, dinani pa batani "Gulu".
- Fasilo yaying'ono imatsegulira, ndikupereka kusankha zomwe makamaka zikufunika kugawidwa: mizere kapena zipilala. Popeza tikufunikira kugawa ndendende mizere, sitimapanga kusintha komweko, chifukwa chosinthika chimayikidwa pamalo omwe tikusowa. Timakanikiza batani "Chabwino".
- Pambuyo pake gulu limapangidwa. Kuti mubise deta yomwe ili mmenemo, dinani pa chithunzicho ngati mawonekedwe "sungani". Ili kumanzere kwa gulu loyang'anizana.
- Monga mukuonera, mizere yabisika. Kuti muwawonetsenso kachiwiri, muyenera kutsegula chizindikiro kuphatikizapo.
Phunziro: Momwe mungapangire gulu mu Excel
Njira 2: Kugwedeza Magulu
Njira yabwino kwambiri yobisa zinthu za maselo mwina kukukoka malire a mzere.
- Ikani cholozera pazowunikira zowonongeka, kumene manambala a mndandanda amadziwika, pamunsi wa m'munsi mwa mzerewu, zomwe tikufuna kubisala. Pankhaniyi, chithunzithunzi chiyenera kutembenuzidwa kukhala chithunzi chopangidwa ndi mtanda chomwe chili ndi pointer iwiri, yomwe imatsogoleredwa ndi pansi. Kenaka timagwiritsa ntchito batani lamanzere ndikukweza pointer mpaka pamwamba ndi kumapeto kwa mzere pafupi.
- Chingwe chidzabisika.
Njira 3: gulu lobisalira maselo pokoka
Ngati mukufuna kubisa zinthu zingapo nthawi imodzi ndi njira iyi, muyenera kusankhapo poyamba.
- Gwiritsani pansi batani lamanzere ndikusankha pazowonongeka ndi gulu la mizere yomwe tikufuna kubisala.
Ngati mzerewu ndi waukulu, sankhani zinthu izi motere: chofufuzira kumanzere pa nambala ya mzere woyamba wa gululi, kenaka tekani batani Shift ndipo dinani pa chiwerengero chomaliza cha zolingazo.
Mutha kusankha ngakhale mizere yosiyana. Kuti muchite izi, aliyense wa iwo ayenera kudindidwa ndi batani lamanzere pamene akugwira batani Ctrl.
- Timakhala chithunzithunzi pamalire a m'munsi mwalimodzi mwa mizereyi ndikuyinyamulira mpaka malire atseke.
- Izi sizibisa kokha mzere umene mukugwira ntchito, koma mizere yonse yasankhidwa.
Njira 4: menyu yachidule
Njira ziwiri zapitazo, ndithudi, ndizovuta kwambiri komanso zosavuta kuzigwiritsa ntchito, koma sitingathe kupereka selo lathunthu. Nthawi zonse pali malo ang'onoang'ono, omwe mumatha kuwonjezera selo kumbuyo. Mungathe kubisa kwathunthu chingwe pogwiritsa ntchito menyu.
- Sankhani mizere imodzi mwa njira zitatu, zomwe takambirana pamwambapa:
- kokha ndi mbewa;
- pogwiritsa ntchito fungulo Shift;
- pogwiritsa ntchito fungulo Ctrl.
- Dinani pazowonongeka za makonzedwe ndi batani lamanja la mouse. Menyu yamakono ikuwonekera. Malizani chinthucho "Bisani".
- Mizere yosankhidwa idzabisika chifukwa cha zomwe tatchulazi.
Njira 5: Zida Zamatepi
Mukhozanso kubisa mizere pogwiritsira ntchito batani pa chibamba.
- Sankhani maselo omwe ali m'mizere yomwe iyenera kubisika. Mosiyana ndi njira yapitayi, sikofunikira kusankha mzere wonse. Pitani ku tabu "Kunyumba". Dinani pa batani pa toolbar. "Format"yomwe ili mu chipika "Maselo". Mu mndandanda wothamanga, sungani chithunzithunzi pa chinthu chimodzi cha gululo. "Kuwoneka" - "Bisani kapena Kuwonetsa". Mu menyu owonjezera, sankhani chinthu chomwe chikufunika kuti mukwaniritse cholinga - "Bisani mizere".
- Pambuyo pake, mizere yonse yomwe ili ndi maselo osankhidwa mu ndime yoyamba idzabisika.
Njira 6: Kuwonetsa
Pofuna kubisala pa pepala zomwe zili zosayenera posachedwa, kotero kuti zisasokoneze, mukhoza kugwiritsa ntchito fyuluta.
- Sankhani tebulo lonse kapena imodzi mwa maselo pamutu wake. Mu tab "Kunyumba" dinani pazithunzi "Sankhani ndi kusefera"yomwe ili mu zida za zipangizo Kusintha. Mndandanda wa zochitika zimatsegula pamene mumasankha chinthucho "Fyuluta".
Mukhozanso kuchita zinazake. Mutasankha tebulo kapena mutu, pitani ku tabu. "Deta". Kukuwoneka pa batani "Fyuluta". Ipezeka pa tepiyi mu chipika. "Sankhani ndi kusefera".
- Mulimonse njira ziwiri zomwe mumagwiritsa ntchito, chizindikiro chowonetsera chidzawonekera pamutu pa tebulo. Ndi kakang'ono kakang'ono kakuda kakang'ono, kamene kamakwera pansi. Timakani pa chithunzi ichi m'ndandanda yomwe ili ndi chizindikiro chomwe tidzasankhiramo deta.
- Mndandanda wa fyuluta imatsegula. Timasintha makhalidwe omwe ali mu mizere yopangidwira. Kenaka dinani pa batani "Chabwino".
- Zitatha izi, mizere yonse yomwe ili ndi malingaliro omwe tachotsa zizindikirozo zidzabisika mothandizidwa ndi fyuluta.
Phunziro: Sakanizani ndi kusinkhira deta mu Excel
Njira 7: Kubisa Maselo
Tsopano tiyeni tiyankhule za momwe tingabisire maselo ena. Mwachibadwidwe, sangathe kuchotsedwa kwathunthu ngati mizere kapena mizati, popeza izi zidzawononga kapangidwe ka chikalatacho, komabe pali njira, ngati sichidzabisala zokhazokha, ndiye kubisa zomwe zilipo.
- Sankhani maselo amodzi kapena angapo amene ayenera kubisika. Dinani pa chidutswa chosankhidwa ndi batani lamanja la mouse. Mndandanda wamakono umatsegulidwa. Sankhani chinthu mmenemo "Maselo ...".
- Fesitimu yokongoletsa ikuyamba. Tiyenera kupita ku tabu yake "Nambala". Kuwonjezera pa chigawo chokhazikitsa "Maofomu Owerengeka" sankhani malo "Zopanga Zonse". Kumanja kwawindo pazenera Lembani " timayendetsa m'mawu otsatirawa:
;;;Timakanikiza batani "Chabwino" kusunga makonzedwe olowa.
- Monga mukuonera, zitatha izi, deta yonse m'maselo osankhidwa inatheratu. Koma iwo adasowa maso okha, ndipo kwenikweni akupitiriza kukhalapo. Kuti muwatsimikizire izi, yang'anani pa bar lamuzomwe amasonyezera. Ngati mukufunikanso kuwonetsa mawonedwe a deta m'maselo, ndiye kuti mukufunika kusintha mawonekedwe awo kwa omwe kale mudapanga mawindo.
Monga mukuonera, pali njira zingapo zomwe mungabise mizere ku Excel. Ndipo ambiri amagwiritsira ntchito matekinoloje osiyana siyana: kusefera, kuguluzana, kusuntha malire a maselo. Choncho, wogwiritsa ntchito ali ndi zida zambiri zothetsera vutoli. Angagwiritse ntchito njira yomwe akuona kuti ikuyenerera pazochitika zinazake, komanso zosavuta komanso zosavuta. Kuphatikiza apo, mothandizidwa ndi kukonza zosavuta zimatha kubisa zomwe zili m'maselo ena.
