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

  • Thread starter Thread starter Meeru
  • Start date Start date
M

Meeru

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
 
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
 
Hit Ctrl+F> Find What two double quotes ==
Find All>Select the items from the list> This will select all the cells with
==
Close Find window>Right click>Delete>Entire Row>OK

If this post helps click Yes
 
thanks, this really helps :)

Jacob Skaria said:
Hit Ctrl+F> Find What two double quotes ==
Find All>Select the items from the list> This will select all the cells with
==
Close Find window>Right click>Delete>Entire Row>OK

If this post helps click Yes
Click to expand...
 
Back
Top