ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Font different than one chosen (https://www.excelbanter.com/excel-discussion-misc-queries/130584-font-different-than-one-chosen.html)

Bruce

Font different than one chosen
 
I have Times New Roman selected as my font. When I highlight a cell, in the
formula bar, it's Times New Roman. When I view it in the actual cells of the
sheet, it's arial.

Even if I highlight all and click Times New Roman, the font won't change.

Please help.

Dave Peterson

Font different than one chosen
 
What's your zoom level set for?

When you zoom to 100% does it look like it's using the font that you specified?

If yes, then 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


Bruce wrote:

I have Times New Roman selected as my font. When I highlight a cell, in the
formula bar, it's Times New Roman. When I view it in the actual cells of the
sheet, it's arial.

Even if I highlight all and click Times New Roman, the font won't change.

Please help.


--

Dave Peterson

Bruce

Font different than one chosen
 
As easy as that! I wish everything were that easy. Thank you.

"Dave Peterson" wrote:

What's your zoom level set for?

When you zoom to 100% does it look like it's using the font that you specified?

If yes, then 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


Bruce wrote:

I have Times New Roman selected as my font. When I highlight a cell, in the
formula bar, it's Times New Roman. When I view it in the actual cells of the
sheet, it's arial.

Even if I highlight all and click Times New Roman, the font won't change.

Please help.


--

Dave Peterson



All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com