View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carlo carlo is offline
external usenet poster
 
Posts: 367
Default How do I resize a worksheet that's stuck on 65,000 rows?

Excel is built up like that, it always has 65536 rows (except excel
2007 which has a lot more!)
If you don't want to see the rows below, hide them. Select them, right
click -- hide.

hth

Carlo

On Dec 11, 9:25 am, JRExcelUser
wrote:
No matter how much I use the delete function, my worksheet is convinced it
has 65,000 rows. This takes up memory and is a pain to navigate. How do I
get rid of everything below the first couple of hundred rows?