Excel

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I am stuck,
How can you deleate blank cells in a colum that is huge and that has blank spaces all the way through, I know how to sort but that just sorts in order,

I want to leave the doc as it is but just get rid of the blanks,
I want do do this in one block so that they all go at the same time, not having to go through the whole doc highlighting blanks and deleating,
Any Idea's,

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

here a macro for deleting rows.

http://www.cpearson.com/excel/deleting.htm

 

try using an filter or autofilter on the col where there are blanks then copy and paste if you need to.

 

Thanks for that guys the auto filter done the trick