Me pēhea te ki te tāpiri i te string ki Excel: tūtohutanga, tauira

Ko te "Excel" i Microsoft Office - he ētita ripanga kaha, e taea ai e kore anake raraunga taonga i roto i nga rarangi, me tīwae, engari ano ki te hanga tātai matatini, me te ki te tuku i te hua i roto i te hōputu kauwhata.

Tenei tuhinga tātari i roto i te kōrero ki te mahi i te rārangi kei i runga i te pepa noa o ngā pukapuka i roto i te paraharaha i āta hangaia, ka ako e founga ki te tuu i te tīwae i roto i Excel-rarangi i te wa ano. Ka rite ki te pūtake tango tatou i te tuku Microsoft Office 2007.

Ngā momo o ngā mahi aho i roto i te "Excel"

E hāngai ana ki ngā rārangi e kaua iti (e kore e pa te hōputu pātai me kape) Ko nga ngā mahi e wātea ana:

• tīpakonga;
• whakapiri;
• muku;
• displacement;
• transposition.

Kia kite tatou i roto i te mea ara ki te whakaoti i enei raruraru i roto i te "Excel 2007", me ki timata ki, rite te tino i roto i te rārangi Excel.

o tāuriuri

Tino maha, raruraru kaiwhakamahi hōtaka 'Excel' ki te wā "Miramira" te kōwhiringa o te ngā i hiahia ratou ki te whānuitanga o ngā pūtau.

I roto i te "Excel 2007" aho e wātea ana arā, o 16,384 ngā pūtau, a ki te whakanui i te taatoaraa, pāwhiri he nui ki te pāwhiri i runga i te mau upoo parau taua te pātene maui, whakaritea poutū i te mata i mahue o te pepa.

Ki te hiahia koe ki te tohatoha i te torutoru noa rarangi o ngā pūtau, te whai i te kōwhiringa, e pupuri iho i te pātene kiore maui. Ka taea e ranei e whiwhi koe i runga i tetahi pūtau, press, me te mau i te Shift + kī Ctrl me, kahore te tuku i te reira, pēhi i te pere "tika" ranei "mahue", i nei te ara e te tīpakonga rānei.

Whakatūpato! Here te tahi mau onäianei. Ki te tīpakohia katoa o nga rārangi pūtau kau ki tonu i te raraunga ranei, ka tohu te raina tonu i mua i te mutunga o te pepa, arā. E. Hei pūtau tau 16, 384. Ki te reira ko he "tauira āputa" (he pūtau katoa kau, ka whakaki tutaki, ranei hurihia) , rere te kōwhiringa i roto i te pūtau e "taiea" me ia, rawa, ka haere ki te awhe i tīpakohia. Na reira, ki te huinga o taviri «Shift + Ctrl + Mauī / Matau" whai ki te kia tupato.

Tatou i teie nei tahuri ki te pehea, ki te tāpiri i te rarangi i roto i Excel.

Te whakauru i te rarangi hou

He pai ki te mohio! Raina i roto i "Eksele" Kei te tāpiri tonu i te whanaunga runga ki te pūtau tīpakohia (s), nga pou - te maui.

Hipanga tetahi. Miramirahia te pūtau ranei awhe o ngā pūtau, te aho katoa i runga i nei whakamahere ki te tāpiri i te aho hou ranei.

Hipanga rua. Tangohia painga o te whiriwhiri o tetahi o ngā mahi e rua:

• Mā te pēhi i te pātene kiore matau ki te whakatuwhera i te tahua horopaki, e taea te haere ki te "Kōkuhu" a ka whakamahi i te pātene irirangi ki te tīpako 'aho'. Pāwhiritia "OK", me mo tou pūtau tīpakohia (s) e waiho he raina hou, tino kau.
• I te "Kāinga" rīpene pukapuka pokatata ki te rōpū "Pūtau" - "Kōkuhu" - ". Kōkuhu rarangi i runga i te rau"

Mahi!

Ka rite ki a koutou e taea te kite, i muri i te whakatinanatanga o enei tūtohutanga whiwhi koe i runga i tou raraunga raina pātea rawa hou.

Na, me pehea ki te tāpiri i te string ki Excel, matau tatou.

Muku i te rarangi

Ka rite ki whakaurua te rarangi hou e, te tango i nui ki te mahi e rua noa mahi.

Hipanga tetahi. ngā koe te aho e hiahia ana koe ki te tango, hoatu noa koutou pehu i roto i tetahi pūtau i roto i te rarangi e kore koe e hiahia ana ranei.

Tino nui! Ka Ahakoa o mehemea kua tāutuhia e koe i te pūtau awhe ranei kia mukua te raina katoa o te pukapuka katoa - e ko, i roto i te take o te "Excel 2007" Ko te pūtau ki te 1 ki te 16384 th. Ki te hiahia noa koe ki te ūkui koutou raraunga i te pūtau, he reira rawaka ki te whakamahi i muri i te kōwhiri i te pātene Muku i runga i te papapātuhi.

