View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RWood
 
Posts: n/a
Default 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