How-To Geek on MSN

Stop using format painter in Excel: Find and replace formatting instead

First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...
HowToGeek on MSN

Need to Duplicate Cell Formatting in Excel? Use This Tool

The Format Painter in Excel lets you copy formatting from one cell or group of cells to another cell or group of cells ...