Me pēhea te ki te Tapia pirau Excel Kōnae Hapa Ritenga UI

• Part 1: He aha te mea te Hapa take Kōnae Excel whiwhi whakangaromanga
• Wāhanga 2: Kōnae Tapi MS Excel ki Tool Tapia Excel

Part 1: He aha te mea te Hapa take Kōnae Excel whiwhi whakangaromanga

I roto i hapa Excel noa, kia puta e whai ake nei hapa Ritenga UI:

"I kitea wāhanga ritenga UI maha i roto i te kōnae. Anake tūmanakohia kotahi wahi e"

Hei mahino te ngā take ka taea hoki tenei hapa (kore ai e tukua Excel ki te puta a kia puta te pirau kōnae Excel), kia kotahi mohio he aha te ritenga UI ko me aha ona tirotiro e. Ka rite ki te ritenga, kei UI kaiwhakamahi kōwhiringa tautuhi e taea e wahi o Tāpiri-mai. Ēnei UI whakahaere tahua taa te mea e mohiotia ana ko Rīpene ranei.

faati'a MS Office taua tāpiri-mai mo te kaiwhakamahi ki te ngā etahi pātene (mana ranei). Hoki Excel, Kua ā enei ritenga UI i XML i roto i nei e tāmau mana. E kōnae hononga XML (.rels) mo te hototahi XML e kei momo me te ūnga MS Office.

Na te take mo te hapa UI ritenga i runga ake-kī te tikanga he tika ki te meka e kia kia etahi tawhā i roto i te XML te whakamahi i te uara kotahi i roto i te kōnae hononga ki te hapai i engari kei te hetia rānei uara muhu maha ranei ā i roto i te XML. I Excel, ka hoatu te wā mahi i tēnei hapa ngā no te mea ka whakairi Excel ake te kimi kahore kōwhiringa mana ranei uara tika ki te puta.

Hei tauira, i roto i te 'Takahuri-Button' tukua rānei o uara e rua kei te engari ki te kei waehere uara maha ranei e kore e te mana tirohia mo te kōwhiringa tika, ka puta hapa ritenga UI o tenei momo.

Waihoki 'Tirohia-Box' i roto i te mahi rānei i ki kia tirohia-tohua waiho pātea ranei. kia ā tenei i roto i te XML, a ka titau Excel wahi uara ranei. Hapa i roto i te XML, reira, ka whakaatu taua hapa ritenga UI.

I roto i te kupu MS, mo te tauira, Bright ranei to Itari ranei Tāraro mana (ahakoa e kore e ritenga UI) i te uara kotahi i roto i te waehere ki te hapai i engari i roto i te āhuatanga ano i roto i te hapa UI ka whakaaturia ki te e hoatu maha nga wahi i roto i te waehere.

Wāhanga 2: Kōnae Tapi MS Excel ki Tool Tapia Excel

Ahakoa te kaiwhakamahi Excel kore-ngaio ka kore e pā ana ki ngā tāpiri-mai ritenga UI ranei engari ki te haere mai ki runga, me te reira he hapa taua hira te rānei kōnae pakaru tangata kino accidently ranei, he aha he otinga ngāwari me pai taea hoki te kaiwhakamahi taua? Ahakoa hoki te ngaio, he ara ngāwari i roto i ko te ki te whakamahi i rōpū tuatoru pūmanawa kōnae Excel hanga. He aha whakaaroa te wira? E wātea ana e kore e noa i tokomaha kōnae te whakatika taputapu, ahakoa. Utu hoki he ngaio pono ki te hanga kino kōnae Excel te pueraa maha nga wa.

Oranga Tapia Phoenix Excel pūmanawa e ko kore te pūmanawa hanga pai hira kōnae e rua putanga. He free putanga Demo. Ko tenei ki te whakahaere i matau kaiwhakamahi, me te tiki i te taketake whakawhirinaki i roto i tona whakamahi. He wātea ana mō te kotahi me te pūnaha maha tēnei pūmanawa kōnae hanga Excel. E tautoko ana tēnei Tapia taputapu Excel putanga katoa o matapihi, me te tautoko Excel 2011 mo Mac. Faati'a tēnei hanga kino kōnae Excel (.xls me .xlsx), ka whakahoki nga raraunga katoa i kino ki te kōnae Excel hou.

Hoki Windows whai i ēnei, kia aru te raupapa ki ngāwari hanga ora kōnae Excel, kino pakaru ranei ranei. Hoki kōwhiringa Mac ko reira me taea te whakamahi i te ara ano.

Hipanga 1 Hei tīpako kino Excel wāhi ngā kōnae (puku, kōpaki, kōnae.

Hipanga 2 whakaatu kōnae Excel kino pakaru ranei katoa i roto i te wāhanga hua rapu, tīpako ki tetahi matawai.

Hipanga 3 I muri karapa te kōnae Excel kino, ka taea e koe te arokite i te kōnae Excel hanga ko.

Hipanga 4 Tīpako wāhi ki te waiho ngā kōnae e hanga

Tips:

I tua atu ki te Tool Tapia Excel ranei pūmanawa kōnae Excel hanga , kia tauturu i te torutoru tohutohu whakatikanga tere ki te ora ranei kua kino hanga kōnae Excel.

Case 1. A, no te kore e taea e Excel whakatuwhera te kōnae, ngana tetahi o te whai ake.

1. Tārua me tuwhera kōnae kino i runga i pakeke-puku.
2. Kimihia kōnae .xlb. pupuri hoki i te tārua me. Mukua .xlb. Tīmata Excel.
3. Whakamātauria te whakatuwhera i te kōnae i roto i te kupu MS Notepad ranei. Heoi, ka tukua e koe ora raraunga engari e kore e whakahōputu.
4. Ki te MS Excel 97/2000 pūtirotiro taea e koe te tiro i te raraunga, me te tā. Whakatūwhera kōnae te whakamahi i tenei hōtaka noa ki te ora raraunga. Ka ora tenei hōtaka hōputu me te uara pūtau.
5. Whakamahi XP Excel. He kōwhiringa pai mo te whakaora tenei.

Case 2. A, no te he tuwhera kōnae Excel tamata tetahi tetahi o nei ai.

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