Excel Convert

  Terry Brown 19:35 19 Aug 04
Locked

Is there a formula that will allow me to convert the pixel size of a cell to either metric or imperial measurments, to show the true size whem printed.
Thanks Terry

  Simsy 20:26 19 Aug 04

but bear in mind that if you were to change the zoom range, the pixels ratio changes.

I'd love to see the solution to this myself!

Good luck,

Regards,

Sims

  pc moron 23:43 19 Aug 04

I'm not sure about this but you could try the following (I'm assuming Excel xp):

Open the VBA Editor (Alt+F11) and in the Help box type pixels.

Select the PixelsPerInch property and have a read.

Printers use dots per inch, so if you can match up the pixels with the dots on your particular printer it might work.

You have to open the Excel workbook in a browser though.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac