How to use Format Painter
Now we will see that what Format painter is in MS Excel.
If we want the format of any particular cell to apply to our normal cell, for example four different cells are having different background color and have borders to them with bold font, then if we want to apply that same format to different cells than we can use Format Painter option from our home tab, and select that cell whose properties we need to acquire, and mark the cells which we want to add the properties which we formatted.
As soon as we do that, the format of the cells which we selected will be similar to the cells which we wanted.
Format painter is a good functionality which is used many times in MS Excel.
Share a personalized message with your friends.