Mizati yobisika mu Excel. Njira 3 Zowonetsera Mizati Yobisika mu Excel

Nthawi zambiri mukamagwiritsa ntchito mkonzi wa spreadsheet, nthawi zina pamakhala kofunika kuti magawo ena a tebulo abisike. Chifukwa cha zochita izi, mizati yofunikira imabisika, ndipo sakuwonekeranso mu chikalata cha spreadsheet. Komabe, palinso ntchito yosiyana - kukulitsa mizati. M'nkhaniyi, tiwona mwatsatanetsatane njira zingapo zogwiritsira ntchito njirayi mumkonzi wa spreadsheet.

Kuwonetsa Mizati Yobisika mu Table Editor

Kubisa mizati ndi chida chothandiza chomwe chimakulolani kuti muyike zinthu moyenera pamalo ogwirira ntchito a chikalata cha spreadsheet. Izi nthawi zambiri zimagwiritsidwa ntchito pazifukwa zotsatirazi:

1. Wogwiritsa akufuna kufananitsa mizati iwiri yolekanitsidwa ndi mizati ina. Mwachitsanzo, muyenera kufananiza ndime A ndi gawo Z. Pankhaniyi, zidzakhala zosavuta kuchita ndondomeko kubisa kusokoneza mizati.
2. Wogwiritsa ntchito akufuna kubisa mizati yowonjezera yowonjezera ndi mawerengedwe ndi ndondomeko zomwe zimamulepheretsa kugwira ntchito mosavuta ndi chidziwitso chomwe chili mu malo ogwirira ntchito a chikalata cha spreadsheet.
3. Wogwiritsa ntchito akufuna kubisa magawo ena a chikalata cha spreadsheet kuti asasokoneze kuwonera zambiri za tabular kwa ogwiritsa ntchito ena omwe angagwire nawo chikalatachi.

Tsopano tiyeni tikambirane momwe tingagwiritsire ntchito kutsegulidwa kwa mizati yobisika mu Excel spreadsheet editor.

Poyamba, muyenera kuwonetsetsa kuti pali mizati yobisika mu mbale, ndiyeno kudziwa malo awo. Njirayi imayendetsedwa mosavuta pogwiritsa ntchito bar yolumikizira yopingasa ya spreadsheet editor. Ndikoyenera kuyang'ana mosamala mndandanda wa mayina, ngati akuphwanyidwa, ndiye pamalo ano pali chigawo chobisika kapena mizati ingapo.

Titapeza kuti pali zigawo zobisika mu chikalata cha spreadsheet, m'pofunika kuchita ndondomeko kuti awulule. Njirayi ingagwiritsidwe ntchito m'njira zingapo.

Njira yoyamba: kusuntha malire a cell

Malangizo atsatanetsatane osunthira malire a cell mu chikalata cha spreadsheet amawoneka motere:

1. Sunthani cholozera kumalire ndizambiri. Cholozeracho chitenga mawonekedwe a mzere wawung'ono wakuda wokhala ndi mivi yolozera mbali zosiyana. Pogwira batani lakumanzere la mbewa, timakoka malire m'njira yofunikira.

2. Njira yosavutayi imakulolani kuti mupangitse gawo lolembedwa "C" kuwonekera. Okonzeka!

Zofunika! Njirayi ndiyosavuta kugwiritsa ntchito, koma ngati pali mizati yambiri yobisika mu chikalata cha spreadsheet, ndiye kuti njirayi iyenera kuchitidwa kangapo, zomwe sizothandiza kwambiri, ndiye kuti ndizoyenera kugwiritsa ntchito. njira zomwe tidzakambirana pambuyo pake.

Njira yachiwiri: kugwiritsa ntchito menyu yapadera

Njirayi ndi yofala kwambiri pakati pa ogwiritsa ntchito spreadsheet editor. Izi, monga zomwe zili pamwambapa, zimakulolani kuti mugwiritse ntchito kuwululidwa kwa mizati yobisika. Malangizo atsatanetsatane ogwiritsira ntchito menyu apadera mu chikalata cha spreadsheet amawoneka motere:

1. Pogwira batani lakumanzere la mbewa, timasankha magawo osiyanasiyana pagawo logwirizanitsa. Muyenera kusankha ma cell omwe mizati yobisika ili. Mutha kusankha malo onse ogwirira ntchito pogwiritsa ntchito batani la Ctrl + A.

2. Dinani kumanja kulikonse munjira yomwe mwasankha. Mndandanda waukulu udawonekera pazenera, zomwe zimakupatsani mwayi wosintha magawo osiyanasiyana pagawo losankhidwa. Timapeza chinthucho ndi dzina la "Show", ndikudina pacho ndi batani lakumanzere.

3. Zotsatira zake, mizati yonse yobisika mumtundu wosankhidwa idzawonetsedwa mu chikalata cha spreadsheet. Okonzeka!

Njira yachitatu: kugwiritsa ntchito zinthu pa riboni yapadera

Njirayi imaphatikizapo kugwiritsa ntchito riboni yapadera yomwe zida zosinthira spreadsheet zilipo. Malangizo atsatanetsatane ogwiritsira ntchito zida pa riboni yapadera ya mkonzi wa spreadsheet amawoneka motere:

1. Pogwira batani lakumanzere la mbewa, timasankha magawo osiyanasiyana pagawo logwirizanitsa. Muyenera kusankha ma cell omwe mizati yobisika ili.
2. Mutha kusankha malo onse ogwirira ntchito pogwiritsa ntchito kuphatikiza Ctrl + A.
3. Timapita ku gawo la "Home", pezani "Maselo" azinthu pamenepo, kenako dinani batani lakumanzere pa "Format". Mndandanda wawung'ono watsegulidwa, momwe muyenera kusankha chinthu "Bisani kapena kuwonetsa", chomwe chili mu chipika cha "Kuwoneka". Pamndandanda wotsatira, sankhani chinthucho "Show columns" ndi batani lakumanzere.

4. Okonzeka! Mizati yobisika ikuwonetsedwanso mu malo ogwirira ntchito a spreadsheet.

Mapeto ndi ziganizo zokhudzana ndi kuwonetsera kwa magawo obisika mumkonzi wa spreadsheet

Kubisa mizati ndi chinthu chothandiza chomwe chimakulolani kuti mubise kwakanthawi chidziwitso chapadera kuchokera pamalo ogwirira ntchito a spreadsheet. Njirayi imakulolani kuti mupange chikalata cha spreadsheet kukhala chosavuta komanso chosavuta kugwiritsa ntchito, makamaka ngati chikalatacho chili ndi zambiri zambiri. Komabe, si aliyense amene akudziwa momwe angagwiritsire ntchito njira yowulula mizati yobisika mu chikalata cha spreadsheet. Tapenda mwatsatanetsatane njira zitatu zogwiritsira ntchito mawonetsedwe a zinthu zobisika za malo ogwirira ntchito a chikalata cha spreadsheet, kuti wogwiritsa ntchito aliyense azisankha yekha njira yabwino kwambiri.