Inā wehe ʻoe iā Excel a ʻike koke ʻoe aia nā helu ma nā poʻomanaʻo kolamu ma kahi o nā leka maʻamau, mai hoʻonāwaliwali a heluhelu i kēia ʻatikala a hiki i ka hopena! Ma kēia haʻawina, e aʻo ʻoe pehea e hoʻololi ai i nā helu i nā leka ma nā kolamu, a e kamaʻāina pū me nā ʻano loulou ma Microsoft Excel.
He aha ke ʻano loulou?
Hana ʻia kēlā me kēia pepa Excel i nā lālani a me nā kolamu. I ka hapanui o nā hihia, hōʻike ʻia nā kolamu e nā leka (A, B, C) a hōʻike ʻia nā lālani e nā helu (1, 2, 3). Ma Excel kapa ʻia kaila loulou A1. Eia naʻe, makemake kekahi e hoʻohana i kahi ʻano ʻokoʻa, kahi i helu ʻia ai nā kolamu. Ua kapa ʻia R1C1 kaila loulou.
Hiki ke hoʻohana ʻia ke ʻano loulou R1C1 i kekahi mau kūlana, akā e like me ka hōʻike ʻana i ka hana, he mea laʻa kēia. Aia kekahi pūʻulu o nā mea hoʻohana makemake e hana me kēia ʻano loulou, akā naʻe, ʻaʻole lākou he mea hou. I ka hapanui o nā hihia, e hana ʻoe me ke ʻano loulou A1, i hoʻokomo ʻia ma Microsoft Excel ma ke ʻano maʻamau.
Hoʻohana kēia kumu aʻo a me nā haʻawina āpau ma kēia pūnaewele i ke ʻano loulou A1. Inā ʻoe e hoʻohana nei i ke ʻano loulou R1C1, pono ʻoe e hoʻopau iā ia.
E hoʻā a hoʻopau i ke ʻano loulou R1C1
- E kaomi i ka File, E nee aku i nānā i hope.
- Press kiko'î.
- I ka pahu kamaʻilio e kū mai ana Nā koho Excel E koho i kahi ʻāpana haʻilula. E nānā i ka pahu R1C1 kaila loulou a ua pilikia OK. E hoʻololi ʻo Excel i ke ʻano loulou R1C1.
E like me kāu i manaʻo ai, e hoʻi i ke ʻano loulou A1, ua lawa ka wehe ʻana i kēia pahu.