deleting empty rows

E

EngelseBoer

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
 
G

Gord Dibben

Select a column then F5>Special>Blanks>OK

Edit>Delete>Entire Rows.

You could record a macro whilst doing this.


Gord Dibben MS Excel MVP
 
E

EngelseBoer

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
 
G

Gord Dibben

Good to hear........about the results of the F5 trick........not about the
RSI

Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting empty rows automatically 2
delete empty rows 1
Write a macro that hides rows based on empty cells 3
Deleting blank rows 4
Deleting/removing unused rows in a worksheet 3
Help on Macro to hide empty rows 4
Remove empty rows in excel? 6
Insert blank rows 2

Top