Be aware that Paste special - Values will not paste formulas. You get the
current result, not the formula.
--
Earl Kiosterud
www.smokeylake.com
"Mangus Pyke" wrote in message
...
On Wed, 20 Jul 2005 16:45:06 -0700, Sam wrote:
I spent a long time formatting the edges of the cells in my document,
now the document looks like a table that I would like to use a template.
It's a pain, ain't it?
a) Is there a way to copy only this formatting [not the values in the
cells] and paste it to other cells? [i.e., create new templates]
Copy the table, select the cell where you'd like the formatting to be
copied to, and then click Edit -- Paste Special, select Format and
click OK
b) Is there a way to paste values INTO a blank template [that has the
correct formatting of the edges of all of the cells, but no values in the
cells], keep the formatting of the edges of the cells?
Copy the table, select the cell where you'd like the formatting to be
copied to, and then click Edit -- Paste Special, select Values and
click OK
MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner