how to delete rows which is blank and which has ======== ( lines)
 

hi all,
i have imported from scala some data and i would like to delete rows which
is blanks, which has a line _______ and which has ===== line.
thanks for your kind answers.
meeru

how to delete rows which is blank and which has ======== ( lines)
 

Apply autofilter to an appropriate column and select Blanks from the
filter pull-down. Then highlight all the blank rows which are filtered
(the row identifiers should appear blue) and click on Edit | Delete
Rows. Then select All from the filter pull-down, and turn off
autofilter.

Hope this helps.

Pete


On Sep 7, 9:19*am, Meeru wrote:
hi all,
i have imported from scala some data and i would like to delete rows which
is blanks, which has a line _______ and which has ===== line.
thanks for your kind answers.
meeru

how to delete rows which is blank and which has ======== ( lines)
 

Hit Ctrl+F Find What two double quotes ==
Find AllSelect the items from the list This will select all the cells with
==
Close Find windowRight clickDeleteEntire RowOK

If this post helps click Yes
---------------
Jacob Skaria


"Meeru" wrote:

hi all,
i have imported from scala some data and i would like to delete rows which
is blanks, which has a line _______ and which has ===== line.
thanks for your kind answers.
meeru

how to delete rows which is blank and which has ======== ( li
 

thanks, this really helps :)

"Jacob Skaria" wrote:

Hit Ctrl+F Find What two double quotes ==
Find AllSelect the items from the list This will select all the cells with
==
Close Find windowRight clickDeleteEntire RowOK

If this post helps click Yes
---------------
Jacob Skaria


"Meeru" wrote:

hi all,
i have imported from scala some data and i would like to delete rows which
is blanks, which has a line _______ and which has ===== line.
thanks for your kind answers.
meeru