Home |
Search |
Today's Posts |
#1
|
|||
|
|||
delete empty rows between rows with text
Please anybody can help me
Ia have a data base with email's but between rows with emails the ecxel file have a empty fields I want remove this empty rows. Best regards Paulo Baptista |
#2
|
|||
|
|||
One way .. (try on a spare copy)
Assume the key data col is col A Select col A Press F5 Special Blanks OK Right click on the selection Delete Shift cells up OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Paulo Baptista" <Paulo wrote in message ... Please anybody can help me Ia have a data base with email's but between rows with emails the ecxel file have a empty fields I want remove this empty rows. Best regards Paulo Baptista |
#3
|
|||
|
|||
Select the range, press F5, special and select blanks, press ctrl and -
(minus/dash), select entire row or shift cells up depending on whether the whole row is empty -- Regards, Peo Sjoblom "Paulo Baptista" <Paulo wrote in message ... Please anybody can help me Ia have a data base with email's but between rows with emails the ecxel file have a empty fields I want remove this empty rows. Best regards Paulo Baptista |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to delete a text box and copy in new one | Excel Discussion (Misc queries) | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
how do i delete empty rows in excel? | Excel Discussion (Misc queries) | |||
Remove empty rows in excel? | Excel Discussion (Misc queries) | |||
Delete Columns not Containing Certain Text | Excel Worksheet Functions |