Mac Excel Font Rendering Site Answers.microsoft.com

1. Mac Excel Font Rendering Site Answers.microsoft.com Download
2. Mac Excel Font Rendering Site Answers.microsoft.com Free
3. Mac Excel Font Rendering Site Answers.microsoft.com Word
4. Mac Excel Font Rendering Site Answers.microsoft.com 1
5. Mac Excel Font Rendering Site Answers.microsoft.com Online

• We often are asked the question of why fonts look different on a Mac vs Windows, or in one web browser compared to another. This article will address the issues of web font quality. First of all, it is the Operating System (OS), and not the web browser that impacts font quality. The Mac OS has a different font rendering system than Windows.
• We recently had a similar issue with all Asian fonts in Excel for OSX (Chinese, Japanese, and Korean). The solution that worked for us was to change the font to 'Arial Unicode MS'. You can do it for just the cells in question or the entire sheet.
• Hi I have installed Office 2016 for MAC, and I noticed a bad font rendering on Excel. I have a macbook pro 15' with retina display. The previous release, Office 2011, works beautiful. Very sad MS done a step back on this. Is there a way to fix this problem? Thanks This is the wrong forum, although Office 2016 may be related to SharePoint online.
• I'm new to the forum so hoping to learn and share. I'm working in Excel 2016. In previous versions the Font dropdown would show you your most recently used fonts at the top of the dropdown list, but that feature is no longer available.

-->

Under the Display group, clear the Use the subpixel positioning to smooth fonts on screen option. If you are still experiencing a problem after you turn off the sub-pixel text rendering setting, re-enable the Use the subpixel positioning to smooth fonts on screen setting, and then go to Step 3.

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Symptoms

When you use Microsoft Office programs, you notice that visual features differ from one computer to another. For example, you see animations in Excel when you scroll through a worksheet on one computer, but you do not see the same animations on another computer.

Additionally, you may experience one or more of the following symptoms that reduce the functionality of an Office program:

• An Office program is blurry.
• Your screen flickers or flashes.
• An Office program is either mostly all white or all black.
• Text in your document is not displayed well.
• Your Office program crashes.
• The performance of an Office program (other than startup and shutdown) is reduced.
• In Microsoft Lync, there may be video delays or slowness when you are on a video call.

Cause

You may experience these symptoms if you have a video configuration on your computer that is incompatible with the Office feature set that is responsible for displaying the application and for animations in the application.

Office 2013 and later versions use a more efficient and accelerated method to draw the Office UI and the content. This includes relying on hardware acceleration, which is managed through the operating system. The hardware acceleration function of the operating system relies on up-to-date and compatible display drivers.

Note Hardware acceleration that uses the video card is always disabled when Office is running in a Remote Desktop session, and also when the application is started in safe mode.

Resolution

The resolution varies depending on your version of Windows and the symptom you are experiencing.

For the symptom: Poorly Displayed Text in Office Documents

If your symptom is 'Poorly Displayed Text in Office Documents,' try the following solutions first. Otherwise, skip to the next section titled All Other Symptoms.

Step 1: Use the 'ClearType Text Tuner' Setting

1. Search for ClearType.

2. Select Adjust ClearType Text.
3. In the ClearType Text Tuner, enable the Turn on ClearType option, and then click Next.
4. Tune your monitor by following the steps in the ClearType Text Tuner, and then click Finish.

If you are still experiencing a problem after you adjust the ClearType settings, go to Step 2.

Step 2: Disable the Sub-Pixel Positioning Feature

Word 2016 and Word 2013 use sub-pixel text rendering by default. While this provides optimal spacing, you may prefer the appearance of pixel-snapped text for a minor improvement in contrast. To disable the sub-pixel positioning feature in Word 2016 or Word 2013, follow these steps.

1. On the File tab, click Options.
2. Click Advanced.
3. Under the Display group, clear the Use the subpixel positioning to smooth fonts on screen option.
4. Click OK.

