Contents
Ke hana mākou i nā ʻike he nui, ʻaʻole ia he mea maʻamau no mākou e ʻōwili i nā papa inoa lōʻihi. No ka ʻike ʻana i nā lālani mua, aia kahi hiʻohiʻona i kapa ʻia ʻo pinning rows. ʻAe kēia iā ʻoe e hoʻomaopopo, no ka laʻana, ʻo ke ʻano o ka ʻāpana o ke kelepona, me ka ʻole o ka pono e kaomi hou i ka pepa. ʻO ia ka mea hiki ke pili i nā kolamu o ka pākaukau. Hana ʻia ka hoʻoponopono ʻana i nā wahi ma o ka pā a i ʻole ka papa kuhikuhi "Nānā", e pili ana i ka mana o ke keʻena suite i hoʻohana ʻia.
Akā ma hope a ma hope paha, ke alo nei ka mea hoʻohana i ka pono e wehe i ka hoʻopaʻa ʻana o nā laina. No nā kumu like ʻole paha kēia. No ka laʻana, ua hana ʻia ka hoʻoponopono ʻana no nā hana ʻenehana. Ma hope o ka pau ʻana o ka hana ma ka papaʻaina, ʻaʻole pono ke pine. I kēia hihia, pono ʻoe e wehe iā ia.
Pehea e wehe ai i kahi lālani ma Excel
No laila, he aha ka mea e hana ai e wehe i kahi lālani i nā mana hou o Excel? Pono mua ʻoe e ʻimi i ka pā "View" ma ka papa nui a kaomi iā ia me ka ʻiole. Ma luna o ka lipine, hiki iā ʻoe ke ʻike i ke pihi like a mākou i hoʻopaʻa mua ai i nā wahi. Pono ʻoe e kaomi ma luna. E hōʻike ʻia kahi papa kuhikuhi pop-up. Aia kahi pihi "Wehe i nā wahi". Ma hope o kā mākou kaomi ʻana, wehe ʻia kā mākou mau laina.
ʻOkoʻa ke kaʻina hana maʻamau ma muli o ka mana o Excel e hoʻohana ai kekahi kanaka. I ka makahiki 2003, ua maʻalahi kēia, i ka makahiki 2007 a ʻoi aku ka paʻakikī.
Pehea e wehe ai i kahi kolamu ma Excel
ʻO ka mīkini no ka wehe ʻana i kahi kolamu ma Excel ua like loa me ka mea i hoʻohana ʻia no nā lālani. Pēlā nō, pono mākou e ʻimi i ka ʻaoʻao "View" ma ka papa Excel nui, a laila ʻike mākou i ka ʻāpana "Window" ma laila a kaomi i ka pihi like ma luna (kahi i wehe ai mākou i ka hoʻopaʻa ʻana o nā laina). A hana ʻia nā kolamu unfreezing e like me nā lālani - ma o ke pihi "Unfreeze regions".
Pehea e wehe ai i kahi wahi i hoʻopaʻa ʻia ma kahi pāpalapala Excel
Inā ua hoʻopaʻa mua ʻia kahi ʻāpana holoʻokoʻa, a laila ʻaʻole paʻakikī ka wehe ʻana. No ka hana ʻana i kēia, e hahai i ke ʻano o nā hana i hōʻike ʻia ma luna. Hiki ke ʻokoʻa ke kaʻina pololei o nā ʻanuʻu ma muli o ka mana o Excel, akā like ka loina. No ka laʻana, i ka mana 2007 a me ka mea hou aku, ua hoʻokō ʻia kēia kaʻina hana ma o ka hāmeʻa, i kapa pinepine ʻia ʻo ka lipine.
A ma ka mana 2003, ua hana ʻia kēia ma kahi ʻano ʻokoʻa iki, a mākou e kūkākūkā nui ai ma lalo nei.
Pono e hoʻomanaʻo ʻaʻole hāʻawi nā mana haʻahaʻa o Excel i ka hiki ke hoʻokuʻu a wehe i nā lālani a me nā kolamu. Inā ʻike koke ʻia ʻaʻole kēia koho ma ka lipine ma kahi kūpono, mai makaʻu. Pono paha ʻoe e uku no kahi papahana pāpalapala ʻoi aku ka holomua.
Kūlike ʻole i ka manaʻo nui, ʻaʻole e hoʻoponopono i ka pilikia i ka wā lōʻihi ke kūʻai ʻana i kahi mana pirated. ʻO ka mea, hiki ke hoʻohana ʻia nā polokalamu laikini ma ka wahi hana me ka pilikia ʻole o ka pilikia me ke kānāwai. Eia kekahi, nānā mau ʻo Microsoft i nā polokalamu a nā mea hoʻohana e hoʻohana ai no ka loaʻa ʻana o nā kī kī. Inā ʻike ʻia kēlā ʻoiaʻiʻo, nalowale ka hoʻāla ʻana.
Pehea e wehe ai i nā lālani a me nā kolamu
Makemake pinepine nā mea hoʻohana i nā mea hiki ke hana e wehe i nā kolamu a me nā lālani i hoʻopaʻa mua ʻia. Hiki ke hana i kēia me hoʻokahi hana maʻalahi. Eia kekahi, e kāhāhā maoli ke ʻano o nā hana me kona maʻalahi. No laila he aha kā mākou e hana ai?
ʻO ka mea mua, wehe i ka palapala Excel i makemake ʻia. Ma hope o kēlā, wehe i ka pā "View", a ma laila e ʻike ai i ka ʻāpana "Window". A laila, ʻike ʻoe i ka ʻāpana "Lock Panes" āu i ʻike mua ai.
Ma hope o kēlā, e kaomi wale i ka pihi "Unpin areas". E like me kāu e ʻike ai, ua like loa nā hana me nā mea mua.
Pehea e wehe ai i nā kelepona ma Excel 2003
He polokalamu kaulana ʻo Excel 2003 i makemake ʻole ka poʻe e hoʻonui i ka mana hou a me ka hana 2007. I kēia manawa, ʻoi aku ka maikaʻi o ke kūlana, ʻoi aku ka maʻalahi o ka mea hoʻohana maʻamau. No laila, ʻaʻole intuitive ke kikowaena o ka mana 2003 o ka pāpalapala.
No laila, nui ka poʻe e noʻonoʻo nei i ka mea e hiki ke hana i mea e wehe ai i nā cell ma Excel 2003 version?
ʻO ke kaʻina o nā hana penei:
- E wehe i ka papa kuhikuhi Window.
- Kaomi ma ka pihi "Unpin areas".
E like me kāu e ʻike ai, ʻike maopopo ʻia ke kumu i kaulana loa ai ka mana 2003 o Excel. Ua lawa wale ka hana ʻana i ʻelua kaomi me ka pihi ʻiole hema, a ua hana ʻia ka hana i makemake ʻia. No ka hana ʻana i kahi hana like ma Excel 2007, pono ʻoe e hana i 3 kaomi. Me he mea lā he mea liʻiliʻi, akā inā pono ʻoe e hana mau i kēia mau hana, a laila hoʻohui kēia mau kekona i nā hola. Eia kekahi, ʻo ka wati maoli ʻaʻole ia he metaphor. He maʻalahi ka helu. Ma kekahi mau hiʻohiʻona, ʻoi aku ka maʻalahi o ka interface Excel hou, akā ma ia mau ʻano ʻaʻole ia e honi e like me ka ergonomics.
Ma keʻano laulā, ua neʻe iki mākou mai ke kumuhana. E kamaʻilio hou kākou e pili ana i ka holoi ʻana i kahi wahi i hoʻopaʻa ʻia. ʻOi aku ka pololei, e hōʻuluʻulu mākou i ka mea i ʻike mua ʻia.
Wehe i kahi wahi paʻa
No laila, ua maopopo iā mākou pehea e wehe ai i ka wahi i hoʻopaʻa ʻia. No ka hana ʻana i kēia, e hoʻohana i ka papa kuhikuhi "View", aia ma Excel 2003 i ka papa kuhikuhi pop-up ma lalo pono o ka pahu poʻo inoa, a ma nā ʻano kahiko - ma kahi pā kūikawā me ka inoa like.
Ma hope o kēlā, pono ʻoe e koho i ka mea "Freeze areas", a laila kaomi i ka "Unfreeze areas" a i ʻole kaomi koke i kēia pihi (ʻo ke koho hope ke ʻano maʻamau no nā mana kahiko o ka interface Excel).
Ma hope o kēlā, e hoʻoneʻe ʻia ka pinning o nā cell. He mea maʻalahi loa nā mea a pau, ʻaʻole pili i ka nui o nā kaomi hiki iā ʻoe ke hana.