Zamkatimu
- Momwe mungayikitsire mzere watsopano
- Momwe mungayikitsire mzere watsopano kumapeto kwa tebulo
- Momwe mungapangire tebulo lanzeru
- Kuwonjezera Mizere Yopanda Chopanda kanthu ku Excel Spreadsheet
- Momwe mungayikitsire / kuwonjezera nambala yoperekedwa yopanda kanthu/mizere yatsopano pamalo enaake?
- Kuyika manambala osiyanasiyana a mizere yopanda kanthu
- Kuchotsa mizere yopanda kanthu
- Kutsiliza
Pakusintha kosiyanasiyana ndi chidziwitso cha tabular, nthawi zambiri zimakhala zofunikira kuwonjezera mizere yatsopano. Njira yowonjezera ndiyosavuta komanso yachangu, koma ogwiritsa ntchito ambiri amavutika panthawiyi. M'nkhaniyi, tiona njira zonse zomwe zimakulolani kuti muwonjezere mzere watsopano pa mbale, komanso kupeza mbali zonse za ntchitoyi.
Momwe mungayikitsire mzere watsopano
Njira yowonjezerera mizere yatsopano ku mbale yoyambirira ndiyofanana ndi mitundu yonse ya sipredishiti. Inde, pali kusiyana kochepa, koma sikofunikira. Malangizo atsatanetsatane amawoneka motere:
- Poyamba, timapeza kapena kupanga piritsi. Timasankha selo la mzere pamwamba pomwe tikukonzekera kuyika mzere watsopano. Dinani batani lakumanja la mbewa pa cell yomwe mwasankha. Menyu yaying'ono yawonekera, momwe muyenera kupeza chinthu cha "Insert ..." ndikudina ndi batani lakumanzere. Njira ina ndiyo kugwiritsa ntchito makiyi "Ctrl" ndi "+".
- Pulogalamuyo idabweretsa zenera lotchedwa "Ikani". Pazenera ili, mutha kugwiritsa ntchito kuwonjezera mzere, mzere kapena selo. Timayika fad pafupi ndi mawu akuti "Mzere". Dinani pa chinthu "Chabwino" kuti musunge zosintha zanu.
- Okonzeka! Mzere watsopano wawonjezedwa patebulo. Chonde dziwani kuti powonjezera mzere watsopano, pamafunika masanjidwe onse kuchokera pamzere womwe uli pamwambapa.
Zofunika! Pali njira yowonjezera yomwe imakulolani kuti muwonjezere mzere watsopano. Timakanikiza RMB pa nambala ya serial ya mzere, ndiyeno mumenyu yomwe imatsegulidwa, dinani "Ikani".
Momwe mungayikitsire mzere watsopano kumapeto kwa tebulo
Nthawi zambiri zimachitika kuti wogwiritsa ntchito amayenera kukhazikitsa kuwonjezera mzere kumapeto kwa data ya tabular. Malangizo atsatanetsatane amawoneka motere:
- Poyamba, timasankha mzere wonse wa mbaleyo mwa kukanikiza batani lakumanzere la mbewa pa nambala ya serial. Sunthani cholozera pansi kumanja kwa mzere. Cholozeracho chiyenera kuoneka ngati chizindikiro chaching'ono chakuda chophatikiza.
- Timagwira chizindikiro ichi chophatikiza ndi batani lakumanzere ndikuchikokera pansi, ndi chiwerengero cha mizere yomwe tikufuna kuika. Pomaliza, tsegulani LMB.
- Tikuwona kuti mizere yonse yowonjezeredwa idadzazidwa ndi chidziwitso kuchokera ku selo yosankhidwa. Kusanjikiza koyambirira kwatsalanso. Kuti muchotse ma cell odzazidwa, muyenera kuchita njira yosankha mizere yatsopano, kenako dinani "Chotsani" pa kiyibodi. Njira ina ndikudina kumanja pazigawo zomwe zasankhidwa, kenako sankhani Chotsani Zamkatimu mumenyu yapadera yomwe imatsegulidwa.
- Okonzeka! Tawonetsetsa kuti mizere yomwe yangowonjezedwa kumene yachotsedwa pazidziwitso zosafunikira. Tsopano tikhoza kuwonjezera deta yofunikira kumeneko tokha.
Zofunika! Njirayi ndi yoyenera panthawi yomwe mzere wapansi sunagwiritsidwe ntchito mu "Total", komanso sikuwonjezera mizere pamwambapa.
Momwe mungapangire tebulo lanzeru
Matebulo a "Smart" amagwiritsidwa ntchito kuti wogwiritsa ntchito azigwira bwino ntchito ndi zidziwitso zambiri. Mbale yamtunduwu imakulitsidwa mosavuta, zomwe zikutanthauza kuti mizere yatsopano imatha kuyikidwa nthawi iliyonse yabwino. Malangizo atsatanetsatane amawoneka motere:
- Timasankha malo ogwirira ntchito omwe tikukonzekera kuwasintha kukhala mbale "yanzeru". Timapita ku gawo la "Home", kenako timapeza chinthu chotchedwa "Format as a table." Timawulula mndandanda wautali wa mbale zomwe akufunidwa. Sankhani masitayilo omwe mumakonda kwambiri ndikudina ndi batani lakumanzere.
- Zenera la Format Table likuwonekera pazenera. Apa, adilesi ya piritsi yomwe idaperekedwa idalowetsedwa. Ngati zogwirizanitsa sizikugwirizana ndi inu, mukhoza kuzisintha mu bokosi la zokambirana. Dinani "Chabwino" kutsimikizira zoikamo zonse anapanga. Ndikoyenera kudziwa kuti pafupi ndi mawu akuti "Table with headers" iyenera kufufuzidwa.
- Okonzeka! Takhazikitsa mbale ya "smart" ndipo tsopano titha kuchita nayonso zina.
Momwe mungayikitsire mzere watsopano mu tebulo lanzeru
Kuti mugwiritse ntchito njira yowonjezerera mzere watsopano ku mbale ya "smart", mungagwiritse ntchito njira zomwe zili pamwambazi. Malangizo atsatanetsatane amawoneka motere:
- Dinani kumanja pa selo iliyonse. Mumndandanda wapadera womwe umatsegulidwa, pezani chinthu cha "Insert" ndikutsegula. Pamndandanda womwe umawonekera, dinani "Table Rows Pamwamba".
- Njira ina yowonjezerera mzere watsopano ndikugwiritsa ntchito makiyi apadera otentha "Ctrl" ndi "+". Kugwiritsa ntchito ma hotkeys kumachepetsa kwambiri nthawi yomwe imagwiritsidwa ntchito powonjezera mizere yatsopano pa mbale.
Momwe mungayikitsire mzere watsopano kumapeto kwa tebulo lanzeru
Pali njira zitatu zomwe zimakulolani kuti muwonjezere mzere watsopano kumapeto kwa mbale ya "smart". Malangizo atsatanetsatane owonjezera mzere watsopano kumapeto kwa mbale ya "smart" amawoneka motere:
- Kokani kumanja kwa mbale ndi batani lakumanzere. Pambuyo pakuchita izi, mbale idzawonjezeka yokha. Idzawonjezera mizere yambiri momwe wosuta amafunira.
- Apa, ma cell owonjezera sangadzazidwe ndi chidziwitso choyambirira. Mafomu okhawo adzakhala m'malo awo. Choncho, palibe chifukwa chochotseratu zomwe zili m'maselo, popeza zilibe kanthu.
- Njira ina ndiyo kulemba deta yatsopano pamzere womwe uli pansi pa mbale yoyambirira ya "smart". Ngati mutagwiritsa ntchito njirayi, ndiye kuti mzere watsopanowo udzasanduka chinthu cha "smart" mbale.
- Njira yachitatu ndikusunthira kumunsi kumanja kwa cell ya "smart" mbale ndikudina batani la "Tab" lomwe lili pa kiyibodi.
- Pambuyo pa kukhazikitsidwa kwa izi, mzere wolowetsedwa udzawonjezedwa patebulo la "smart" ndikusungidwa koyambirira.
Kuwonjezera Mizere Yopanda Chopanda kanthu ku Excel Spreadsheet
Kuti mugwiritse ntchito njira yowonjezerera mizere iwiri kapena yochulukirapo ku data ya tabular, muyenera kuchita njira zingapo zosavuta. Malangizo atsatanetsatane owonjezera mizere yopanda kanthu amawoneka motere:
- Pogwiritsa ntchito batani lakumanzere, timasankha mzere umene tikukonzekera kuwonjezera zatsopano, ndiyeno, popanda kutulutsa LMB, sankhani chiwerengero cha mizere yomwe tikufuna kuwonjezera pa chikalata cha spreadsheet.
- Kusankha mizere yonse yofunikira kumapangidwa bwino. Tsopano muyenera kudina kumanja kulikonse komwe mwasankha.
- Mndandanda wawung'ono wapadera watsegulidwa, momwe muyenera kupeza chinthu chomwe chili ndi dzina "Ikani" ndikudina ndi batani lakumanzere. Njira ina ndiyo kugwiritsa ntchito zida zomwe zili pa riboni yapadera yomwe ili pamwamba pa mawonekedwe a spreadsheet editor.
- Okonzeka! Takhazikitsa njira yowonjezerera mizere ingapo yopanda kanthu ku mbale yoyambirira.
Momwe mungayikitsire / kuwonjezera nambala yoperekedwa yopanda kanthu/mizere yatsopano pamalo enaake?
Izi zitha kuchitika pogwiritsa ntchito zida za VBA. Mutha kudziwa zambiri za njirayi powonera kanema wotsatira:
Kuchokera pavidiyo yomwe ili pamwambayi, muphunzira tsatanetsatane wa kugwiritsa ntchito zowonjezera, kugwiritsa ntchito macros ndi zina zothandiza zomwe zilipo mu Excel spreadsheet editor.
Kuyika manambala osiyanasiyana a mizere yopanda kanthu
Mwachitsanzo, tili ndi tebulo ili ndi chidziwitso chofunikira:
Malangizo atsatanetsatane oyika mizere yosiyana ya mtundu wopanda kanthu amawoneka motere:
- Timasunthira ku bokosi la dialog lotchedwa "Ikani Mizere Yopanda Chopanda Mwachisawawa".
- M'munda wa "Column Number ndi chiwerengero cha mizere", tchulani mtengo womwe tikufuna.
- Ndizofunikira kudziwa kuti ngati tiyang'ana bokosi pafupi ndi "Nambala yosiyana ya mizere yopanda kanthu kuti muyike", ndiye kuti mzere wokhala ndi mizere yoyikamo usintha kukhala nambala ya ordinal ya gawo lomwe deta yamtundu wa manambala ili. zafotokozedwa.
- Pamapeto pake, ntchitoyi idzadziyimira pawokha nambala ya mzere yomwe ikugwirizana ndi zomwe ogwiritsa ntchito anena. Idzalowetsa ndendende mizere yopanda kanthu monga momwe yafotokozedwera pamzere womwe waperekedwa pagawo lotchulidwa.
Kuchotsa mizere yopanda kanthu
Pali njira zingapo zochotsera mizere yopanda kanthu. Tiyeni tione nkhaniyi mwatsatanetsatane, poganizira zitsanzo zenizeni. Tiyerekeze kuti tili ndi tebulo lotsatirali lomwe likuwonetsa magiredi a ophunzira m'maphunziro osiyanasiyana:
Njira yoyamba kuchotsa mizere yopanda kanthu ikuwoneka motere:
- Kugwiritsiridwa ntchito kwa chidziwitso kumatsimikiziridwa. Timasankha mbale yonse. Timapita ku gawo la "Data" ndipo mu "Sort and Filter" block block, dinani "Sort". Njira ina ndikudina kumanja pagawo lomwe mwasankha ndikudina chinthucho "kuchokera pakuchepera mpaka pamlingo waukulu".
- Chifukwa cha zochita zomwe zatengedwa, mizere yopanda kanthu yomwe tikufunikira yasunthira pansi kwambiri pa mbale yoyambirira. Tsopano titha kuchotsa mizere yopanda kanthu iyi mosavuta pogwiritsa ntchito kiyi ya "Chotsani", titasankha kale pamalo ogwirira ntchito pogwiritsa ntchito LMB.
Njira yachiwiri yochotsa mizere yopanda kanthu ikuwoneka motere:
- Kugwiritsa ntchito fyuluta kumatanthawuza. Timasankha "kapu" ya mbale.
- Timapita ku gawo la "Data", ndiyeno dinani kumanzere "Zosefera", zomwe zili mu "Sort and Filter" block block.
- Tsopano, kumanja kwa dzina la ndime iliyonse, muvi wawung'ono ukuwonetsedwa, ukulozera pansi. Dinani pa izo kuti mutsegule zenera la fyuluta.
- Chotsani chizindikiro pafupi ndi "(Zopanda)".
- Okonzeka! Njirayi idapangitsa kuti zitheke kuchotsa selo iliyonse yopanda kanthu pamzere.
Njira yachitatu yochotsa mizere yopanda kanthu ikuwoneka motere:
- Zikutanthauza kugwiritsa ntchito kusankha gulu la maselo. Poyamba, timasankha tebulo lonse.
- Pitani ku "Sinthani" ndikudina "Pezani ndikusankha". Pamndandanda womwe umatsegulidwa, dinani "Sankhani gulu la ma cell".
- Pawindo lomwe likuwonekera pansi pa dzina lakuti "Sankhani gulu la maselo" ikani fad pafupi ndi mawu akuti "maselo opanda kanthu" ndi batani lakumanzere.
- Mkonzi wa spreadsheet adakhazikitsa zolemba zopanda kanthu. Pazenera lalikulu la pulogalamuyi, dinani "Maselo" ndi batani lakumanzere la mbewa, kenako sankhani chinthu "Chotsani".
- Okonzeka! Njirayi idapangitsa kuti zitheke kuchotsa selo iliyonse yopanda kanthu pamzere.
Mizere ikachotsedwa, ma cell ena amasunthira mmwamba. Izi zingayambitse chisokonezo, makamaka pochita ndi zambiri zambiri. Choncho, njirayi si yoyenera kwa matebulo omwe ali ndi mizere yambiri ndi mizere.
Malangizo! Kugwiritsa ntchito kuphatikiza kiyi "CTRL" + "-", komwe kumakupatsani mwayi wochotsa mzere wosankhidwa, kufulumizitsa kwambiri ntchito yogwira ntchito ndi chidziwitso mu Excel spreadsheet editor. Mutha kusankha mzere womwe mukufuna pogwiritsa ntchito kiyi yotentha "SHIFT + SPACE".
Kutsiliza
Kuchokera m'nkhaniyi, taphunzira kuti pa tebulo mkonzi pali njira zambiri zomwe zimakulolani kuti muwonjezere mzere watsopano ku deta ya tebulo. Njira yabwino ndiyo kugwiritsa ntchito mbale "yanzeru", chifukwa imathandizira ogwiritsa ntchito zovuta kuti apitirize kugwira ntchito ndi chidziwitso. Komabe, wogwiritsa ntchito aliyense adzatha kusankha yekha njira yabwino kwambiri yomwe imakulolani kuti muwonjezere mzere watsopano ku chikalata cha spreadsheet.