For all those who live in MS Excel (myself included), here’s a nifty tip paraphrased from AccountingWeb:
Double Click the Format Painter to lock the Format Painter. Paste the format into as many cells as you want then hit the Escape Key.
When I found out about the Format Painter several years ago, my mind was blown. It’s one of those small things that once you learn, it becomes essential. This tip lets you paste the cell formatting into as many cells as you want without having to go back and click the Format Painter icon before each paste.
I’ve tried double clicking on Format Painter in both Excel 2003 and newer versions (2007 I think), and it works.
It’s the details that count.