Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu "smart table"

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:

  1. 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 "+".
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
1
  1. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
2
  1. Okonzeka! Mzere watsopano wawonjezedwa patebulo. Chonde dziwani kuti powonjezera mzere watsopano, pamafunika masanjidwe onse kuchokera pamzere womwe uli pamwambapa.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
3

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 mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
4

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:

  1. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
5
  1. Timagwira chizindikiro ichi chophatikiza ndi batani lakumanzere ndikuchikokera pansi, ndi chiwerengero cha mizere yomwe tikufuna kuika. Pomaliza, tsegulani LMB.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
6
  1. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
7
  1. Okonzeka! Tawonetsetsa kuti mizere yomwe yangowonjezedwa kumene yachotsedwa pazidziwitso zosafunikira. Tsopano tikhoza kuwonjezera deta yofunikira kumeneko tokha.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
8

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:

  1. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
9
  1. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
10
  1. Okonzeka! Takhazikitsa mbale ya "smart" ndipo tsopano titha kuchita nayonso zina.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
11

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:

  1. Dinani kumanja pa selo iliyonse. Mumndandanda wapadera womwe umatsegulidwa, pezani chinthu cha "Insert" ndikutsegula. Pamndandanda womwe umawonekera, dinani "Table Rows Pamwamba".
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
12
  1. 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 mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
13

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:

  1. Kokani kumanja kwa mbale ndi batani lakumanzere. Pambuyo pakuchita izi, mbale idzawonjezeka yokha. Idzawonjezera mizere yambiri momwe wosuta amafunira.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
14
  1. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
15
  1. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
16
  1. Njira yachitatu ndikusunthira kumunsi kumanja kwa cell ya "smart" mbale ndikudina batani la "Tab" lomwe lili pa kiyibodi.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
17
  1. Pambuyo pa kukhazikitsidwa kwa izi, mzere wolowetsedwa udzawonjezedwa patebulo la "smart" ndikusungidwa koyambirira.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
18

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:

  1. 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.
  2. Kusankha mizere yonse yofunikira kumapangidwa bwino. Tsopano muyenera kudina kumanja kulikonse komwe mwasankha.
  3. 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.
  4. Okonzeka! Takhazikitsa njira yowonjezerera mizere ingapo yopanda kanthu ku mbale yoyambirira.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
19

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:

Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
20

Malangizo atsatanetsatane oyika mizere yosiyana ya mtundu wopanda kanthu amawoneka motere:

  1. Timasunthira ku bokosi la dialog lotchedwa "Ikani Mizere Yopanda Chopanda Mwachisawawa".
  2. M'munda wa "Column Number ndi chiwerengero cha mizere", tchulani mtengo womwe tikufuna.
  3. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
21
  1. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
22

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:

Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
23

Njira yoyamba kuchotsa mizere yopanda kanthu ikuwoneka motere:

  1. 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".
  2. 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.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
24

Njira yachiwiri yochotsa mizere yopanda kanthu ikuwoneka motere:

  1. Kugwiritsa ntchito fyuluta kumatanthawuza. Timasankha "kapu" ya mbale.
  2. Timapita ku gawo la "Data", ndiyeno dinani kumanzere "Zosefera", zomwe zili mu "Sort and Filter" block block.
  3. Tsopano, kumanja kwa dzina la ndime iliyonse, muvi wawung'ono ukuwonetsedwa, ukulozera pansi. Dinani pa izo kuti mutsegule zenera la fyuluta.
  4. Chotsani chizindikiro pafupi ndi "(Zopanda)".
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
25
  1. Okonzeka! Njirayi idapangitsa kuti zitheke kuchotsa selo iliyonse yopanda kanthu pamzere.

Njira yachitatu yochotsa mizere yopanda kanthu ikuwoneka motere:

  1. Zikutanthauza kugwiritsa ntchito kusankha gulu la maselo. Poyamba, timasankha tebulo lonse.
  2. Pitani ku "Sinthani" ndikudina "Pezani ndikusankha". Pamndandanda womwe umatsegulidwa, dinani "Sankhani gulu la ma cell".
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
26
  1. Pawindo lomwe likuwonekera pansi pa dzina lakuti "Sankhani gulu la maselo" ikani fad pafupi ndi mawu akuti "maselo opanda kanthu" ndi batani lakumanzere.
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
27
  1. Mkonzi wa spreadsheet adakhazikitsa zolemba zopanda kanthu. Pazenera lalikulu la pulogalamuyi, dinani "Maselo" ndi batani lakumanzere la mbewa, kenako sankhani chinthu "Chotsani".
Momwe mungawonjezere mzere watsopano mu Excel. Mkati ndi kumapeto kwa tebulo, mu tebulo lanzeru
28
  1. 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.

Siyani Mumakonda