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.
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.
