CTRL - END

[David French]

When working in an Excel worksheet and a number of rows, columns or both are
deleted a strange phenomenon seems to occur.
After those row and/or columns are deleted and a CTRL-END is used to get to
the end of the list the resulting active cell is PAST where the actual data
ends.
Short of using CTRL and the arrow keys, does anyone know why this happens or
how to make it stop?

Dave French
dfrench at hopennmachinery (point) com

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/xlfaqApp.html#Unused
to reset the used range