| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make text fit into 1 block in 2 or more lines in Excel
i want to know do i make my text fit into 1 block if it is a long sentance
needing two or three lines . pressing enter in the fromula bar doen't work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i make text fit into 1 block in 2 or more lines in Excel
FormatCellsAlignment tab, check Wrap text
-- Kind regards, Niek Otten "Siwelile" wrote in message ... i want to know do i make my text fit into 1 block if it is a long sentance needing two or three lines . pressing enter in the fromula bar doen't work. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i make text fit into 1 block in 2 or more lines in Excel
You can force text to wrap by inserting the vertical bar symbol "|" (above the backslash on most US keyboards.) You may have to adjust the cell height to see the second line. ---Glenn -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=509325 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i make text fit into 1 block in 2 or more lines in Excel
Sorry, I guess my age is showing, I was thinking 1-2-3. Use Alt-Enter to force the line wrap within a cell in Excel... -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=509325 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import text to Excel | Excel Discussion (Misc queries) | |||
| Deleting Lines in Excel | Excel Discussion (Misc queries) | |||
| Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
Linear Mode
