Linked spreadsheet is not automatically adjusting row height?

G

Guest

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?
 
G

Gord Dibben

You don't.

It must be copied over separately.

Linking formulas can only return values, not formatting.


Gord Dibben MS Excel MVP
 
G

Guest

Gord Dibben said:
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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting row height not to exceed... 1
Excel Cell Height - white space 2
Protection and row height 3
Need help on formatting row height 1
Return to Auto Row Height - 2007 2
Auto fit text in cell of a protected worksheet 3
Autofit Height of Rows too High 2
Autofit Row Height 4

Top