View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Measurements, the ruler in page layout

Ben

Other than running the code from Ole's site I do not know of a method to set
column widths and row heights to exact measurements in mm.

Gord

On Fri, 7 Sep 2007 21:52:00 -0700, Ben Edwards
wrote:

Thanks very much for both messages. The purpose for which it would be great
to set column widths exactly is that we produce financial models (finacial
projections, up to 20 rows deep and typically 10 columns wide) that then form
part of powerpoint presentations (not for screen shows, but for financing
"pitch books"). In the format of our Powerpoint presentations, the space I've
created is exactly 22.5 cm wide, and so I thought if I can make things look
exactly right in Excel 2007 (and to be exactly 22.5 cm wide), I could then
cut/paste special as a wmf or some such file scaled to exactly 100% and have
it fit perfectly in our company-wide PPT presentation templates. Given all
the above, is there a better way?? Am also using PPT 2007.

Thanks again,
Ben