Hi,Check the below link,
http://funwithexcel.blogspot.com/search/label/Delete
to learn about various types of deletes (deleting blank cells / rows /
columns, deletion based on a value etc.,)


On Thu, Jun 4, 2009 at 7:35 AM, Hemant <hemantbales...@gmail.com> wrote:

>
> Do it simply without using a macro:
>
> 1) Insert a row at the top
>
> 2) write the formula in the inserted row (say the column is "A" and
> the inserted row is "1") =COUNTA(A2:A99999)
>     (it will give the count of non blank cells in the column) drag
> the formula for the entire row
>
> 3)select the cells in the new row having the value 0
>
> 4) Delete the entire column in the selection
>
> >
>


-- 
http://funwithexcel.blogspot.com/

--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to