View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Perplexed of Worcs[_2_] Perplexed of Worcs[_2_] is offline
external usenet poster
 
Posts: 3
Default How do I remove redundant rows at end of sheet?

I'm cutting a larger Excel file into 2 smaller ones, and then converting to
csv. The original but now smaller file shows empty lines when converted,
which causes a problem for the resultant application. Rather than cut and
paste this into a new Excel file, can anyone tell me how to resolve these
empty, but apparently 'in use' cells/rows?