| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting does not follow when copying from one cell to another
I have a cell on sheet 1 that I have added text to with some bolding,
coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in the cell on sheet 1 described above. Why doesn't the formatting copy over too?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting does not follow when copying from one cell to another
A formula returns a result, not any formatting.
Pete On Apr 7, 9:55*pm, Banker wrote: I have a cell on sheet 1 that I have added text to with some bolding, coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in the cell on sheet 1 described above. *Why doesn't the formatting copy over too?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting does not follow when copying from one cell to another
"told to copy" means you have used a linking formula such as =Sheet1!A1
Linking formulas do not bring over formatting............values only. Gord Dibben MS Excel MVP On Wed, 7 Apr 2010 13:55:01 -0700, Banker wrote: I have a cell on sheet 1 that I have added text to with some bolding, coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in the cell on sheet 1 described above. Why doesn't the formatting copy over too?? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting does not follow when copying from one cell to anoth
That is exactly what I am doing. Are there any other options?
"Gord Dibben" wrote: "told to copy" means you have used a linking formula such as =Sheet1!A1 Linking formulas do not bring over formatting............values only. Gord Dibben MS Excel MVP On Wed, 7 Apr 2010 13:55:01 -0700, Banker wrote: I have a cell on sheet 1 that I have added text to with some bolding, coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in the cell on sheet 1 described above. Why doesn't the formatting copy over too?? . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting does not follow when copying from one cell to anoth
Do you know of any other options/?
"Pete_UK" wrote: A formula returns a result, not any formatting. Pete On Apr 7, 9:55 pm, Banker wrote: I have a cell on sheet 1 that I have added text to with some bolding, coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in the cell on sheet 1 described above. Why doesn't the formatting copy over too?? . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting does not follow when copying from one cell to anoth
Copy and Paste.
-- David Biddulph "Banker" wrote in message ... Do you know of any other options/? "Pete_UK" wrote: A formula returns a result, not any formatting. Pete On Apr 7, 9:55 pm, Banker wrote: I have a cell on sheet 1 that I have added text to with some bolding, coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in the cell on sheet 1 described above. Why doesn't the formatting copy over too?? . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting does not follow when copying from one cell to anoth
Thanks for the response. I know the Manual function of Copy/Paste will work
but I am trying to automate the spreadsheet so there is less manual work with repeating information. I appreciate your time. "David Biddulph" wrote: Copy and Paste. -- David Biddulph "Banker" wrote in message ... Do you know of any other options/? "Pete_UK" wrote: A formula returns a result, not any formatting. Pete On Apr 7, 9:55 pm, Banker wrote: I have a cell on sheet 1 that I have added text to with some bolding, coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in the cell on sheet 1 described above. Why doesn't the formatting copy over too?? . . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting does not follow when copying from one cell to anoth
I think you will have to go with VBA for your automation if you need the
formatting copied over along with the data. Gord Dibben MS Excel MVP On Fri, 9 Apr 2010 11:47:01 -0700, Banker wrote: Thanks for the response. I know the Manual function of Copy/Paste will work but I am trying to automate the spreadsheet so there is less manual work with repeating information. I appreciate your time. "David Biddulph" wrote: Copy and Paste. -- David Biddulph "Banker" wrote in message ... Do you know of any other options/? "Pete_UK" wrote: A formula returns a result, not any formatting. Pete On Apr 7, 9:55 pm, Banker wrote: I have a cell on sheet 1 that I have added text to with some bolding, coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in the cell on sheet 1 described above. Why doesn't the formatting copy over too?? . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting does not follow value when list is sorted | Excel Discussion (Misc queries) | |||
| Copying formatting from a cell whose location I have calculated. | New Users to Excel | |||
| Copying cell formatting when selecting from a list | Excel Discussion (Misc queries) | |||
| Copying color formatting from cell to cell | Excel Discussion (Misc queries) | |||
| Formatting doesn't follow data sort | Excel Discussion (Misc queries) | |||
Linear Mode
