I've deleteda number of rows (250) yet the worksheet still thinks the
worksheet is it's original size (the scroll bar hasn't changed).

I want to "shorten" the worksheet to it's current size and lose the
formatting for the unused cells.

Thanks

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"RWood" wrote in message
...
I've deleteda number of rows (250) yet the worksheet still thinks the
worksheet is it's original size (the scroll bar hasn't changed).

I want to "shorten" the worksheet to it's current size and lose the
formatting for the unused cells.

Thanks

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

RWood wrote:

I've deleteda number of rows (250) yet the worksheet still thinks the
worksheet is it's original size (the scroll bar hasn't changed).

I want to "shorten" the worksheet to it's current size and lose the
formatting for the unused cells.

Thanks

--

Dave Peterson

You really have to delete those rows, not just empty them.
Then save and close the file and re-open.

--
Kind regards,

Niek Otten

"RWood" wrote in message
...
I've deleteda number of rows (250) yet the worksheet still thinks the
worksheet is it's original size (the scroll bar hasn't changed).

I want to "shorten" the worksheet to it's current size and lose the
formatting for the unused cells.

Thanks

Thanks, it worked!
RW

"Niek Otten" wrote:

You really have to delete those rows, not just empty them.
Then save and close the file and re-open.

--
Kind regards,

Niek Otten

"RWood" wrote in message
...
I've deleteda number of rows (250) yet the worksheet still thinks the
worksheet is it's original size (the scroll bar hasn't changed).

I want to "shorten" the worksheet to it's current size and lose the
formatting for the unused cells.

Thanks

Niek Otten's responsed worked for me

Thanks for the assistance

RW


"Dave Peterson" wrote:

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

RWood wrote:

I've deleteda number of rows (250) yet the worksheet still thinks the
worksheet is it's original size (the scroll bar hasn't changed).

I want to "shorten" the worksheet to it's current size and lose the
formatting for the unused cells.

Thanks

--

Dave Peterson

Niek Otten's responsed worked for me

Thanks for the assistance

RW



"RWood" wrote:

I've deleteda number of rows (250) yet the worksheet still thinks the
worksheet is it's original size (the scroll bar hasn't changed).

I want to "shorten" the worksheet to it's current size and lose the
formatting for the unused cells.

Thanks