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!

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

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Format Painter Multiple Cells | MyExcelOnline