Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
Windows and Office gives you Arial font when you ask for Helvetica.
We recently told you about the Helvetica font in Windows and Microsoft Office – or rather it’s noticeable absence. Microsoft plays some strange font substitution tricks that got us digging further.
As we’ve noted, if you open up a document with Helvetica formatting, Office for Windows will show you Arial as a substitute. That’s not unusual because Mac computers have Helvetica but Office for Mac doesn’t support font embedding.
For example, here’s a document in Word 2011 for Mac with both Helvetica and Arial fonts. Notice the difference between the right down stroke on the capital R – it’s almost vertical in Helvetica and more of an angle in Arial.
Now open the same document in Word 2013 for Windows (or any Word for Windows) and check out the capital R – they are the same even though there’s two different fonts. That’s because Windows has, without warning, replaced Helvetica with Arial on the displayed page.
The font list shows you the font that’s set in the document but there’s no direct or obvious way to know that the named font isn’t the one being displayed or, for the most part, printed.
That might not seem like a big deal but it’s a massive difference for designers and can cause all sorts of formatting hassles.
The only way to know what’s going on is to dig down to Options | Advanced | Show document content | Font Substitution. Even then, the substitution isn’t clear.
We can see that ‘Helvetica Neue’ is substituted with ‘Malgun Gothic’ – no problem there.
According to Word 2013 the substitution for ‘Helvetica’ is ‘Helvetica’ or ‘Default’ depending on which part of the dialog box you read! That doesn’t make any sense on several levels. In fact it’s quite wrong and misleading. It’s a sneaky way to substitute a popular font while obscuring the truth.
Of course, the wording should be:
The default substitution for ‘Helvetica’ is ‘Arial’
You can change the font substitution for an individual document on the Word dialog shown above by choosing another font.
The idea of font substitution is a good one. Alas, Microsoft’s implementation lacks transparency or clarity for anyone who needs the exact font used. It’s not too much to ask that users are told when and what font substitution is done.
Windows is setup to use Arial whenever it sees a reference to ‘Helvetica’. This happens at the Windows level and doesn’t just apply to Microsoft Office. Most web browsers get the same thing – web pages that ask for ‘Helvetica’ to display in web page will get the Arial font instead. It drives web designers crazy, especially since CSS has a way to choose from a family of preferred fonts.
Way down in the bowels of the Windows Registry is HCLMSOFTWAREMicrosoftWindows NTCurrentVersionFontSubstitutes which lists the subsitutions.
The registry has a list of font names and the font which Windows should deliver instead. The number after a comma is a specific Code Page. Some of those Windows 8 entries are:
Ask for this font …
And you’ll get
MS Sans Serif
Times New Roman
Arabic – an Arabic language font
Rod – a Hebrew font
The two ‘Transparent’ fonts were used in Windows 2000, Windows XP and Windows Server 2003 but have been replaced for later versions of Windows.
Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.