CTL-END not working as expected

D

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
 
D

David Lipetz

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top