If you are still experiencing a problem after you turn off the sub-pixel text rendering setting, re-enable the Use the subpixel positioning to smooth fonts on screen setting, and then go to Step 3.

Step 3: On Windows 7 clients, install the Windows 8 Inter-operatibility Pack

If you are using Windows10, Windows 8.1 or Windows 8, skip this section and go to the steps under the For All Other Symptoms section.

If you are using Windows 7, install the update for improving video-related components that is available in the following Knowledge Base article:

2670838 Platform update for Windows 7 SP1 and Windows Server 2008 R2 SP1

If the previous steps did not resolve the 'Poorly Displayed Text in Office Documents' symptom, continue to troubleshoot your issue by using the steps in the next section.

For all other symptoms

Mac Excel Font Rendering Site Answers.microsoft.com Download

Update your video driver

The best way to update your video driver is to run Windows Update to see whether a newer driver is available for your computer.

To run Windows Update based on your version of Windows, follow these steps:

Windows 10, Windows 8.1 and Windows 8

1. On the Start Screen, click Settings on the Charms Bar.
2. Click Change PC Settings.
3. In the PC settings app, click Windows Update.
4. Click Check for updates now.
5. If updates are available, click the driver that you want to install, and then click Install.

Windows 7

1. Click Start.
2. Type Windows Update in the Search programs and files box.
3. In the search results, click Check for updates.
4. If updates are available, click the driver that you want to install, and then click Install.

If your video-related problems in Office were fixed by when you updated your video driver, you do not have to take any further steps. Go to step 2 if updating the video driver does not fix the problems.

Note

Video card manufacturers frequently release updates to their drivers to improve performance or to fix compatibility issues with new programs.If you do not find an updated video driver for your computer through Windows Update and must have the latest driver for your video card, go to the support or download section of your video card manufacturer's website for information about how to download and install the newest driver.

More Information

Automatic disabling of hardware acceleration for some video cards

By default, hardware acceleration is automatically disabled in Office programs if certain video card and video card driver combinations are detected when you start an Office program. If hardware acceleration is automatically disabled by the program, nothing indicates that this change occurred. However, if you update your video card driver and it is more compatible with Office, hardware acceleration is automatically reenabled.

The list of video card/video driver combinations that trigger this automatic disabling of hardware graphics acceleration is not documented because the list is hard-coded in the Office programs and will be constantly changing as we discover additional video combinations that cause problems in Office programs. Therefore, if you do not see the same animation functionality on one computer that you see on another computer, we recommend that you update your video driver by using the instructions provided in the 'Update your video driver' section. If you still do not see the expected animation on your computer, update your video driver again soon. Microsoft is working with the major video card manufacturers on this issue, and these video card manufacturers will be releasing new video drivers as such drivers are developed.

Note

If two computers have the same video card/video driver combinations, you may still see a difference in the Office animation features between the two computers if one computer is running Windows 7 and the other computer is running Windows 8. On a computer that is running Windows 7, animations in Office are disabled if the video card/video driver combination appears on the incompatibility list. However, the same video combination on Windows 8 does not have animations disabled because of the improved video capabilities in Windows 8.

Word on the Macintosh is basically Word for Windows re-compiled to run on the Mac. It's not just 'compatible'. It's not just 'like' Word for the PC. It is Microsoft Word, the same one Microsoft makes for every platform. However:

• Not all of the modules of Word on the PC are included in Word for the Mac.
• Word for the iPhone and Word for the iPad are quite different.
• Word for the web browser (Office 365) is completely different: a very lite version.

The cost and number of person-hours spent developing Word is mind-boggling. It's well over a billion dollars, and there are well over ten thousand person-years of effort in it. Making a new one just for the Mac would have been so expensive that a copy of Word would cost several thousand dollars. You might buy two at that price, but the rest of us couldn't afford it!

