A recent questions was as follows:

Dear sir, hope my mail will find u in best of ur health, Im again thankful to u for ur assistance regarding my last request, now plz i need another help that i have a data in excel sheet almost 5000 entries, now if i want to skip or delete any column data which shows zero value, in other words i want to remove the complete row, suppose i have a zero data in F123 how can i find such other columns, is there any command which can help me to delete all such cases as its very difficult to delete one by one. plz advice me some function.

Watch the video clip on http://www.auditexcel.co.za/Autofilter%20cleanup.htmlto see how to delete rows easily. If you are unfamiliar with AutoFilter or the Goto special feature you can learn more about them on http://www.auditexcel.co.za/Autofilter%20Basics.html  and on http://www.auditexcel.co.za/GoTo%20Special%20Project.html . Hope this helps