Me pēhea te ki te hanga i te rarangi i roto i te rārangi Excel, neke ratou, ka whakatika i te teitei?

Ko te tino rongonui pūmanawa Microsoft Excel tika ki tona ahurei. Ka taea te whakamahi i tēnei tono i roto i ao katoa o te mahi. Ka taea e Excel kore anake te mahi tahi me ngā tau, engari ano ki te whakarato i ngā mōhiohio i roto i te puka o kauwhata me ngā tūtohi. Māngai o ngaio rerekē kawea te nui o te mahi i roto i mea ïa no te mea o tenei hōtaka.

Tata ki te katoa kaiwhakamahi PC kanohi te hiahia ki te mahi i roto i Microsoft Excel. Kaupapa pērā i whakatōpū raina, taua aunoa, pehea ranei ki te hanga i te rarangi i roto i te rārangi Excel, tino hāngai.

Te mahi i roto i Excel: te maha o ngā rārangi, me ratou roa

Me whiwhi ia putanga he maha etahi o nga rarangi. I roto i te MS Excel 2003, ka taea e koe te whakamahi i te rārangi 65,536, a i roto i MS Excel 2010 - kua 1,048,576.

Ko te wā "roa o string" ngā rua motuhake e. taea ana te ruri i tēnei tohu i roto i te maha o ngā pūtau, me te maha o ngā pūāhua e taea te tomo ki te pūtau.

I roto i te MS Excel 2003 te maha o tīwae he 256. Ko te whai wāhitanga nui hoki te whakarato MS Excel 2010 - 16 384 ngā pūtau.

putanga rua i te taua maha o ngā pūāhua i te pūtau, e ko te 32.767 pūāhua. I roto i te pūtau, enei pūāhua katoa, o te akoranga, e taea e kore e kitea, engari e taea te kite ratou i roto i te pae tātai.

Me pēhea te ki te whakauru me te muku rarangi i roto i Excel?

Hei whakaoti i te raruraru i roto i ara e rua:

• Mā te whakamahi i te tahua horopaki. He mea tika ki te whakanui i te wahi ngā wahi e kia kei te aho, me ka whakamahi i te pātene kiore matau ki te pāwhiri i te tahua. I muri te kōwhiri "Kōkuhu" "Raina" puta. He mea tika ki te whakaū i te mahi mā te pāwhiri "OK".
• Na roto i te paewhiri mana. Me whiriwhiri e koe he wāhi mo te aho, me te i runga i te paewhiri mana ki te kitea te "Main" ripa, pāwhiri "Kōkuhu" a ka "Kōkuhu Haupae".

E mukua rarangi whakamana te i roto i te ara rite, engari hei utu o te tūemi "Kōkuhu" Ko reira e tika ana ki te pāwhiri i runga i "Muku."

Te teitei haupae i roto i Excel

whakaritea ana tēnei tawhā te i roto i te maha ngā huarahi. Ko te tino watea, me te ngāwari - he reira ki te huri i te teitei mā te whakamahi i te kiore. Me whakanohoia te pehu i runga i taua raina, a ka mau i te pātene, totoro kōpeke reira iho ki te rahi ranei.

Hoki e taea te huri i te teitei i te tikanga o te paewhiri mana. I roto i te "Home" ki te tīpako "Hōputu" a ka pāwhiri "Teitei haupae". I roto i te matapihi e hiahia ana koe ki te tautuhi i te uara e hiahia ana koe i roto i te take ngā.

rapu utu putanga rua kōwhiringa aunoa o te teitei haupae. Ko te tika tenei, ki te hiahia koe ki te huri i te tautuhinga rite ki te kuputuhi i te mea i reira. Heoi, ka whakamahi i tenei mahi, e hiahia ana koe ki te mohio e ka mahi i te kupu anake, no te takina te pouaka kei te "Tākai" i roto i te ripa "Tīaroaro". Ko te teitei mōrahi e taea te whakaturia - ko reira 409 uara.

Ko te whakarōpūtanga o rarangi i roto i te Excel

Ki te tika, e hiahia ana ngā rōpū o ngā rārangi ki te tīpako ratou, ka haere ki te ripa "Raraunga". He ka Me ki tīpako i te "Hanganga" - "Group".

rarangi Weterōpū i faaauraa, pāwhiri tika "wete".

A, ki te hiahia koe i te torutoru rārangi?

He hiahia i roto i te āhua o ki te hanga i te rarangi i roto i te rārangi Excel tokomaha te iwi. Kahore he hoki kahore mahi nui. I roto i te tikanga ki te hanga i roto i te Excel, he torutoru rārangi i roto i te rarangi, e hiahia ana koe ki te whakamahi i te Alt pokatata papapātuhi + Tāuru. Ka whakatinanahia Whakawhiti kia tika i roto i te pūtau, tonu urunga raraunga ki te kōwae.

