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

[RWood]

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

 

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Dave Peterson]

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

 

[Niek Otten]

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

 

[RWood]

Thanks, it worked!
RW

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

 

[RWood]

Niek Otten's responsed worked for me

Thanks for the assistance

RW

 

[RWood]

Niek Otten's responsed worked for me

Thanks for the assistance

RW