Me pēhea te ki te Tapia Excel kore he Ingoa Kōnae Hapa whaimana

Ko te tino noa hoki tetahi kaiwhakamahi e pā ana ki Excel kōnae ki te farerei i tetahi o maha ngā momo o ngā hapa tenei. E mea pinepine te hapa e pā ana ki te whakatuwheratanga i tētahi kōnae hira ngā (e te tikanga he raruraru i roto i te whakauru i te kōnae Excel e hiahiatia), mo ranei tiaki i te kōnae ranei hira tuhinga (ripanga) puta. He maha ngā take ka taea mo enei hapa, me hāngai mahi whakaora e taea te āwhina te whakatau i taua take.

• Wāhanga 1: Ko te Tool Excel Tapia Kōnae Best
• Wāhanga 2: Me pēhea te ki te Tapia Kōnae pirau Excel
• Part 3: Tapia Excel With 'Open me Tapia' āhuatanga
• Wāhanga 4: Me pēhea te ki te karo i Kōnae Excel tiki pirau

He hapa i a nui rite i roto i te āhua puta rite rānei o ngā karere e whai ake nei:

• ingoa kōnae kore tika
• e kore i taea te uru te kōnae.
• He roa rawa te ara tomo koutou, '<kōnae>',.
• <Kōnae> taea kore e kitea.
• '<Kōnae>. <Toronga>' i taea e kore e kitea (kitea i roto i Excel 2000).

'E kore te mea whaimana Ingoa Kōnae': i hanga, me te whakaora, te whakatuwhera i tētahi kōnae Excel ranei kia te tikanga taua hapa tetahi o te whai take:

1. kia nui Ara o kōnae tae atu ingoa kōnae 218 maha o pūāhua fakangatangata
2. Kia ai te ingoa Kōnae hē
3. e kore ai e tika Ara
4. tauwāhi Kōnae puku ranei e kore e taea te tika i homai
5. Herenga o ngā pūāhua i ingoa o kōpaki
6. Rītahamuri i waenganui i ngā kōpaki
7. Pūāhua i roto i te ingoa kōnae
8. kia tika te ingoa kōnae, engari kua whakaingoatia ranei neke ki ētahi atu wāhi ka accidently mukua ranei.

Te fifi i roto i te hanga i te hono ki tētahi atu kōnae Excel whakatika i te herenga o te 256 pūāhua. Te mea whakawhāiti 218 pūāhua mō te tautuhi i te ara hāngai te rite:

• Excel ingoa rau, mōrahi 31 pūāhua.
• Taiapa me Apostrophes e whakamahia ana ki te tohu ingoa pukamahi.
• He tohu hauhā.
• Tohutoro o te pūtau.

Tenei āhuatanga ko, Heoi, ohie ki te mahi rite tetahi kia rānei whakaingoa kōnae kōpaki ranei te whakamahi i te ingoa poto (kore rawa 218 pūāhua) ranei neke i te kōnae ki te kōpaki, ko poto. Ko whakatika te uaua, ka tangata kino kōnae Excel pakaru ranei.

Wāhanga 1: Ko te Tool Excel Tapia Kōnae Best

Hei hanga hāmate kōnae Excel maha Utauta hanga Excel ko Excel pūmanawa kōnae hanga e wātea ana. Tool Tapia Excel oranga taea hapai i hapa pērā i "Kāore e taea ki te pānui i te kōnae" ranei "he kino te kōnae, me te kore e taea te whakatuwheratia". Ka taea e hapai i te reira i putanga katoa Excel engari ki runga ki Excel 2003. Tautoko putanga XLS katoa.

Wāhanga 2: Me pēhea te ki te Tapia Kōnae pirau Excel

I muri i te raupapa o ngā whakaaturanga mata (mo Wini) tere te āwhina ki te neke taahiraa i te taahiraa whakatika me te ora kōnae Excel e kua kino ranei pakaru. Kōwhiringa mō te Mac tatau kia whakamahia ai.

Hipanga 1 Whakarewa kōnae Excel hanga , ka tīpako kino kōnae Excel i puku rohe me te rapu.

