ʻO ka manawa pinepine, i ka wā e hana pū ana me nā papa ma Microsoft Excel, pono ʻoe e helu i ka nui o kahi kolamu me ka ʻikepili. Penei, ma kēia ʻano hiki iā ʻoe ke helu i ka nui o ka waihona o ke kuhikuhi no kekahi mau lā, inā he lā nā lā o ka papa ʻaina, a i ʻole ka nui o nā ʻano o nā huahana. E ʻike mākou i nā ala like ʻole e hiki ai iā ʻoe ke hoʻohui i ka ʻikepili kolamu i kahi papahana a Microsoft Excel.
E nānā i ka nui huina
ʻO ke ala maʻalahi e nānā i ka huina o ka nui o ka ikepili, me nā data i loko o nā pū o ka kolamu, ʻo ka koho wale ʻana iā lākou me ka mea i poino ma ka kaomi ʻana ma ka pihi hema. I ka manawa like, hōʻike ʻia ka nui o nā cell i koho ʻia i loko o ka pae kūlana.
Akā, ʻaʻole e hoʻokomo ʻia kēia helu i ka papa, a mālama ʻia i kahi ʻē aʻe, a hāʻawi ʻia i ka mea hoʻohana wale no ka ʻike.
AutoSum
Inā makemake ʻoe e ʻike ʻole i ka huina o ka waihona kolamu, akā e komo nō hoʻi i loko o kahi papa i loko o kahi ʻāpana ʻē aʻe, a laila maʻalahi ke hoʻohana pono i ka hana auto-sum.
No ka hoʻohana ʻana i ka nui o ke kaʻa, koho i ke kelepona ma lalo o ka kolamu i makemake ʻia, a kaomi ma ka pihi "AutoSum" e kau ʻia ma ka lira i ka pā "Home".
Ma kahi o ka kaomi ʻana i ka pihi ma ka pahu, hiki iā ʻoe ke kāpae i ka puʻupuʻu pōkole ALT + =.
Hoʻomaopopo ʻili wale ʻo Microsoft Excel i nā ʻoihana kolamu i hoʻopiha ʻia me ka ʻikepili no ka helu ʻana a hōʻike i ka hopena i pau i ke kelepona i hōʻike ʻia.
E ʻike ai i ka hopena i hoʻopau ʻia, kaomi wale i ka pihi Enter i ka papa.
Inā nō i kū kekahi kumu āu i manaʻo ʻole, ʻaʻole i manaʻo pono i ka helu-i nā mea āpau āu e pono ai, a i ʻole ʻoe e helu pono i ka huina ʻaʻole i nā puʻupuʻu a pau o ka kolamu, hiki iā ʻoe ke kuhikuhi ponoʻī i ka nui o nā waiwai. No ka hana ʻana i kēia, e koho i ka nui o nā pihi i makemake ʻia i ka kolamu, a hopu i ka pūnohi mua i lalo i lalo. A laila, kaomi i ka pihi āpau "AutoSum".
E like me kāu e ʻike ai, hōʻike ʻia ka nui i loko o kahi nīpona ʻole, aia i lalo o ka kolamu.
AutoSum no nā kolamu he nui
ʻO ka huina no nā kolamu nui e hiki ke helu ma ka manawa like, a me ke kolamu hoʻokahi. ʻO ia, e koho i nā pona ma lalo o kēia mau kolamu, a kaomi ma ka pihi "AutoSum".
Akā he aha ka hana inā ʻike nā kolamu āu e makemake ai e kuhi ma kahi o kēlā me kēia? Ma kēia hihia, hoʻopaʻa i ka pā o ka Enter, a koho i nā ʻōnaehana ʻole i noho ma lalo o nā kolamu i makemake ʻia. A laila, kaomi i ka pihi "AutoSum", a i ʻole kaomi i ka hui pū me ALT + =.
Ma kahi koho, hiki iā ʻoe ke koho i ka laulā āpau i loko o ia mau papa e pono ai ʻoe e ʻike i ka nui, a me nā pūnaka hakahaka i lalo o lākou, a laila kaomi i ke pihi ma ka helu ʻehā.
E like me kāu e ʻike ai, ua helu ʻia ka nui o kēia mau kolamu.
Hoʻopuka haʻahaʻa
Eia kekahi, hiki ke hoʻopili pono i nā sel i kahi kolamu papa. ʻO kēia ala, ʻoiaʻiʻo, ʻaʻole maʻalahi loa e helu me ka helu ʻana ma o ka helu ʻemi, akā ma ka ʻaoʻao ʻē aʻe, hiki iā ia ke hōʻike i ka ʻike helu i ʻike ʻole ʻia i loko o nā puna i loaʻa i lalo o ka kolane, akā i nā mea ʻē aʻe i kū i ka waihona. Inā makemake ʻia, ʻo ka nui o ka helu i kēia ala hiki ke hōʻike ʻia ma kekahi ʻaoʻao o kahi puke hana Excel. Eia kekahi, i kēia ala hiki iā ʻoe ke helu i ka nui o nā sela ʻaʻole o ka kolamu āpau, akā nā mea wale nō i koho iā ʻoe iho. ʻOiai, ʻaʻole pono ia e neʻe i kēia mau pūlima.
E kaomi mākou i kekahi kelepona āu e makemake ai e hōʻike i ka nui, a hoʻokomo i ka inoa "=" i loko. A laila, hoʻokahi ma o ka mea a mākou e pākuʻi i kēlā mau sela o ka kolamu āu e makemake ai e hōʻino. Ma hope o ke komo ʻana i kēlā me kēia cell e pili ana, pono ʻoe e kaomi i ke kī "+". Hōʻike ʻia ka ʻano ʻōkuhi me ke olakino o kāu makemake, a ma ka pae hoʻohālike.
I kou komo ʻana i nā wahi o nā helu āpau, e hōʻike i ka hopena o ka huina, e kaomi ke pihi Enter.
No laila, ua nānā mākou i nā ala like ʻole o ka helu ʻana i ka nui o nā ikepili i nā kolamu ma Microsoft Excel. E like me kāu e ʻike ai, aia nā ala like ʻole ʻelua, akā ʻoi aku hoʻi i nā ala like ʻole, a me nā koho e pono ai i ka manawa hou aku, akā i ka manawa like e ʻae nā koho o nā kelepona kikoʻī no ka helu ʻana. ʻO ke ʻano e hana e pili ana i nā hana kikoʻī.
