![]() |
multiple lines in a cell
Does anyone know how to put multiple lines in a cell that is high enough for
more than one line? charles arnett |
multiple lines in a cell
At the end of your line hit alt-enter
"charles" wrote: Does anyone know how to put multiple lines in a cell that is high enough for more than one line? charles arnett |
multiple lines in a cell
charles Wrote: Does anyone know how to put multiple lines in a cell that is high enough for more than one line? charles arnett Two possibilities: 1) When you're typing, hit ALT-ENTER to keep typing on a new line for the same cell. 2) If you just want the text to wrap to the next line when you're typing, go to Format - Cells... Select Alignment, check off the Wrap text cell, and hit OK. (As long as you haven't merged the cell, it will automatically resize. If you've merged, you'll possibly have to manually resize the cell.) Scott -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=564298 |
multiple lines in a cell
Right-click and select Format Cells, then in the Alignment tab tick the Wrap
text box under Text contol. Hope this helps. Tara "charles" wrote: Does anyone know how to put multiple lines in a cell that is high enough for more than one line? charles arnett |
multiple lines in a cell
alt+enter
"charles" escreveu: Does anyone know how to put multiple lines in a cell that is high enough for more than one line? charles arnett |
All times are GMT +1. The time now is 04:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com