Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Link function
How do I show cell formatting using paste link in Excel sheets?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Link function
Pasting a link creates a formula to retrieve a value from a different cell.
Formulas don't bring back formatting--they bring back values. Al wrote: How do I show cell formatting using paste link in Excel sheets? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Link function
Hi Al,
You can copy the format from one cell and paste the format to another cell using paste special, format. However, if the formating changes from the source cell - the updated formatting won't update. If you want to maintain a cohesive style in your workbook, you should look at using style in Excel -- If this post helps click Yes --------------- Peggy Shepard "Al" wrote: How do I show cell formatting using paste link in Excel sheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
How to stop Paste Link function from pasting an object | Excel Discussion (Misc queries) | |||
Using the paste link function in Excel 2003 | Excel Worksheet Functions | |||
Paste Link Function | Excel Discussion (Misc queries) | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) |