View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
df df is offline
external usenet poster
 
Posts: 4
Default blank rows still "read" by excel

I have inherited several spreadsheets that for some reason have over 2,000
lines each when they only poplulate about 200 lines each. I am a big fan of
the end-home function, but when I do this in these files, I end up at the
2000th line rather than the last line of data in my spreadsheet. And more
importantly, the size of my file is HUGE with these extra lines. How do I
remove these unused lines so that excel doesn't read them anymore.