After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes me
back to the same position even though the end of the data is rows and columns
above it?

Hi

one way to solve this is to go to the end of your data (the actual data) and
then from there do control & shift & end and then delete the rows.

now close & save the workbook - when you reopen it the "ending" point should
have been reset.

Cheers
JulieD

"onthe_brink" wrote in message
...
After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes
me
back to the same position even though the end of the data is rows and
columns
above it?

Have a look here

http://www.contextures.com/xlfaqApp.html#Unused

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"onthe_brink" wrote in message
...
After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes
me
back to the same position even though the end of the data is rows and
columns
above it?

"JulieD" wrote:

Hi

one way to solve this is to go to the end of your data (the actual data) and
then from there do control & shift & end and then delete the rows.

now close & save the workbook - when you reopen it the "ending" point should
have been reset.

Cheers
JulieD

"onthe_brink" wrote in message
...
After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes
me
back to the same position even though the end of the data is rows and
columns
above it?


That worked- I didnt think of the save and reopen file.

glad it worked and thanks for the feedback - some versions need the save &
close - others don't - and as i can't remember which do & which don't i
always suggest it!

"onthe_brink" wrote in message
...


"JulieD" wrote:

Hi

one way to solve this is to go to the end of your data (the actual data)
and
then from there do control & shift & end and then delete the rows.

now close & save the workbook - when you reopen it the "ending" point
should
have been reset.

Cheers
JulieD

"onthe_brink" wrote in message
...
After I have deleted data in a spreadsheet, when i use (ctrl+end) it
takes
me
back to the same position even though the end of the data is rows and
columns
above it?


That worked- I didnt think of the save and reopen file.

Just to clarify, DELETE on the Edit menu, not the Del key (which only clears
contents).

On Wed, 9 Feb 2005 23:18:58 +0800, "JulieD"
wrote:

Hi

one way to solve this is to go to the end of your data (the actual data) and
then from there do control & shift & end and then delete the rows.

now close & save the workbook - when you reopen it the "ending" point should
have been reset.

Cheers
JulieD

"onthe_brink" wrote in message
...
After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes
me
back to the same position even though the end of the data is rows and
columns
above it?