Solved: Fonts on a Mac for Microsoft office – why are they not updating? Where are they? That it will appear in Excel – it might once the cache catches up. For a few years now I have download new fonts into my Font Book and can use them all in PPT and Word. Recently I bought and downloaded a new font bundle and only half the fonts. By default, Excel for Mac uses Body Font in font size 12, which is displayed as Calibri font in font size 12 when you type data in a worksheet, header or footer, or text box. However, you can change the default font and font size for all new workbooks that you create. On the Excel menu, click Preferences.
Macs are not perfect even though one’s productivity is much higher with one. When things go wrong – they can sometimes really go wrong.
One customer had issues with a critical branding font that installs fine on everyone else’s Macbook but not theirs. I now know more about fonts that I ever wanted to know especially how Microsoft fonts fit into the Mac picture. I researched dozens of websites each adding a piece to the puzzle. Here we go …
- There are 4 font stores on your Mac
- user fonts stored in /Users/youraccount/Library/Fonts
- computer wide (all accounts) fonts in /Library/Fonts
- system fonts in /System/Library/Fonts (never ever touch these)
- Microsoft Office fonts in /Library/Fonts/Microsoft (ahhh I see)
- ONLY TTF fonts work for Office – or so MS claims
- To install fonts for MS Office 2011 – don’t double click them – this installs them naturally in the user fonts
- instead – start up Font Book (use the spotlight or magnifying glass to find it quick in the upper right of your Mac)
- drag them from your Finder onto Computer (under the Collection section at the left of the Font Book app)
- A reboot triggers the Mac Font store to sync with Office. Don’t forget to reboot before ripping your hair out
- Adding fonts to the user fonts will never show up in Microsoft Office products
- Don’t assume that because a font works in lets say Word, that it will appear in Excel – it might once the cache catches up
- Microsoft font cache file can be delete so it will force a refresh – but it can be in 2 places – check both. Microsoft moved it for Office 2011 for Mac for some computers different than others
- Lion? goto finder and hold the option key and …
- click the menu Go->Library or type in a folder /Library by choosing the Go->Go to Folder option then navigate eventually to /Library/Preferences/Microsoft/Office 2011
- not there? Microsoft moved them in later releases of Office 2011 to /Library/Application Support/Microsoft/Preferences/Office 2011 – even MS’ articles are incorrect!
- also you might need to look in /Users/yourname/Library/Application Support/Microsoft/Preferences/Office 2011
- when you re-start work or Excel you will now see a task completing to rebuild the cache files and if you observe the location above you will see new cache files
- Here is a link to completely remove Office on a mac and is the final puzzle piece that allowed me to solve this riddle http://support.microsoft.com/kb/2398768
Many thanks to these sites:
FAQ
How to install a font under Windows?
How to install a font under Mac OS?
How to install a font under Linux?
How to use a new font with a software?
How to use a font for a web site?
Why the fonts don't show up in e-mails / instant messengers?
How many fonts can be installed?
Why aren't stressed characters or numbers included?
Nothing is working!
How to create my own font?
I've submitted my font, how long will it take to be published?
Are all the fonts free of charge?
Your question isn't answered here? Ask on the forumHow to install a font under Mac OS?
How to install a font under Linux?
How to use a new font with a software?
How to use a font for a web site?
Why the fonts don't show up in e-mails / instant messengers?
How many fonts can be installed?
Why aren't stressed characters or numbers included?
Nothing is working!
How to create my own font?
I've submitted my font, how long will it take to be published?
Are all the fonts free of charge?
Extract the files you have downloaded.
Details: Click on the 'Download' button, save the zip somewhere on your hard disk, go to the place where it is saved, double-click on the zip to open it, then either click on 'Extract all files' or drag and drop the files elsewhere from the zip window (hold down the CTRL key to select several files at once)
For the 20th century versions of Windows you must install an unzip tool first.
Details: Click on the 'Download' button, save the zip somewhere on your hard disk, go to the place where it is saved, double-click on the zip to open it, then either click on 'Extract all files' or drag and drop the files elsewhere from the zip window (hold down the CTRL key to select several files at once)
For the 20th century versions of Windows you must install an unzip tool first.
- Under Windows 10/8/7/Vista
Select the font files (.ttf, .otf or .fon) then Right-click > Install - Under any version of Windows
Place the font files (.ttf, .otf or .fon) into the Fonts folder, usually C:WindowsFonts or C:WINNTFonts
(can be reached as well by the Start Menu > Control Panel > Appearance and Themes > Fonts).
Note that with the internal unzip tool of Windows (unlike Winzip), you cannot install a font by a simple drag and drop of the .ttf from the zip window to the Fonts window. You must first drag and drop it anywhere (for example on the desktop) then into the Fonts folder.
You can also go through: File > Install a new font... in the Fonts folder menu then browse the fonts, instead of drag and drop the fonts into the window. Although this method is laborious, it would seem that it functions better in some cases.
There are some videos on YouTube if that helps.
Tip (for Windows XP/Vista, not Windows 7/8): if you occasionally need a font, you don't need to install it. Just double-click on the .ttf file, and while the preview window is opened you can use it in most of the programs you'll launch (apart from a few exceptions like OpenOffice).
Mac OS X recognizes TrueType and OpenType fonts (.ttf and .otf) but not the PC bitmap fonts (.fon).
Files are compressed, you may need an utility like Stuffit Expander.
Files are compressed, you may need an utility like Stuffit Expander.
- Under Mac OS X 10.3 or above (including the FontBook)
Double-click the font file > 'Install font' button at the bottom of the preview. - Under any version of Mac OS X:
Put the files into /Library/Fonts (for all users),
or into /Users/Your_username/Library/Fonts (for you only). - Under Mac OS 9 or earlier:
The old Mac fonts are not supported anymore at dafont. First, you have to convert the font files (.ttf or .otf) you have downloaded.
Then drag the fonts suitcases into the System folder. The system will propose you to add them to the Fonts folder.
Copy the font files (.ttf or .otf) to fonts:// in the File manager.
Or: Go into the /home folder, in the menu select View > Show Hidden Files, you will see the hidden folder .fonts (if not, create it) then copy the font files there.
Or:(under some Linux versions - Ubuntu for example) Double-click the font file > 'Install font' button in the preview window.
Or: Go into the /home folder, in the menu select View > Show Hidden Files, you will see the hidden folder .fonts (if not, create it) then copy the font files there.
Or:(under some Linux versions - Ubuntu for example) Double-click the font file > 'Install font' button in the preview window.
How to use a new font with a software?
It is sometimes necessary to relaunch the current application to be able to use the new font.
Then you may proceed as usual, the font will appear in your software's font combo-box (word processing, drawing etc.).
Then you may proceed as usual, the font will appear in your software's font combo-box (word processing, drawing etc.).
If you specify a particular font in your web pages which is not installed on the visitor's machine, it will be replaced by the default font in his browser, usually Times New Roman.
(you can specify several fonts in the CSS by priority order, but nothing is guaranteed)
The main solutions:
- To realize a title, the easiest method is to make an image. Use a drawing program and save the image as PNG or GIF.
- For a long text, you can embed the font so that visitors download it at the same time as the page, using the CSS3 @font-face property.
- Generate an image with PHP
(you can specify several fonts in the CSS by priority order, but nothing is guaranteed)
The main solutions:
- To realize a title, the easiest method is to make an image. Use a drawing program and save the image as PNG or GIF.
- For a long text, you can embed the font so that visitors download it at the same time as the page, using the CSS3 @font-face property.
- Generate an image with PHP
Why the fonts don't show up in e-mails / instant messengers?
Your correspondent can only view the fonts installed on his computer. Better avoid to send a email or an instant message (MSN Messenger, etc.) with a non-standard font; or then make sure your correspondant has installed it too, otherwise he will see a default font.
Windows is supposed to be able to manage about 1000 fonts. But avoid to install too many fonts at one time because that slows down the system. A lot of programs have to load to memory all installed fonts to be able to run.
So it is better to put fonts you use regularly in the Fonts folder. Keep the rest in any other folder or storage device, so you can install/uninstall them as needed.
So it is better to put fonts you use regularly in the Fonts folder. Keep the rest in any other folder or storage device, so you can install/uninstall them as needed.
Why aren't stressed characters or numbers included?
The present fonts on this site are freewares or sharewares, sometimes demos, which don't systematically include stressed letters, figures or certain punctuation chars.
You can check this here by clicking on the fonts to show the characters map.
You can check this here by clicking on the fonts to show the characters map.
Relaunch the target application after the new font's installation.
Make sure to have copied the .ttf file, and not the zip into the Fonts folder.
In the worst of the cases, reboot your computer.
Make sure to have copied the .ttf file, and not the zip into the Fonts folder.
In the worst of the cases, reboot your computer.
How to create my own font?
Creating a font requires some technical skills, a lot of inspiration, and the appropriate softwares. In order to learn more about the font creation process, check this: Part 1 | Part 2
I've submitted my font, how long will it take to be published?
Publication on this site is not automatic. There is a selection, each font is reviewed before being accepted or not.
If it got accepted, you will receive an email once online, otherwise no email is sent.
If it got accepted, you will receive an email once online, otherwise no email is sent.
The fonts presented on this website are their authors' property, and are either freeware, shareware, demo versions or public domain. The licence mentioned above the download button is just an indication. Please look at the readme-files in the archives or check the indicated author's website for details, and contact him/her if in doubt.
If no author/licence is indicated that's because we don't have information, that doesn't mean it's free.
If no author/licence is indicated that's because we don't have information, that doesn't mean it's free.