Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells and text wrap / autofit function
I am trying to link a cell to another cell that contains text only and have
the linked cell auto fit. I have wrap text and autofit enabled for the entire sheet. Per previous discussions I don't have any merged cells anywhere in the workbook. In fact these are the only two cells that currently contain any data. My data entry cell autofits fine but the linked cell dosen't change unless I perform an autofit command to it then it won't change until I do it again. Thanks for reading and any help you may have. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells and text wrap / autofit function
That's the way excel works.
You could have an event macro resize the rows/columns whenever the worksheet recalculates. But be aware that these kinds of things will kill your edit|Undo ability. If you want to try, right click on the worksheet tab that should have this behavior. Select view code and paste this into the code window: Option Explicit Private Sub Worksheet_Calculate() Me.Rows.AutoFit 'or be specific Me.Rows("1:33").AutoFit End Sub Ken H wrote: I am trying to link a cell to another cell that contains text only and have the linked cell auto fit. I have wrap text and autofit enabled for the entire sheet. Per previous discussions I don't have any merged cells anywhere in the workbook. In fact these are the only two cells that currently contain any data. My data entry cell autofits fine but the linked cell dosen't change unless I perform an autofit command to it then it won't change until I do it again. Thanks for reading and any help you may have. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit and word wrap don't work? | Excel Discussion (Misc queries) | |||
Wrap text and row autofit not working in Excel | Excel Discussion (Misc queries) | |||
Autofit with Merged Cells/Wrap Text Macro Problem | Excel Discussion (Misc queries) | |||
when I wrap text in excel it disappears? autofit does not work | Excel Worksheet Functions | |||
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions |