Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default How Can I Make a Manual Line Break in a Cell?

I would like to be able to make manual line breaks within a cell like you can
in Word. For instance, I am making a spreadsheet of conferences people in my
office need to go to. Within a single cell I would like to be able to make
four lines: Confernece name, Dates, Place, and Name.

Yes, I know I can combine cells and stuff like that, but it takes too long
nd get mesed up as the spreadsheet is passed around.

Thanks for the help,
RickB
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 964
Default How Can I Make a Manual Line Break in a Cell?

While editing the cell, hit ALT-ENTER. That will start a new line within a
cell.

HTH,
Elkar


"RickB" wrote:

I would like to be able to make manual line breaks within a cell like you can
in Word. For instance, I am making a spreadsheet of conferences people in my
office need to go to. Within a single cell I would like to be able to make
four lines: Confernece name, Dates, Place, and Name.

Yes, I know I can combine cells and stuff like that, but it takes too long
nd get mesed up as the spreadsheet is passed around.

Thanks for the help,
RickB

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default How Can I Make a Manual Line Break in a Cell?

That simple? Holy cow! Thanks!!!!

"Elkar" wrote:

While editing the cell, hit ALT-ENTER. That will start a new line within a
cell.

HTH,
Elkar


"RickB" wrote:

I would like to be able to make manual line breaks within a cell like you can
in Word. For instance, I am making a spreadsheet of conferences people in my
office need to go to. Within a single cell I would like to be able to make
four lines: Confernece name, Dates, Place, and Name.

Yes, I know I can combine cells and stuff like that, but it takes too long
nd get mesed up as the spreadsheet is passed around.

Thanks for the help,
RickB

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
Remove Manual Line Breaks in Cell prizm Excel Discussion (Misc queries) 3 June 13th 07 04:41 PM
Break cell into multiple lines by line break Chia Excel Discussion (Misc queries) 1 August 20th 06 06:37 AM
Insert manual line break in formula 0-0 Wai Wai ^-^ Excel Worksheet Functions 3 December 11th 05 07:10 PM
Manual line break in cell GKW in GA Excel Discussion (Misc queries) 1 November 6th 05 05:28 AM
Insert manual line break in formula 0-0 Wai Wai ^-^ Excel Worksheet Functions 1 September 8th 05 12:03 PM


All times are GMT +1. The time now is 03:10 AM.

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"