| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wrap text, in an Excel CELL, which is linked to another sheet.
Can I wrap text and autoexpand a cell that is linked to another excel sheet?
I can do it when not linked. Di Thank You |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wrap text, in an Excel CELL, which is linked to another sheet.
Yes.
What happened when you tried? What is in the cell that you are linked to on the other sheet. Gord Dibben MS Excel MVP On Fri, 10 Aug 2007 21:02:00 -0700, dls25 wrote: Can I wrap text and autoexpand a cell that is linked to another excel sheet? I can do it when not linked. Di Thank You |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wrap text, in an Excel CELL, which is linked to another sheet.
I generate a report from ACCESS to excel. I have many columns, one is named
Comments, some times the comment is longer than what i have room (for in the second sheet) . This is linked to a report that charts numbers and other information. It puts the comment in and wraps text, but will not auto expand. I need it to auto expand. "Gord Dibben" wrote: Yes. What happened when you tried? What is in the cell that you are linked to on the other sheet. Gord Dibben MS Excel MVP On Fri, 10 Aug 2007 21:02:00 -0700, dls25 wrote: Can I wrap text and autoexpand a cell that is linked to another excel sheet? I can do it when not linked. Di Thank You |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wrap text, in an Excel CELL, which is linked to another sheet.
Is the target cell/row set to Autofit?
Is the target cell a merged cell? Merged cells will not Autofit without event code. Gord On Sat, 11 Aug 2007 06:06:03 -0700, dls25 wrote: I generate a report from ACCESS to excel. I have many columns, one is named Comments, some times the comment is longer than what i have room (for in the second sheet) . This is linked to a report that charts numbers and other information. It puts the comment in and wraps text, but will not auto expand. I need it to auto expand. "Gord Dibben" wrote: Yes. What happened when you tried? What is in the cell that you are linked to on the other sheet. Gord Dibben MS Excel MVP On Fri, 10 Aug 2007 21:02:00 -0700, dls25 wrote: Can I wrap text and autoexpand a cell that is linked to another excel sheet? I can do it when not linked. Di Thank You |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wrap text, in an Excel CELL, which is linked to another sheet.
The cells that i want to wrap text and auto fit, are set.
Other cells in that row have merged cells. Di "Gord Dibben" wrote: Is the target cell/row set to Autofit? Is the target cell a merged cell? Merged cells will not Autofit without event code. Gord On Sat, 11 Aug 2007 06:06:03 -0700, dls25 wrote: I generate a report from ACCESS to excel. I have many columns, one is named Comments, some times the comment is longer than what i have room (for in the second sheet) . This is linked to a report that charts numbers and other information. It puts the comment in and wraps text, but will not auto expand. I need it to auto expand. "Gord Dibben" wrote: Yes. What happened when you tried? What is in the cell that you are linked to on the other sheet. Gord Dibben MS Excel MVP On Fri, 10 Aug 2007 21:02:00 -0700, dls25 wrote: Can I wrap text and autoexpand a cell that is linked to another excel sheet? I can do it when not linked. Di Thank You |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wrap text, in an Excel CELL, which is linked to another sheet.
Unfortunately the merged cells in the row seem to override the autofit for the
entire row. Dump the merged cells and make life much easier and less stressful. Or see this google thread. http://tinyurl.com/2netq8 Gord On Sat, 11 Aug 2007 12:28:01 -0700, dls25 wrote: The cells that i want to wrap text and auto fit, are set. Other cells in that row have merged cells. Di "Gord Dibben" wrote: Is the target cell/row set to Autofit? Is the target cell a merged cell? Merged cells will not Autofit without event code. Gord On Sat, 11 Aug 2007 06:06:03 -0700, dls25 wrote: I generate a report from ACCESS to excel. I have many columns, one is named Comments, some times the comment is longer than what i have room (for in the second sheet) . This is linked to a report that charts numbers and other information. It puts the comment in and wraps text, but will not auto expand. I need it to auto expand. "Gord Dibben" wrote: Yes. What happened when you tried? What is in the cell that you are linked to on the other sheet. Gord Dibben MS Excel MVP On Fri, 10 Aug 2007 21:02:00 -0700, dls25 wrote: Can I wrap text and autoexpand a cell that is linked to another excel sheet? I can do it when not linked. Di Thank You |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked cells and text wrap / autofit function | Excel Worksheet Functions | |||
| Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| Chart Title or Text Box Linked to cell & sheet | Charts and Charting in Excel | |||
| Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
