Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo

Kuwonjezera mizati yatsopano patebulo ndi luso lofunikira lomwe wogwiritsa ntchito aliyense wa Excel spreadsheet ayenera kukhala nalo. Popanda luso limeneli, n'zosatheka kugwira ntchito bwino ndi deta ya tabular. M'nkhaniyi, tiwona njira zambiri zothandiza zopangira mizati yowonjezera papepala lachikalata.

Kuwonjezera gawo latsopano

Pali njira zingapo zowonjezerera ndime yatsopano patsamba lantchito. Iliyonse mwa njira zomwe zili pansipa ndizosavuta kuchita, kotero kuti ngakhale wongoyamba kumene amatha kuzigwira. Tiyeni tione njira iliyonse mwatsatanetsatane.

Njira 1. Kulowetsa ndime kudzera mu kapamwamba kogwirizanitsa

Njirayi ndi yosavuta komanso yosavuta kugwiritsa ntchito. Imagwiritsa ntchito kuwonjezera mzere watsopano kapena mzere wowonjezera ku data ya tabular. Njirayi ikuwoneka motere:

  1. Timapeza gulu logwirizanitsa la mtundu wopingasa ndikudina pa dzina la gawo lomwe tikufuna kuwonjezera gawo latsopano. Mukamaliza kuchita izi, gawo lonse lidzawonetsedwa patsamba lantchito.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
1
  1. Timadina RMB pagawo lililonse lachidutswa chomwe mwasankha. Menyu yaying'ono yankhani idawonetsedwa pazenera. Timapeza chinthu chotchedwa "Insert" ndikudina pacho ndi batani lakumanzere.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
2
  1. Okonzeka! Tinakhazikitsanso gawo latsopano lopanda kanthu kumanzere kwa gawo lomwe linasankhidwa poyambirira.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
3

Njira 2: Kuwonjeza Chigawo Pogwiritsa Ntchito Menyu Yankhani Yama cell

Njira iyi, monga yapitayi, imaphatikizapo kugwiritsa ntchito mndandanda wazinthu, koma osati ndime yonse yomwe yasankhidwa apa, koma selo imodzi yokha. Njirayi ikuwoneka motere:

  1. Sankhani selo kumanzere komwe tikukonzekera kupanga ndime yowonjezera. Kusankhidwa kumapangidwa pogwiritsa ntchito batani lakumanzere kapena mivi pa kiyibodi.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
4
  1. Dinani kumanja pa selo losankhidwa. Menyu yodziwika bwino idawonetsedwa pazenera. Timapeza chinthu "Ikani ..." ndikudina pacho ndi batani lakumanzere.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
5
  1. Iwindo laling'ono lidawonekera pachiwonetsero, momwe muyenera kufotokozera zomwe zidzawonjezedwe pa mbale. Pali mitundu itatu ya zinthu: selo, mzere ndi mzere. Timayika chizindikiro pafupi ndi mawu akuti "Column". Pambuyo pochita zosintha zonse, dinani batani "Chabwino", lomwe lili pansi pawindo.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
6
  1. Okonzeka! Tinakhazikitsanso gawo latsopano lopanda kanthu kumanzere kwa gawo lomwe linasankhidwa poyambirira.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
7

Njira 3: Matani pogwiritsa ntchito zida zomwe zili pa riboni

Pa riboni, yomwe ili pamwamba pa mawonekedwe a Excel spreadsheet, pali chinthu chapadera chomwe chimakulolani kuti muyike ndime yatsopano patebulo. Maphunziro a tsatane-tsatane akuwoneka motere:

  1. Sankhani selo kumanzere komwe tikukonzekera kupanga ndime yowonjezera. Kusankhidwa kumapangidwa pogwiritsa ntchito batani lakumanzere kapena mivi pa kiyibodi.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
8
  1. Timasunthira ku gawo la "Home", lomwe lili pamwamba pa mawonekedwe a spreadsheet. Wonjezerani mndandanda wa chinthu cha "Insert". Pamndandanda womwe umatsegulidwa, pezani batani "Ikani mizati pa pepala" ndikudina pa izo.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
9
  1. Okonzeka! Tinakhazikitsa kuwonjezera gawo latsopano lopanda kanthu kumanzere kwa gawo lomwe linasankhidwa poyambirira
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
10

Njira 4. Makiyi otentha oyika gawo latsopano

Kugwiritsa ntchito ma hotkey ndi njira ina yomwe imadziwika kwambiri pakati pa ogwiritsa ntchito ma spreadsheet a Excel. Pali mitundu iwiri ya njira iyi. Njira yothetsera vutoli ndi monga:

  1. Dinani pa dzina la mzati mu gulu logwirizanitsa.

