Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cell and formating
I am copying information from on sheet to another in the same workbook. Is
there a way to copy the entire format of the cell automatically? Page 1 A B C 1 2 3<~~ number is red and bolded 3 Page 2 A B C 1 2 +page1!B2 <~~gives me a black non bolded 3 3 I want page to to have a red bolded 3. Is there a way? Any help would be nice thank you ....... Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cell and formating
If you *copy* a cell, you will copy the format as well as the content
(unless you paste special to restrict which aspects you want to copy). If you *link* to a cell, you don't pick up the format of the source cell. -- David Biddulph Eric wrote: I am copying information from on sheet to another in the same workbook. Is there a way to copy the entire format of the cell automatically? Page 1 A B C 1 2 3<~~ number is red and bolded 3 Page 2 A B C 1 2 +page1!B2 <~~gives me a black non bolded 3 3 I want page to to have a red bolded 3. Is there a way? Any help would be nice thank you ....... Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cell and formating
so what is the difference between linking and copying. What would this look
like in a formula? I am currently using the +cell location. Eric "David Biddulph" wrote: If you *copy* a cell, you will copy the format as well as the content (unless you paste special to restrict which aspects you want to copy). If you *link* to a cell, you don't pick up the format of the source cell. -- David Biddulph Eric wrote: I am copying information from on sheet to another in the same workbook. Is there a way to copy the entire format of the cell automatically? Page 1 A B C 1 2 3<~~ number is red and bolded 3 Page 2 A B C 1 2 +page1!B2 <~~gives me a black non bolded 3 3 I want page to to have a red bolded 3. Is there a way? Any help would be nice thank you ....... Eric . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cell and formating
By +page1!B2 you presumably mean =page1!B2 ?
Perhaps you've forgotten that Excel starts formulae with an = sign? The + sign at the start of the formula sounds like a relic from a Lotus spreadsheet application. To *copy* the cell, go to page1 cell B2, select the cell, Control C (or Copy), go back to your destination cell on page 2, Control V (or Paste). That will paste the 3, and its format, into the destination cell. -- David Biddulph Eric wrote: so what is the difference between linking and copying. What would this look like in a formula? I am currently using the +cell location. Eric "David Biddulph" wrote: If you *copy* a cell, you will copy the format as well as the content (unless you paste special to restrict which aspects you want to copy). If you *link* to a cell, you don't pick up the format of the source cell. -- David Biddulph Eric wrote: I am copying information from on sheet to another in the same workbook. Is there a way to copy the entire format of the cell automatically? Page 1 A B C 1 2 3<~~ number is red and bolded 3 Page 2 A B C 1 2 +page1!B2 <~~gives me a black non bolded 3 3 I want page to to have a red bolded 3. Is there a way? Any help would be nice thank you ....... Eric . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy ALL formating and setup? | Excel Discussion (Misc queries) | |||
formating the color and border of a cell and then copy numbers int | Excel Discussion (Misc queries) | |||
??? Copy conditional formating | Excel Discussion (Misc queries) | |||
Copy worksheet and keep all formating | Excel Discussion (Misc queries) | |||
Copy cell formating as part of a formula | Excel Worksheet Functions |