Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy drop down boxes and associate to cells dynamically in excel | Excel Worksheet Functions | |||
Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
loan calculator cells, P&I formulas do not copy to second cloumn | Excel Worksheet Functions | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) |