Excel 2003 - Ctrl-End selects last cell. How chg last cell addr?

[Trevose1955]

Ctrl-End selects last cell in a worksheet. Let's say it is Z1000. However, I
have deleted many rows and some columns so my data now ends at T555. When I
press
Ctrl-End Excel still brings me to Z1000. What do I need to do to make
Ctrl-End take me to T555?

Thanks

[Biff]

Hi!

Reset the used range.

Instructions here:

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

Biff

"Trevose1955" <[email protected]> wrote in message
news:[email protected]...
> Ctrl-End selects last cell in a worksheet. Let's say it is Z1000. However,
> I
> have deleted many rows and some columns so my data now ends at T555. When
> I
> press
> Ctrl-End Excel still brings me to Z1000. What do I need to do to make
> Ctrl-End take me to T555?
>
> Thanks

[Gord Dibben]

Trev

Select all rows below 555 by SHIFT + END + Down Arrow.

Edit>Delete(not clear contents).

Do sam for columns to the right of T.

Now......IMPORTANT......Save the workbook. In some versions a save, close and
re-open was needed.


Gord Dibben Excel MVP

On Fri, 16 Dec 2005 14:15:02 -0800, "Trevose1955"
<[email protected]> wrote:

>Ctrl-End selects last cell in a worksheet. Let's say it is Z1000. However, I
>have deleted many rows and some columns so my data now ends at T555. When I
>press
>Ctrl-End Excel still brings me to Z1000. What do I need to do to make
>Ctrl-End take me to T555?
>
>Thanks