Contents
ʻO kahi pōmaikaʻi nui o nā pāpalapala Excel ʻo ia ka mea hiki ke hana me ka mea hoʻohana me hoʻokahi pepa a me kekahi. ʻO kēia ka mea e hiki ai ke hoʻonohonoho i ka ʻike me ka maʻalahi. Akā i kekahi manawa hiki ke hele mai me kekahi mau pilikia. ʻAe, aia nā ʻano kūlana āpau, aia paha ka ʻike e pili ana i nā waiwai kālā koʻikoʻi a i ʻole kekahi ʻano mea huna kālepa i hūnā ʻia mai nā mea hoʻokūkū. Hiki ke hana i kēia me nā mea hana maʻamau Excel. Inā hūnā ka mea hoʻohana i ka pepa, a laila e noʻonoʻo mākou i ka mea e hana ai e hōʻike ai. No laila, he aha ka mea e pono ai e hana i ka hana mua a me ka lua?
ʻO kēia kaʻina hana ka maʻalahi loa e hoʻokō no ka mea aia ʻelua mau ʻanuʻu.
- Pono mua mākou e kāhea i ka papa kuhikuhi. No ka hana ʻana i kēia, pono ʻoe e kaomi ʻākau a kaomi paha me nā manamana lima ʻelua ma ka trackpad, ma hope o ka neʻe ʻana i ka cursor i kahi āu e makemake ai. Kākoʻo ʻia ke koho hope loa e kāhea i ka papa kuhikuhi pōʻaiapili e nā kamepiula hou, ʻaʻole nā mea āpau. Eia naʻe, kākoʻo ka hapa nui o nā ʻōnaehana hana hou iā ia, no ka mea ʻoi aku ka maʻalahi ma mua o ke kaomi wale ʻana i kahi pihi kūikawā ma ka trackpad.
- Ma ka papa kuhikuhi i hōʻike ʻia, e ʻimi i ka pihi "Hūnā" a kaomi ma luna.
ʻO nā mea a pau, ʻaʻole e hōʻike ʻia kēia pepa.
Pehea e hūnā ai i kahi pepa ma Excel me nā mea hana
ʻAʻole kaulana kēia ala e like me ka mea ma mua. Eia nō naʻe, aia kahi mea e hiki ai, no laila maikaʻi ke ʻike e pili ana. Aia kekahi mau mea e hana ai ma aneʻi:
- E nānā inā aia ʻoe ma ka pā "Home" a i ʻole ma kahi ʻē aʻe. Inā wehe ʻia kahi papa ʻē aʻe o ka mea hoʻohana, pono ʻoe e neʻe i ka "Home".
- Aia kekahi mea "Cells". Pono ʻoe e kaomi i ke pihi pili. A laila e puka mai ana ʻekolu mau pihi hou, kahi a mākou e makemake ai i ka ʻaoʻao ʻākau loa (i kau inoa ʻia ʻo "Format").
- Ma hope o kēlā, hōʻike ʻia kahi papa inoa ʻē aʻe, kahi ma ka waena e loaʻa kahi koho "Hūna a hōʻike". Pono mākou e kaomi ma luna o "Hūnā pepa".
- Ma hope o ka pau ʻana o kēia mau ʻanuʻu, e hūnā ʻia ka pepa mai nā maka o nā poʻe ʻē aʻe.
Inā ʻae ka puka aniani i kēia, a laila e hōʻike pololei ʻia ke pihi "Format" ma ka lipine. ʻAʻole e kaomi ʻia ma ke pihi "Cells" ma mua o kēia, ʻoiai he poloka ia o nā mea hana.
ʻO kekahi mea hana e hiki ai iā ʻoe ke hūnā i kahi pepa i kapa ʻia ʻo Visual Basic Editor. I mea e wehe ai, pono ʻoe e kaomi i ka hui pū Alt + F11. Ma hope o kēlā, kaomi mākou i ka pepa hoihoi iā mākou a nānā i ka puka makani waiwai. Makemake mākou i ke koho ʻike ʻia.
ʻEkolu mau koho no ka hoʻopilikino ʻana i ka hōʻike pepa:
- Hōʻike ʻia ka palapala. Hōʻike ʻia e ke code -1 ma ke kiʻi ma luna.
- ʻAʻole i hōʻike ʻia ka pepa, akā hiki ke ʻike ʻia ma ka papa inoa o nā lau huna. Hōʻike ʻia e ke code 0 i ka papa inoa o nā waiwai.
- Huna ikaika loa ka lau. He hiʻohiʻona kūikawā kēia o ka mea hoʻoponopono VBA e hiki ai iā ʻoe ke hūnā i kahi pepa i ʻole e ʻike ʻia ma ka papa inoa o nā pepa huna ma o ka pihi "Show" ma ka papa kuhikuhi.
Eia kekahi, hiki i ka mea hoʻoponopono VBA ke hoʻololi i ke kaʻina hana ma muli o nā waiwai, ma ke ʻano he koho, i loko o nā cell a i ʻole nā hanana e hiki mai ana.
Pehea e hūnā ai i nā lau he nui i ka manawa hoʻokahi
ʻAʻohe ʻokoʻa koʻikoʻi ma waena o ka hūnā ʻana ma mua o hoʻokahi pepa i ka lālani a i ʻole pehea e hūnā ai i kekahi o lākou. Hiki iā ʻoe ke hūnā iā lākou ma ke ʻano i wehewehe ʻia ma luna. Inā makemake ʻoe e mālama i kahi manawa liʻiliʻi, aia kekahi ala ʻē aʻe. Ma mua o kou hoʻokō ʻana, pono ʻoe e koho i nā ʻāpana āpau e pono e hūnā. Hana i kēia kaʻina hana e wehe i kekahi mau pepa mai ka ʻike ʻana i ka manawa like:
- Inā pili lākou kekahi i kekahi, pono mākou e hoʻohana i ke kī Shift e koho iā lākou. No ka hoʻomaka ʻana, kaomi mākou i ka pepa mua, a laila kaomi a paʻa i kēia pihi ma ka papa keyboard, a laila kaomi i ka ʻaoʻao hope o nā mea e pono ai mākou e hūnā. Ma hope o kēlā, hiki iā ʻoe ke hoʻokuʻu i ke kī. Ma keʻano laulā, ʻaʻohe ʻokoʻa i ke ʻano o ka hana ʻana i kēia mau hana. Hiki iā ʻoe ke hoʻomaka mai ka mea hope, paʻa i lalo Shift, a laila hele i ka mea mua. No ka hoʻokō ʻana i kēia ʻano, pono ʻoe e hoʻonohonoho i nā ʻāpana e hūnā ʻia ma kahi kokoke i kekahi me ka huki wale ʻana i ka ʻiole.
- Pono ke ala ʻelua inā ʻaʻole pili nā lau i kekahi i kekahi. E lōʻihi iki ana. No ke koho ʻana i kekahi ma kahi mamao mai kekahi i kekahi, pono ʻoe e kaomi i ka pepa mua, a laila koho i kēlā me kēia me ke kī Ctrl. Ma keʻano maʻamau, pono e hoʻomauʻia, a no kēlā me kēia pepa, e hana i hoʻokahi kaomi me ka pihiʻiole hema.
Ke hoʻopau mākou i kēia mau ʻanuʻu, ua like nā ʻanuʻu aʻe. Hiki iā ʻoe ke hoʻohana i ka papa kuhikuhi pōʻaiapili a hūnā i nā ʻaoʻao a i ʻole e ʻimi i ke pihi pili ma ka hāmeʻa.
Nui nā ala e hōʻike ai i nā pepa huna ma Excel. ʻO ka maʻalahi loa o lākou ʻo ka hoʻohana ʻana i ka papa kuhikuhi pōʻaiapili like me ka hūnā ʻana. No ka hana ʻana i kēia, pono ʻoe e kaomi i kekahi o nā lau i koe, kaomi ʻākau me ka ʻiole (a i ʻole e hoʻohana i ke ʻano trackpad kūikawā inā ʻoe mai kahi kamepiula hou) a loaʻa i ka pihi "Show" i ka papa inoa i hōʻike ʻia. Ma hope o kā mākou kaomi ʻana, e ʻike ʻia kahi puka me kahi papa inoa o nā pepa huna. E hōʻike ʻia inā hoʻokahi wale nō pepa. 
Inā hana ʻia ka hūnā me ka macro, a laila hiki iā ʻoe ke hōʻike i nā ʻāpana āpau i hūnā ʻia me kahi code liʻiliʻi.
Sub OpenAllHiddenSheets()
Pepa Pohihihi e like me ka Pepa Hana
No kēlā me kēia Pepa Ma ActiveWorkbook.Pepa Hana
Inā Sheet.Visible <> xlSheetVisible A laila
Sheet.Visible = xlSheetVisible
Hoʻopau Inā
Aʻe
Ka pau 'iiaciiie
I kēia manawa, e holo wale ana kēia macro, a e wehe koke ʻia nā pepa huna a pau. ʻO ka hoʻohana ʻana i nā macros kahi ala maʻalahi e hoʻokaʻawale i ka wehe ʻana a me ka hūnā ʻana o nā lau ma muli o nā hanana i hana ʻia i ka papahana. Eia kekahi, me ka hoʻohana ʻana i nā macros, hiki iā ʻoe ke hōʻike i ka nui o nā lau i ka manawa. He mea maʻalahi ke hana i kēia me ke code.