View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default How do I change the end cell (Ctrl end) in a excel spreadsheet?

If you just delete the data in the 500 rows, the last row will not be
reset. You need to use Edit | Delete | Entire Rows and this should
reset the counter to 4,500.

Pete