Pehea e holoi ai i nā lālani blank ma Excel i kēlā me kēia pae

Welina mai i ka honua kupaianaha a - i kekahi manawa - paʻakikī o Excel. E aʻo ana mākou i kēia manawa pehea e holoi ai i nā lālani hakahaka ma excel ʻanuʻu. E hoʻāʻo mākou e hana maʻalahi i hiki iā ʻoe ke aʻo wikiwiki, e waiho mākou iā ʻoe i kahi macro. No ka mea inā ʻoe e hoʻohana iā Excel e ʻike ʻoe e hoʻomaʻamaʻa nā macros i ke ola, akā pono ʻoe e loaʻa iā lākou a hoʻokō iā lākou. Ma keia hihia e haawi aku makou ia oe. ʻAʻole pono mākou e haʻi iā ʻoe ʻo ka manawa āu e hoʻolilo ai i ke aʻo ʻana iā Excel ka manawa i loaʻa i kāu mau hana āpau. A ke aʻo nei ʻoe me ka ʻikepili maikaʻi loa a me ka mea hana helu ma ka mākeke.

No ka mea, ʻo Excel i kēia lā ʻo ia ka mea hana ikaika i hoʻohana ʻia e nā miliona o ka poʻe, akā hoʻomaopopo ʻia e ka poʻe liʻiliʻi. He mea maʻamau ʻoe e pono ai ke kōkua, ʻoiai ʻo ia wale nō no ka holoi ʻana i nā lālani blank ma Excel, pono mākou āpau i kekahi manawa. Ke hana nei ʻoe me ka nui o ka ʻike, he mea maʻamau iā ʻoe ke ʻike i nā lālani hakahaka, a me kēia keʻakeʻa loa ia i kāu heluhelu a me ka hana ʻana i ka ʻikepili, hōʻemi ʻoe i ka nānā ʻana i ka manawa hou aku.

4 mau ala e holoi ai i nā lālani hakahaka ma Excel

 

E like me kāu e ʻike ai, aia nā ʻano hana like ʻole, e aʻo aku mākou iā ʻoe i ʻehā, a ma kēia ala e ʻike ai ʻoe pehea e holoi ai i nā lālani blank ma Excel. I ka hopena e hāʻawi mākou iā ʻoe ka no he aha ka mea e hoʻopau ai i kēlā mau lālani, ma ke ala ākeai. Akā ʻae, inā makemake ʻoe, loaʻa iā mākou kahi ʻatikala hou a mākou e kamaʻilio nei E hoʻohana iā AI ma Excel e helu pololei a maʻalahi i nā formula. Inā he mea hoʻohana Mac ʻoe, loaʻa iā mākou kahi alakaʻi nā ʻaoʻao pōkole ma Excel no Mac. Ua ʻike ʻia ka mea i ʻike ʻia ma Tecnobits Makemake mākou iā Excel, akā ma mua o nā mea āpau e kōkua iā ʻoe me ia.

Holoi i nā lālani hakahaka ma ka lima

He liʻiliʻi kāu ʻikepili i kāu faila Excel? No laila ʻo kēia ke ʻano. Ma kēia hihia wale nō e pono ke holoi lima iā lākou, e hoʻomanaʻo i kēlā. Inā ʻo kēia kāu hihia, e hahai i kēia mau ʻanuʻu:

• E koho i nā lālani hakahaka, ʻo ia hoʻi nā mea ʻole. Inā ʻike ʻoe ua hoʻopuehu ʻia kēlā mau lālani keʻokeʻo, hiki iā ʻoe ke koho iā lākou ma ka hoʻopaʻa ʻana i ke kī Ctrl i ke kaomi ʻana iā lākou.
• E kaomi pololei ma nā wahi āpau o kēlā koho holoʻokoʻa a kaomi i ke pihi "hemo"
• No ka nānā ʻana ʻaʻole ia he hewa, e hōʻike ʻia kahi pahu kamaʻilio, a hāʻawi pū iā ʻoe i ke koho "Lalani a pau" ke koho ʻoe iā ia, pono ʻoe e kaomi "Accept"

ʻIke? Inā ʻoe e noʻonoʻo nei pehea e holoi ai i nā lālani blank ma Excel, ua wikiwiki a maikaʻi hoʻi, ʻaʻole? Akā, e hoʻomanaʻo i kēia no ka mea wale nō liʻiliʻi o nā lālani hakahaka, i ole e hele pupule oe.

E hoʻohana i nā kānana e ʻimi a wehe i nā lālani hakahaka

ʻAʻole like me ke ʻano ma mua, i kēia manawa no kēia nui o na lalani hakahaka. Eia mākou e hele ai me ke alakaʻi kānana:

