| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Blank Lines | Excel Discussion (Misc queries) | |||
| Delete Blank Lines | Excel Discussion (Misc queries) | |||
| How do i delete blank lines at bottom of an Excel worksheet? | Excel Discussion (Misc queries) | |||
| Is there a easy way to delete blank lines to clean up worksheets? | Excel Worksheet Functions | |||
| Delete Blank Lines | Excel Discussion (Misc queries) | |||
Linear Mode
