Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 EditNewDWORD Value 6. Type the name for the DWORD: FontSub 7. Press Enter to complete the renaming 8. Choose EditModify 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 |
#3
|
|||
|
|||
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 EditNewDWORD Value 6. Type the name for the DWORD: FontSub 7. Press Enter to complete the renaming 8. Choose EditModify 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 |
#4
|
|||
|
|||
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 EditNewDWORD Value 6. Type the name for the DWORD: FontSub 7. Press Enter to complete the renaming 8. Choose EditModify 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change display font to actual selected font | Excel Discussion (Misc queries) | |||
How can I display certain results in a color font | Excel Worksheet Functions | |||
ACAD does not display Technic font properly in office 2003-why? | Excel Discussion (Misc queries) | |||
How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |