View Single Post
  #2   Report Post  
JMB
 
Posts: n/a
Default

Do you mean it doesn't reduce the size of the worksheet when you try to print?

Try File/Print Area/Clear Print Area.

Also, instead of just deleting the rows you don't need, try Edit/Clear/All.
This will remove any formatting.



"Bud Reid" wrote:

Hi:

I have been given a sheet with 200 rows.

Rows 10 through 200 are identical.

The print area is rows 1 through 30.

I want to delete rows 31 through 200 so that it may be used in another
program.

How do I do this? Highlighting the rows and deleting deletes the contents
but does not reduce the size of the woorksheet.

Help please.

Thanks .....Bud