Sometimes even that didn't work for me, plus being a time-consuming pain.
I finally found that doing a save-as to itself fixes the problem.

"Ron Coderre" wrote:

Try this:
Generally, after deleting the extra rows/columns, you must save the
workbook. Depending on your version of Excel....you may need to
Save/Close/Re-open.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Hairy Hurdler" wrote:

If I use Ctrl End after deleting collumns I jump to the old end of data not
the current one; how can I fix this ?