Change Last Cell
 

How do you change the last cell in your worksheet? I want to reassign the
last cell it takes me to when I choose CTRL+END.

Change Last Cell
 

Try this:

Delete all of the extraneous rows and columns.
(EditDeleteEntire Row/Column)

Save the workbook.

Try [Ctrl]+[End]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"DAVIS" wrote:

How do you change the last cell in your worksheet? I want to reassign the
last cell it takes me to when I choose CTRL+END.

Change Last Cell
 

If you search for ctrl+end in microsoft.public.access, you will see several
posts asking about this.
With Excel 2003, sometimes edit/delete works, sometimes it doesn't. What
does work (sometimes I have to do the edit/delete first), is to do
file/save-as to save the file to itself.

"Ron Coderre" wrote:

Try this:

Delete all of the extraneous rows and columns.
(EditDeleteEntire Row/Column)

Save the workbook.

Try [Ctrl]+[End]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"DAVIS" wrote:

How do you change the last cell in your worksheet? I want to reassign the
last cell it takes me to when I choose CTRL+END.