HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS
 

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

HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS
 

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

HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS
 

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

HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS
 

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

HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CE
 

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

HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CE
 

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

HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS
 

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