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 2016, 2013, 2010 and earlier.Ī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.
