| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a cell from another worksheet and create a line wrap
When I copy a wide cell L15 from worksheet US_CA, my SUMMARY worksheet's
narrower cell H15 only shows the first few words of the text. I need to see the whole text with line wrap in my summary cell. Here is what I use for cell H15 in my SUMMARY worksheet: =IF(US_CA!L15="","",US_CA!L15) How can I create a line wrap so that the receiving cell expands horizontally? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a cell from another worksheet and create a line wrap
Correction! I need the receiving cell to expand down.
"Vic" wrote: When I copy a wide cell L15 from worksheet US_CA, my SUMMARY worksheet's narrower cell H15 only shows the first few words of the text. I need to see the whole text with line wrap in my summary cell. Here is what I use for cell H15 in my SUMMARY worksheet: =IF(US_CA!L15="","",US_CA!L15) How can I create a line wrap so that the receiving cell expands horizontally? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to line up wrap around text within cell by tabbing over? | Excel Worksheet Functions | |||
| how to copy a whole line according to one cell in the line to a di | Excel Worksheet Functions | |||
| Compare a value and if is true copy the line to other worksheet | Excel Worksheet Functions | |||
| Disabling "wrap text" neuters alt-return line feeds within cell | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Hybrid Mode
