Format Painter is a very useful feature in MS Excel. You can use it for applying formatting to cells, for instance, when you need to change all the cells with numbers into currency symbols. Format Painter can also be used when you need to apply the same style of borders around all the cells in a column or row.
Choose the text or image with the formatting you wish to copy.
Select Format Painter from the Home tab.
To apply the formatting, paint over a selection of text or visuals with the brush.
Press ESC to halt the formatting.
Format Painter can be installed by downloading it from the Microsoft Office website. Once installed, you can access Format Painter by clicking on “Home” tab and then clicking on “Format Painter”.
Let's take a look at how the format painter shortcut works in Excel: Select the cells or rows that hold the required format, or those from which we want to copy and paste the formatting. Then, on the keyboard, press the Alt, H, F, and P keys.
The benefits of Format Painter are:
It is a quick way to copy formatting.
It can be used for any type of object, not just text.
You can paste the formatting onto any other object.
It saves you time and effort by copying formatting from one object to another.
Learner's Ratings
4.6
Overall Rating
81%
11%
6%
2%
0%
Reviews
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.