Linked spreadsheet is not automatically adjusting row height?
 

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?

Linked spreadsheet is not automatically adjusting row height?
 

You don't.

It must be copied over separately.

Linking formulas can only return values, not formatting.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 12:59:01 -0800, lyngwin
wrote:

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?

Linked spreadsheet is not automatically adjusting row height?
 

"Gord Dibben" wrote:

You don't.

It must be copied over separately.

Linking formulas can only return values, not formatting.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 12:59:01 -0800, lyngwin
wrote:

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?

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?