This time we have several numbers in different cells, so every time we need to press the option of “Format Painter,” so instead of pressing every time, we can make the Format Painter active for more than one time. So all the formatting of cell A1 is copied to cell D1 with just a click of the mouse.
Place your cursor in cell A1 and click on “Format Painter”.Follow the steps to copy cell formatting using format painter.
