View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default How do i get the 65k of rows to go away??

They will always be showing unless you hide them, the thing is that when you
press ctrl + End
it should just go to the end of the used range so if your last cell with a
values is E455 then it will go to the cell below.
If you have Excel97 you might have to save, close excel and open it again
before it will take effect



--
Regards,

Peo Sjoblom


wrote in message
oups.com...
well that didnt work =( all 65k rows are still showing