Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make row height and column width equal
I want to make my grid into perfect squares: row height = column
width. The problem is, they seem to use different measurement schemes. Is there some conversion factor, or way to set columns to use the same measurement scheme as rows? I need them to print out as perfect squares. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make row height and column width equal
it's your monitor resolution, if you are at 800x600, 80x60 pixels will give
you a square, and so forth " wrote: I want to make my grid into perfect squares: row height = column width. The problem is, they seem to use different measurement schemes. Is there some conversion factor, or way to set columns to use the same measurement scheme as rows? I need them to print out as perfect squares. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make row height and column width equal
My 17"LCD is set for 1158 x 864 resolution. I use 1.71 column width to give
me some pretty good looking squares.........I use it as a 1ft by 1ft grid to draw floorplans. It works pretty good for that. Vaya con Dios, Chuck, CABGx3 " wrote: I want to make my grid into perfect squares: row height = column width. The problem is, they seem to use different measurement schemes. Is there some conversion factor, or way to set columns to use the same measurement scheme as rows? I need them to print out as perfect squares. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make row height and column width equal
75.75 x 13.57 will get you close. BUT that will shift based on your
printer and monitor settings. So start there, and then print and adjust based on the output. wrote: I want to make my grid into perfect squares: row height = column width. The problem is, they seem to use different measurement schemes. Is there some conversion factor, or way to set columns to use the same measurement scheme as rows? I need them to print out as perfect squares. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make row height and column width equal
No, you are confusing resolution of the monitor with DPI. the DPI is the
same in both directions so 80x80 pixels will be a square, BUT the print out will be slightly off. dlw wrote: it's your monitor resolution, if you are at 800x600, 80x60 pixels will give you a square, and so forth " wrote: I want to make my grid into perfect squares: row height = column width. The problem is, they seem to use different measurement schemes. Is there some conversion factor, or way to set columns to use the same measurement scheme as rows? I need them to print out as perfect squares. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make row height and column width equal
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 Tue, 05 Feb 2008 07:40:21 -0800, wrote: I want to make my grid into perfect squares: row height = column width. The problem is, they seem to use different measurement schemes. Is there some conversion factor, or way to set columns to use the same measurement scheme as rows? I need them to print out as perfect squares. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row height/column width | Excel Discussion (Misc queries) | |||
Cell Height & Width Equal | Excel Discussion (Misc queries) | |||
Column Width and Row Height | Excel Worksheet Functions | |||
How to make row height to exactly equal column width? | Excel Discussion (Misc queries) | |||
Can I make column width and row height equal (a grid) in Excel? | Excel Discussion (Misc queries) |