Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 34
Default Formatting text in a cell

Is there a way to key text in one cell that is multiple lines? We would like
to be able to insert new lines where we want them.


Thanks for the help!!
--
akkrug
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,058
Default Formatting text in a cell

Use the Formula Bar:

1. click in the formula bar
2. in the formula bar, move the cursor to the desired point of insertion
3. touch ALT-ENTER
4. enter the new line.
--
Gary''s Student - gsnu200855


"akkrug" wrote:

Is there a way to key text in one cell that is multiple lines? We would like
to be able to insert new lines where we want them.


Thanks for the help!!
--
akkrug

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default Formatting text in a cell

Akkrug,

You can also via the Formula bar change color of text, make parts of
the text bold, italic,....

Just select the part of the text you want to format and push the
respectivly buttons.

Good luck formatting,
Tom

On 28 mei, 14:25, akkrug wrote:
Is there a way to key text in one cell that is multiple lines? *We would like
to be able to insert new lines where we want them. *

Thanks for the help!!
--
akkrug


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 70
Default Formatting text in a cell

Hi akkrug,

Type in the data and press key combination (Alt+Enter) to move down to next
row.

--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"akkrug" wrote:

Is there a way to key text in one cell that is multiple lines? We would like
to be able to insert new lines where we want them.


Thanks for the help!!
--
akkrug

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
Text in Cell Formatting travelinman Excel Discussion (Misc queries) 5 April 1st 09 01:46 AM
Conditional formatting Based on cell A text with conditions in Cell B Raicomm Excel Discussion (Misc queries) 0 January 21st 08 05:46 PM
Conditional Formatting based on text within a cell w/ text AND num Shirley Excel Worksheet Functions 2 December 22nd 06 02:40 AM
Formatting text within a cell AV Guy New Users to Excel 9 March 30th 06 10:07 PM
Cell/text formatting Frustrated Excel Discussion (Misc queries) 4 August 9th 05 10:03 PM


All times are GMT +1. The time now is 11:25 PM.

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

About Us

"It's about Microsoft Excel"