View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?