![]() |
How to scale from Excel screen to printer?
I am trying to make a grid with Excel to use to plan a building. I can set a
column and row to be 96 pixels which should give an inch square, but when I print to my Dell 942 the horizontal distance is a little over an inch while the vertical distance is less than an inch. Is this due to the printer's resolution? Is there a way to calculate widths and heights in Excel to scale correctly to the printer? Thank You! |
How to scale from Excel screen to printer?
You're simply using the wrong application.
-- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Norm Lundquist" wrote: |I am trying to make a grid with Excel to use to plan a building. I can set a | column and row to be 96 pixels which should give an inch square, but when I | print to my Dell 942 the horizontal distance is a little over an inch while | the vertical distance is less than an inch. | | Is this due to the printer's resolution? Is there a way to calculate widths | and heights in Excel to scale correctly to the printer? | | Thank You! |
How to scale from Excel screen to printer?
Norm,
There was a recent post here (I forget who) about the vagaries of Excel's print engine. If you need this precision, don't use Excel. AutoCad or Illustrator would be better applications. Open Office have a drawing app that free; can't say how good. If this must be in Excel/VBA, the Printer APIs can achieve precise results, but then you have to do everything yourself. NickHK "Norm Lundquist" wrote in message ... I am trying to make a grid with Excel to use to plan a building. I can set a column and row to be 96 pixels which should give an inch square, but when I print to my Dell 942 the horizontal distance is a little over an inch while the vertical distance is less than an inch. Is this due to the printer's resolution? Is there a way to calculate widths and heights in Excel to scale correctly to the printer? Thank You! |
All times are GMT +1. The time now is 11:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com