Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 331
Default putting multiple lines of text in one cell

Ive seen it before but dont know how its done, but how do you have multile
lines of text within an individual cell?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 301
Default putting multiple lines of text in one cell

Alt/enter while typing


"Greg" wrote in message
...
Ive seen it before but dont know how its done, but how do you have multile
lines of text within an individual cell?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default putting multiple lines of text in one cell

If you mean several horizontal lines of text within the one cell - e.g. once
cell displaying something like:

This cell
has multiple
lines of text
in it.

As opposed to:

This cell has multiple lines of text in it

then you need to slect the cell with which you want the text to be changed,
click the "format" drop-down menu, click "cells", click the "alignment" tab
and then check the box beside "wrap text".

You may then need to increase the row height of the cell you wnat to wrap
the text on.

"Greg" wrote:

Ive seen it before but dont know how its done, but how do you have multile
lines of text within an individual cell?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple formatting in text cell blank it out! Tom Excel Discussion (Misc queries) 0 August 1st 06 10:34 AM
How do I insert two lines of text into one cell? mb Excel Discussion (Misc queries) 2 June 29th 06 01:04 AM
how do I copy several lines of word text into one excel cell? jhh New Users to Excel 2 June 16th 06 11:18 PM
Cell Capacity - text i2meek Excel Discussion (Misc queries) 4 March 13th 06 12:06 AM
How do I define column width that allows multiple lines of text? tx_cowgirl Excel Discussion (Misc queries) 4 February 27th 06 07:42 AM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"