View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Eliminating Blank Rows

A simple way is to do a sort. the empty lines will either end up at the top
or bottom of the worksheet.

"Tatebana" wrote:

I have a huge Spreadsheet with data from which I want to eliminate all empty
rows.

Is there a simple Macro to do that?

(I have only experience with Macros when I can create them by recording...)