FORMAT PAINTER is the most useful OPTION in EXCEL.
FORMAT PAINTER We use FORMAT of any CELL to COPY. Using this we can easily paste the format in just one click.
By using this, we can also save a lot of our time and increase the SPEED to do our work.
Let us understand with the help of EXAMPLE.
Here in the photo below we are given a TABLE and we have to copy its FORMAT.
We can do this easily in just 3 STEPS.
STEP -1 # First, we will SELECT the FORMAT we want to copy.
STEP -2 # Then CLICK on FORMAT PAINTER in CLIPBOARD BLOCK in HOME TAB.
STEP -3 # Then after CLICK on FORMAT PAINTER, our SELECT FORMAT is created around and DOTTED BORDER, after that we will select that FORMAT wherever you want to paste that CELL and our format gets copied.
And in this way we can copy any FORMAT.
We can use any OPTION even after filling the DATA in CELL. Even then it will work in the same way. Whether we use it first or later we can use it whenever we want.
If we have to use it again and again, after SELECT FORMAT, we will DOUBLE CLICK on FORMAT PAINTER (twice). After that we can use the FORMAT wherever needed and CLICK it as many times as you want. And to remove it again we will use Esc BUTTON.