How to copy "edge" formatting to other cells.

S

Sam

Hello

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.

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]

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?

Thanks you!
 
M

Mangus Pyke

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.
Click to expand...

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]
Click to expand...

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?
Click to expand...

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-
 
E

Earl Kiosterud

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 said:
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.
Click to expand...

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]
Click to expand...

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?
Click to expand...

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-
Click to expand...
 
Top