Ara pea ki te huna tīwae roto i Excel

Te mahi ki te hōtaka i Microsoft Office Excel ko ētahi wā e tika ana ki te huna i te tahi mau tīwae rarangi ranei. Ko te take mō tenei kia mahi ki te whakapai ake i te pānui o te tuhinga ranei tika te hiahia ki te huna i tetahi tātai raraunga ranei. I roto i tenei whakaaro, nga kaiwhakamahi o taputapu pūmanawa ko te pātai: "Me pēhea te ki te huna tīwae i Excel, me pehea ki te tiki hoki ki to ratou kitenga?".

Ara ki te huna tīwae

Hoki te haratau o te mahi i roto i Excel hōtaka kei mahi ki te huna etahi awhe o ngā pūtau. Aita e hi'oraa e ahakoa puritia ratou etahi mōhiohio ranei he kau ratou. I roto i te tikanga ki te whakatutuki i huna o tetahi atu ranei tīwae, me mahi koutou tetahi o nga hātepe wha e whai ake nei.

• Tīpakohia te pūtau o te tīwae e hiahia ana koe ki te huna, neke i te pehu kiore i runga i te awhe tīpakohia - ka te mau upoo parau tīwae kia pania i roto i te tae mumura, a ka hanga he pāwhiri-matau. I roto i te tahua horopaki tīpako "Huna".
• Whakarato i te tīwae tika rite te katoa, hua press i runga i te papapātuhi te pātene "Tahua", e ka arahi ki te whākinga taua o te tahua horopaki, a ka hoki te hanga i te "Huna" kōwhiringa whakahau.
• Te kōwhiri i tētahi, ētahi rānei pūtau i roto i te pou tīpakohia, te whai i nga whakahau e whai ake nei. Te Paeutauta Uru Tere, tīpako "Home", ka kitea i te paeutauta "Pūtau", i roto i nei koutou pāwhiri i runga i te "Hōputu" icon. I roto i te rārangi taka-iho ki te kitea te taitara o "aritanga", e kei te "Huna whakaatu ranei" wahi tīpako "Huna raina."
• E hoatu ki te whakatutuki i te hua tere i roto i te Excel, he huinga o hotkeys, ki e taea e koe te huna tīwae mā te pēhi i rua pātene i runga i te papapātuhi. Te tohu i te tīwae o te pūtau e hiahia ana koe ki te huna, pēhi te pokatata papapātuhi: "Ctrl" + "0".

Ka rite ki a koutou e taea te kite, ki te tika, ki te matau me pehea ki te huna tīwae ki Excel, ki te ako kore he uaua tenei.

Hoki nga tīwae kitea

I muri huna e maha tīwae whakatika te pātai e pā ana ki te pehea, ki te whakatuwhera i te tīwae huna i roto i Excel. He tino ngāwari Hoki o te pūtau huna - ki ngā etahi awhe o ngā pūtau kei roto e rua tīwae, i waenganui i reira ko te huna, te mahi i te taua mahi rite i roto i to ratou huna i te wāhi mutunga whakahau "Whakaatu tīwae". I roto i te take o te whakamahi i te huinga hotkey he nui ki te pēhi: "Ctrl" + "Shift" + "0".

He aha atu taea te huna e koe?

I tua atu ki tīwae, faauru Excel te kaiwhakamahi ki te huna atu me ngā rārangi, me te te whārangi katoa. Hei whakaatu huna i te aho ranei, ko te mea e tika ana ki te mahi i roto i te ara ano, me pehea ki te huna me te pehea, ki te whakaatu i te tīwae huna i roto i Excel. Ko te rerekētanga anake ko te kōwhiringa o te pūwāhi mutunga whakahau "Huna Haupae" me "aho Whakaatu", me te pokatata paku whakarerekētia papapātuhi: "Ctrl" + "9" ki te huna me te "Ctrl" + "Shift" + "9" ki te whakaatu i te rārangi.

A, no te mahi ki te tukanga pepa ko ahua rerekē, i roto i te rite ki te pehea, ki te huna tīwae i Excel. Huna ranei whakaatu te rārangi, ka taea e koe te whakamahi i te ripa "Hōputu" mā te tīpako "Huna ranei whakaatu i te" whakahau "whārangi huna", i ki te whārangi e hiahiatia ana ki te huna. nui ki te mahi i te taua tukanga mo te hoki o te aritanga mā te tīpako "Whakaatu Rārangi" mā te tīpako i te matapihi e puta pepa e tika ana. taea hoki te mahi tenei i te pāwhiri matau i runga i te röpü, kei roto i te rārangi o ngā rārangi i reira ki te hanga i te wāhi pai rawa o huna whakaatu ranei.

Pū o te pūtau huna

Na roto i te mahara ki pehea ki te huna aho, me pehea ki te huna tīwae i Excel, ka taea e koe nui faaohie i tō mahi. Ko te painga o te pūtau huna he kore ratou o tā - te kupu e taea te ki waho i te raraunga putanga i runga i te pepa, e te hunga hira, i waho whakatika i te tuhinga. Ko tētahi atu painga, ko te ki te whakapiki ake i te pānui o te raraunga - i roto i tenei take, huna tīwae faufaa, kia tikanga ai raraunga whai kiko ana pātata ki tahi i te tahi.