Arial Font not fixed pitch on display zoom <79%

In Excel 2000, if you use Arial font with a size of 10 pitch, with a View
Zoom factor of 79% or below it is displayed as a proportional font. i.e. the
number 1 uses less space than the number 8. If you use a zoom factor of
greater than 80% it displays as a fixed pitch font. Is there any way to make
the font display permanently as fixed pitch, regardless of zoom factor?

Arial is always proportional--maybe you meant courier new???

Maybe this post by Debra Dalgleish will help:

You can change a registry setting to prevent this from happening (make a
backup copy of the registry first):

1. From the Start button, choose Run
2. Type regedit then click OK
3. Click the + sign to the left of HKEY_CURRENT_USER
4. Open Software, Microsoft, Office, 9.0, Excel, Options
5. Choose Edit>New>DWORD Value
6. Type the name for the DWORD: FontSub
7. Press Enter to complete the renaming
8. Choose Edit>Modify
9. Type 0 as the value, select Decimal, and click OK
10. Close the Registry Editor

=====
That 9.0 will vary with your version of excel.

LeighUK wrote:
>
> In Excel 2000, if you use Arial font with a size of 10 pitch, with a View
> Zoom factor of 79% or below it is displayed as a proportional font. i.e. the
> number 1 uses less space than the number 8. If you use a zoom factor of
> greater than 80% it displays as a fixed pitch font. Is there any way to make
> the font display permanently as fixed pitch, regardless of zoom factor?

--

Dave Peterson

The fix suggested had no effect. The Font is definitely Arial and it does
display as a fixed pitch on Zoom >80%

Thanks.

"Dave Peterson" wrote:

> Arial is always proportional--maybe you meant courier new???
>
> Maybe this post by Debra Dalgleish will help:
>
> You can change a registry setting to prevent this from happening (make a
> backup copy of the registry first):
>
> 1. From the Start button, choose Run
> 2. Type regedit then click OK
> 3. Click the + sign to the left of HKEY_CURRENT_USER
> 4. Open Software, Microsoft, Office, 9.0, Excel, Options
> 5. Choose Edit>New>DWORD Value
> 6. Type the name for the DWORD: FontSub
> 7. Press Enter to complete the renaming
> 8. Choose Edit>Modify
> 9. Type 0 as the value, select Decimal, and click OK
> 10. Close the Registry Editor
>
> =====
> That 9.0 will vary with your version of excel.
>
> LeighUK wrote:
> >
> > In Excel 2000, if you use Arial font with a size of 10 pitch, with a View
> > Zoom factor of 79% or below it is displayed as a proportional font. i.e. the
> > number 1 uses less space than the number 8. If you use a zoom factor of
> > greater than 80% it displays as a fixed pitch font. Is there any way to make
> > the font display permanently as fixed pitch, regardless of zoom factor?
>
> --
>
> Dave Peterson
>

I've never seen Arial show up as fixed width at 100%.

So I don't have another guess.

That fix worked for me in xl97, xl2k, xl2002 and xl2003, though.

LeighUK wrote:
>
> The fix suggested had no effect. The Font is definitely Arial and it does
> display as a fixed pitch on Zoom >80%
>
> Thanks.
>
> "Dave Peterson" wrote:
>
> > Arial is always proportional--maybe you meant courier new???
> >
> > Maybe this post by Debra Dalgleish will help:
> >
> > You can change a registry setting to prevent this from happening (make a
> > backup copy of the registry first):
> >
> > 1. From the Start button, choose Run
> > 2. Type regedit then click OK
> > 3. Click the + sign to the left of HKEY_CURRENT_USER
> > 4. Open Software, Microsoft, Office, 9.0, Excel, Options
> > 5. Choose Edit>New>DWORD Value
> > 6. Type the name for the DWORD: FontSub
> > 7. Press Enter to complete the renaming
> > 8. Choose Edit>Modify
> > 9. Type 0 as the value, select Decimal, and click OK
> > 10. Close the Registry Editor
> >
> > =====
> > That 9.0 will vary with your version of excel.
> >
> > LeighUK wrote:
> > >
> > > In Excel 2000, if you use Arial font with a size of 10 pitch, with a View
> > > Zoom factor of 79% or below it is displayed as a proportional font. i.e. the
> > > number 1 uses less space than the number 8. If you use a zoom factor of
> > > greater than 80% it displays as a fixed pitch font. Is there any way to make
> > > the font display permanently as fixed pitch, regardless of zoom factor?
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson