[plug] Format painter

[ryan at is.as.geeky.as]

On Mon, Aug 26, 2002 at 09:13:25AM +0800, James Elliott wrote:
> In MS Excel and Word you have a "Format Painter" - a button with a paint
> brush icon.  You select some text, or cells in a spread sheet, click on the
> button and then, select a different piece of text, or group of cells in the
> spreadsheet .... and the format of the first selection is copied to the
> second selection.

1. Select the text and copy it as normal.
2. Select the destination cells.
3. Right click them and chose 'Paste Special ...'
4. Untick 'Paste all' and then leave 'Formats' as the only one ticked
under the selection section.
5. Click OK and it will remember that setting for the next time you
'Paste Special ...'

Ryan