Contents
Ma kēia ʻatikala, e wehewehe wau i ke kumu e wehe ai i nā lālani blank ma Excel me ka hoʻohana ʻana e hōʻike i nā pūnaewele hakahaka > kāpae laina He manaʻo maikaʻi ʻole, a e hōʻike wau iā ʻoe i 2 ala wikiwiki a pololei e wehe ai i nā laina hakahaka me ka luku ʻole i ka ʻikepili. Hana kēia mau ʻano hana ma Excel 2013, 2010, a me nā mana kahiko.
Inā ʻoe e heluhelu nei i kēia ʻatikala, a laila e hana mau ana ʻoe ma Excel me nā papa nui. Ua ʻike ʻoe aia nā lālani hakahaka i kēlā me kēia manawa ma waena o ka ʻikepili, e kaupalena ana i ka hana o ka hapa nui o nā mea paahana Excel (kau ʻana, wehe i nā kope, subtotals, a pēlā aku), e pale ana iā lākou mai ka hoʻoholo pololei ʻana i ka laulā o ka ʻikepili. A i kēlā me kēia manawa pono ʻoe e wehewehe lima i nā palena, inā ʻaʻole he hopena kūpono ʻole ka hopena a nui ka manawa e hoʻopau ai i ka hoʻoponopono ʻana i nā hewa.
Nui nā kumu e puka mai ai nā laina hakahaka. No ka laʻana, ua loaʻa iā ʻoe kahi puke hana Excel mai kekahi kanaka ʻē aʻe a i ʻole ma muli o ka lawe ʻia ʻana mai kahi waihona ʻikepili hui, a i ʻole ka ʻikepili pono ʻole i nā lālani i holoi lima ʻia. ʻO kēlā me kēia hihia, inā ʻo kāu pahuhopu e wehe i kēlā mau laina hakahaka a loaʻa kahi papaʻaina maʻemaʻe a maʻemaʻe, a laila e hahai i nā pae maʻalahi ma lalo nei:
Mai holoi i nā lālani hakahaka me ke koho cell blank
Ma ka pūnaewele puni honua, e ʻike ʻoe i kahi ʻōlelo maʻalahi i manaʻo ʻia e ʻae iā ʻoe e wehe i nā laina hakahaka:
- E koho i ka ʻikepili mai ka mua a i ka cell hope.
- Press F5e wehe i ke kamaʻilio E hele (Hoʻololi).
- I ka pahu kamaʻilio, kaomi i ke pihi Special (Hiʻona).
- I ka pahu kamaʻilio E hele i kahi kūikawā (E koho i kahi hui o nā pūnaewele) e nānā i ka pahu hakahaka (Empty cell) a kaomi OK.
- E kaomi ʻākau ma kekahi o nā cell i koho ʻia a kaomi e kāpae i (Holoi).
- I ka pahu kamaʻilio e kāpae i (Delete cell) koho Lalani holoʻokoʻa (laina) a kaomi OK.
He ala ʻino loa kēia., e hana wale i kēia me nā papa maʻalahi loa me nā lālani ʻelua kakini kūpono ma ka pale hoʻokahi, a ʻoi aku ka maikaʻi - mai hana pela! ʻO ke kumu nui inā loaʻa i kahi laina me ka ʻikepili koʻikoʻi ma ka liʻiliʻi o hoʻokahi kelepona ʻole, a laila e holoi ʻia ka laina holoʻokoʻa.
No ka laʻana, loaʻa iā mākou kahi papaʻaina mea kūʻai aku me nā lālani 6 i ka huina. Makemake mākou e wehe i nā laina 3 и 5no ka mea, ua nele.
E hana e like me ka mea i ʻōlelo ʻia ma luna a loaʻa i kēia hopena:
Line 4 (Roger) ua nalowale no ka mea ke kelepona D4 ma kahi kolamu Kumu kalaiwa ua nele
Inā ʻaʻole nui kāu papaʻaina e ʻike ʻoe i ka nalowale ʻana o ka ʻikepili, akā i nā papa maoli me nā tausani o nā lālani hiki iā ʻoe ke hoʻopau me ka ʻike ʻole i ka nui o nā lālani pono. Inā laki ʻoe, e ʻike ʻoe i ka poho i loko o kekahi mau hola, hoʻihoʻi i ka puke hana mai kahi waihona, a hoʻomau i ka hana. He aha inā he pōʻino ʻoe a ʻaʻohe āu waihona?
Ma hope o kēia ʻatikala, e hōʻike wau iā ʻoe i 2 mau ala wikiwiki a hilinaʻi hoʻi e wehe i nā lālani blank mai nā pepa Excel.
Ke wehe nei i nā lālani hakahaka me ke kolamu kī
Hana kēia ʻano hana inā loaʻa i kāu papaʻaina kahi kolamu e kōkua ana e hoʻoholo inā he hakahaka a ʻaʻole paha ke kolamu i nīnau ʻia (ke kolamu kī). No ka laʻana, he ID mea kūʻai aku a i ʻole kahi helu kauoha, a i ʻole kekahi mea like.
He mea nui iā mākou ke mālama i ka hoʻonohonoho o nā lālani, no laila ʻaʻole hiki iā mākou ke hoʻokaʻawale i ka papaʻaina ma kēlā kolamu e hoʻoneʻe i nā lālani kaʻawale i lalo.
- E koho i ka papaʻaina holoʻokoʻa, mai ka mua a hiki i ka lālani hope (paʻi Ctrl+Home, a laila Ctrl + Shift + Hoʻopau).
- Hoʻohui i kahi kānana auto i ka papaʻaina. No ka hana ʻana i kēia, ma ka pā 'Ikepili (ʻikepili) kaomi Kānana (Kānana).
- E hoʻopili i kahi kānana i kahi kolamu Cust#. No ka hana ʻana i kēia, kaomi i ke pihi pua ma ke poʻomanaʻo kolamu, wehe i ke koho E koho i All (E koho i nā mea āpau), e kaomi i lalo a hiki i ka hopena o ka papa inoa (ma ka hoʻomaʻamaʻa, hiki ke lōʻihi kēia papa inoa) a nānā i ka pahu hakahaka (Empty) ma ka lalo loa o ka papa inoa. Kaomi OK.
- E koho i nā lālani i kānana ʻia: kaomi Ctrl+Home, a laila ka pua i lalo e neʻe ai i ka lālani mua o ka ʻikepili, a laila kaomi Ctrl + Shift + Hoʻopau.
- E kaomi ʻākau ma kekahi kelepona i koho ʻia a koho mai ka papa kuhikuhi Holoi lālani (Delete line) a i ʻole kaomi wale Ctrl + -(hōʻailona hōʻemi).
- Ma ka puka aniani e hōʻike ʻia me kahi nīnau Holoi i ka lālani pepa holoʻokoʻa? (E holoi i ka lālani pepa holoʻokoʻa?) kaomi OK.
- Hoʻomaʻemaʻe i ka kānana i hoʻopili ʻia: ma ka pā 'Ikepili (ʻikepili) kaomi akaka (Maʻemaʻe).
- Maikaʻi! Hoʻopau loa ʻia nā laina hakahaka a pau, a me ka laina 3 (Roger) aia ma kahi (e hoʻohālikelike me ka hopena o ka hoʻāʻo mua).
Ke wehe ʻana i nā lālani hakahaka i loko o ka pākaukau me ke kolamu kī ʻole
E hoʻohana i kēia ʻano inā he nui nā keena hakahaka o kāu papaʻaina i hoʻopuehu ʻia ma nā kolamu like ʻole, a pono ʻoe e holoi wale i kēlā mau lālani ʻaʻohe mau cell me ka ʻikepili.
I kēia hihia, ʻaʻohe kā mākou kolamu kī e kōkua ai e hoʻoholo inā he kaʻawale ke kaula a ʻaʻole paha. No laila, hoʻohui mākou i kahi kolamu kōkua i ka papaʻaina:
- Ma ka hope o ka papaʻaina, hoʻohui i kahi kolamu i kapa ʻia hakahaka a hoʻopili i kēia ʻano hana i loko o ka cell mua o ke kolamu:
=COUNTBLANK(A2:C2)=СЧИТАТЬПУСТОТЫ(A2:C2)ʻO kēia ʻano, e like me kona inoa e hōʻike nei, helu ʻia nā cell hakahaka ma kahi ākea. A2 и C2 ʻo ia ka mua a me ka hope o ka lālani o kēia manawa.
- E kope i ke kolamu i ke kolamu holoʻokoʻa. Pehea e hana ai - e ʻike i ke aʻo ʻana i kēlā me kēia ʻanuʻu Pehea e hoʻokomo ai i ke ʻano like i loko o nā cell i koho ʻia i ka manawa hoʻokahi.
- I kēia manawa he kolamu kī ko kā mākou papaʻaina! E hoʻopili i kahi kānana i kahi kolamu hakahaka (ʻo luna ke alakaʻi i kēlā me kēia ʻanuʻu pehea e hana ai i kēia) e hōʻike wale i nā lālani me ka waiwai kiʻekiʻe (3). Helu 3 'o ia ho'i, ua nele nā pūnaewele a pau o kēia lālani.
- A laila, koho i nā lālani kānana a pau loa. Pehea e hana ai i kēia i wehewehe ʻia ma luna. ʻO ka hopena, e holoi ʻia ka laina kaʻawale (laina 5), e noho mau nā laina ʻē aʻe (me ka ʻole a i ʻole nā pūnaewele ʻole) ma ko lākou wahi.
- I kēia manawa hiki ke wehe ʻia ke kolamu kōkua. A i ʻole hiki iā ʻoe ke hoʻopili i kahi kānana ʻē aʻe e hōʻike wale i kēlā mau cell i loaʻa hoʻokahi a ʻoi aku paha nā mea ʻole. No ka hana ʻana i kēia, wehe i ka laina me ka waiwai 0 (zero) a kaomi OK.