Hipanga 2 I roto i te wāhanga hua rapu whakaatu katoa kōnae Excel kino, tīpako tetahi tīmata katoa ki te whakatika tukanga ranei

Hipanga 3 Previewing te kōnae e hanga ana tīpakohia i te pae maui.

Hipanga 4 Tiaki hanga ko kōnae Excel ki te wāhi ūnga.

Part 3: Tapia Excel With 'Open me Tapia' āhuatanga

āhuatanga MS Excel o whakahaere he tukanga whakaora aunoa i roto i te take kitea reira he kōnae Excel kino. Heoi, ki te kore aratau whakaora ki te tīmata ai tamata kaiwhakamahi whakaora ā rite whakaaturia i raro nei.

Hipanga 1. Pāwhiritia Kōnae> Open.

Hipanga 2. kōpaki Pāwhiritia kei roto raumahi pāngia, me te wāhi

Hipanga 3. Tīpakohia i pouaka kōrero te kōnae kino

Hipanga 4. pere Press tata pātene tuwhera

Hipanga 5. Pāwhiritia tuwhera & hanga rite kitea konei.

Tips:

I tua atu i te whakamahi i te Tool rōpū tuatoru Excel Tapia pūmanawa kōnae Excel hanga ranei, kia tauturu i te torutoru tohutohu te kaiwhakamahi ki te whakahoki mai ranei kua kino hanga kōnae Excel.

e kore e taea e Case 1. Ki te Excel whakatuwhera te kōnae ngana e whai ake nei ki te whakatau i te take koe.

1. Tāruatia kōnae kino i runga i to koutou pakeke-puku, ki te vai te reira i runga i pīngore.
2. Whakamātauria ki te kitea te kōnae .xlb pupuri me te tārua. Na muku .xlb me tīmata anō Excel.
3. Whakamātauria ki te whakatuwhera i te kōnae i roto i te kupu MS Notepad ranei e ai kia ora koe raraunga engari e kore e whakahōputu.
4. kia MS Excel kia 97/2000 pūtirotiro tiro koe te raraunga, me te tā. Whakatūwhera kōnae te whakamahi i tenei hōtaka noa ki te ora raraunga. kia ora tēnei hōtaka ara whakahōputu me te uara pūtau.
5. Whakamahia XP Excel e whai kōwhiringa pai mo te ora.

Case 2. Ki te he kōnae Excel tuwhera piro e whai ake nei ki te whakatau i te take koe.

1. Whakamātauria i runga i te rorohiko rerekē
2. Kaua e rere Excel i te pīngore
3. Whakawhitia atu whakaora-aunoa
4. Tahuri atu te kōwhiringa tiri kōnae
5. Whakaorangia te kōnae rite te whārangi tukutuku, ka tūwhera anō te reira rite kōnae Excel.

Wāhanga 4: Me pēhea te ki te karo i Kōnae Excel tiki pirau

• Kei te tutakina iho tika Me whakarite pūnaha. Hoki taua mea mua tutakina tata tono katoa ki raro. Heoi, kia tika ki tūkunga tua atu mana tangata rite momotunga tonu o te supply mana tīmata te pirau kōnae e tika ana ki te kati hē o ngā tono.
• Whakamātauria ki te tāuta i te hou anti-huaketo ki te pupuri i tou pūnaha free i whakaeke kino. hanga tonu wheori hira kōnae i haria ki te pirau
• Whakamātauria ki te pupuri i to koutou wāhi rokiroki nui taea noa i tūponotanga rängai kino o Excel kōnae pirau e nui ki te ora te raraunga i runga i te rängai kino.
• Whakamātauria ki te kōmaka i ngā take i roto i te tono MS Excel. tutakitanga hē, me te ohorere o te whārangi Excel pāngia e ngā kōnae pirau.
• Whakamātauria ki te hapai i raraunga iti ka pā ana ki te kōnae Excel. raraunga nui i runga i whārangi Excel ko te take ārahi o te pirau kōnae.