Because it is the same software, and Microsoft has a policy of bringing the two versions closer together, the differences will become less over time. Essentially, each version on the PC is matched a year later by a version on the Mac (Microsoft is trying to reduce that gap, recently the Mac Business Unit became part of the main Office Business Unit that makes Office for every platform).

Macintosh	Equivalent PC Version
Word 2013
Word 2010
Word 2007
Word 2011	Word 2003
Word 2008	Word 2002
Word 2004	Word 2000
Word v.X	Word 2000
Word 2001	Word 2000
Word 98	Word 97
Word 6	Word 95
Word 5	Word 6

Same File Formats Used in Mac and PC

Mac Office MVP Jim Gordon writes: 'The Microsoft Office file format Open XML (OOXML) is for Word, Excel and PowerPoint files and used on both the Mac and the PC. The file format was accepted by an international standards body. Office 2010 for Windows with service pack 2 or later and Office 2011 for Mac comply strictly with the standard. Office 2008 for Mac and 2007 and 2010 for Windows prior to service pack 2 comply about 98% of the way to the standard (there's a very minor exception in Excel).

'Microsoft also ships a set of fonts with the same names on both Microsoft Office for Mac and PC. The fonts distributed with Mac Office have been very carefully adjusted ('hinted') so documents on the Mac will look and orint the same way as documents using the PC versions of those fonts on the PC. The differences are tiny, but they account for the differences in the way the Mac places pixels on the screen.

'As for having documents be identical when moving from one computer to another there are factors you must consider. This is true PC to PC, PC to Mac, Mac to Mac, and Mac to PC. Microsoft Word is a word processor that has text that flows, unlike a PDF or page layout program. Any difference in font or printer driver from one machine to another has the potential to affect spacing, breaks, window & orphans, paragraphs, etc. To repeat - these changes have nothing to do with Mac to PC, rather they are caused by computer to computer differences.

'Your documents should look the same on the Mac as long as ALL of these conditions are met:

• The documents on the PC originated in Microsoft Word 2010 with service pack 2
• The documents were saved in a current OOXML file format in Word 2010
• The documents used only fonts supplied with Microsoft Office 2010
• Old versions of the same fonts are not installed or active on either the Mac or the PC
• The documents are opened on the Mac in Microsoft Word 2011
• The current versions of the Microsoft Office fonts are active on the Mac
• The printer driver on the Mac behaves identically to the printer driver that was being used on the PC where the documents were saved.

The behavior of Word is identical on the two platforms, provided the above conditions are met, if you want your documents to look alike when moving from one computer to another - regardless of platform. It's the fonts, file formats and printer drivers that are the sticky points when moving a document from one computer to another regardless of platform.'

Rules of Thumb

Having said all this:

• It’s a totally moving target. Every patch Tuesday, something changes.
• Network Templates 'Don’t' work in Mac Word. Due to multiple bugs in the file path resolving and handling mechanism, templates in network directories should not be shared between PC Word and Mac Word. For a long and happy life, copy the templates locally to the user's My Templates folder on the Mac.
• Ribbon Customizations are not available in Mac Word. They will be silently ignored, unless done in code, where they will blow up.
• Mac Word can use ONLY TrueType fonts and OpenType fonts with TrueType outlines. Other fonts will not appear/work or occasionally, crash.
• The color table is markedly different between Mac and PC (and even between PowerPoint and Word/Excel on the Mac). Generally Mac Office has a wider gamut, but Mac monitors have a very different gamma. Unless you are prepared to create color profiles and carefully color-match every device in the chain on both the PC and the Mac, just accept that colors are going to look quite different. It is expensive and time-consuming to fix this, and you will never get it perfect.
• Various commands in Mac Word exist only in the menu bar, which Mac Word still has, or on the toolbars that Mac Word still has. Toolbars remain customizable in Mac Word.
• The same physical printer will often produce different results from the same document depending on whether the printer driver is on a Mac or a PC. If the printer driver is running on a Print Server, results will be closer (but remember: the fonts are different!).
• Design for the Difference, Design for Re-Flow. Do not use hard page breaks anywhere. Minimize section breaks. Use paragraph properties to manage pagination. Assume your user is going to throw an A4 document onto a US Letter paperstock, or vice versa. Assume that a Mac will reflow text by about half a per cent. The people who have real trouble are the ones that have used floating text boxes and spaces to try to line things up: that will produce word-salad. Tossed word-salad…

