Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-12-2013, 08:36 AM
VictoriaT8 VictoriaT8 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2013
Posts: 2
VictoriaT8 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-22-2013, 03:18 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,801
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-22-2013, 06:14 AM
VictoriaT8 VictoriaT8 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2013
Posts: 2
VictoriaT8 is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 02-22-2013, 07:54 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,801
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printable Area issues zaineyma Word 3 12-12-2012 09:11 AM
Markup Area Too Large sthguard Word 2 06-17-2011 02:14 AM
Section 1 margins outside print area Doc_man Word 2 04-29-2011 03:46 PM
How can I add an area for people to take notes chloe PowerPoint 1 12-05-2010 02:57 PM
Area Graph Question DavidB Excel 0 09-21-2009 08:14 PM


All times are GMT -7. The time now is 08:07 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft