Microsoft Office Forums

Microsoft Office Forums (https://www.msofficeforums.com/)
-   Excel (https://www.msofficeforums.com/excel/)
-   -   How to edit cell data without changing print area. FIXED print area (https://www.msofficeforums.com/excel/15954-how-edit-cell-data-without-changing-print.html)

VictoriaT8 02-12-2013 08:36 AM

How to edit cell data without changing print area. FIXED print area
 
I have a workbook with multiple sheets that I need to print.


Is there a way to create a fixed print area within which you can mess around with formatting without extending or shrinking the print area?


I have tried adjusting the margins settings so that they are all the same, but this does nothing to keep a fixed print area.


Any advice would be greatly appreciated


Thanks

macropod 02-22-2013 03:18 AM

Hi Victoria,

In Excel, anything you do to change a row's height or a column's width affects all cells on that row or column, respectively. Given what you're describing, you may need to create one or more separate worksheets, linked to the just the content containing the print data in the source sheets, with only the destination sheet formatted for printing.

FWIW, In Word, a table can have rows & columns that are independently sized from the other rows & columns.

VictoriaT8 02-22-2013 06:14 AM

Thanks for your reply.

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?

- How should I do that

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?

- If I change the size of a cell, do my margins change?

Thanks again for your help

Victoria

macropod 02-22-2013 07:54 PM

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


All times are GMT -7. The time now is 12:55 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft