Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking cells between worksheets
When linking cells only the formula/value is copying over, I also need the
formatting. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking cells between worksheets
Hi Dawn
Not really - formulas can't amend the formatting of the cell in which they reside (other than in limited circumstances eg by Conditional Formatting). You would need to copy and pastespecial the formats from the target cells yourself, I'm afraid. Best regards Richard Dawn101 wrote: When linking cells only the formula/value is copying over, I also need the formatting. Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking cells between worksheets
Hello Dawn
You can link the cell from one work book to another , One cell to antoher cell, one sheet to another sheet, you can get the linked data only, You can't get the original format While linking the formula or anything. (For link) u will get the original result except the original format -- Name : K.Prasad Inventory Manager CRYSTALGALLERY DUBAI "Dawn101" wrote: When linking cells only the formula/value is copying over, I also need the formatting. Is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking cells between worksheets
On a case by case basis, you can do this in 2 steps.
Right click in the source cell and choose copy, Navigate to the target sheet and right click in the target cell, Choose Paste Special, Click on Paste Link, Right click again in the target cell, Choose Paste Special, Click on Formats, Then <OK. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Dawn101" wrote in message ... When linking cells only the formula/value is copying over, I also need the formatting. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Linking Merged Cells | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Linking across worksheets not working as desired | Excel Worksheet Functions | |||
Linking set of worksheets between different workbooks! | Excel Discussion (Misc queries) |