• Jim says 'The text-flow problem is the same as you will find moving from one PC to another where font versions and default printer driver are different. The fonts provided by Microsoft should provide smooth cross-platform sailing provided the same version of each is the active version on all machines involved.'

Differences in Appearance

On each platform, Word adopts the default appearance of the Operating System. There is almost nothing that you see on the screen that is drawn by Word: on the Mac, the display is created by Mac OS; on the PC, by Windows. It saves money and it saves vast amounts of disk space and processor power.

The only difference you are likely to notice is that if you are in OS X, the window controls are on the opposite side to Windows.

Different Keystrokes

On the Mac the Command (Apple) key is the Control Key in Windows, whereas the Control Key from the Mac is the Right-Click in Windows.

On a Windows keyboard, the Control key is always labeled Ctrl. On a Mac keyboard, expect to find the ⌘ or ? symbol on the Command key. (These characters will not display on the PC; they should look like this:.) This paragraph is a classic example of the cross-platform font difficulties you will experience. There is no default font common to the PC and the Mac that contains both of those characters (in case you are interested, that's 'Lucida Grande', the most wide-ranging of the Mac OS X Unicode fonts).

Word is very right-click-centric. If you do not have a two-button mouse, you will find it is a very worthwhile investment if you are going to spend much time in Word.

Windows	Macintosh
Control Key	Command (Apple) Key
Right-Click	Control-Click
ctrl+c	Command+c
ctrl+v	Command+v
ctrl+s	Command+s
File>Close	Command+w
ctrl key	Option Key
ctrl+q	Command+Option+q
ctrl+space	Ctrl+space
Tools>Options	Word>Preferences
File>New Task Pane	Project Gallery
Mail Merge Task Pane	Data Merge Palette

The Control-Click (or Right-Click) brings up the 'context menu' wherever you happen to be. In Word almost everything you want to do, or everything you want to know, will appear on the right-click. The menus that appear vary dramatically depending on where your mouse-pointer is.

Word also responds to the scroll-wheel if you have one. (Not all windows; for example preferences and options dialogs do not..). Mouse scroll wheel support in Word pre-X depends totally on the mouse drivers. Microsoft drivers for the Microsoft Mouse generally work (and will often drive other companies' mice!).

In Windows, the keyboard shortcuts are listed in the Help, in a topic surprisingly enough called 'keyword shortcuts'. On the Mac, only some of the keystrokes are listed, in various topics such as 'About using shortcut keys' and 'Select text and graphics'. To find the list on either platform, use Search from the Microsoft Office Help to look for the word 'keyboard'.

You can look at the Key Assignments by using Tools>Customize>Keyboard on either platform. If you select a command, and it has a key assignment, the Customize dialog will tell you what it is. This is a better place to look than the Help, because users can (and should) change their keystrokes to suit themselves on either platform. The Customize dialog also includes a handy Reset button if you decide you do not like the keystrokes you inherited from the previous user on that computer.

Finally, each version of Word enables you to print a list of the currently-assigned keystrokes so you can stick them on the wall. To print them on the Mac:

1. Go to Tools>Macro>Macros
2. In the Macros In pop-up menu, click Word Commands
3. In the Macro name box click ListCommands
4. Click Run
5. In the List Commands dialog, click Current Menu and Keyboard settings and OK
6. On the File menu, click Print.

You do it exactly the same way in Windows, or see here for a more extensive pre-built list.

One keystroke that will catch you out a few times is Command + h. Ctrl + h in Windows is the shortcut for the Replace dialog. On Mac OS X, Command + h hides the application! Use Command + Shift + H for the Replace dialog on OS X.

With OS X, Apple changed some of the keystrokes reserved for the operating system and added some new ones. On each version of Mac OS, Word follows system convention.

Some Mac keyboards do not have a Forward Delete key. Word needs one: there is a difference in Word between Forward Delete and Back Delete. You will strike it most often in tables: in a Table, Delete becomes 'Clear' which removes the cell contents without removing the cells. Use Cut to delete the cells themselves. Back Delete will remove text within a cell but has no effect if more than one cell is selected. If you are on a Mac laptop, the Forward Delete key is probably Function + Delete.

The Mac has an Option Key, Windows does not have an equivalent. Generally what you expect from the Option key will be on the Control Key in Windows.

Three very commonly-used shortcuts are Command + c (Copy), Command + v (Paste), and Command + s (Save). On Windows these are Ctrl + v, Ctrl + c, and Ctrl + s.

A keystroke that may catch you out a few times is Clear Formatting: on the PC it's Ctrl + q to restore paragraph formatting to that of the underlying style, and Ctrl + Space Bar to restore character (font) formatting. On Mac OS 9, they are the same. On Mac OS X, these are Command + Option + q and Ctrl + Space Bar.

Later versions of Word have an Edit>Clear>Formats command on the Menu bar, which will save you trying to remember the other two. However, note that Clear>Formats resets the formatting back to the formatting of Normal Style (it applies Normal Style) whereas the individual commands simply reset a paragraph to the formatting of the current style.

Different Menus

One thing that will catch you out all the time is that on the Mac, Word adopts the Mac convention of having a Preferences command. In OS X it's on the Application (Word) menu, in OS 9 it's on the Edit menu, again, following the OS convention. On the PC, this is Tools>Options on the Tools menu. It's the same thing, the tabs are exactly the same inside.

Word on the Mac still has a Work menu you can put on your menu bar; this has been replaced by the Task Pane (which is nowhere near as convenient) in later versions of PC Word.

Mac Word also has a Font menu which the PC lacks.

Different Print Mechanism

In order to display a document in WYSIWYG mode, Word needs to know a lot about the capabilities of the printer the document will eventually be sent to.

In Windows this is very simple: Word reads all the information it needs from the printer driver for the printer set as the Windows default. On the Mac, it attempts to do the same thing, but the mechanism is vastly more complex. Look here for more detail.

Some Features Didn't Make it

Making software is a depressingly manual activity. Every line of code has to be planned, typed, and checked. There are more than 30 million of them in Microsoft Office. There simply was not enough time and money to bring all the features of PC Word across to the Mac. And some of them we wouldn't want, anyway! Most of the omissions are of interest only to solution developers:

• Font embedding is not supported on the Mac.
• Customized toolbar buttons are supported on the Mac, but the Icon Editor is missing.
• Speech recognition is not available.
• HTML support in Word for the Mac is not at the same level as it is in Word on the PC: many web pages load as a shattered mess. The code stripping utility HTMLFilter2 available for the PC is not available for the Mac.
• Word on the PC has a menu item enabling you to Export to Compact HTML. On the Mac, this is an option on the File>Save As Web Page menu option named Save only display information into HTML. The other option, Save entire file into HTML is the equivalent of the Word PC's Save As Web Page; it saves a Word document expressed in XML. Note: if you 'Save only display information', the file looks the same, but the structural information and content that enable Word to reconstruct a Word document from the XML file has been removed.

Fonts Can be a Problem

On the PC, you can use characters with impunity: if the PC does not have the font, it will find the closest font that contains the character. On the Mac, in Word 2004 and above, you can use the exact same range of characters because Word 2004 is running in Unicode; however, because you cannot embed the font in the document, you need to make sure that each character that you use exists in one or more of the Unicode fonts your recipient has. If in doubt, for PC compatibility, use only the fonts that Microsoft supplies.

Applies to: Virtual PC for Mac Version 7.0 and 7.0.1 Before you can install Virtual PC for Mac Version 7.0.2, one or more of the following programs must be installed on your computer: Virtual PC for Mac Version 7.0 or 7.0.1 Operating system: Mac OS X Version 10.2.8; Mac OS X Version 10.3. Aug 14, 2007  Before you can install this update, one or more of the following programs must be installed on your computer: Virtual PC for Mac 7.0 through 7.0.2. Operating system: Mac OS X 10.2.8 (Jaguar) or a later version of Mac OS. G5 processor requires Mac OS X 10.3 or 10.4.1 to run Virtual PC for Mac. Jun 21, 2005  Before you can install Virtual PC for Mac Version 7.0.2, one or more of the following programs must be installed on your computer: Virtual PC for Mac Version 7.0 or 7.0.1 In addition, your computer must meet the following minimum requirements: Processor. Microsoft Virtual PC 7.0 is a software application for Mac's, designed to allow windows based programs to run on your mac without the hassel of having to partition a drive, Install a completey new OS or set up a VM or 'Virtual Machine,' to do so, just install and go.

Microsoft includes a pack of fonts with Mac Office that have been very carefully hinted to display and print the same on the Mac as the same-named fonts do on the PC. Although the Mac can happily use PC fonts, the rendering of those may be subtly different, particularly on the high-res Mac displays.

Jim Gordon reports that he has no problems at all with the following list of fonts:

Arial

Mac Excel Font Rendering Site Answers.microsoft.com Free

Calibri

Cambria

Candara

Consolas

Constantia

Corbel

Times New Roman

Verdana

Meiryo

Jim says 'Office for Mac has a very nice feature to make font compatibility a cinch. When you choose a font using the Home tab of the Ribbon, the first item in the list is Font Collections. The easy way to ensure compatibility is to choose fonts from the Windows Office Compatible font collection submenu.

'If you have company specific fonts they must be installed onto each Mac in order for Mac Word to use them. There is no work-around to the restrictions John mentioned. Fonts embedded by Windows Word are ignored.

'I haven't had problems with cross-platform differences with our HP, Epson, and Lanier printer drivers, but we do test for differences before purchasing so that we don't run into such problems.

While there's no interface on Mac Word to make Font Themes and Color Themes (you can do it in PowerPoint, or with VBA), Themes made on PCs will work on a Mac.

The Advanced Typography settings you can apply in Mac Word will display in Windows Word, but there's no Advanced Typography interface in Word for Windows, so you have to use Mac Word for this feature.

VBA a Level Behind

The VBA level in Mac Word is markedly less capable than in PC Word: around the level of Word 2003 but with missing bits.

Visual Basic for Applications on the Mac is at version 6 (on the PC, this is Word 2000 level of VBA); Word 2013 on the PC is at version 7. Code you write on the Mac will run on the PC if you are careful. Expect code you write on the PC in Word 2000 or above to generate compile- or run-time errors on the Mac.

Mac Excel Font Rendering Site Answers.microsoft.com Word

Active-X controls will not work on Macs. 'Legacy' controls will work. Some of the latest controls from 2103 won't work on a Mac.

Mac Excel Font Rendering Site Answers.microsoft.com 1

Developers should read George Clark's article for more detail.

ActiveX is not supported on the Mac at all. If you create userforms, use only the controls provided in the Forms Toolbar on the Mac, anything else you bring from the PC will generate an error when the user opens the document.

Digital Signatures are not supported on the Mac, and neither is code signing. You will not be able to open a signed project in Mac Word. If the signature prevents you from changing a macro, the code will be execute-only on the Mac.

AppleScript is not available on the PC. VBA is very powerful: investigate scripting your application from AppleScript with VBA, using the 'Do Visual Basic' command.

Mac Excel Font Rendering Site Answers.microsoft.com Online

The VBA Integrated Development Environment is severely cut back on the Mac. If you plan to develop much VBA, invest in a copy of Virtual PC: the productivity you gain is enormous. Hint: Use Windows 7 and NTFS disk format.