Pinterest Pixel

Format Painter Multiple Cells

Format Painter Multiple Cells The Format Painter copies formatting from one place and applies it to another... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Format Painter Multiple Cells | MyExcelOnline Format Painter Multiple Cells | MyExcelOnline

Format Painter Multiple Cells

The Format Painter copies formatting from one place and applies it to another but this can also be extended to multiple cells.

To activate this hidden gem you need to double click on the Format Painter and then go crazy with the paint brush!

download excel workbook Format-Painter.xlsx

STEP 1: Pick a cell that contains the formatting you want to copy

Go to Home > Clipboard > Format Painter and make sure to double click on the format painter icon

Format Painter Multiple Cells

STEP 2: These are the cells that we want to apply the same formatting. Click on all of them

Format Painter Multiple Cells

STEP 3: The same formatting is applied with just a click. Now try applying it to the entire YEAR Column by highlighting the entire column

Format Painter Multiple Cells

They now all have the same formatting!

Format Painter Multiple Cells

If you like this Excel tip, please share it
Format Painter Multiple Cells | MyExcelOnline Format Painter Multiple Cells | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  2 Best Ways to Use the IF ELSE Function in Excel (Examples)

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...