Pehea e hiki ai iaʻu ke holoi maʻalahi i nā lālani hakahaka a pau ma Excel

ʻO ke akamai o ka hana ʻana me ka papahana Excel he mea pono no nā ʻelele o nā ʻoihana he nui. Ma kēia ʻatikala, e noʻonoʻo mākou i kekahi mau pilikia - ʻo ia hoʻi, No ke aha ʻo ka wehe ʻana i nā lālani ma Excel me ka hoʻohana ʻana i ka "koho i nā cell blank -> delete row" ʻaʻole ka manaʻo maikaʻi loa.. E kālailai pū mākou 3 ʻO nā ala wikiwiki a hilinaʻi e wehe i nā laina blank penei, no laila ʻaʻole ia e hōʻino i ka ʻike ma nā ʻāpana ʻē aʻe ma kekahi ʻano. Hoʻopili ʻia nā hoʻonā āpau i Excel 2019, 2016, 2013 a ma mua.

3 ʻO nā ala wikiwiki a hilinaʻi e wehe i nā laina blank 

No ka mea ke nānā nei ʻoe i kēia ʻatikala, kūpono ke manaʻo ʻoe, e like me nā poʻe ʻē aʻe, e hana mau me nā papapalapala excel o ka nui nui. Loaʻa paha ʻoe i nā kūlana kahi laina hakahaka, ka pale ʻana i ka hapa nui o nā mea hana i kūkulu ʻia mai ka ʻike pono ʻana i ka laulā o ka ʻikepili. No laila, i kēlā me kēia manawa, pono ʻoe e kuhikuhi i nā palena me ka lima - i ʻole e loaʻa iā ʻoe ka hopena hewa, a e lawe ʻoe iā ʻoe ma mua o hoʻokahi hola o ka manawa e ʻike a hoʻoponopono i kēlā mau hewa. 

Hiki i nā kumu like ʻole ke ʻike ʻia nā laina hakahaka - no ka laʻana, ua loaʻa iā ʻoe kahi faila Excel mai kahi ʻē aʻe, a i ʻole ua lawe ʻia ka faila mai kekahi waihona, a i ʻole ʻoe i holoi ʻole i ka ʻike ma nā laina makemake ʻole. Ma lalo o nā kūlana, inā makemake ʻoe wehe i nā laina hakahaka a ma muli o ka loaʻa ʻana o kahi papaʻaina maʻemaʻe a nani, pono ʻoe e hoʻokō he kaʻina hana maʻalahi. E nānā kākou i kekahi mau kūlana kiko'ī ma kēia mau kumuhana.

• No ke aha ʻaʻole pono ʻoe e wehe i nā lālani kaʻawale ma ke koho ʻana i nā cell hakahaka.
• Pehea e hoʻopau ai i nā lālani kaʻawale inā loaʻa kahi kolamu kī.
• Pehea e hoʻopau ai i nā lālani kaʻawale inā ʻaʻohe kolamu kī.
• Pehea e hoʻohana ʻia ai ka mea hana Delete Empty Lines, a no ke aha ʻo ia ka mea maʻalahi, a ʻo ka mea nui loa, ke ala wikiwiki loa.

Mai wehe i nā lālani kaʻawale ma ke koho ʻana i nā cell hakahaka  

Ma ka Pūnaewele, hiki iā ʻoe ke ʻike pinepine i kēia mau ʻōlelo aʻo:

• E koho i nā pūnaewele a pau i loaʻa ka ʻike, mai ka la 1 a i ka hope.
• Kaomi i ke kī F5 - ʻO ka hopena, ʻo ka pahu kamaʻilio "ʻO ka hoʻololi".
• I loko o ka puka aniani e wehe ai, kaomi "Kahiāuli Ho'ā".
• Ma ka pukaaniani "Ke koho ʻana i kahi pūʻulu cell» koho koho «nā pūnaewele hakahaka", a laila "OK".
• E kaomi ʻākau ma kekahi cell i koho ʻia, a laila koho i ka "Holoi…".
• Iloko o ka puka aniani e wehe anaKe holoi nei i nā pūnaewele» kaomi ma ke koho «kaula". 

