Appearance of linked cell from another document

New Contributor

I made a new document where I work with linked cels form other documents.

In the original document my cell contains coloured fonts and multiple lines of texts.

In the new document the linked cells looks different, all the text is in 1 row, without enter.

Is it possible to link a cell and keep the exact same appearance? 

2 Replies


No, that is not possible.

You can turn on Wrap Text for the cells with the formulas to display multiple lines, but a formula cannot reproduce the fonts and colours of the source cells.

Thank you @Hans Vogelaar 

I can work with that!