Use Format Painter In Excel Multiple Times Without Clicking It Multiple Times

Its a painful and time consuming task to apply format to a large number of cells from a particular cell,You hit format painter each time and apply the format to other cell.

Luckily we have solutions to do that in excel without clicking format painter multiple times.

Suppose we want to format multiple cells with the same format as a cell has.




Select the cell from which you want to copy format and double click Format Painter under Home ribbon in excel.

Capture

Now your format is copied and you could apply this format to as many cells as you want to without going each time to Format Painter.

When you are done, press Esc.

Hope this helped.




 

Share The Knowledge

Random Posts

Leave a Reply