• E koho i ka laula ʻikepili a i ʻole kolamu āu e makemake ai e haʻalele me nā lālani ʻole
• E hele i ka papa hana papahana a koho i ka pā "Data", a laila kaomi "Kānai". E ʻike ʻoe i kahi papa kuhikuhi.
• Kaomi i ka kānana no ke kolamu kahi āu e makemake ai e wehe i nā lālani ʻole. Wehe i nā koho a pau koe wale nō "Whites" 
• I kēia manawa e hōʻike wale ka pepa iā ʻoe i nā lālani keʻokeʻo, koho iā lākou a koho e holoi.

Holoi i nā lālani hakahaka me ka hana Go to Special

He ala ʻē aʻe ia no nā pepa Excel me ka nui o ka ʻikepili. Me kēia ala hiki iā ʻoe koho i nā lālani hakahaka a pau mai ke kolamu a i ʻole ka lālani:

• E koho i ka laulā ʻikepili a i ʻole ke kolamu pololei āu e makemake ai
• I kēia manawa pono ʻoe e kaomi i ka hui Ctrl + G a i ʻole e hele i ka ʻaoʻao "Home" a koho i ka "ʻimi a koho". e kaomi i kēia manawa E hele i Special.
• E koho i "Blank Cells" a kaomi iā OK
• Ke koho ʻoe i nā mea a pau, pono ʻoe e hele "home" a laila "hoʻopau" a koho i ka "holoi i nā lālani pepa"

Macro e holoi i nā lālani hakahaka ma Excel

E like me kā mākou i hoʻohiki ai, eia mākou e haʻalele iā ʻoe i kahi macro. ʻO kahi macro, inā he mea hou ʻoe iā Excel, ʻaʻohe mea ʻē aʻe he kauoha e hoʻokaʻawale i kāu hana. No ka hiki iā ʻoe ke komo i loko, pono ʻoe e hana i kēia:

• E hoʻohana i ka hui kī Alt + F11 e wehe i ka mea hoʻoponopono Visual Basic for Applications
• I kēia manawa i ka hoʻoponopono Visual Basic, kaomi "hoʻokomo" a laila "module"
• E kope i ke code a mākou e waiho ai iā ʻoe ma lalo a ma hope o ke kope ʻana e kaomi i ke kī F5 a i ʻole "Holo" no ka macro e hana i kāna hana

Sub DeleteBlankRows()
Kaulana Poʻomanaʻo e like me ka laulā
Kelepona pohihihi e like me ka laulā
Ma ka Haʻa Haʻawina Ma hope
E hoʻonohonoho i ka laulā = ActiveSheet.UsedRange
No kēlā me kēia pūnaewele ma ka laulā
Inā Application.WorksheetFunction.CountA(Cell.EntireRow) = 0 A laila
Cell.EntireRow.Delete
Hoʻopau Inā
Kelepona aʻe
Ka pau 'iiaciiie

No ke aha e holoi ai au i nā lālani hakahaka ma Excel?

Ma hope o ka hāʻawi ʻana iā ʻoe i nā ʻano hana, a ʻike mākou ua aʻo mua ʻoe pehea e holoi ai i nā lālani blank kela aku, ua haʻi aku mākou iā ʻoe ma mua e haʻi mākou iā ʻoe i ke kumu he faila maopopo kāu. A inā hiki iā ʻoe ke aʻo pehea e hoʻopau ai iā lākou, e hoʻokō ʻoe i kēia:

• E hoʻonui ʻoe i ka faila Excel no laila, ʻaʻole i kaumaha loa a wikiwiki nā mea a pau
• E hoʻomaikaʻi ʻoe i ka ka nānā ʻana a me ka nānā ʻana o ka ikepili i loko. E holoi ʻoe i nā mea a pau.
• Kāohi hewa holoʻokoʻa mahalo i ka hoʻomaʻemaʻe ʻana i ka faila mai nā lālani hakahaka a ʻole.
• Ma ka hopena, ʻO ka hōʻike ʻana i kahi faila piha, me ka hala ʻole, ʻōlelo maikaʻi iā ʻoe, ʻoi aku paha inā i loko o kāu hana. ʻO ia ke kumu e haʻi aku ai mākou iā ʻoe i ke ʻano o ka hoʻopukapuka kālā iā ʻoe iho.

ʻO ke aʻo ʻana pehea e holoi ai i nā lālani blank ma Excel he kumu no kēia papahana. A hauʻoli mākou i kou hele ʻana mai Tecnobits e aʻo pū me mākou. No ka mea, ʻoiai ua hiki mai ʻoe i kēia mamao, waiho mākou iā ʻoe i kahi ʻatikala e pili ana ʻO nā ʻōlelo hoʻohālikelike koʻikoʻi no ka hoʻomaka ʻana e aʻo i nā formula Excel.