#Office365Challenge – Formatting text normally takes me longer than writing the actual content. Today’s post will show you how to use Format Painter to apply the same formatting to other text / cells.

Day: 18 of 365, 347 left
Tools: Microsoft Office; Office 365; Excel 2013
Description: How to use the Format Painter in Office

In this example I’ve added text to various fields in Excel. I want to apply the same formatting as used in J12 (1), to other cells.

  1. Apply formatting (1)
  2. Go to the Home Tab (2)
  3. Click on Format Painter (3)
  4. Now click on the field you want to apply the formatting to (4)

Note:  Click on the Format painter once, to apply the formatting once, if you double click the format painter, you can click on multiple cells to apply the same formatting. Click on the format painter again to cancel.

Format Painter

Happy Formatting.

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but to the overall Microsoft Office Suite as well as where applicable, SharePoint.