To activate this hidden gem you need to double click on the Format Painter and then go crazy with the paint brush!
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
STEP 2: These are the cells that we want to apply the same formatting. Click on all of them
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
They now all have the same formatting!
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.