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!

YouTube video

Format Painter Multiple Cells | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

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 | MyExcelOnline

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

Format Painter Multiple Cells | MyExcelOnline

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 | MyExcelOnline

They now all have the same formatting!

Format Painter Multiple Cells | MyExcelOnline

Helpful Resource:

728x90

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin