How do i change the last cell on a worksheet?

[jmalcm]

I have somehow got a last cell on my worksheet at row 65536 when I click
CTRL+END. How do i change the last cell so that when I click CTRL+END it
only goes to row 150, which is the last row with data?

[Bill Martin]

Highlight all the rows from 151 to the end of the sheet, right click and
select "delete". Then save your file and close it. When you reopen the
file, it should be right.

Bill
--------------------------
On Thu, 9 Mar 2006 09:18:45 -0800, jmalcm wrote:

> I have somehow got a last cell on my worksheet at row 65536 when I click
> CTRL+END. How do i change the last cell so that when I click CTRL+END it
> only goes to row 150, which is the last row with data?

[Dave Peterson]

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

jmalcm wrote:
>
> I have somehow got a last cell on my worksheet at row 65536 when I click
> CTRL+END. How do i change the last cell so that when I click CTRL+END it
> only goes to row 150, which is the last row with data?

--

Dave Peterson

[Ron Coderre]

See Debra Dalgleish's website:

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

Does that help?

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

XL2002, WinXP-Pro


"jmalcm" wrote:

> I have somehow got a last cell on my worksheet at row 65536 when I click
> CTRL+END. How do i change the last cell so that when I click CTRL+END it
> only goes to row 150, which is the last row with data?