Reducing the size of a woorsheet

  • Thread starter Thread starter Bud Reid
  • Start date Start date
B

Bud Reid

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
 
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.
 
Highlight rows 31 through 200, then click Edit, Delete.


Bud Reid said:
Hi:
Click to expand...
I have been given a sheet with 200 rows.
Click to expand...
Rows 10 through 200 are identical.
Click to expand...
The print area is rows 1 through 30.
Click to expand...
I want to delete rows 31 through 200 so that it may be used in another
program.
Click to expand...
How do I do this? Highlighting the rows and deleting deletes the contents
but does not reduce the size of the woorksheet.
Click to expand...
 
Hi:

Thanks for the reply.

To do what I want I had to select A31 and then "ctl end" and then do the
delete.

Thanks again.

....Bud
 
Back
Top