Discussion Locked

Clear memory of deleted cell in Excel

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Ctrl+Shift+End highlights all cells containing data. However, even when a cell is deleted. Excel must have it in it's memory so that the highlighted cell can never decrease. How do you clear Excel's memory of that data?

9 replies

by hinrgman

What happens sometimes is when you delete the contents of a cell with the delete key the formatting is still in the cell even though you can not see it. Use Edit - Clear - All instead of just the delete key. That should remove all data and formatting.

by kari

Try it. If you enter data into A1 + N50. Then clear all columns and rows from B2 to Q52 - Ctrl+Shift+End highlights upto Q52! Your answer doesn't work!

by hinrgman

The item that i have been helping with is interesting.
It is a memory quirk that is held until you close the file.
Try it

Create you test cenario - run it

and it will return to that last point until you close the file and then reopen it.
closing the file clears that refference point - that is the only way I see you can do it

mpc

This discussion is closed to new replies.