Format Multiple Cells at Once/ Format Painter Multiple Cells Excel

Copy format into multiple cells with Format Painter/ How to Format Multiple Cells at Once/ Apply format of a cell into multiple cells with Format Painter.

Format Painter is a very useful tool, if you want to copy a format of a cell and want to apply it on another cell, go to the formated cell and click on Format Painter tool which you will find on Home tab just below the copy button. Now click wherever you want to apply or paste that format.

Format Painter Button

But how to format multiple cell at once in excel, is it possible with Format Painter? The answer is yes, it is possible.
It's very simple, go to the formated cell and after that double click on Format Painter. Now you can apply that format into multiple cells. It's a very simple and time consuming activity. Try it.

Format Painter