Home   >  ZandaX Blogs   >  Business Blog   >  Microsoft Software Articles   > 
How to Use Format Painter in Excel for Multiple Cells

How to Use Format Painter in Excel for Multiple Cells

 
Improving your Microsoft software skills
Learn how to copy formats from one cell to another using the Format Painter tool in Excel, with this tutorial from ZandaX Training.
 
Article author: Jordan James
      Written by Jordan James
       (2-minute read)
Sometimes multiple format changes are required in Excel on various locations and sheets within a Workbook, this can be time consuming and ineffective.  Excel can provide a more efficient way of doing this for you.


How To Use Format Painter In Excel For Multiple Cells Video

Watch to see how to use format painter in excel for multiple cells

[ Video tutorial created by Activia Training and purchased by ZandaX ]


Format Painter is a very powerful and efficient method of copying formats from one cell to another and ensuring that documents and spreadsheets have uniform formatting.

Select the cell with the correct formatting that you want to copy over and click on Format Painter in the Home Ribbon. Your mouse cursor will now have a paint brush next to it and the original cell has a dotted border to identify which cell's formatting has been copied. Click on the cell that you want to copy the formatting to and the formatting will be applied and the Format Painter will be deactivated.

We can double click on the Format Painter option if you need to copy it to multiple cells. Once you have formatted all the cells required you will need to click on the Format Painter icon again to deactivate it.

In the example below, cell A2 contains the correct formatting that we would like to have applied to other cells. By clicking on cell A2 and then double clicking the Format Painter tool, we can then single click on multiple cells to apply the required formatting to them.

format-painter

format-painter-in-table

We can also use this to copy formatting such as Data Validation and Conditional Formatting but it will not copy data content or formulas.

Improve Your Excel Skills


If you'd like to learn more about Microsoft Excel, why not take a look at how we can help?

We have a whole range of online courses for all skill levels.
RRP from $39 – limited time offer just $8.99

More Articles on Microsoft Software

Version History of Microsoft Word
Version History of Microsoft Word
Jordan James
Author: Jordan James
About the article
Summary
Read about the different versions of Microsoft Word, from Activia Training, providers of flexible, cost effective Word training courses.
[ close ]
10 Ways Excel Pivot Tables can help you.
10 Ways Excel Pivot Tables can help you.
Jordan James
Author: Jordan James
About the article
Summary
Pivot Tables are extremely useful in analysing data and seeing how its linked. This looks at 10 ways to use Pivot Tables properly.
[ close ]
How to Highlight Data in Different Colors in Microsoft Word
How to Highlight Data in Different Colors in Microsoft Word
Jordan James
Author: Jordan James
About the article
Summary
Learn how to highlight data in different colors in Word with this guide on the ZandaX website.
[ close ]
How to Add Special Characters in Word with Keyboard
How to Add Special Characters in Word with Keyboard
Jordan James
Author: Jordan James
About the article
Summary
Find out how to add special characters, such as the trademark and copyright symbols in Microsoft Word, using the keyboard.
[ close ]
Enhancing Legal Operations: The Power of Microsoft Integration
Enhancing Legal Operations: The Power of Microsoft Integration
Jordan James
Author: Jordan James
About the article
Summary
With greater efficiency needed by corporate legal operations, this article looks into the advantages and applications of Microsoft integration.
[ close ]
Simplify Microsoft Excel with the Right Training Course
Simplify Microsoft Excel with the Right Training Course
Jordan James
Author: Jordan James
About the article
Summary
You can play around with Microsoft Excel for hours, and still get nowhere! Here, we give you tips on how to find a training course to help
[ close ]
Our Course Of The Month  Microsoft Project
Our Course Of The Month Microsoft Project
Jordan James
Author: Jordan James
About the article
Summary
The course of the month this month is Microsoft Project. As a project manager, are you using the tools that are available to you?
[ close ]
What Is Microsoft Visio Used For?
What Is Microsoft Visio Used For?
Jordan James
Author: Jordan James
About the article
Summary
Microsoft Visio can be used for a lot more than people realise. Popular uses include creating organisation charts, floor plans and timelines
[ close ]
7 Reasons Why You Should Learn How to Use Excel
7 Reasons Why You Should Learn How to Use Excel
Jordan James
Author: Jordan James
About the article
Summary
The Article shows how to boost productivity with Excel, Improve Quality of Work, Versatility, You will become a God in the Office!
[ close ]
What are Macros used for in Excel?
What are Macros used for in Excel?
Jordan James
Author: Jordan James
About the article
Summary
Macros in Excel are incredibly powerful tools that can provide the user with large benefits. This article looks at what macros are for.
[ close ]
How To Use Animation Triggers In PowerPoint
How To Use Animation Triggers In PowerPoint
Jordan James
Author: Jordan James
About the article
Summary
Learn how to use animation triggers in Microsoft PowerPoint from this tutorial from Activia Training.
[ close ]
How To Run A PowerPoint Presentation
How To Run A PowerPoint Presentation
Jordan James
Author: Jordan James
About the article
Summary
Learn how to add motion paths to animations in Microsoft PowerPoint from this tutorial from Activia Training.
[ close ]
 

Write for us on the ZandaX blog

We're always looking for guest contributors to increase the variety and diversity of what we present.
Click to see how you can write for us:
 

The ZandaX Business Skills blog categories

Click a panel to visit the main category pages for the blog
Career Success
Career Success
Marketing
Marketing
Presentation Skills & Public Speaking
Presentation Skills & Public Speaking
Customer Service
Customer Service
Microsoft Software
Microsoft Software
[ This category ]

ZandaX Blog Contents

Want to see them all? Click to view a full list of articles in our blogs.

zandax online courses logo
"ZandaX courses are such great value, and with the help and support they give, there's no better option in the market"
ZandaX LinkedIn logo
ZandaX YouTube logo
ZandaX FaceBook logo
 
All content © ZandaX 2024