Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
cell/column/row size??
Excel 2k, winxp
Would like to set up a spreadsheet with the columns and rows all the same size and with the measurements in " instead of characters, pixels and/or points. What I'm actually trying to do is set up each column as 1.25" and row .50". Is this possible without "trial and error"? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
cell/column/row size??
You will have to use VBA to get those exact measurements.
Ole Erlandson has code for setting row and column dimensions in millimeters. http://www.erlandsendata.no/english/...vbawssetrowcol 25.4 mm to the inch Gord Dibben Excel MVP On Wed, 2 Jul 2008 14:41:45 -0500, "L.S." wrote: Excel 2k, winxp Would like to set up a spreadsheet with the columns and rows all the same size and with the measurements in " instead of characters, pixels and/or points. What I'm actually trying to do is set up each column as 1.25" and row .50". Is this possible without "trial and error"? |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
cell/column/row size??
Thanks.
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... You will have to use VBA to get those exact measurements. Ole Erlandson has code for setting row and column dimensions in millimeters. http://www.erlandsendata.no/english/...vbawssetrowcol 25.4 mm to the inch Gord Dibben Excel MVP On Wed, 2 Jul 2008 14:41:45 -0500, "L.S." wrote: Excel 2k, winxp Would like to set up a spreadsheet with the columns and rows all the same size and with the measurements in " instead of characters, pixels and/or points. What I'm actually trying to do is set up each column as 1.25" and row .50". Is this possible without "trial and error"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Wrap and extending cell/row/column size | Excel Discussion (Misc queries) | |||
Row/Column Size to inches? | Excel Discussion (Misc queries) | |||
cell size and font size | Excel Discussion (Misc queries) | |||
How can I determine the largest physical size cell in a column | Excel Worksheet Functions | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) |