View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Shailesh Shah Shailesh Shah is offline
external usenet poster
 
Posts: 17
Default Automatically delete blank rows


In case you want it frequently try to record the macro of your action as
suggested.

BTW if you want to do with others addins, you may download my "workbook
navigation" add-ins from below site from addins page.

http://in.geocities.com/shahshaileshs/

See Image, more info in above site.

Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)




"Tinkerbell1178" wrote:

I need to delete every second row in my spreadsheet - the rows are blank.
There are 30,000 rows so I don't want to do it manually - is there an easy
way to delete every second (or every blank) row?