Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Why can't I type in exact column widths in the page layout ruler so that it
is exactly the same size of an object (a line, or a rectangle), say 20 cm long (such as having 5 columns 4cm each?). Can it be done? Where can I find out more of this?? Ben |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you want ALL columns the same width, Pick Format, Column, Standard
Width, plug in a number, and click OK. Ben Edwards wrote: Why can't I type in exact column widths in the page layout ruler so that it is exactly the same size of an object (a line, or a rectangle), say 20 cm long (such as having 5 columns 4cm each?). Can it be done? Where can I find out more of this?? Ben |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the inch. The number that appears in the Standard column width box is the average number of digits 0-9 of the standard font that fit in a cell. For an interesting and enlightening discussion on this subject see http://snipurl.com/dzz8 If you want to use VBA to set height and width in mm. Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Wed, 5 Sep 2007 12:48:05 -0700, Ben Edwards wrote: Why can't I type in exact column widths in the page layout ruler so that it is exactly the same size of an object (a line, or a rectangle), say 20 cm long (such as having 5 columns 4cm each?). Can it be done? Where can I find out more of this?? Ben |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- Ben "Gord Dibben" wrote: Row heights are measured in points or pixels. There are 72 points to an inch and "maybe" 96 pixels to the inch. The number that appears in the Standard column width box is the average number of digits 0-9 of the standard font that fit in a cell. For an interesting and enlightening discussion on this subject see http://snipurl.com/dzz8 If you want to use VBA to set height and width in mm. Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Wed, 5 Sep 2007 12:48:05 -0700, Ben Edwards wrote: Why can't I type in exact column widths in the page layout ruler so that it is exactly the same size of an object (a line, or a rectangle), say 20 cm long (such as having 5 columns 4cm each?). Can it be done? Where can I find out more of this?? Ben |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Gord. Will give the code a try and see how things work. Appreciate the
post. Ben -- Ben "Gord Dibben" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Page Layout | Excel Discussion (Misc queries) | |||
How do I print a page with a horizontal layout? | Excel Discussion (Misc queries) | |||
Page Layout in Excel | Excel Discussion (Misc queries) | |||
default page layout | Excel Discussion (Misc queries) | |||
Default page margin measurements in Excel 2000 | Excel Discussion (Misc queries) |