Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display multiple lines in a cell
Hi all,
I put the Cell1Add & char(10) & Cell2Add into another cell and the content from Cell1 and Cell2 are put in seperate lines. The question is the containing cell did not collapse automatically to display the multiple lines. Clara thank you so much for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display multiple lines in a cell
Select the row and do format=row and select autofit.
-- Regards, Tom Ogilvy "clara" wrote: Hi all, I put the Cell1Add & char(10) & Cell2Add into another cell and the content from Cell1 and Cell2 are put in seperate lines. The question is the containing cell did not collapse automatically to display the multiple lines. Clara thank you so much for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display multiple lines in a cell
Hi Paul,
Thank you very much for your reply. My case is that I put the formula: Cell1Addr & char(10 ) & Cell2Addr into a cell. The contents from two are displayed in two seperate lines, but the cell is not extended automatically in order to display the whole multiple lines. thank you so much for your help "Paul B" wrote: Clara, to get two lines in one cell use Alt+enter, is that what you need? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "clara" wrote in message ... Hi all, I put the Cell1Add & char(10) & Cell2Add into another cell and the content from Cell1 and Cell2 are put in seperate lines. The question is the containing cell did not collapse automatically to display the multiple lines. Clara thank you so much for your help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display multiple lines in a cell
Clara, to get two lines in one cell use Alt+enter, is that what you need?
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "clara" wrote in message ... Hi all, I put the Cell1Add & char(10) & Cell2Add into another cell and the content from Cell1 and Cell2 are put in seperate lines. The question is the containing cell did not collapse automatically to display the multiple lines. Clara thank you so much for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display multiple lines in pop up when workbook opens | Excel Programming | |||
display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
display multiple lines of text within a merged cell automatically | Excel Worksheet Functions |