ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   multiple lines in a cell (https://www.excelbanter.com/excel-worksheet-functions/100955-multiple-lines-cell.html)

charles

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



tim m

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




Maistrye

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


Tara H

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




Marcelo

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