Could anyone tell me if thay can draw a normal straight line in excel 2007
with a weight of 0.25pt or 0.5pt without it ending up as 0.75pt. I have asked
this question about 9months ago and no one could help me.

Any help will be appreciated.

I used Insert / Shape to draw a line on a worksheet
I copied and pasted it, now I have two
Right clicked the first, used Format, and set weight to 0.25
Ditto the second, to 0.75
On the screen they look alike
But wait, I zoomed to 250% and they are clearly of different size.
Ok to email me privately to exchange files if you wish (remove TRUENORTH.)
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mel" wrote in message
...
Could anyone tell me if thay can draw a normal straight line in excel 2007
with a weight of 0.25pt or 0.5pt without it ending up as 0.75pt. I have
asked
this question about 9months ago and no one could help me.

Any help will be appreciated.

Bernard Liengme wrote:
I used Insert / Shape to draw a line on a worksheet
I copied and pasted it, now I have two
Right clicked the first, used Format, and set weight to 0.25
Ditto the second, to 0.75
On the screen they look alike
But wait, I zoomed to 250% and they are clearly of different size.
Ok to email me privately to exchange files if you wish (remove TRUENORTH.)
best wishes

I tried the same approach and created four lines with weight set from
0.25 to 1 point. With magnification, each line gets progressively
thicker, but when I print out the sheet with normal print quality the
weights all appear to be the same. Even changing to maximum dpi printout
did not change the result on my HP Officejet 5610.

One point, of course, is only 1/72 of an inch. Thats 0.013 inches, which
is pretty thin already.

Bill

Thanks for your reply(s)
I would like to add that if you create different weight lines in 'Word' or
'Publisher' then these lines print out correctly. Due to the nature of the
work I do in Excel I really need to be able to print out the thinnest line
possible.
Do you think that there could be a fix for this problem such as a registry
alteration?

Mel

"Bill Sharpe" wrote:

Bernard Liengme wrote:
I used Insert / Shape to draw a line on a worksheet
I copied and pasted it, now I have two
Right clicked the first, used Format, and set weight to 0.25
Ditto the second, to 0.75
On the screen they look alike
But wait, I zoomed to 250% and they are clearly of different size.
Ok to email me privately to exchange files if you wish (remove TRUENORTH.)
best wishes

I tried the same approach and created four lines with weight set from
0.25 to 1 point. With magnification, each line gets progressively
thicker, but when I print out the sheet with normal print quality the
weights all appear to be the same. Even changing to maximum dpi printout
did not change the result on my HP Officejet 5610.

One point, of course, is only 1/72 of an inch. Thats 0.013 inches, which
is pretty thin already.

Bill

Mel wrote:
Thanks for your reply(s)
I would like to add that if you create different weight lines in 'Word' or
'Publisher' then these lines print out correctly. Due to the nature of the
work I do in Excel I really need to be able to print out the thinnest line
possible.
Do you think that there could be a fix for this problem such as a registry
alteration?

I doubt it. I have no idea why you need even thinner lines in Excel, but
you may want to consider copying the spreadsheet to a Word table and
adding the lines there.

Bill