Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column width
I'm trying to make the cells on a spreadsheet be 4.5" long by 2.5" tall. I
can't seem to figure out how to make it be a measurement vs pixels/characters. Can anyone help me with this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column width
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 which you can convert to inches. Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Sun, 6 Jan 2008 10:00:00 -0800, HomeworkHelpNeeded! wrote: I'm trying to make the cells on a spreadsheet be 4.5" long by 2.5" tall. I can't seem to figure out how to make it be a measurement vs pixels/characters. Can anyone help me with this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column width
Thank you! That helped!
"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 which you can convert to inches. Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Sun, 6 Jan 2008 10:00:00 -0800, HomeworkHelpNeeded! wrote: I'm trying to make the cells on a spreadsheet be 4.5" long by 2.5" tall. I can't seem to figure out how to make it be a measurement vs pixels/characters. Can anyone help me with this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column width
Based on the discussion in that link, do you know the original standard font
and point size that was used to create a measurable sheet? My logic says that if I change my "style" to that standard font (not necessarily the actual font used in the cells), I can then get the exact measurements to line up a sheet so that the margins are not variable. The problem I run into is that my headers don't snap to the top and left margins because my furthest right column drops off the printable area before it reaches the last few pixels available for a letter-sized sheet. "HomeworkHelpNeeded!" wrote: Thank you! That helped! "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 which you can convert to inches. Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Sun, 6 Jan 2008 10:00:00 -0800, HomeworkHelpNeeded! wrote: I'm trying to make the cells on a spreadsheet be 4.5" long by 2.5" tall. I can't seem to figure out how to make it be a measurement vs pixels/characters. Can anyone help me with this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column width
From help on default column width....................
The number that appears in the Standard column width box is the average number of digits 0-9 of the standard font (standard font: The default text font for worksheets. The standard font determines the default font for the Normal cell style.) that fit in a cell. The "standard font" is whatever you have chosen under ToolsOptionsGeneral I think you would have to play around with various fonts until(maybe) you get what you need. Gord On Tue, 3 Mar 2009 15:37:14 -0800, AS wrote: Based on the discussion in that link, do you know the original standard font and point size that was used to create a measurable sheet? My logic says that if I change my "style" to that standard font (not necessarily the actual font used in the cells), I can then get the exact measurements to line up a sheet so that the margins are not variable. The problem I run into is that my headers don't snap to the top and left margins because my furthest right column drops off the printable area before it reaches the last few pixels available for a letter-sized sheet. "HomeworkHelpNeeded!" wrote: Thank you! That helped! "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 which you can convert to inches. Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Sun, 6 Jan 2008 10:00:00 -0800, HomeworkHelpNeeded! wrote: I'm trying to make the cells on a spreadsheet be 4.5" long by 2.5" tall. I can't seem to figure out how to make it be a measurement vs pixels/characters. Can anyone help me with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
width of column is zero | Excel Worksheet Functions | |||
Varying column width in a column chart | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |