Excel Convert

  Terry Brown 19:35 19 Aug 2004
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 2004

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 2004

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.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?