Kumbukirani! Mzere wowonjezera nthawi zonse umawonjezeredwa kumanzere kwa gawo losankhidwa.

  1. Dinani kuphatikiza kiyi pa kiyibodi "Ctrl" + "+". Pambuyo pokonza zonse, gawo latsopano lidzawonekera kumanzere kwa gawo losankhidwa.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
11

Kukonzekera kwa njira yachiwiri ndi iyi:

  1. Dinani pa selo ndi batani lakumanzere la mbewa.
  2. Dinani kuphatikiza kiyi pa kiyibodi "Ctrl" + "+".
  3. Zenera lodziwika bwino lotchedwa "Add Cells" linawonetsedwa pazenera. Timayika fad pafupi ndi mawu akuti "Column". Pambuyo pochita zosintha zonse, dinani batani "Chabwino", lomwe lili pansi pawindo.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
12
  1. Okonzeka! Mukamaliza kuchita zonse kumanzere kwa gawo lomwe mwasankha, gawo latsopano lidzawonekera.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
13

Kuyika mizati iwiri kapena kuposerapo

Nthawi zina wogwiritsa ntchito spreadsheet afunika kuyika zigawo zingapo nthawi imodzi. Kugwira ntchito kwa pulogalamuyi kumapangitsa kuti izi zikhale zosavuta. Njirayi ikuwoneka motere:

  1. Poyamba, timasankha ma cell mopingasa. Muyenera kusankha ma cell ochulukirapo monga pali zigawo zina zomwe mukufuna kuwonjezera.

Tcherani khutu! Ndipo zilibe kanthu komwe kusankha kumapangidwira. Mutha kusankha ma cell onse patebulo lokha komanso pagulu logwirizanitsa.

Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
14
  1. Pogwiritsa ntchito maupangiri omwe tawafotokozera pamwambapa, timapanga njira yowonjezerera mizati yowonjezera. Muchitsanzo chathu chapadera, tidatsegula menyu yankhani ndi batani lakumanja la mbewa ndikusankha chinthu "Ikani".
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
15
  1. Okonzeka! Tinakhazikitsa zowonjezera zowonjezera zopanda kanthu kumanzere kwa mizati yomwe idasankhidwa poyambirira.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
16

Ikani mzati kumapeto kwa tebulo

Njira zonse zomwe zili pamwambazi ndizoyenera pazochitikazo pamene kuli kofunikira kuwonjezera mizati imodzi kapena zingapo zowonjezera pakati kapena chiyambi cha mbale yomwe ili pa tsamba lachikalatacho. Zoonadi, pogwiritsa ntchito njirazi, mukhoza kuwonjezera mizati yatsopano kumapeto kwa tebulo, koma muyenera kuthera nthawi yambiri mukuikonza.

Kuti mugwiritse ntchito kuyika mizati yatsopano patebulo popanda masanjidwe owonjezera, pali njira imodzi yothandiza. Zili mu mfundo yakuti mbale yokhazikika imasandulika kukhala "wanzeru". Njirayi ikuwoneka motere:

  1. Timasankha mwamtheradi maselo onse a tebulo lathu. Pali njira zambiri zowunikira deta yonse. Tidzagwiritsa ntchito kuphatikiza kiyi pa kiyibodi "CTRL + A".
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
17
  1. Timapita ku gawo la "Home", lomwe lili pamwamba pa mawonekedwe. Timapeza chipika cha malamulo "Styles" ndikudina chinthucho "Format as table".
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
18
  1. Mndandanda wokhala ndi masitayelo watsegulidwa. Timasankha kalembedwe koyenera kwa "smart table" podina batani lakumanzere.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
19
  1. Zenera laling'ono lotchedwa "Format Table" linawonetsedwa pazenera. Pano muyenera kufotokoza malire a malo osankhidwa. Ndi kusankha koyenera koyambirira, palibe chifukwa chosinthira chilichonse apa. Ngati muwona deta yolakwika, mukhoza kusintha. Ikani cholembera pafupi ndi chinthu "Table with headers". Pambuyo pochita zosintha zonse, dinani batani "Chabwino".
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
20
  1. Chifukwa cha kusintha kwathu, mbale yoyambirira idasandulika kukhala "wanzeru".
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
21
  1. Timangofunika kuwonjezera gawo latsopano kumapeto kwa tebulo. Timangodzaza zofunikira ndi selo iliyonse yomwe ili kumanja kwa tebulo la "smart". Mzere wodzazidwa ndi deta udzakhala chinthu cha "smart table". Mapangidwe onse adzasungidwa.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
22

Momwe mungayikitsire ndime pakati pa mizati mu Excel?

Tsopano tiyeni tikambirane mwatsatanetsatane momwe mungayikitsire mzati pakati pa mizati ina mu Excel spreadsheet. Tiyeni tione chitsanzo chapadera. Mwachitsanzo, tili ndi mndandanda wamitengo yomwe palibe manambala azinthu. Tiyenera kuwonjezera ndime yowonjezera pakati pa mizati kuti mudzaze manambala amtengo wamtengo wapatali. Pali njira ziwiri zogwiritsira ntchito njirayi.

Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
23