Eia naʻe, ʻaʻole kēia ke ala maikaʻi loa - hoʻohana wale ia no nā papa liʻiliʻi kahi e hōʻike ʻia ai nā lālani i loko o ka pale, a ʻoi aku ka maikaʻi - mai hoohana iki.

Loaʻa kēia ma muli o ka ʻoiaʻiʻo inā hoʻokahi wale nō kelepona ʻole i loko o ka laina i loaʻa nā ʻike koʻikoʻi, holoi ʻia ka laina holoʻokoʻa. 

E nānā kākou i kekahi laʻana. Ma mua o mākou he papaʻaina o nā mea kūʻai aku, i loko wale nō 6 huaolelo. Makemake mākou holoi i nā laina ʻekolu a me ka ʻelima, oiai ua nele lakou.

E hoʻohana i ke ala i luna a e loaʻa iā ʻoe kēia:

Nalo pū ka laina 4 (Rojer)., no ka mea ma ke kolamu "Kumu kaʻahele".  ʻaʻohe o ka cell D4.

No ka mea he papaʻaina liʻiliʻi kāu, hiki iā ʻoe ke loaʻa nele i ka ʻikepili, akā i loko o nā papa nui i loaʻa nā kaukani lālani, hiki iā ʻoe ke holoi i nā haneli o nā lālani pono me ka ʻike ʻole. Inā ʻoe laki e ʻike ʻoe ua nalo i loko o kekahi mau hola, e hoʻihoʻi i kāu faila mai kope papaʻaa laila e hana hou. Akā, pehea inā ʻaʻole ʻoe i pōmaikaʻi a ʻaʻohe mea hoʻihoʻi? 

E nānā kākou 3 ʻO nā ala wikiwiki a hilinaʻi hoʻi e wehe i nā laina hakahaka mai kāu papapalapala Excel. A inā makemake ʻoe e mālama i kou manawa - e hele pololei i 3rd ala.

E hoʻopau i nā lālani kaʻawale inā loaʻa kahi kolamu kī

ka hana hana inā loaʻa iā ʻoe kahi kolamu e kōkua iā ʻoe e noʻonoʻo inā ʻaʻohe kaula a ʻaʻole paha (ka mea i kapa ʻia kolamu kī). No ka laʻana, he helu kauoha paha kēia, a i ʻole ID mea kūʻai aku, a i ʻole kekahi mea like.

Pono mākou e haʻalele laina laina ʻaʻole i hoʻololi ʻia, no laila, ʻaʻole e holo ka hoʻokaʻawale ʻana ma kēia kolamu a me ka hoʻololi ʻana i nā lālani kaʻawale a pau i ka hopena o ka papaʻaina. Pela i ka mea pono e hana.

1. E koho piha i ka papaʻaina, mai ka 1st a hiki i ka lālani hope (e hana i kēia, hiki iā ʻoe ke paʻa i ka manawa like Ctrl+Home, ʻOi aku - Ctrl + Shift + Hoʻopau).

2. hoʻonoho ʻAukulele: hele i ka pā "'Ikepili"a kaomi i ke pihi"Kānana".

3. A laila, pono ʻoe e hoʻopili i kahi kānana i ke kolamu "Cust #" ("Customer No."): kaomi i ka pua hāʻule iho "Autofilter" ma ka inoa kolamu, wehe (koho i nā mea a pau), e kaomi i lalo a hiki i ka hopena (ʻoiaʻiʻo he lōʻihi ka papa inoa), a laila e nānā i ka pahu "Empty"… Kaomi OK.

4. E hoʻohui i nā lālani i kānana ʻia: no kēia hiki iā ʻoe ke paʻa i lalo i ka manawa like Ctrl+Home, a laila e hoʻi hou i ka lālani mua, a laila paʻa Ctrl + Shift + Hoʻopau.

5. E kaomi ʻākau ma kekahi cell i koho ʻia a kaomi ma ka "Holoi i ka laina» a i ʻole e kaomi wale Ctrl + – (hōʻailona hōʻemi).

6. Kaomi ma ka pihi OK i ka pane ana i ka ninauHoloi i ka huaʻōlelo holoʻokoʻa o ka leka?»

