Deleting columns

[Brad E]

Hi everyone.

I have a sheet which has entries over to column AB. When
I hit CTRL-END the active cell becomes IV94. So I have
gone to AC1 and deleted the column (1 time or 10 times),
then saved the workbook, hit CTRL-END and again it ends up
at IV94. I thought saving the workbook reset the end of
the worksheet?

Before sending this I saved and closed the workbook. When
I opened it again and CTRL-END it went to AB94. So I got
it working, but could anyone tell me why I had to close
and re-open, when sometimes just doing a SAVE will reset
the end??

TIA, Brad E.

 

[Frank Kabel]

Hi
this depends on your Excel version. Older versions require
this procedure.
See: http://www.contextures.com/xlfaqApp.html#Unused