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
|