Pūnaewele ma Excel - nā manaʻo kumu

ʻO ke kelepona ma Excel ka mea hoʻokumu nui o kahi pepa kahi e hiki ai iā ʻoe ke hoʻokomo i ka ʻikepili a me nā ʻike ʻē aʻe. Ma kēia haʻawina, e aʻo mākou i nā kumu o ka hana ʻana me nā cell a me kā lākou mau mea i mea e hana ai i ka helu ʻana, ka nānā ʻana a me ka hoʻonohonoho ʻana i ka ʻikepili ma Excel.

Hoʻomaopopo i nā Pūnaewele ma Excel

Hana ʻia kēlā me kēia pepa haʻawina ma Excel i mau kaukani ʻāpana ʻāpana i kapa ʻia nā cell. ʻO ke kelepona ka hui ʻana o kahi lālani a me kahi kolamu. Hōʻike ʻia nā kolamu ma Excel e nā leka (A, B, C), aʻo nā lālani e hōʻike ʻia e nā helu (1, 2, 3).

Ma muli o ka lālani a me ke kolamu, hāʻawi ʻia kēlā me kēia cell i Excel i kahi inoa, ʻike ʻia hoʻi he helu wahi. No ka laʻana, ʻo C5 ke kelepona aia ma ke kikowaena o ke kolamu C a me ka lālani 5. Ke koho ʻoe i kahi kelepona, hōʻike ʻia kona helu wahi ma ka kahua Name. E ʻoluʻolu, i ka wā e koho ʻia ai kahi cell, e hōʻike ʻia nā poʻomanaʻo o ka lālani a me ke kolamu ma ka ʻaoʻao o ia mea.

Hiki iā Microsoft Office Excel ke koho i nā pūnaewele he nui i ka manawa hoʻokahi. Ua kapa ʻia kahi pūʻulu o ʻelua a ʻoi aku paha he laulā. ʻO kēlā me kēia laulā, e like me ke kelepona, loaʻa iā ia kona wahi ponoʻī. I ka hapanui o na hihia, aia ka helu wahi o ka laula me ka helu wahi o na keena akau o luna a me lalo, i hookaawaleia e ke kiko. Kapa ʻia kēlā ʻano laulā he contiguous a hoʻomau paha. No ka laʻana, e kākau ʻia kahi laulā i loaʻa nā cell B1, B2, B3, B4, a me B5 e like me B1:B5.

Hōʻike ka kiʻi ma lalo nei i ʻelua mau pūlima like ʻole:

• Kaulana A1:A8
• Kaulana A1:B8

Inā hōʻike ʻia nā kolamu ma ka pepa haʻawina e nā helu ma mua o nā leka, pono ʻoe e hoʻololi i ke ʻano loulou paʻamau ma Excel. No nā kikoʻī, e nānā i ka haʻawina: He aha ke ʻano o nā loulou ma Excel.

E koho i nā pūnaewele ma Excel

No ka hoʻokomo ʻana i ka ʻikepili a i ʻole ka hoʻoponopono ʻana i nā ʻike o kahi kelepona, pono ʻoe e koho mua iā ia.

1. Kaomi ma kahi kelepona e koho ai.
2. E palena ʻia ke kelepona i koho ʻia a e hōʻike ʻia ke kolamu a me nā poʻomanaʻo lālani. E koho ʻia ke kelepona a hiki i kou koho ʻana i kekahi kelepona ʻē aʻe.

Hiki iā ʻoe ke koho i nā cell me ka hoʻohana ʻana i nā kī pua ma kāu kīpē (nā kī pua).

E koho i ka laulā o nā cell ma Excel

I ka hana ʻana me Excel, pono pinepine e koho i kahi hui nui o nā cell a i ʻole kahi ākea.

1. E kaomi ma luna o ke kelepona mua ma ka laulā a, me ka wehe ʻole ʻana i ke pihi, e hoʻoneʻe i ka ʻiole a hiki i ke koho ʻia ʻana o nā cell pili āu e makemake ai e koho.
2. E hoʻokuʻu i ke pihi ʻiole, e koho ʻia ka laulā i makemake ʻia. E koho ʻia nā cell a hiki i kou koho ʻana i kekahi kelepona ʻē aʻe.