Last cell beyond actual data.

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

Thanks! That did the trick.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Brooke

Reply | Quote

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.

Reply | Quote