Trick To Copy With “Format Painter” With A Single Click But Unlimited Multiple Pastes | Exceltip2day

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to use “Format Painter”

Tip Quiz

Is there any trick to exscape away Header and Footer?

How can I use “Format Painter” for unlimited multiple pastes?

As you might know that using the “Format Painter” Excel function is very useful and save time. 

Nevertheless, not many people know the trick and enjoy using it in a very simple way.

Trick is:

1] Select the specific cell(S) that you want to copy the format. (Ex. as the image below is cell "A2")

2] To click twice quickly without moving the mouse (Double-clicking) onto the “Format Painter” function button.

3] Click to any cell(s) you want to paste the format.

4] Click on the “Format Painter” again to inactivate the task regards no more use.

Before "Format Printer"

Processing "Format Printer"

After "Format Printer"

Tip Answer

Check: How To Escape Away From Header And Footer To Normal View

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Thanks for reading.
Bye,

Posted by: Michael Leng



I've known, then I've grown.


See more articles:

• Compare Percentage Result Between Excel Formula [Average] And [Averageif Exclude "0"]
• How To Align Number To Be At The Center Of Active Cell(S) In Excel's Workbook
• How To Escape Away From “Header And Footer” To "Normal View" | Exceltip2day