View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lawrenceiow Lawrenceiow is offline
external usenet poster
 
Posts: 3
Default Cntrl-end goes beyond end after rows have been deleted ?

Domrob,

Select cell A1 in your sheet, save and then close your file. When you
re-open your file Ctrl-End will work as you expect.



"Domrob" wrote:

Particurlarly with a large file, 20,000 rows for example, after I have
deleted say the bottom 5,000 rows and later do a CNTL-END to get to the
bottom of the file, the cursor goes back to row 20,000 instead of row 15,000.
??