| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Adjusting Row Height in Merged Cells | Excel Discussion (Misc queries) | |||
| Automatically adjusting columns | Excel Discussion (Misc queries) | |||
| Automatically Re-Size Row Height | Excel Worksheet Functions | |||
| linked cell contents not autofitting row height | Excel Discussion (Misc queries) | |||
| Row height is not adjusting after activating Merge Cells & Wrap Te | Excel Worksheet Functions | |||
Linear Mode
