Hi Victoria,
Quote:
|
So is the only solution to create the data in word or another program and then insert it into the print area on an excel sheet?
|
No, not at all. Aside from the fact that won't work, I already told you how you could use a separate worksheet for the print ranges in Excel.
Quote:
|
Also, is it possible to manually manipulate excel sheets with different layouts to print to the same size using margins, scale and print are settings?
|
Within reason, yes. In fact, if you select multiple sheets, then use the Page layout tools to set the margins & scale, etc, the same setting will automatically apply to all those worksheets. Just don't try doing this when you've got sheets with a mix of portrait & landscape pages selected