| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Cell atributes to another
I would like to know of there is a way to copy one cell atributes to another.
Example: Sheet 1 / A1 = James (Font Red/Bold, Highlighted Yellow) I want to copy the exact cell with all it's properties to another sheet. Sheet 2 / A1 Also, when I change the cell. If I change 'James' to 'Bill' or change the font Color and Face to something else, or Change the Highlighted color; the corisponding cell will also change to exactly what you changed on the A1 cell. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Cell atributes to another
Use Edit Copy / Paste
This will copy the cell with all attributes. But if you later change the formatting of the source cell, you will have to re-copy. -- Gary''s Student - gsnu200801 "Matlock" wrote: I would like to know of there is a way to copy one cell atributes to another. Example: Sheet 1 / A1 = James (Font Red/Bold, Highlighted Yellow) I want to copy the exact cell with all it's properties to another sheet. Sheet 2 / A1 Also, when I change the cell. If I change 'James' to 'Bill' or change the font Color and Face to something else, or Change the Highlighted color; the corisponding cell will also change to exactly what you changed on the A1 cell. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Cell atributes to another
I think what you want is a way to ensure that no matter what is in cell A1,
it will also be in another cell. Use Copy Special, then Paste Link to the new cell. "Matlock" wrote: I would like to know of there is a way to copy one cell atributes to another. Example: Sheet 1 / A1 = James (Font Red/Bold, Highlighted Yellow) I want to copy the exact cell with all it's properties to another sheet. Sheet 2 / A1 Also, when I change the cell. If I change 'James' to 'Bill' or change the font Color and Face to something else, or Change the Highlighted color; the corisponding cell will also change to exactly what you changed on the A1 cell. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Cell atributes to another
Paste link will link the data, not the formatting.
Gord Dibben MS Excel MVP On Wed, 20 Aug 2008 09:23:01 -0700, Steven wrote: I think what you want is a way to ensure that no matter what is in cell A1, it will also be in another cell. Use Copy Special, then Paste Link to the new cell. "Matlock" wrote: I would like to know of there is a way to copy one cell atributes to another. Example: Sheet 1 / A1 = James (Font Red/Bold, Highlighted Yellow) I want to copy the exact cell with all it's properties to another sheet. Sheet 2 / A1 Also, when I change the cell. If I change 'James' to 'Bill' or change the font Color and Face to something else, or Change the Highlighted color; the corisponding cell will also change to exactly what you changed on the A1 cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
Linear Mode
