Format Painter in Excel

Hello,
             Today we will discussed about Formatt Painter in excel. This is the most important topic in excel. Formatting has so many features in excel that it is not easy to discuss in a single topic or single day, it will take much time to be discussed. Some feature like formatting numbers, font, color, table, cell, row, column, border, alignment etc.

We will discuss here one by one and with screen shot, so that it would be easy to understand the exact matter. Suppose that there is a cell in excel  and want to maximise the size of the that cell font so what to do,  simply put the cursor on that cell and go to Home tab and increase the font size by dragging down 12 to 16 and the font size will be increased automatically. Like in the following image

                          Image 1                                                       Image 2

                     

  In the previous image 1 you can see that cell B3 has value 3005 and the font size is 11 but in the next image 2 you can see that the font size is 16 and cell B3 size is bigger than previous one, so this is one part of formatting cell by increasing size of cell and same can be done by the decreasing size of cell. By the help of below mentioned image we can understand the several use of formatting function. Here we can see the buttons and its use in excel.

 

In the below given image we can understand "Format Painting" in a better way, In the below image we can see that in cell "A1" we have a $ sign value but in the another columns "C" and "D" we have the value does not containing any $ sign , so for converting these value also in the $ sign format, simply follow the step,

Click on cell "A1" and go to "Format Painter" button and click on "Format Painter" button red circled in the image and once the cell is copied, take the cursor on cell "C1" and drag it up to "D2" 

And once you done this you will get the following result. As we are seeing that the range "C2:D3" has been changed as the same as cell "A2". This is the one use of format painter button.

Now we will learn another way of using "Format Painter" by below given example :-

Here in this image, we can see that there is only one cell has $ sign format and we want to convert all the range into $ sign format. So we will follow the same procedure but in a different way, 

Simply put the cursor or mouse in cell "A1" and  drag it up to end of the row i.e. cell "A7" and leave the mouse. See the image below :- 

And once you leave the mouse you will get the following result : -

Here we can see that all the cell value have been converted into the same format as cell "A1" but also the change that all the cell has the same value as cell "A1" has ($10.00). As we are seeing that in the above given image there is a small drop down option in the below right side of the series, simply click on this drop down arrow button, you will get the above mention option , choose the third option "Fill Formatting Only" option and click on it you will get the desired result.

See the image below ;-

In the above given image we can see that all the value are come back with the desired format.

Formatting to an Entire Column or Row

Now there is another way of using "Format Painter", situation is, we have a cell and we want to convert entire column in the same format. See the  example :-

In the above image we can see that, we want to convert the entire column "C" as same format as  "A1" has. 

So first copy cell "A1" by press "Ctrl + C" copy command and then select the entire data range or column, where we have to change the format and then : -

 "Right Click"-->"Paste Special" --> "Formats--> "OK"

See the image below ;-

Click on the "Paste Special" option, see the image below :-

Click on the "Formats" button then click "OK". And once press "OK" button you will get the desired result as mentioned in the image below :-

Here in this image you can see that the selected values have been converted in the desired format.

So in this tutorial we learned that with the help of "Format Painter' and another option to change the format of the data and get the desired result.

Best of luck

NarendrasExcelTips.blogspot.com