Nā Pepa huna ma Excel: Pehea e hōʻike ai a hūnā paha

Ma Excel, hiki i ka mea hoʻohana ke hana a hana i kekahi mau pepa i ka manawa hoʻokahi. A i kekahi manawa, no nā kumu like ʻole, pono paha e hūnā i kekahi o lākou. No ka laʻana, ma ka nānā ʻana i ka makemake e hūnā i ka ʻike waiwai mai ka prying eyes, hiki ke hūnā a loaʻa, e ʻōlelo, waiwai kūʻai. A i ʻole, makemake wale ka mea hoʻohana e pale iā ia iho mai nā hana kuʻuna me ka ʻikepili ma kahi pepa pono ʻole e hoʻopā ʻia.

No laila, pehea e hūnā ai i kahi pepa ma Excel? ʻElua ala e hana ai i kēia. E nānā kākou i kēlā me kēia o lākou.

Pehea e hūnā ai i kahi pepa ma o ka papa kuhikuhi

ʻO kēia ke ala maʻalahi a wikiwiki hoʻi e hūnā i kahi pepa, i hana ʻia ma nā ʻanuʻu 2 wale nō.

1. No ka hana ʻana i kēia, pono mākou e kāhea i ka papa kuhikuhi ma ke kaomi ʻana i ka pepa i makemake ʻia.
2. E koho i "Hūnā" mai ka papa inoa i hōʻike ʻia.
3. ʻO kaʻoiaʻiʻo,ʻo ia wale nō. Ua hūnā ʻia ka pepa i makemake ʻia.

Peʻe me ka hoʻohana ʻana i nā mea hana polokalamu

ʻO kahi ala kaulana ʻole, akā naʻe, ʻaʻole nui ka ʻike e pili ana iā ia.

1. ʻO ka mua, koho i ka pepa āu e makemake ai e hūnā.
2. E hele i ka ʻaoʻao "Home", e kaomi i ka mea hana "Cells", i nā koho i ʻike ʻia, koho i ka "Format".
3. Ma ka papa inoa e wehe ana, koho "Hūnā a hōʻike" a laila "Hūnā pepa".

   

4. E hūnā ʻia ka pepa i koho ʻia.

'Ōlelo Aʻo: inā ʻae nā ana o ka puka makani me ka polokalamu Excel, e hōʻike koke ʻia ke pihi "Format" ma ka ʻaoʻao "Home", e kāʻalo ana i ka pahu hana "Cells".

Pehea e hūnā ai i nā lau he nui

ʻO ke kaʻina hana no ka hūnā ʻana i kekahi mau lau, ʻoiaʻiʻo, ʻaʻole ʻokoʻa i nā mea i hōʻike ʻia ma luna. Eia naʻe, ma mua o ka hoʻomau ʻana me ia, pono ʻoe e koho i nā ʻāpana āpau e hūnā ʻia.

1. Inā hoʻonohonoho ʻia nā lau i ka lālani, hiki mai ke kī Shift. E koho i ka pepa mua, e paʻa i lalo i ke kī Shift, a me ka wehe ʻole ʻana, kaomi ma ka pepa hope, a laila e hoʻokuʻu i ke kī. Hiki ke hoʻokō ʻia ke koho ʻana ma ka ʻaoʻao ʻē aʻe - mai ka hope a i ka mua. Ma keʻano maʻamau, ke kamaʻilio nei mākou e pili ana i ka pepa mua a me ka hope e pono e hūnā.
2. Inā ʻaʻole i hoʻonohonoho ʻia nā lau e hūnā ʻia i ka lālani, pono e koho ʻia me ke kī Ctrl (Cmd - no macOS). Hoʻopaʻa mākou i lalo a kaomi hema i nā pepa āpau e pono e hūnā. Hiki iā ʻoe ke hoʻokuʻu i ke kī Ctrl.
3. Ua koho mākou i nā pepa āpau e pono ai, i kēia manawa hiki iā ʻoe ke hūnā iā lākou me ka hoʻohana ʻana i kekahi o nā ala i manaʻo ʻia ma mua. E like ana ka hopena.

Panina

No laila, ua noʻonoʻo mākou pehea e hūnā ai i nā pepa ma Excel i ʻelua ala. Ma waho o ka mea āu e koho ai, ʻike ʻia ka pono o kēia hana i kekahi mau hihia, no laila e kōkua ka ʻike a me ka hiki ke hoʻohana i nā mea hoʻohana e hana pinepine me ka papahana ma mua o hoʻokahi manawa.