rārangi huna me ratou whakamahere muri

I te tahi taime, no te mahi ki te hōtaka Excel, he mea e tika ana ki te huna rarangi. Ka taea te mahi i tēnei te whakamahi i te pātene kiore matau. I muri karanga te tahua horopaki, tīpako "Huna" i muri i te kōwhiri etahi whatiwhatinga.

I roto i te take i reira e hiahia ana koe ki te whakaatu rarangi huna, te mahi kia kia rite whai: tīpako i te mongamonga tika ki te hopu i ara nga mea e te hunga i runga ranei i raro i te awhe motuhake. Na, i muri i te pāwhiri i te pātene kiore matau, ka kite koe i te tahua horopaki i reira kia tīpako koe "Whakaatu".

Concatenation ki Excel

Ko te āhuatanga faufaa e taea hanumi koe pūtau, no te hanga tepu. Ki tenei mutunga, pae motuhake, me te tīpako i te ripa e hiahia ana koe ki te tīpako "Home", ka te mahi "Hanumi" me "Neke ki te pokapū." Ki te tika, ka taea e koe te whiriwhiri i ētahi atu huarahi ki te uru atu. Na e matau ana koutou e founga ki te hanga i te rarangi i roto i te aho Excel me pehea ki te whakahaere ia ratou. Kia mōhio e he faufaa i roto i te whakaoti rapanga i roto i te hōtaka i homai enei kaupae.

E te ara, ki te mahi ano koutou i te takahanga, ka kia whakakorea te whakahau o mua.

He aha te mea he tonotono me aha e ratou mo?

Kua tūpono He maha ngā kaiwhakamahi te wā "tonotono", engari e mohio e kore katoa te mea te mea te reira. Ko te hōtaka e kei tohutohu motuhake me ngā mahi e te tonotono - i te tono e kore ranei - e taea te whakaatu take epā.

Tonotono i tuhituhia e te hötaka kaiwhakamahi ranei e faati'a ai wāhanga whakaaunoa me te whakaiti i te wa e hiahiatia ana ki te whakaoti i te mahi.

A, no te mahi ki nui-tauine, me te rōrahi o te raraunga ki te kia tukatuka, te tangata Ahatia te rota o te wā i runga i ngā mahi auau. Waihanga i te tonotono e ka e taea ki te kawe i roto i taua mahi i runga i to ratou ake, Excel kaiwhakamahi e whakaora haora mahi. I tua atu, Ko te ahei o te kimi hapa aunoa katoa, e hanga te mahi atu watea, me te māmā pai-hangaia paku-hōtaka.

ati tonotono

E ngohengohe ana ki etahi tūponotanga Mā te tonotono. Ka taea e rorohiko nanakia te waihanga i tētahi huaketo, whakaatu i te reira rite te tonotono e ka pahuatia nga raraunga katoa ka meinga arā. I tua atu, ka taea e tenei hōtaka mahi rite te tutei i te tai'oraa katoa o te mōhiohio.

tākainga

Ka taea te rite Whakawhiti rārangi Excel i te maha o ngā huarahi. I roto i te take i reira me te tomo koutou he nui nui o ngā pūāhua, ka taea e koe whakaturia i te "kuputuhi rerengia i roto i ngā pūtau pātata." Mahi hōtaka Na ka whakaaturia te kōrero i runga i ngā rārangi maha.

Ka taea te tukinotia kuputuhi roa kia taua i whakanohoia ai i roto i te pouaka. Ki te mahi i tenei, tīpako i te ripa "Kōkuhu" a ka "Text" me "Tapanga". Na ka taea e koe te tīmata patopato. I roto i te pouaka kuputuhi, he reira taea ki te kawe i te hōputu o te rauemi kopakia kahore tohutoro ki rohe.

Ko te huarahi māmā ki te neke i te rarangi i roto i Excel, - he ki te neke i te reira ki te kiore. He mea tika ki te neke i te pehu ki te pūtau tīpakohia, ka mau i te pātene kiore maui, tōia te rohe tīpakonga ki te wāhi hou. Whakahohea tenei āhuatanga, e taea e koe i roto i te "Kōwhiringa" - "Arā".

E mohio ana pehea ki te hanga i te rarangi i roto i te rarangi Excel me he atu pūkenga mahi, ka tino meinga koe taua mea māmā ki te mahi ki te hōtaka, me te whakapiki ake i hua, whakaora wā mahi.