Excel - Row Height / Column Width Unit 1

[danrobson]

Hi all, can anyone tell me how I can set a row and column to a specific size in inches or mm? ?

Thanks in Adnace,

Dan

 

[LittleRedHat]

Hi Dan,

Selecting the row or column, then using Format/Row/Height and Format/Column/Width should do it for you.

Right clicking on the row no. or column letter also takes you there.

LRH

 

[danrobson]

Thanks for the advise, however, that's not the problem, what I want to do is set the width or height to a certain size, in either inches or mm, eg, if I want to set the row height to 1 inch or 25 mm what should I set the row height value too ? The default values are width 8.43 and height 12.75 what units do these values represent ?

Thanks again,

Dan

 

[ilses]

Quote from article Q130050 in the Knowledge Base:

<quote>Microsoft Excel uses the font assigned in the Normal style as the basis for column widths. There is no direct way to assign exact column widths in inches/centimeters without trial and error.

Microsoft Excel uses the number of digits (specifically, the number of zeros) using the Normal style font as the measurement to determine column widths. (There are some fonts that have digits of different widths, but this is unusual.)

For example, using the default font, a column width of 10 means the column width needed to display 10 non-bold, non-italic, Arial 10-point zeros. On the Macintosh, this same column width is 10 non-bold, non-italic Geneva 10-point zeros. Microsoft Excel uses digits to determine column widths so that when you change the font for a style on a worksheet, the columns grow or shrink to display this number of digits in the column.<unquote>

The rest of the article gives some VBA methods to help you work with this issue.

IS