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
 
Thread Tools 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,740
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  
Administrator
Curlyben is offline
 
Curlyben's Avatar
 
Join Date: Mar 2005
Location: Behind You !!
Posts: 6,582
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.
Pay to call Curlyben for advice ($1/min)
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  
Science Expert
Capuchin is offline
 
Capuchin's Avatar
 
Join Date: Oct 2006
Location: UK
Posts: 4,740
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  
Administrator
Curlyben is offline
 
Curlyben's Avatar
 
Join Date: Mar 2005
Location: Behind You !!
Posts: 6,582
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.
Pay to call Curlyben for advice ($1/min)
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  
Computer Expert
ScottGem is online now
 
ScottGem's Avatar
 
Join Date: Jan 2003
Location: LI, NY - USA
Posts: 23,998
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 Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

 
Similar Sponsors

Similar Threads
Question Asker Forum 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 11:20 AM.