Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good to hear........about the results of the F5 trick........not about the
RSI Gord On Sat, 6 Sep 2008 16:53:02 -0700, EngelseBoer wrote: THANKS i wish i had asked yesterday now, BEFORE getting repetitive strain injury (well it feels like it spent HRS scroling down and manually deletin thaks a bunch Gord "Gord Dibben" wrote: Select a column then F5SpecialBlanksOK EditDeleteEntire Rows. You could record a macro whilst doing this. Gord Dibben MS Excel MVP On Sat, 6 Sep 2008 16:20:01 -0700, EngelseBoer wrote: the scripts i am running for returned results are such that there are dozens to 100's of empty rows - as i am dealing with a page conting almost 37,000 rows; manually deleting the empty rows so that the returned info is more legible is a pain -- for real - i typically save as delimited then copy the delimited back to active so i can work with the data futher - what script can i run to auto delete empty field rows please |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting Rows Between Empty Cells | Excel Worksheet Functions | |||
Deleting empty rows automatically | Excel Discussion (Misc queries) | |||
Deleting All Empty Rows | Excel Discussion (Misc queries) | |||
Deleting unwanted and empty rows.... | New Users to Excel | |||
Deleting unwanted and empty rows... | Excel Discussion (Misc queries) |