Thread: Blanks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Blanks

One way - select the range you want, click Edit/Goto/Blanks, then click
Edit/Delete/Entire row.

Be sure to back up your data before trying.

"msn" wrote:

Hi all
How can I clean-up an excel worksheet from blank rows.
File exported from crystal reports.
Thanks
Radu