CTL-END not working as expected

[David Lipetz]

CTL-END should select the last cell in a worksheet. I have a workbook that
contains a worksheet used to store transactional data. The 12/31/08 sheet
had 15401 rows of data and CTL-END always selected last cell O15401.

Each week, I copy and paste the new transactional data from one workbook to
the worksheet in my master.

The latest 2009 data worksheet has 726 rows of data and CTL-END properly
select O726 within that sheet. However, after copying and pasting (using
CTL-A to select all data in the source and destination sheets, then pressing
CTL-Cin the source sheet and CTL-V in the destination to paste), CTL-END
zips me down to O15401. There is no data there. I have selected the entire
sheet using CTL-A and selected clear and delete to no avail.

How can I correct this so that CTL-END works properly?

Thanks,
David

 

[Don Guillett]

Instead of clear use DELETE to delete the rows and then SAVE the workbook.

 

[David Lipetz]

Unfortunately, using DELETE destroys all of my defined names for that sheet.
Looks like I may just have to recreate the names.

 

[Don Guillett]

Defined names can be self adjusting. ie:
=offset($a$1,0,0,counta($a:$a),12)

 

[MartinW]

Hi David,

You need to reset the used range, Debra Dalgleish shows you how here.
http://www.contextures.com/xlfaqApp.html#Unused

HTH
Martin