Hipanga rua. Hei whiriwhiri i:

• Te pēhi i te pātene kiore matau ki te kawe ake i te tahua horopaki, e haere ana ki te "Muku", a ka ki te awhina o whakakā ki te tīpako "Raina". Press "OK", me te aho "tetepe" me te mea e kore i reira i.
• I te "Kāinga" pokatata ki te neke i te rīpene ki te rōpū "Pūtau" - "muku" - ". Mukua rarangi i te rau"

Te neke i te rārangi

Na roto i te neke ano te aho, matau te nuinga te kaupapa o te iti awhe motuhake o ngā pūtau. Otiia i roto i tenei take enei kōwhiringa e he rerekē te parau tumu o te mahi.

Tīpakohia te rārangi rite te katoa ona pūtau takitahi ranei. Na ka neke te pehu ki te kōwhiringa atanga, kia huri i te pehu, a tango te ahua o pere kë. Kati iho te pātene kīore mauī ki "hopu" koutou pūtau, neke ki te wāhi e hiahiatia ana hou, me te tuku. Ki te te wahi neke koe, i kua whakakiia ana ki te tetahi raraunga, aunoa e kia whakaekea koe ki te whakakapi i te tirotiro o te pūtau ūnga.

Transposing rārangi

He maha ngā kaiwhakamahi e "Excel" ki te matau hohoro pehea ki te tāpiri i te string ki Excel, me pehea ki te nuku tārua ranei, engari transposition tonu te mea ngaro mo te tokomaha, me te te oraraa rawa o te mahi taua i roto i te hōtaka.

raina Transposition - te tukanga o faafariu te whakapae ki te huinga poutū o ngā pūtau. Nä, ko te transposition tīwae - ko te tukanga whakamuri.

Kōwhiringa, rite taea te faafariuraa e whakamana e rua:

• Tīpakohia te awhe o ngā pūtau o tetahi raina, me te whai ake (mā te pēhi i te pātene kiore matau ranei te huinga o Ctrl + C). Next, tu i runga i te pūtau wahi e hiahia ana koe ki te tīmata i tō tīwae hou o raraunga, whakatuwhera te tahua horopaki "Whakapiri Motuhake", te wahi i te pouakataki "whakawhiti". Mahi! tahuri Aho ki te tīwae.

• Excel 2007 he āhuatanga motuhake - "Whakawhiti." Ki te haere koe ki te tahuri i te awhe o rima ngā pūtau kei waho o ngā ano hoki tenei awhe rite rima ngā pūtau, engari whakaritea i roto i te tīwae. Pāwhiritia te tohu "rite" ka tuhituhi "Whakawhiti." Open reu me ngā koutou ngā, kei te haere nei ki te tahuri. Katia te taiapa, me te pēhi i te tomo hei utu o tika Ctrl + Shift + Tāuru. Mahi!

kia mohio ki te reira e te whakatinanatanga tuatahi (ki te whakauru motuhake) he pai mai i kore e reira te whakamahi i te tātai. Ki te whakamahi koe i te rua o nga kōwhiringa, a ka muku i te aho taketake, whiwhi koutou Zeroes katoa i roto i te wahi o ratou uara.

Ripanga roto te pukapuka, me o ratou āhuatanga

Haunga whārangi paerewa o ngā haupae me tīwae tīari hoki i roto i te ripanga Excel. Tuhituhia he kuware ratou - tīpako noa te awhe tika o ngā pūtau, a ka i runga i te ripa "Kōkuhu" tīpako "Ripanga." A feruri i te rerekētanga i waenganui i te ngā tukanga o rarangi whakahaere i roto i te tepu taua o te rārangi mahi i roto i te pukapuka tikanga.

Kei te matau te reira e te tohanga o te taua pūtau. Hei kōkuhu ranei muku rarangi i te tahua horopaki o tūemi e wātea ana "Kōkuhu - rarangi Ripanga i runga", me "Muku - Haupae o te tepu." I tua atu, ka taea e koe te tāpiri i te aho hou, noa na roto i te neke i te pehu ki te pūtau matau raro o te tepu, me te pēhi Ripa.

He hoki rerekētanga iti i roto i te kaupapa, engari ratou te tono anake ki ngā pane. Ki te tīpako koe tetahi atu ranei pūtau kei roto i te pane tepu, ka whai ratou kaupapa, ka kite koutou i e te raraunga koutou tārua tika me kua noho taitara taketake i roto i te wahi. Ki te tamata tatou i ki te neke i te tepu katoa, na reira he kore peculiarities, oho kahore raruraru.

Te ti'aturi nei tatou e whakakitea ki a koe i nga mea ngaro katoa i runga i te āhua o ki te tāpiri i te string ki Excel, me pehea ki te muku, nekehanga, me te whakawhiti raina.