Format Painter in Excel

Hello friends,

                      today we will discuss about a important function called Format Painter in excel.

With the help of below given example it will be easy for us to understand the function.

Here we can see that in cell A1 there is a text in bold, italic and underline format but the same text we can see in a different cell A3 but this is neither bold nor italic and underline, but if we take our cursor to cell A1 and click from mouse on the above shown Format Painter brush  icon and click on icon and paste the same to the cell i.e. A3 to change the format like the cell A1

It will be look like as follows that cell A3 has become same as cell A1 bold, italic and underlined.

Shortcut for above cell format like bold, italic and underline

Cntr B, for Bold, Cntr U for Underline and Cntr I for Italic

Simply Cntr B,U,I

So by this way we can use this tool to change format without going to format a cell option.


Thanks and good bye for now!


Narendra