Njira yothetsera vutoli ndi monga:

  1. Sunthani cholozera cha mbewa ku selo A1 ndikusankha.
  2. Timasunthira ku gawo la "Home", lomwe lili pamwamba pa mawonekedwe a spreadsheet. Timapeza chipika cha malamulo otchedwa "Maselo" ndikusankha chinthu cha "Insert".
  3. Mndandanda wawung'ono watsegulidwa, momwe muyenera kusankha "Ikani mizati pa pepala".
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
24
  1. Okonzeka! Takhazikitsanso gawo latsopano lopanda kanthu pakati pa mizati.

Kukonzekera kwa njira yachiwiri ndi iyi:

  1. Dinani kumanja pamgawo A.
  2. Mndandanda wazinthu zazing'ono unawonetsedwa pazenera, momwe muyenera kusankha chinthu chotchedwa "Ikani".
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
25
  1. Okonzeka! Takhazikitsanso gawo latsopano lopanda kanthu pakati pa mizati.

Pambuyo pogwiritsira ntchito imodzi mwa njira ziwiri zomwe tafotokozazi, tikhoza kuyamba kudzaza ndime yopangidwa ndi manambala azinthu zamtengo wapatali.

Ikani magawo angapo pakati pa mizati nthawi imodzi

Kupitiliza ndi chitsanzo chamtengo pamwambapa, tiyeni tipeze momwe tingawonjezere mizati yambiri pakati pa mizati nthawi imodzi. Mndandanda wamtengo ulibe mizati ya 2: kuchuluka ndi mayunitsi a muyeso (zidutswa, kilogalamu, malita, phukusi, ndi zina zotero). Njirayi ikuwoneka motere:

  1. Kuti tigwiritse ntchito kuwonjezera mizati iwiri yowonjezera, tiyenera kuchita ndondomeko yosankha ma cell a 2. Tikuwonetsa C1:D
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
26
  1. Timasunthira ku gawo la "Home", lomwe lili pamwamba pa mawonekedwe a spreadsheet. Timapeza chipika cha malamulo otchedwa "Maselo" ndikusankha chinthu cha "Insert". Mndandanda wawung'ono watsegulidwa, momwe muyenera kusankha "Ikani mizati pa pepala".
  2. Okonzeka! Takhazikitsa kuwonjezera mizati iwiri pakati pa mizati iwiri.

Pali njira ina yochitira izi. Njirayi ikuwoneka motere:

  1. Timasankha mitu iwiri C ndi D.
  2. Dinani kumanja mbewa batani. Menyu yodziwika bwino imatsegulidwa. Timapeza chinthu chotchedwa "Insert" ndikudina ndi LMB.
Momwe mungawonjezere ndime mu Excel. Kuwonjezera ndime yatsopano, mizati 2 ndi mzati kumapeto kwa tebulo
27
  1. Okonzeka! Takhazikitsa kuwonjezera mizati iwiri pakati pa mizati iwiri.

Nthawi zina zimachitika kuti wogwiritsa ntchito, akugwira ntchito ndi chidziwitso cha tabular, mwangozi amawonjezera ndime yosafunika. Tiyeni tiwone momwe tingachitire njira yochotsera. Njirayi ikuwoneka motere:

  1. Sankhani kuchuluka kwa ma cell omwe mizati yomwe tikufuna kuchotsa.
  2. Timapita ku gawo la "Home", pezani chipika cha "Chotsani" ndikudina chinthucho "Chotsani mizati papepala." Kapenanso, dinani kumanja kuti mutsegule menyu yankhani ndikusankha chinthu "Chotsani".
  3. Okonzeka! Takhazikitsa kuchotsa zipilala zosafunikira ku data ya tabular.

Ndikofunika kukumbukira! Mizati yowonjezera nthawi zonse imawonjezedwa kumanzere kwa mizati yosankhidwa. Chiwerengero cha mizati yatsopano chimadalira kuchuluka kwa mizati yomwe inaperekedwa poyamba. Dongosolo la mizati yomwe yalowetsedwa imadalira dongosolo la kusankha (kupyolera m'modzi ndi zina zotero).

Kutsiliza

Spreadsheet ya Excel ili ndi njira zambiri zomwe zimakulolani kuti muwonjezere zigawo zina pamalo aliwonse patebulo. Kutembenuza deta yochokera ku "smart table" kukulolani kuti muyike mizati yowonjezera popanda kuwononga nthawi pa masanjidwe, popeza maonekedwe a mizati yatsopano adzatengera mawonekedwe a tebulo lomalizidwa. Njira zosiyanasiyana zowonjezerera zipilala zimalola wogwiritsa ntchito aliyense kusankha yabwino kwambiri kwa iwo eni.

Siyani Mumakonda