7. A laila pono ʻoe e holoi i ka kānana i noi ʻia: e hana i kēia, e hele i ka "'Ikepili"a kaomi i ke pihi"Clean".

8. Hana maikaʻi! Ua pau nā laina hakahaka, a aia nō ke kolu o ka laina (Rojer) (no ka hoʻohālikelike, hiki iā ʻoe ke kuhikuhi i ka mana mua).

E hoʻopau i nā lālani hakahaka a pau inā ʻaʻohe kolamu kī    

E hoʻohana i kēia alainā loaʻa iā ʻoe kahi papaʻaina i kāu hana me ka nui o nā keʻena hakahaka i waiho ʻia ma nā kolamu like ʻole, a makemake ʻoe e holoi pololei i kēlā mau lālani. nele loa.

kolamu kī, hiki ke hoʻohana ʻia e ʻike inā ʻaʻole i nele ke kaula i kā mākou hiʻohiʻona. He aha ka hana? ʻO mākou iho hana i kolamu keu:

1. Hoʻoulu kolamu “Blanks” (“Empty cells”) ma ka hope loa o kāu papaʻaina, a laila e kākau ma ka cell 1st o kēia kolamu. ke kumuhana: = COUNTBLANK (A2: C2).

keia haʻilula helu ʻia nā cell hakahaka i loko o ka mea i kuhikuhi ʻia huahelu, kahi ʻo A2 ka pūʻali 1, ʻo C2 ka pūlima hope.

2. ke kope ke kumuhana no nā pūnaewele a pau o ke kolamu.

3. I kēia manawa ua loaʻa iā mākou kolamu kī. A laila hoʻohana Kānana ma ke kolamu "Blanks" (nā kuhikuhi kiko'ī ma luna) e hōʻike i nā lālani me ka waiwai nui (3). ʻO ke ʻano o ka "3" penei: ʻaʻohe hakahaka nā cell a pau o ka lālani.

4. A laila koho i nā mea a pau nā lālani kānana a hemo loa neleme ka hoʻohana ʻana i nā ʻōlelo kuhikuhi i wehewehe mua ʻia.

Pela ka laina hakahaka (laina 5) weheʻia, a me nā laina me ka ʻike pono noho ma kahi.

5. A laila, holoi kolamu hou. ʻAʻole pono hou. A i ʻole hiki iā ʻoe ke kau i kahi ʻē aʻe Kānana a hōʻike i nā lālani i loaʻa hoʻokahi a ʻoi aʻe paha nā keena kaʻawale.

No ka hana ʻana i kēia, wehe i ka0", a laila kaomi "OK".

ʻO ka hoʻohana ʻana i ka Wehe Empty Lines ka mea maʻalahi a wikiwiki hoʻi  

ʻO ke ala wikiwiki a maikaʻi ʻole e wehe i nā laina hakahaka he mea hanaWehe i nā laina hakahaka”, i loko o ka pahu Suite Ultimate no Excel.

Ma waena o nā mea pono ʻē aʻe hana aia kekahi mau mea utilities, e ʻae i hoʻokahi kaomi e hoʻoneʻe i nā kolamu ma ke kauo ʻana; Holoi i nā keena ʻole a pau, nā lālani a me nā kolamu, a me ka kānana e ka waiwai i koho ʻia, e helu i nā pākēneka, e hoʻopili i kekahi hana makemakika maʻamau i kahi ākea, kope i nā helu kelepona i ka clipboard a ʻoi aku.

Pehea e wehe ai i nā laina blank ma 4 maʻalahi

Ke hoʻohana nei i ka Ultimate Suite, Eia hou hoʻokomo ʻia i ka polokalamu Excel, ʻo ia ka mea āu e pono ai do:

1. Kaomi ma kekahi aeea i ka pākaukau.
2. Kaomi i ka pā Mea hana Ablebits > Hui Hoololi.
3. Press Wehe i nā laina hakahaka > Nā laina hakahaka.

4. Kaomi i ka pihi OKe hōʻoia i kou makemake maoli lawe laina hakahaka.

O ia wale nō! He mau kaomi wale nō a loaʻa iā ʻoe papaʻaina maʻemaʻe, ua pau na laina hakahaka a pau, a o ka hooponopono ana o na laina, aole hee!