Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to eliminate blank rows between information
I need to delete many blank rows between information but i do not want to go
one by one how can I delete it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to eliminate blank rows between information
Try this quick sequence on a copy of your sheet ..
Assume col A is the key col which defines the blank rows (ie where col A is blank, then the entire row is considered as blank) Select col A (select the col header) Press F5SpecialCheck "Blanks"OK Right-clickDeleteCheck "Entire Row"OK -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "juliomex" wrote: I need to delete many blank rows between information but i do not want to go one by one how can I delete it. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to eliminate blank rows between information
Maybe you can select the range and sort it by a key column.
The blanks will be grouped together (maybe at the top), but they'll be easy to delete. Another way is to pick out a column that always has something in it if the row is used. Then apply data|filter|autofilter and show the blank cells. Then delete the visible rows And remove the autofilter. juliomex wrote: I need to delete many blank rows between information but i do not want to go one by one how can I delete it. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non-Array Play to Eliminate Blank Cells | Excel Worksheet Functions | |||
Excel 2003-eliminate blank rows in target worksheet using =IF | Excel Discussion (Misc queries) | |||
Excel (Eliminate blank rows) | Excel Worksheet Functions | |||
how to eliminate a space when the field is blank in a merge | Excel Discussion (Misc queries) | |||
How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions |