Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Basalt, Colorado, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Last cell beyond actual data.

    <img src=/S/question.gif border=0 alt=question width=15 height=15>How do I get cntrl-end to be at the actual lower right corner of my data?

    When I hit cntrl-end to go to the last cell in my sheet, I end up about 800 rows below any actual data. I have tried removing all formats, and deleted all data, but find that cntrl-end still takes me to the same place. I also noticed that if I enter any data in another cell beyond this cell and delete it, this becomes the new last cell.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Last cell beyond actual data.

    Try the following. Go to the last row containing data. Block select all rows beneath that and then Edit, Clear, All. You might like to do the same for columns. Then immediately save and close the file.

    When you re-open the problem should be sorted.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Basalt, Colorado, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last cell beyond actual data.

    Thanks! That did the trick. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last cell beyond actual data.

    You do not have to do all the selecting, clearing, saving, closing, and reopening. Just saving the file does the trick.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last cell beyond actual data.

    There are a number of cases where just closing and reopening does not do the trick. For whatever reason, sometimes Excel seems to lose track of the fact that some cells are no longer used. When that happens, closing and reopening does not change where it thinks the end of the used area is.
    Legare Coleman

  6. #6
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last cell beyond actual data.

    One trick I've found useful is doing a quick print preview. Again, sometimes it works, sometimes it doesn't.

    Brooke

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last cell beyond actual data.

    I may have been very lucky, but I have never had trouble with just saving (no deleting, or closing then reopening). It is certainly worth trying just saving first.

Posting Permissions

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