Sinthani manambala-monga-mawu kukhala manambala wamba

Ngati zolembazo zidakhazikitsidwa pamaselo aliwonse papepala (izi zitha kuchitika ndi wogwiritsa ntchito kapena pulogalamuyo pokweza deta ku Excel), ndiye kuti manambala omwe adalowetsedwa pambuyo pake m'maselo awa a Excel amayamba kuwaona ngati zolemba. Nthawi zina maselo otere amalembedwa ndi chizindikiro chobiriwira, chomwe mwachiwonapo:

Ndipo nthawi zina chizindikiro choterocho sichimawonekera (chomwe chiri choipa kwambiri).

Nthawi zambiri, mawonekedwe a manambala-monga-mawu mu data yanu nthawi zambiri amabweretsa zotsatira zoyipa kwambiri:

• kusankha kumasiya kugwira ntchito bwino - "manambala abodza" amafinyidwa, ndipo samakonzedwa mwadongosolo monga momwe amayembekezera:

  
  

• mtundu wa ntchito VLOOKUP (VLOOKUP) osapeza zofunikira, chifukwa kwa iwo nambala ndi nambala yofanana-monga-malemba ndizosiyana:

  
  

• posefa, manambala abodza amasankhidwa molakwika
  
• ntchito zina zambiri za Excel zimasiyanso kugwira ntchito bwino:
• etc.

Ndizoseketsa kwambiri kuti chikhumbo chachilengedwe chongosintha mawonekedwe a cell kukhala manambala sichithandiza. Iwo. mumasankha ma cell, dinani pomwepa, sankhani Mawonekedwe a cell (Maselo a Format), sinthani mawonekedwe kukhala Zambiri (nambala), kufinya OK - ndipo palibe chomwe chimachitika! Ayi!

Mwina, "ichi si cholakwika, koma mawonekedwe", ndithudi, koma izi sizimapangitsa kuti zikhale zosavuta kwa ife. Kotero tiyeni tiwone njira zingapo zothetsera vutoli - imodzi mwa izo idzakuthandizani.

Njira 1. Kona ya chizindikiro chobiriwira

Ngati muwona ngodya yobiriwira pa foni yomwe ili ndi nambala m'malemba, ganizirani nokha mwayi. Mutha kusankha ma cell onse okhala ndi data ndikudina chizindikiro chachikasu chowonekera chokhala ndi chilengezo, kenako sankhani lamulo. Sinthani kukhala Nambala (Sinthani kukhala nambala):

Nambala zonse zomwe zasankhidwa zidzasinthidwa kukhala manambala athunthu.

Ngati palibe ngodya zobiriwira, fufuzani ngati zazimitsidwa pazokonda zanu za Excel (Fayilo - Zosankha - Mafomula - Nambala zojambulidwa ngati zolemba kapena zotsogozedwa ndi apostrophe).

Njira 2: Kulowanso

Ngati palibe maselo ambiri, ndiye kuti mutha kusintha mawonekedwe awo kukhala manambala, ndikulowetsanso deta kuti kusintha kwa mawonekedwe kuchitike. Njira yosavuta yochitira izi ndikuyimirira pa selo ndikudina makiyi motsatana F2 (lowetsani edit mode, selo limayamba kuthwanima cholozera) ndiyeno Lowani. Komanso m'malo F2 mukhoza kungodina kawiri pa selo ndi kumanzere mbewa batani.

Zimangonena kuti ngati pali maselo ambiri, ndiye kuti njirayi, ndithudi, siigwira ntchito.

Njira 3. Fomula

Mutha kusintha mwachangu manambala abodza kukhala abwinobwino ngati mupanga gawo lowonjezera ndi formula yoyambira pafupi ndi deta:

Kuchotsa kawiri, pamenepa, kumatanthauza, kwenikweni, kuchulukitsa ndi -1 kawiri. Kuchotsa ndi kuchotsera kumapereka kuphatikizika ndipo mtengo wa cell sudzasintha, koma kuchita masamu kumasinthiratu mtundu wa data kukhala nambala yomwe tikufuna.

