Kapa mākou maʻamau i kēlā me kēia faila Excel he pāpalapala. Maikaʻi ka hoʻomaopopo ʻana ʻaʻole ʻokoʻa ka pāpalapala ma Excel me kahi pāpalapala. Hiki i ka papapalapala ma Excel ke maʻalahi i kekahi mau hana o kēlā me kēia lā iā ʻoe, ma ka home a ma kāu ʻoihana.
Ma kēia ʻatikala, e aʻo mākou iā ʻoe pehea e hoʻohana ai i kekahi mau manaʻo kumu o ka hāmeʻa.
He aha ka papapalapala ma Excel?
ʻO ka pepa haʻawina he papa wale nō i kahi faila Excel.
ʻIke paha ʻoe ʻo kekahi o nā mākau i koi nui ʻia i kēia mau lā i nā ʻoihana ʻo ka haku o Excel, akā hiki iā mākou ke hōʻoiaʻiʻo iā ʻoe ʻo ke aʻo ʻana i kāna mau hana āpau e pono ai kekahi manawa a ma luna o nā mea āpau.
No ka hana ʻana i nā pāpalapala ma Excel, inā ʻoe i loko o ka interface Excel, e hoʻokomo wale i kahi pā hou. Hiki iā ʻoe ke koho i ke koho e hoʻohana i ka pōkole keyboard Shift + F11 a i ʻole kaomi ma ka "+" ma hope o ka inoa o ka pepa haʻawina.
Pehea e hoʻokele ai ma waena o nā lau?
Loaʻa iā mākou kekahi mau ʻikepili a i ʻole nā ʻike ʻokoʻa, a pono e kau ʻia kēia mau mea ma nā ʻāpana like ʻole a i ʻole nā pāpalapala e hoʻomaʻamaʻa i ka hoʻonohonoho ʻana o ka hana. No ka hoʻokele ʻana ma waena o nā ʻaoʻao a i ʻole nā lau, hiki iā ʻoe ke kaomi hema ma kēlā me kēia pā e wehe ai, a i ʻole e hoʻohana i ka pōkole CTRL + PgDn e neʻe i mua a i ʻole CTRL + PgUp e hoʻi i hope.
Nui nā manawa āu e hoʻonui ai i nā papa like ʻole i nā pepa hana ʻokoʻa kahi i ʻokoʻa ai ka ʻikepili. He mea maʻamau kēia ʻano kūlana i waena o ka poʻe e hana me nā loiloi manawa (i kēlā me kēia lā, kēlā me kēia pule, kēlā me kēia mahina). No laila, he mea nui e ʻike pehea e hoʻonohonoho ai iā lākou i hiki ke maʻalahi i kekahi ʻike.
Pehea e hoʻopili ai i nā kala i ka pāpalapala?
I ka hana ʻana me nā ʻāpana/pepa he nui, hoʻokahi koho e hoʻokaʻawale i nā wahi pili, a i ʻole e ʻike maka i kēlā me kēia ʻano ʻikepili, ʻo ia ka hoʻohana ʻana i nā kala like ʻole no kēlā me kēia mea. No ka hana ʻana i kēia, hiki iā ʻoe ke kaomi ʻākau ma ka lālani, kolamu, a i ʻole ka hoʻonohonoho ʻana o nā cell, a laila kaomi ʻākau a koho i ka "fill color", a laila koho i ke kala āu e makemake ai no ka mea i nīnau ʻia.
Pehea e hoʻohui ai i nā pepa hana ma Excel?
Ma hope o ka hoʻokomo ʻana i kāu waihona i loko o nā pāpalapala, he mea hoihoi ia e hana i nā hana e like me ka huina o nā nui i hōʻike ʻia, ka helu ʻana o nā pākēneka e hoʻohana ʻia, a me nā ʻikepili ʻē aʻe he nui paha āu e pono ai, a me ka hui i loko o nā cell i kāu pāpalapala.
Ke pau ia, pono ʻoe e aʻo pehea e hana ai i nā formulas mai ka ʻikepili i loaʻa iā ʻoe. No ka laʻana, ʻo ka waiwai o nā huahana ma ka laina 1 o ka pepa hōʻuluʻulu o kahi mahiʻai ʻo ia ka huina o ka waiwai o nā huahana ma ka laina 1 o kēlā me kēia ʻikepili o ka hana a nā hui, a pēlā aku no ka ʻike pili. i kēlā me kēia lālani a me ke kolamu o kāu pepa mana.
Hiki iā ʻoe ke aʻo i ka hoʻohana ʻana i nā pakuhi a me nā pakuhi e wehewehe maikaʻi i kāu mau hopena. ʻO ke kumu o nā pakuhi, e like me ka inoa e hōʻike ai, ʻo ia ka hāʻawi ʻana i kahi hōʻike kiʻi o nā ʻikepili koʻikoʻi, no ka ʻike maikaʻi ʻana i nā hopena i loaʻa.
i ka hopena
Pehea kou manaʻo ke ʻike ʻoe he koi mua ʻo Excel no ka mākeke hana o kēia lā? Inā pilikia ʻoe i kekahi mau hana a ʻaʻole ʻoe ʻike pehea e hoʻohuli ai i ka ʻikepili i ʻike pili pono, mai hopohopo, hiki iā ʻoe ke aʻo pehea e hoʻohana pono ai iā Excel, a aia kekahi wikiō aʻo manuahi i helu ʻia ma kā mākou pūnaewele. Hele mai lākou mai nā kahua hoʻonaʻauao nui loa.
