Here's our Microsoft Office Tip for.. October 19, 2004
Click Here to see a complete list of all of our previously released Tips!
Special Fill Feature
Most of us use the Fill handle to copy data, but you can also use it to copy formats. Right-click the fill handle and drag it to the range to which you want to copy the selected cell's formats. When you release the handle, Excel will display a shortcut menu. Choose Fill Formats from that menu to copy just the formats and not the values.