Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reducing the size of a woorsheet
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Highlight rows 31 through 200, then click Edit, Delete.
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 -- Gary L. Smith Columbus, Ohio |
#4
|
|||
|
|||
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 "Gary Smith" wrote in message ... Highlight rows 31 through 200, then click Edit, Delete. 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 -- Gary L. Smith Columbus, Ohio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font size prints same size regardless of how I set it in Excel | Excel Discussion (Misc queries) | |||
Reducing the size of an xls file with pivot charts | Charts and Charting in Excel | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
Customize page size | Setting up and Configuration of Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |