Format Painter Not Working

Occasional Visitor

Good Morning/Afternoon/Evening,

My format painter is not working. I'm not trying to do anything complex. Just the basic positioning of text inside a cell, the font, and the date format. When I highlight the cell I want to copy the format from and then select the cell I want to have the same formatting in, it literally does nothing. Absolutely nothing changes at all. Does anyone know how to fix this?

2 Replies
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
* Knowing the Excel version and operating system would also be an advantage.

Thank you for your understanding and patience

I know I don't know anything (Socrates)


To be sure what you are doing:

stay on cell, right click and here click on Format painter


cursor will be with paint. Click on another cell, format shall be applied