View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
CJN CJN is offline
external usenet poster
 
Posts: 8
Default Last Cell Problem

That didn't work. I ended up copy the active data into another worksheet and
deleting the problem worksheet.

Thanks

"Flick Olmsford" wrote:

I use Excel 2003

CTRL+END will go to the last cell in the last row with any data. Try clear
all - data and formatting - for any and all cells in that row and column.

Also, why not just try and delete just row 65536 instead of 65K rows?



"CJN" wrote:

Somehow a worksheet I have thinks that I have somethink in the last row
which is 65536. I checked that row and I don't. Meanwhile the worksheet is
sluggish due to its size.

I tried deleting the bottom 65000 rows but it hangs my computer.

Is there another solution to this problem?