|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 7th, 2010, 09:55 PM
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
April 7th, 2010, 11:19 PM
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
April 7th, 2010, 11:39 PM
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
April 8th, 2010, 02:34 PM
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
April 8th, 2010, 02:35 PM
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
April 8th, 2010, 11:10 PM
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
April 9th, 2010, 07:47 PM
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
April 10th, 2010, 01:11 AM
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?? . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
