Change Last Cell

[Guest]

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.

 

[Guest]

Try this:

Delete all of the extraneous rows and columns.
(Edit>Delete>Entire Row/Column)

Save the workbook.

Try [Ctrl]+[End]

Does that help?

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

XL2002, WinXP-Pro

 

[Guest]

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.

Try this:

Delete all of the extraneous rows and columns.
(Edit>Delete>Entire Row/Column)

Save the workbook.

Try [Ctrl]+[End]

Does that help?

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

XL2002, WinXP-Pro

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.