How to copy formatting in Excel with Format Painter.As you have probably guessed, I am talking about the Excel Format Painter that makes it really easy to take the formatting of one cell and apply it to another.įurther on in this tutorial, you will find the most efficient ways to use Format Painter in Excel, and learn a couple of other techniques to copy formatting in your sheets.

Whether you are creating a repot for your head office or building a summary worksheet for the board of directors, proper formatting is what makes important data stand out and convey the relevant information more effectively.įortunately, Microsoft Excel has an amazingly simple way to copy formatting, which is often overlooked or underestimated. These techniques work in all versions of Excel, from 2007 through Excel 365.Īfter you've put a lot of effort in calculating a worksheet, you would usually want to add some finishing touches to make it look nice and presentable. This short tutorial shows how to copy formatting in Excel using Format Painter, Fill Handle and Paste Special options.

Paintbrush for mac tips and tricks