Momwe mungatulutsire makasitomala ndi hyperlink ku nambala mu Excel

Nthaŵi zambiri pamene kukopera deta kuchokera pa intaneti kupita ku Excel, nambalayi ili ndi makasitomala monga olekanitsa zikwi. Momwe timasinthira mawonekedwe a selo kuti awerengere, imakalatabe chifukwa Excel silingamvetsetse wagawanitsa wa zikwi chiwerengerocho chitakhala ndi chiwerengero cha 6, chomwecho ndi oposa 1 miliyoni.

Ndikuwonetsani nkhaniyi pa matebulo awa a intaneti, omwe Ndayankhula masiku angapo apitawo:

estadisticasinternet Onani mmene bukuli limagwirira ntchito, malinga ngati silikutumiza maselo ogwirizana. Koma manambala awo amapita ngati malemba.

estadisticasinternet4

Kutuluka kwa iwo kumatenga njira zitatu zosavuta:

ma intaneti 1. Perekani maselo mawonekedwe.

Izi zimachitika posankha malembawo, kuwonekera moyenera ndikusankha Fomu ya maselo. Ndiye apo ife timapanga kusintha.

2. Fufuzani ndikubwezerani makasitomala.

Izi zamasulidwa ndi key Ctrl + b ngati Excel mu Spanish. Sankhani njira yoti muyang'ane comma (,) ndipo musamalowe bokosi m'malo. Ndiye batani Sinthani zonse.

Zotsatira zake n'zakuti makasitomala onse adzachotsedwa. Samalani, chifukwa zosankhidwazo ziyenera kuphatikiza manambala amene tikufuna kuti asasokoneze zigawo za fayilo pomwe pali makasitomala omwe ali ovomerezeka.

3. Perekani maselo chiwerengero cha chiwerengero.

Kenaka phazi la 1 libwerezedwa, koma likusonyeza kuti mawonekedwe ndi nambala.

Momwe mungachotsere ma hyperlink ku maselo angapo

Zedi zedi pali njira ina koma ine ndikumasula izo chifukwa chiri pamapeto a lilime mu zochitika zofanana. Chotsani imodzi ndi imodzi si vuto chifukwa chagwiritsidwa bwino ndi batani, koma kuti muchite maselo angapo sangathe kuchitidwa kapena inakopedwa ndikuyikidwa yapadera, kotero ngati tipempha sungani mfundo hyperlink nthawi zonse idzapita pokhala gawo lolowa mu selo monga xml osati lolemba.

Chimene chingachitike ndikutengera chilichonse chomwe chimatifunira ife, pazomwe zilipo kopanda kanthu, ndikusunga zizindikiro.

Selo limenelo lidzakhala ndi zokhazokha koma osati zowonjezera ndipo izi zikhoza kupopedwa ndikuperekedwa kuchokera kuzinthu zamtengo wapatali mpaka maselo oyambirira.

Mayankho a 5 ku "Mmene mungatulutsire makasitomala ndi hyperlink ku nambala mu Excel"

  1. Zinandithandizira kwambiri zikomo. Osati ngati ma geeks onse a YouTube

  2. Moni Ndikuyenera kuthetseratu kompuyo pomasunga 0 kumapeto kwa chilumikicho, koma ndikagwiritsa ntchito njira yophunzitsidwa imachotsedwa. 2.950,30 yomwe imatsala 295030. Kodi ndimagwiritsa ntchito mtundu uti? Kapena ndimatsata njira iti? Zikomo !!

  3. Zomwezo zinakuchitikirani chifukwa m'malo mosiya malo oyera, kumene mumasankha chifukwa chake makinawo adzasinthidwa, mumayika malo ndi barolo lachinsinsi pa makiyi.
    Tsopano muyenera kusankha malo apansi ndi pansi kuti muwasiye woyera, ndipo adzachotsa malo.

  4. ps ndikuyang'ana ndipo ndinachita masewerawa ndi 1,080,480 ndipo ndimakhala 1 080 480 ndipo ndinkafuna 1080480, zomwe ndiyenera kuchita?

Siyani yankho

Anu email sati lofalitsidwa.

Tsambali likugwiritsa ntchito Akismet kuchepetsa spam. Phunzirani momwe deta yanu ikufotokozera.