#Microsoft365 – 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.

For previous posts in my #Microsoft365Challenge go to the index page.

DISCLAIMER:  I WRITE ARTICLES ABOUT OFFICE / MICROSOFT 365. CONTENT IS ACCURATE AT TIME OF PUBLICATION, HOWEVER UPDATES AND NEW ADDITIONS HAPPEN DAILY WHICH COULD CHANGE THE ACCURACY OR RELEVANCE. PLEASE KEEP THIS IN MIND WHEN USING MY BLOGS AS GUIDELINES.

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) – double click if you want to re-use it.
  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

Use this to easily apply the same formatting to shapes in PowerPoint as well.

Happy Formatting.

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found here. I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.