|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 28th, 2004, 08:13 PM
|
|||
|
|||
Is there anyway to change exact cell height.
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? 
|
|
#2
October 28th, 2004, 08:36 PM
|
|||
|
|||
|
Hi
AFAIK you can only define it in pixels -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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?
|
|
#3
October 28th, 2004, 08:47 PM
|
|||
|
|||
|
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" wrote: Hi AFAIK you can only define it in pixels -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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?
|
|
#4
October 28th, 2004, 09:24 PM
|
|||
|
|||
|
Hi
maybe MS Word will do this or a 'real' pagemaking program (e.g. Quark) -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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" wrote: Hi AFAIK you can only define it in pixels -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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?
|
|
#5
October 28th, 2004, 10:14 PM
|
|||
|
|||
|
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" wrote: Hi maybe MS Word will do this or a 'real' pagemaking program (e.g. Quark) -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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" wrote: Hi AFAIK you can only define it in pixels -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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?
|
|
#6
October 28th, 2004, 10:20 PM
|
|||
|
|||
|
Also check Pagemaker, Adobe InDesign, etc.
-- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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" wrote: Hi maybe MS Word will do this or a 'real' pagemaking program (e.g. Quark) -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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" wrote: Hi AFAIK you can only define it in pixels -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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?
|
|
#7
October 29th, 2004, 12:35 AM
|
|||
|
|||
|
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/...vbawssetrowcol Gord Dibben Excel MVP On Thu, 28 Oct 2004 14:14:04 -0700, "nascar24" wrote: 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" wrote: Hi maybe MS Word will do this or a 'real' pagemaking program (e.g. Quark) -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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" wrote: Hi AFAIK you can only define it in pixels -- Regards Frank Kabel Frankfurt, Germany "nascar24" schrieb im Newsbeitrag ... 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatically change row height when wrapping text in merged cell. | wadrazil | General Discussion | 2 | October 20th, 2004 12:19 AM |
| Change cell background coulor | Des | General Discussion | 2 | July 11th, 2004 09:42 PM |
| Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
Linear Mode
