Menu
Question: In Word 2011 for Mac, how do I change the font color for some of the text? Answer: Select the text that you'd like to change the font color. Then select the Home tab in the toolbar at the top of the screen. Then click on the arrow to the right of the Font Color button in the Font group.A popup window should appear. Select the color that you'd like your text to be. Does anyone know the shortcut to change the text color on Word 2011 on a Mac? I would like to ideally select a part of the text, press a key combination, and change the color of the text to the color in the Font toolbar.
I recently downloaded and installed Office 2011 and I was wondering if anybody knew of a way to change the background color from grey to anything you want. In 2008, there was a file in the Contents-Resources folder called 'Page Layout View Background Rest' that you could replace with any image and the background would change (by 'background', I mean the actual grey color on each side of the word document, not the background of the document itself). Below is my Word 2008 appearance, which I would very much like to replicate for 2011. Just wondering if we ever got an answer to this question. I'm a writer and editor that just switched to Mac, and thus far I'm loving every second of it except for trying to read documents in Print Layout View in Office 2011. That gray is just hard as heck on the eyes.
I want to switch it back to something like the cool blue of the Windows version. I see there's a drop-down list to change the background in Full Screen (which, by the way is a huge improvement over the Windows version of Office I was using), and I see a place where it looks like you can manage add-ons and plugins for Word and Office, but I don't see anything that will let you change this color. Are there any plugins that will do it? For reading and editing I use mostly Full Screen, but I also spend a lot of time manipulating layout and document components to see what formatting changes will look like on the page and that lifeless gray on an LED backlit screen with black and white text in front of it feels like scraping my eyes over razor blades. Just wondering if we ever got an answer to this question. I'm a writer and editor that just switched to Mac, and thus far I'm loving every second of it except for trying to read documents in Print Layout View in Office 2011. That gray is just hard as heck on the eyes.
I want to switch it back to something like the cool blue of the Windows version. I see there's a drop-down list to change the background in Full Screen (which, by the way is a huge improvement over the Windows version of Office I was using), and I see a place where it looks like you can manage add-ons and plugins for Word and Office, but I don't see anything that will let you change this color. Are there any plugins that will do it? For reading and editing I use mostly Full Screen, but I also spend a lot of time manipulating layout and document components to see what formatting changes will look like on the page and that lifeless gray on an LED backlit screen with black and white text in front of it feels like scraping my eyes over razor blades.
@Andrew K.: Here is what you need to do to change the background in Word 2008: Go to Microsoft Word.app right click and choose 'show package contents' click 'contents' and then 'resources' Now, the two relevant files are there: 1. Page Layout View Background Rest 2. Page Layout View Background Top Change the contents of these files with images you choose. (if they do not work, pay attention to the pixel size of the original files and adjust your chosen images accordingly using e.g. That's it for 2008.
But for Word 2011: I have tried a lot to find the relevant files to change the background, but to no avail. So, I second Shado's question. @Andrew K.: Here is what you need to do to change the background in Word 2008: Go to Microsoft Word.app right click and choose 'show package contents' click 'contents' and then 'resources' Now, the two relevant files are there: 1. Page Layout View Background Rest 2. Page Layout View Background Top Change the contents of these files with images you choose. (if they do not work, pay attention to the pixel size of the original files and adjust your chosen images accordingly using e.g. That's it for 2008.
But for Word 2011: I have tried a lot to find the relevant files to change the background, but to no avail. So, I second Shado's question. Replacing png with image?
Hi, Can anyone help me by telling me how exactly to replace a png file with an image? I'm trying to change the grey background in Word 2008 for Mac. I've accessed the contents-resource files and then I drew a blank. I've tried renaming the image I want to use as Page Layout View Background Rest with png extensions and that leaves me with a blank white background. I can't really think of any other way to replace these with the desired image (and I clearly have no sort of programming or computer background!) Any help would be greatly appreciated, that grey is driving me crazy! I forgot about this thread. Moofe1, if you have not found the solution in the mean time, see above: it's there.
As for MW 2011, the solution is most probably changing the DocWindowImages.bin file under 'Resources' in 'Package Contents' for Word. This can be modified with Hex editors.
I tried to change some values without any knowledge of hex editing, and indeed noticed tiny changes on the page background. Now, someone skilled in hex editing can probably provide the solution easily. (see the last post here as an example: ).
Mike - June 2, 2017 Hi Jon, Thanks a lot for your addon, helps a lot. But I would like to ask you for another solution, if you know it. There is a possibility to make a custom ribbon in Word and Excel which is absolutely beautiful. But is there a way to add two buttons for changing font color:.
one – black. second – blue This simple thing would hugely improve processes in my company. If you know how to add two font color buttons with different colors, I am ready to pay $10 or more, let us say. Thanks in advance!
Looking forward to hear good news. Rich G - August 9, 2017 A simple way that I’ve used to overcome this is to program two simple macros (Black and Blue) and add them to the ribbon. Just paste these two macros to your personal.xlsb file, add them to the ribbon and change the icons and you should be all set. Sub Blue ‘ ‘ Macro4 Macro ‘ ‘ With Selection.Interior.Pattern = xlSolid.PatternColorIndex = xlAutomatic.Color = 15773696.TintAndShade = 0.PatternTintAndShade = 0 End With End Sub Sub Black ‘ ‘ Black Macro ‘ ‘ With Selection.Interior.Pattern = xlSolid.PatternColorIndex = xlAutomatic.ThemeColor = xlThemeColorLight1.TintAndShade = 0.PatternTintAndShade = 0 End With End Sub You can send the $10 to my paypal account. – just kidding.
January 13, 2017 Hi Bill, Thank you for purchasing the add-in. Not a silly question at all. I thought I had done that, but looks like I forgot to upload the file to the members area. I just uploaded the new file with the button on the XL Campus tab.
You should be able to download and install it. To install the update: 1. Close Excel completely. Download and unzip the new add-in file from the members site.
Find the existing Formatting Shortcuts Add-in file (ECFormattingShortcutsFull.xlam) that you saved on your computer. Replace the existing file with the new file. The Formatting Shortcuts button should appear on the XL Campus tab of the ribbon. The Add-ins tab will not appear unless you have add-ins installed from other developers that use that tab. Please let me know if you have any questions. Thanks again!
Juliet - December 1, 2016 Hi Jon, I got it working. Initially I saved it to a shared drive, but when I saved it to my computer hard drive it started working.
It is usful in my line of work however, I am finding that I use this short cut to color coordinate cells, and then when I send my excel spreadsheet via email to a coworker, she reports that the spreadsheet comes in blank, with no highlighted cells. If someone else does not download the short cut then any colors that were established, will they not appear when someone else opens the same document in excel? Noah Browder - May 5, 2016 Hello Jon, I have been searching for this functionality for a long time, very excited to find your add-in. I am running Excel 2016, and I have enabled the Add-in. When I use the key combination I defined, I get the following message:”Cannot run the Macro “C Users.FormattingShortcuts.xlam” The Macro may not be available in this workbook or all macros may be disabled.” I frequently use macros, so I know that they are not disabled.
Can you advise any potential solutions? Thanks, Noah. April 26, 2016 Hi Steven, One workaround is to create a macro in your and assign a shortcut key to it.
The macro could look something like the following. Sub FillYellow Selection.Interior.Color = vbYellow End Sub You would just need to assign a shortcut key to the macro. I did this on the 2011 version for Mac and assigned the shortcut key Cmd+Option+y. Now every time that shortcut is pressed, the selected cells are filled yellow. I hope that helps.
Let me know if you have any questions. I will write an article about it with more details in the future. April 26, 2016 If you plan to use macros or do any type of coding then I would recommend the 2011 version. There are some additional features in 2016 that make it more like the Windows version, but the VB Editor isn’t good for coding and debugging. I don’t use the Mac on a day to day basis, so it’s hard for me to really make a strong recommendation.
I have developed VBA projects for the Mac, including my Tab Hound add-in, and 2011 will be the only way to go for stuff like that. I hope that helps. Gabrielle - September 28, 2015 Hello, I had installed this add-in on my previous computer. I just got a new computer and had downloaded the add-in again, but this time I am getting an error message (on Save&Close) that is not allowing me to use it.
It is a Microsoft Visual Basic error: “Run-time error ‘1004’: Method ‘OnKey’ of object ‘Application’ failed. I also noticed that the 1st macro Key (Ctrl+Shift+A) does not have anything selected in the Key field. I tried putting in “a”, “A”, and some other letter, but still was unable to Save&Close. Have you seen this before, and do you have any recommendations on how to resolve this problem?
I like this macro and would like to use it again! August 16, 2013 Thanks Don! You can assign the letter of each shortcut in the Key field text boxes. These keys are not locked, and you can change it to any letter character. Number characters already have built-in keyboard shortcuts for Ctrl+Shift, so the numbers can not be used.
You can also delete the letter in the Key field text box if you want to temporarily disable the shortcut key. I am not sure I fully understand your question, so please let me know if this answers it. Also let me know if you think of a way that any of the processes can be easier or more intuitive. Thanks again! August 5, 2013 Hi Carlo, I would be happy to help. To change the font or style for the shortcut, you will first need to format a cell with the font type or style you want to use, then set that by clicking the Cell/Format box in the Formatting Shortcuts menu. You will also need to change the Format Type to Cell Style.
Here are some step-by-step instructions. Format a cell in your worksheet with the formatting you want to use with a keyboard shortcut. Click the Formatting Shortcuts button in the Add-Ins tab of the ribbon. In this example we will setup shortcut key #1. The shortcut key should be already setup as Ctrl+Shift+A.
Select “Cell Style” from the Format Type drop-down box. Click the box to the right of the Format Type drop-down. You will be prompted to select the formatted cell. This is the cell you formatted in step 1. Selected the formatted cell and click OK. Then click Save & Close in the Formatting Shortcuts window. Your keyboard shortcut should now be ready to use.
Select an un-formatted cell in your workbook and press Ctrl+Shift+A to format it. Please let me know if this helps answer your question. July 26, 2013 Hi Don, I’m glad you’re enjoying the add-in. Currently you can only save 3 keyboard shortcuts at one time.
This could be expanded to 5. Yes, you can create a shortcut for the center across alignment by creating a cell style with the formatting properties. To apply it to a range, simply select the range and then press the keyboard shortcut. Your selected cells will be formatted with the center across alignment. By the way, center across is a much better alternative to the more popular merge and center alignment.
Merging cells can cause issues when inserting columns or copying cells. It typically requires a lot of extra work to constantly merge and unmerge the cells.
It can also cause issues when working with VBA. I much prefer the center across alignment over merge and center. Thanks again, Jon.