Zachidziwikire, m'malo mochulukitsa ndi 1, mutha kugwiritsa ntchito masamu ena aliwonse osavulaza: kugawa ndi 1 kapena kuwonjezera ndikuchotsa ziro. Zotsatira zake zidzakhala zofanana.

Njira 4: Matani Mwapadera

Njirayi idagwiritsidwa ntchito m'mitundu yakale ya Excel, liti oyang'anira amakono ogwira mtima adapita pansi pa tebulo  panalibe ngodya yobiriwira yobiriwira komabe kwenikweni (zinangowoneka mu 2003). Algorithm ndi iyi:

• lowetsani 1 mu selo iliyonse yopanda kanthu
• koperani
• sankhani ma cell okhala ndi manambala m'mawu ndikusintha mawonekedwe awo kukhala manambala (palibe chomwe chidzachitike)
• dinani kumanja pamaselo okhala ndi manambala abodza ndikusankha lamulo Matani apadera (Paste Special) kapena gwiritsani ntchito njira yachidule ya kiyibodi Ctrl + Alt + V
• pa zenera limene limatsegula, sankhani njira Makhalidwe (Makhalidwe) и Pitirizani (Kuchulukitsa)

M'malo mwake, timachita zomwezo monga momwe zidalili kale - kuchulukitsa zomwe zili m'maselo ndi imodzi - koma osati ndi ma formula, koma mwachindunji kuchokera ku buffer.

Njira 5. Lembani ndi mizati

Ngati ma pseudonumbers oti atembenuzidwe amalembedwanso ndi decimal olakwika kapena olekanitsa zikwi, njira ina ingagwiritsidwe ntchito. Sankhani gwero lochokera ndi data ndikudina batani Zolemba ndi zigawo (Mawu ku mizati) tsamba Deta (Tsiku). M'malo mwake, chida ichi chapangidwa kuti chigawanitse zolemba zomata kukhala mizati, koma, pakadali pano, timachigwiritsa ntchito pazinthu zina.

Lumphani masitepe awiri oyamba podina batani Ena (Ena), ndipo lachitatu, gwiritsani ntchito batani Kuwonjezera apo (Zapamwamba). Bokosi la zokambirana lidzatsegulidwa pomwe mutha kukhazikitsa zilembo zolekanitsa zomwe zikupezeka m'mawu athu:

Pambuyo pang'anani chitsiriziro Excel idzasintha malemba athu kukhala manambala wamba.

Njira 6. Macro

Ngati mukuyenera kuchita zosintha zotere nthawi zambiri, ndiye kuti ndizomveka kusinthira izi ndi ma macro osavuta. Dinani Alt+F11 kapena tsegulani tabu Woyambitsa (Wolemba Mapulogalamu) Ndipo dinani Zooneka Basic. Pazenera la mkonzi lomwe likuwoneka, onjezani gawo latsopano kudzera pa menyu Ikani - Module ndi kukopera khodi ili:

Sub Convert_Text_to_Numbers() Selection.NumberFormat = "General" Selection.Value = Selection.Value End Sub  

Tsopano mutasankha mitundu, mutha kutsegula tabu nthawi zonse Wopanga - Macros (Wopanga - Macros), sankhani macro athu pamndandanda, dinani batani Thamangani (Thamangani) - ndikusintha nthawi yomweyo manambala abodza kukhala athunthu.

Mutha kuwonjezera izi ku buku lanu lalikulu kuti mugwiritse ntchito pambuyo pake mufayilo iliyonse.

PS

Nkhani yomweyi imachitika ndi masiku. Madeti ena amathanso kudziwika ndi Excel ngati malemba, kotero kupanga magulu ndi kusanja sikungagwire ntchito. Mayankho ake ndi ofanana ndi manambala, mawonekedwe okhawo ndi omwe akuyenera kusinthidwa ndi nthawi m'malo mwa manambala.

• Kugawa mawu omata m'migawo
• Mawerengedwe opanda ma fomula ndi ma pasta apadera
• Sinthani mawu kukhala manambala ndi chowonjezera cha PLEX