Hiki ke loaʻa iā ʻoe kekahi.
I ka hana ʻana me kahi puke haʻawina nui ma Excel, ʻaʻole i ka manawa kupanaha loa ʻoe e hana i kahi mea ʻino ʻole (e hoʻohui i kahi lālani a i ʻole hoʻokomo ʻana i kahi ʻāpana nui o nā cell, no ka laʻana) a loaʻa koke ʻoe i kahi puka aniani me ka hewa "He nui nā cell like ʻole. formats”:
I kekahi manawa, hiki mai kēia pilikia ma kahi ʻano maikaʻi ʻole. I ka pō nei, e like me ka mea maʻamau, ua mālama ʻoe a pani i kāu hōʻike ma Excel, a i kēia kakahiaka ʻaʻole hiki iā ʻoe ke wehe iā ia - hōʻike ʻia kahi leka like a me kahi manaʻo e wehe i nā ʻano āpau mai ka faila. ʻAʻole lawa ka hauʻoli, ʻae? E nānā kākou i nā kumu a me nā ala e hoʻoponopono ai i kēia kūlana.
No ke aha mai kēia e hana nei
Loaʻa kēia hewa ke ʻoi aku ka puke haʻawina ma mua o ka helu kiʻekiʻe loa o nā palapala i hiki iā Excel ke mālama:
- no Excel 2003 a ʻoi aku - he 4000 kēia
- no Excel 2007 a me ka mea hou aku, he 64000 kēia
Eia kekahi, ʻo ke ʻano i kēia hihia ke ʻano o kahi hui like ʻole o nā koho formatting:
- hōʻike
- nā hoʻopiha
- ka hoʻopili ʻana i ke kelepona
- ʻano helu
- hōʻano kūlana
No laila, no ka laʻana, inā ʻoe i hana i kahi ʻāpana liʻiliʻi o ka pepa e like me kēia:
... a laila e hoʻomanaʻo ʻo Excel i 9 mau ʻano kelepona ʻokoʻa i loko o ka puke hana, ʻaʻole 2, e like me ka mea i ʻike mua ʻia, no ka mea, e hoʻokumu ʻia kahi laina mānoanoa a puni ka perimeter, ʻoiaʻiʻo, 8 mau koho hoʻohālikelike ʻokoʻa. E hoʻohui i kēlā mea hoʻolālā hula me nā font a me ka hoʻopiha, a ʻo ka makemake i ka nani i kahi hōʻike nui e alakaʻi i nā haneli a me nā tausani o nā hui like ʻole e hoʻomanaʻo ai ʻo Excel. ʻAʻole emi ka nui o ka faila mai ia mea.
Hiki mai kekahi pilikia like ke kope mau ʻoe i nā ʻāpana mai nā faila ʻē aʻe i kāu puke haʻawina (no ka laʻana, i ka wā e hui pū ai i nā pepa me kahi macro a lima paha). Inā ʻaʻole i hoʻohana ʻia kahi paʻi kūikawā o nā waiwai wale nō, a laila hoʻokomo pū ʻia nā ʻano o nā pae i kope ʻia i loko o ka puke, e alakaʻi wikiwiki ana i ka palena.
Pehea e hana ai
Aia kekahi mau kuhikuhi maanei:
- Inā loaʻa iā ʻoe kahi faila o ke ʻano kahiko (xls), a laila e hoʻopaʻa hou i kahi faila hou (xlsx a i ʻole xlsm). E hoʻokiʻekiʻe koke kēia i ka pahu mai 4000 a 64000 mau ʻano like ʻole.
- Wehe i ka hoʻopololei kelepona ʻē aʻe a me nā "mea nani" me ke kauoha Home — Clear — Hoʻomaʻemaʻe i nā ʻano (Home — Hoʻomaʻemaʻe — Hoʻomaʻamaʻa ʻia). E nānā inā loaʻa nā lālani a i ʻole nā kolamu ma nā ʻaoʻao i hoʻohālikelike ʻia (ʻo ia hoʻi, i ka hope o ka pepa). Mai poina e pili ana i nā lālani huna a me nā kolamu.
- E nānā i ka puke no nā pepa huna a huna nui - i kekahi manawa ua hūnā ʻia nā "masterpieces" ma luna o lākou.
- Wehe i ka hōpili kūlana makemake ʻole ma kahi pā Home — Hoʻoponopono Kūlana — Manage Rules — Hōʻike i nā Rula Hoʻoponopono no ka Pepa holoʻokoʻa (Home — Hōʻuluʻulu Kūlana — Hōʻike i nā lula no kēia pepa haʻawina).
- E nānā inā ua hōʻiliʻili ʻoe i ka nui o nā ʻano pono ʻole ma hope o ke kope ʻana i ka ʻikepili mai nā puke hana ʻē aʻe. Inā ma ka pā Home (Home) Ma ka papa inoa Styles (Nā ʻano) ka nui o ka "'ōpala":
… a laila hiki iā ʻoe ke hoʻopau iā ia me kahi macro liʻiliʻi. Kaomi Alt + F11 a i ʻole pihi Ke kākoʻo XIX. uku pila mea haku polokalamu (Ka mea hoʻomohala), e hoʻokomo i kahi module hou ma o ka papa kuhikuhi Hoʻokomo - Module a kope i ka code macro ma laila:
Sub Reset_Styles() 'e wehe i nā ʻano pono ʻole no kēlā me kēia objStyle Ma ActiveWorkbook.Styles On Error Resume Next Inā ʻAʻole objStyle.BuiltIn A laila objStyle.Delete On Error GoTo 0 Next objStyle 'kope i ka hoʻonohonoho maʻamau o nā styles mai ka puke hana hou = Active SetWowbbook E hoʻonoho i ka wbNew = Nā puke hana. Hoʻohui i ka wbMy.Styles.Merge wbNew wbNew.Close savechanges:=False End Sub
Hiki iā ʻoe ke hoʻomaka iā ia me kahi pōkole keyboard. Alt + F8 a i ʻole ma ke pihi macros (Macros) uku pila mea haku polokalamu (Ka mea hoʻomohala). E hoʻoneʻe ka macro i nā kaila i hoʻohana ʻole ʻia, e waiho wale ana i ka hoʻonohonoho maʻamau:
- Pehea e hoʻokalaka ʻokoʻa ai i nā kelepona me ka hoʻohālikelike kūlana ma Excel
- He aha nā macros, kahi a pehea e kope ai i ka code macro ma Visual Basic, pehea e holo ai
- Ua lilo ka puke hana Excel i mea kaumaha a lohi - pehea e hoʻoponopono ai?