|
Here's our Tip for.. October 19, 2004
Click Here to see a complete list of all of our previously released Tips!
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.
|