Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now		 3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Software > Spreadsheets   »   Multi line cells in excel

Answer this Question Ask about Spreadsheets
 
Question Tools Search this Question Display Modes
Question
 
 
#1  
Old Jan 2, 2007, 12:19 AM
Capuchin's Avatar
Capuchin
Science Expert
Capuchin is offline 		 
Join Date: Oct 2006
Location: UK
Posts: 4,588
Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.
Send a message via MSN to Capuchin Call Capuchin via Skype™
Multi line cells in excel
Hey guys, any idea how to have multiple lines in a single cell in excel?

I'm trying to make my table look a little neater, but it makes some of my comments overlap into following cells - is there any way to make the rows higher and to have 2 lines of text in a cell?

Thanks in advance - Cap

Reply With Quote
 
     

Answers
 
 
Old Jan 2, 2007, 12:24 AM   #2  
Curlyben
Administrator
Curlyben is offline
 
Curlyben's Avatar
 
Join Date: Mar 2005
Location: Behind You !!
Posts: 5,785
Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.
Call Curlyben via Skype™
Erm how about a simple WRAP TEXT

Comments on this post
Capuchin agrees: Possibly the most useful answer on AMHD. Thank you so much. I wish I could repay you properly.
  Reply With Quote
 
     
 
 
Old Jan 2, 2007, 12:25 AM   #3  
Capuchin
Science Expert
Capuchin is offline
 
Capuchin's Avatar
 
Join Date: Oct 2006
Location: UK
Posts: 4,588
Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.Capuchin See this member's comment history on his/her Profile page.
Call Capuchin via Skype™ Send a message via MSN to Capuchin
Where's that button?

Edit - Found it. Rep++
  Reply With Quote
 
     
 
 
Old Jan 2, 2007, 12:27 AM   #4  
Curlyben
Administrator
Curlyben is offline
 
Curlyben's Avatar
 
Join Date: Mar 2005
Location: Behind You !!
Posts: 5,785
Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.Curlyben See this member's comment history on his/her Profile page.
Call Curlyben via Skype™
RIGHT click the cell > Format Cells > Aligment Tab > Text Control near the bottom
  Reply With Quote
 
     
 
 
Old Jan 2, 2007, 06:22 AM   #5  
ScottGem
Computer Expert
ScottGem is offline
 
ScottGem's Avatar
 
Join Date: Jan 2003
Location: LI, NY - USA
Posts: 21,899
ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.
Pay to call ScottGem for advice ($.75/min)
Call ScottGem via Skype™
You can FORCE a linebreak using Alt+enter

Comments on this post
Capuchin agrees: Good Tip.
  Reply With Quote
 
     
Answer this Question Ask about Spreadsheets

« Previous Question | Next Question »

Question Tools Search this Question
Search this Question:

Advanced Search
Display Modes
Linear Mode Linear Mode

 
Similar Sponsors

Similar Questions
Question Asker Topic Answers Last Post
calcium and cells GBSA Biology 1 Jul 8, 2007 11:37 PM
Sleeper Cells bhayne Television 1 Nov 1, 2006 02:15 PM
Excel line chart with "confidence band" JohnnyCav Spreadsheets 0 Oct 25, 2006 09:12 PM
clicking differnet cells and it selecting all cells mlister Spreadsheets 2 Aug 4, 2006 09:23 PM
excel line chart - no lines Shawnee Spreadsheets 5 Feb 6, 2006 07:30 PM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 02:34 PM.

Content Relevant URLs by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.