Linked spreadsheet is not automatically adjusting row height?

[lyngwin]

The linked cells are not carrying the row height auto fit format from the
source sheet. How do I carry that format to the linked sheet?

 

[Gord Dibben]

You don't.

It must be copied over separately.

Linking formulas can only return values, not formatting.


Gord Dibben MS Excel MVP

 

[lyngwin]

You don't.

It must be copied over separately.

Linking formulas can only return values, not formatting.


Gord Dibben MS Excel MVP



If the source spreadsheet and the destination spreadsheet are both formatted to auto fit the row height, why is it notadjusting on the destination spreadsheet when the data is entered? Or how do I do this so it will auto adjust?