Momwe mungawonjezere mizere ingapo nthawi imodzi mu Excel

Mukamagwira ntchito ndi matebulo mu Microsoft Office Excel, nthawi zambiri pamafunika kuyika mzere kapena mizere ingapo pakati pa gulu la tebulo pakati pa zinthu zoyandikana kuti muwonjezere chidziwitso chofunikira kwa wogwiritsa ntchito, potero ndikuwonjezera mbale. Momwe mungawonjezere mizere ku Excel tikambirana m'nkhaniyi.

Momwe mungawonjezere mzere umodzi mu Excel

Kuti muwonjezere kuchuluka kwa mizere patebulo lopangidwa kale, mwachitsanzo, pakati pake, muyenera kuchita masitepe osavuta a algorithm:

1. Gwiritsani ntchito batani lakumanzere la mbewa kuti musankhe selo pafupi ndi komwe mukufuna kuwonjezera zinthu zatsopano.

2. Dinani kumanja pa malo owunikira.
3. Pazenera lamtunduwu, dinani "Ikani ...".

4. Menyu yaying'ono ya "Add cell" idzatsegulidwa, momwe muyenera kufotokozera zomwe mukufuna. Izi zikachitika, wogwiritsa ntchitoyo ayenera kuyika chosinthira m'munda wa "String", kenako dinani "Chabwino".

5. Onani zotsatira. Mzere watsopano uyenera kuwonjezeredwa ku malo omwe aperekedwa mu tebulo loyambirira. Komanso, omwe adawonekera pagawo loyamba, adzakhala pansi pa mzere wopanda kanthu.

Tcherani khutu! Momwemonso, mutha kuwonjezera mizere yambiri, nthawi iliyonse kuyitanitsa menyu yankhani ndikusankha njira yoyenera pamndandanda wamakhalidwe omwe aperekedwa.

Momwe mungawonjezere mizere ingapo ku Excel spreadsheet nthawi imodzi

Microsoft Office Excel ili ndi njira yapadera yopangidwira yomwe mutha kuthana nayo ntchitoyi munthawi yochepa kwambiri. Ndikofunikira kutsatira malangizowo, omwe samasiyana kwenikweni ndi ndime yapitayi:

1. M'gulu lachidziwitso choyambirira, muyenera kusankha mizere yambiri momwe mukufuna kuwonjezera. Iwo. mutha kusankha maselo odzazidwa kale, sizimakhudza chilichonse.

2. Momwemonso, dinani pagawo lomwe mwasankha ndi batani lakumanja la mbewa ndipo pazenera lamtundu wankhaniyo, dinani "Matani ...".
3. Pazosankha zina, sankhani njira ya "String" ndikudina "Chabwino" kuti mutsimikizire zomwe zikuchitika.
4. Onetsetsani kuti nambala yofunikira ya mizere yawonjezedwa kumagulu a tebulo. Pankhaniyi, maselo osankhidwa kale sadzachotsedwa, adzakhala pansi pa mizere yopanda kanthu.

Momwe mungachotsere mizere yopanda kanthu mu Excel

Ngati wosuta ayika molakwika zinthu zosafunikira patebulo, amatha kuzichotsa mwachangu. Pali njira ziwiri zazikulu zokwaniritsira ntchitoyi. Zikambidwanso mowonjezereka.

Zofunika! Mutha kufufuta chilichonse mu MS Excel spreadsheet. Mwachitsanzo, mzere, mzere kapena selo linalake.

Njira 1. Kuchotsa zinthu zowonjezedwa kudzera pa menyu yankhaniyo

Njirayi ndiyosavuta kugwiritsa ntchito ndipo imafuna wogwiritsa ntchito kutsatira njira zotsatirazi:

1. Sankhani mizere yowonjezeredwa ndi batani lakumanzere la mbewa.
2. Dinani kumanja kulikonse komwe mwasankha.
3. Pazenera lamtunduwu, dinani "Chotsani ...".

4. Onani zotsatira. Mizere yopanda kanthu iyenera kuchotsedwa, ndipo mndandanda wa tebulo udzabwerera ku mawonekedwe ake akale. Momwemonso, mutha kuchotsa zipilala zosafunikira patebulo.

Njira 2: Bwezerani zomwe zachitika kale

Njirayi ndiyofunikira ngati wogwiritsa ntchito achotsa mizere atangowonjezera patebulo, apo ayi zomwe zachitika kale zidzachotsedwanso, ndipo pambuyo pake ziyenera kuchitidwanso. Microsoft Office Excel ili ndi batani lapadera lomwe limakupatsani mwayi wosintha zomwe zachitika kale. Kuti mupeze ndi kuyambitsa ntchitoyi, muyenera kuchita motere:

1. Sankhani zinthu zonse zomwe zili patsambalo podina LMB pamalo aliwonse aulere.
2. Pakona yakumanzere kwa chinsalu pafupi ndi batani la "Fayilo", pezani chithunzicho ngati muvi kumanzere ndikudina ndi LMB. Pambuyo pake, chomaliza chochitidwa chidzachotsedwa, ngati chinali kuwonjezera mizere, ndiye kuti zidzasowa.

3. Dinani batani losinthanso ngati kuli kofunikira kuti muchotse zochita zingapo zam'mbuyomu.

Zina Zowonjezera! Mutha kusintha zomwe zidachitika kale mu MS Excel pogwiritsa ntchito makiyi otentha a Ctrl + Z powakanikiza nthawi imodzi kuchokera pa kiyibodi ya pakompyuta. Komabe, izi zisanachitike, muyenera kusinthana ndi masanjidwe a Chingerezi.

Momwe mungawonjezere mizati yambiri nthawi imodzi mu Excel

Kuti mugwiritse ntchito njirayi, muyenera kuchita zofanana ndi zomwe mukuwonjezera mizere. Algorithm yothetsera vutoli ikhoza kugawidwa m'magawo awa:

1. M'ndandanda wa tebulo, pogwiritsa ntchito batani lakumanzere, sankhani chiwerengero cha mizati ndi deta yodzaza yomwe mukufuna kuwonjezera.

2. Dinani kumanja kulikonse komwe mwasankha.
3. Pazosankha zomwe zikuwoneka, dinani LMB pamzere "Ikani ...".
4. Pazenera lowonjezera ma cell omwe amatsegulidwa, sankhani njira ya "Column" ndikusintha kosinthira, ndikudina "Chabwino".

5. Onani zotsatira. Mizati yopanda kanthu iyenera kuwonjezeredwa malo omwe asankhidwa pandandanda wa tebulo.

Tcherani khutu! Pazenera lomwe limawonekera, muyenera dinani batani "Ikani ...". Palinso mzere wanthawi zonse wa "Matani", womwe umawonjezera zilembo zomwe zidakopedwa kale kuchokera pa clipboard kupita ku cell yosankhidwa.

Kutsiliza

Chifukwa chake, ku Excel ndikosavuta kuwonjezera mizere ingapo kapena mizati patebulo lokonzedwa kale. Kuti muchite izi, muyenera kugwiritsa ntchito imodzi mwa njira zomwe tafotokozazi.