Windows 10: Format Painter no longer working in Microsoft Excel for Mac

Discus and support Format Painter no longer working in Microsoft Excel for Mac in Microsoft Office and 365 to solve the problem; I have several cells that are formatted with a specific background color in Microsoft Excel for Mac 2019. I always used to be able to select a cell and... Discussion in 'Microsoft Office and 365' started by salilsurendran, Aug 5, 2021.

  1. Format Painter no longer working in Microsoft Excel for Mac


    I have several cells that are formatted with a specific background color in Microsoft Excel for Mac 2019. I always used to be able to select a cell and then double click on format painter and then click on other cells and the format (background color, font size etc.) of the original cell would be copied to the cells I clicked on . But for the past 6 months of so that has stopped . Now when I click on other cells after having double clicked (or single-clicked) on format painter nothing happens. How to fix this?

    :)
     
    salilsurendran, Aug 5, 2021
    #1

  2. Odd behaviour of Format Painter

    Hi Ken,

    Thanks for the suggestion.

    I misunderstood what you had said about pasting - I guess I read the first paragraph and then lept to the document without reading the rest.

    Anyway ...

    I wrote two short passages of text. One in Arial italic 11pt and the other in Berlin Sans FB Bold 14pt.

    Before:


    Format Painter no longer working in Microsoft Excel for Mac [​IMG]


    I then 'Format Painted' the Arial text onto a part of the Berlin Sans text and Format Painter worked as expected.

    After:


    Format Painter no longer working in Microsoft Excel for Mac [​IMG]


    Will now try your suggestion which replicates what I was doing but avoiding the Notepad step.

    Art

    UPDATE:

    Well, I went to the web souce and copied some text then pasted it into my docuement using the 'Paste Special', 'Paste as Unformatted Text' and I got the copied tect from the web in the same font as the line above (as expected since Word hadn't changed the formatting).

    I then took two different font styles from further up the document to test using Format Painter.

    The first worked as expected, keeping the font bold but changing the text from Berin Sans FB 14pt Bold to Arial 12pt bold.

    The second didn't work as expected. The font style selected for copying was Arial 24pt normal but using Format Painter it changed the style from Berin Sans FB 14pt Bold to Arial 12pt bold - i.e. keeping the bold text option/flag (whatever).


    Format Painter no longer working in Microsoft Excel for Mac [​IMG]


    Something very odd going on and, as you intimated, some sort of 'formatting carry-over' fromNotepad.

    Most curious.

    Art
     
    ArthurDent, Aug 5, 2021
    #2
  3. Odd behaviour of Format Painter

    Hi folks.

    I'm getting some very odd behaviour with Format Painter in Word 2016. First of all, I know how format painter works, I have been using it for years!

    However, on this new installation of both Windows 10 Pro (ver 2004) and MS Office Pro Plus 2016 Version 2005 (Build 12827.203336) I'm getting a very curious and unexplainable effect.

    I'm compiling a document which has been pulled from webpages. After putting the copied text through Notepad (to get rid of any embedded formatting), the text is pasted into Word.

    Each newly-pasted piece of text needs to be formatted the same as the previous section - and this where the problem arises.

    To demonstrate. Here is the document after a new piece of text has been pasted, but not formatted.


    Format Painter no longer working in Microsoft Excel for Mac [​IMG]


    So, I highlight the title ("2. Dirt and Grime"), click on 'Format Painter' and then swipe (for want of a better word) across the text that needs re-formatting ("3. Blocking Views") and this is what I get ...


    Format Painter no longer working in Microsoft Excel for Mac [​IMG]


    Any ideas (a) what is going on and (b) how to fix it??

    Art
     
    ArthurDent, Aug 5, 2021
    #3
  4. AndreTen Win User

    Format Painter no longer working in Microsoft Excel for Mac

    Odd behaviour of Format Painter

    I would strongly suggest using styles, instead of copy formatting. At least for headings and text body. Give your styles shortcuts (I have ctrl + numbers for headings, and Ctrl+n is default for normal).

    You'll be much faster, and layout will be as expected. Format painter is for the parts that are different than defined styles (you play with part of the text .. then copy the formatting)

    As you see, Notepad is not good enough for clearing the formatting from text.
     
    AndreTen, Aug 5, 2021
    #4
Thema:

Format Painter no longer working in Microsoft Excel for Mac

Loading...
  1. Format Painter no longer working in Microsoft Excel for Mac - Similar Threads - Format Painter longer

  2. Converting and Excel with Dropdown search box to work on a mac

    in Windows 10 Installation and Upgrade
    Converting and Excel with Dropdown search box to work on a mac: Is there a way to get an excel created in windows to work on a mac if it include macros and a dropdown search box? https://answers.microsoft.com/en-us/windows/forum/all/converting-and-excel-with-dropdown-search-box-to/f8a51227-58ad-4adc-ae77-9ac0ab68dfb7
  3. Odd behaviour of Format Painter

    in Microsoft Office and 365
    Odd behaviour of Format Painter: Hi folks. I'm getting some very odd behaviour with Format Painter in Word 2016. First of all, I know how format painter works, I have been using it for years! However, on this new installation of both Windows 10 Pro (ver 2004) and MS Office Pro Plus 2016 Version 2005 (Build...
  4. Corel Painter .rif files no longer showing thumbnails

    in Windows 10 Network and Sharing
    Corel Painter .rif files no longer showing thumbnails: File Explorer on Windows 10 used to display thumbnails for Corel Painter .rif files. Why has this changed and we can not view .rif thumbnails? Is MS ****'ing us again?...
  5. Microsoft Excel has stopped working

    in Windows 10 BSOD Crashes and Debugging
    Microsoft Excel has stopped working: My computer shows the following display when I try to open either Excel or Word. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available As I have already had to have the hard drive replaced on...
  6. Preview Pane in Explorer No Longer Working with Excel Files

    in Windows 10 Network and Sharing
    Preview Pane in Explorer No Longer Working with Excel Files: System Parameters: Windows 10 Pro, Version 1803 OS Build 17134.345 64 bit Excel for Office 365 MOS (16.0.1129_20045) 32 bit Issue: Windows/Excel recently updated. Presumably, this was done to "fix" a problem (which reminds me of when I "fixed" my pet). Now, when...
  7. excel conditional formating

    in Microsoft Office and 365
    excel conditional formating: Hi to all,,, I am using excel 2016 and I have a 2 rows of data of which the top row consists of W or L and the row underneath consists of numbers that can be a number from 1 to 8. If the top cell is an L and the cell below is >6 I want the selected cell to be formatted with a...
  8. Windows update and Corel Painter

    in Windows 10 Installation and Upgrade
    Windows update and Corel Painter: I had Corel Painter 2018 installed and it worked fine. Had not used for a while and suddenly it wouldn't load and had an error message - I contacted Corel and they said that it had to be that some Windows update had not completed correctly and I needed to totally re-install...
  9. Excel Conditional formatting question.

    in Microsoft Office and 365
    Excel Conditional formatting question.: If I wanted to make a conditional formatting rule that would select all cells in a column [I2-I65] with a formula generated value less than 0.9 and greater than 1.1, ignoring all empty cells, what formula would I use? Thanks. 83089
  10. HFS+ from Mac to Windows - Formatted?

    in Windows 10 Drivers and Hardware
    HFS+ from Mac to Windows - Formatted?: I was using an HFS+ 3TB Buffalo hard drive on my iMac and plugged it into my laptop running Windows 10 Tech Preview. It didn't show up in Explorer but I think I may have formatted it in Disk Utility. Somewhere along the way, a dialog popped up that mentioned a choice between...