Is there anyway to change exact cell height.

[Guest]

I am working on using Excel to print out an exact spacing for a terminal
strip. I have used to 72 points to an inch to get the exact spacing but excel
wont alow me to enter the exact number when I specify it, I notice it only
allows the exact pixel by increments of 1. Is there anyway around this so I
can type ine the exact number for the cell height?

 

[Frank Kabel]

Hi
AFAIK you can only define it in pixels

 

[Guest]

Thanks the the answer, I guess I will have to look for another solution to my
problem, Havnt found any program that lets me specify the exact space between
text like I need, Anyone with any suggestions?

 

[Frank Kabel]

Hi
maybe MS Word will do this or a 'real' pagemaking program (e.g. Quark)

 

[Guest]

Quark loked like maybe it might do it, Looked at using MS Word as well but
didnt see anything to type in exact numbers such as .205 spacing between text
lines, I really cant believe I cant find anything out there to do this.

 

[Frank Kabel]

Also check Pagemaker, Adobe InDesign, etc.

 

[Gord Dibben]

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/index.php?d=envbawssetrowcol

Gord Dibben Excel MVP