Results 1 to 2 of 2
  1. #1

    Ctrl+End aware of deleted rows

    Hi folks. I just deleted 1000+ rows from a worksheet (Excel 2k). Ctrl+End doesn't realize this and goes to the old end. How do I get it to go to the new last used cell?

    OK, I'll answer my own question: Once I save the spreadsheet Ctrl+End starts working correctly. (I don't think it was that simple in Excel 97.)

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: Ctrl+End aware of deleted rows

    If you close and save the workbook, Excel should figure out where the new end of the sheet is. And yes, it has been that simple for as many releases back as I can remember.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts