eCharcha.Com   Support eCharcha.Com. Click on sponsor ad to shop online!

Advertise Here

Go Back   eCharcha.Com > Science and Technology > How to

Notices

How to Stuck for an answer to "How to do .."?

Reply
 
Thread Tools Display Modes
  #1  
Old April 14th, 2004, 01:20 AM
2gud's Avatar
2gud 2gud is offline
We change, values don't
 
Join Date: Nov 2003
Posts: 4,037
2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute
How to enter a newline within a Excel cell?

I have a workaround which I use to enter a newline within a cell in a excel sheet.. Is there a more easier and direct way to do this?
Reply With Quote
  #2  
Old April 14th, 2004, 01:25 AM
2gud's Avatar
2gud 2gud is offline
We change, values don't
 
Join Date: Nov 2003
Posts: 4,037
2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute2gud has a reputation beyond repute
In several cases we need to write inside an Excel cell using multiple lines. In Excel, we have to fill the rest of the line with spaces so that the line 'folds' inside the cell. But the direct way to do this...

I googled around and got this solution

use ALT+Enter
Reply With Quote
  #3  
Old May 14th, 2012, 11:09 AM
Dead On Arrival's Avatar
Dead On Arrival Dead On Arrival is offline
Love Saneless
 
Join Date: Sep 2011
Posts: 1,490
Dead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

What's this thread Man!! I always see some guest viewing it.. Always!!!
Is this such an important question???!!
Reply With Quote
  #4  
Old May 15th, 2012, 07:18 AM
sanjayt's Avatar
sanjayt sanjayt is offline
Senior eCharchan
 
Join Date: Jul 2011
Location: Cygnus X-1
Posts: 2,069
sanjayt has a reputation beyond reputesanjayt has a reputation beyond reputesanjayt has a reputation beyond reputesanjayt has a reputation beyond reputesanjayt has a reputation beyond reputesanjayt has a reputation beyond reputesanjayt has a reputation beyond reputesanjayt has a reputation beyond reputesanjayt has a reputation beyond reputesanjayt has a reputation beyond reputesanjayt has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Quote:
Originally Posted by Dead On Arrival View Post
What's this thread Man!! I always see some guest viewing it.. Always!!!
Is this such an important question???!!
It be a trick question, Behena.

Embedded into that question are some essential truths about the human condition, revealed only to the chosen few who can unravel the code.

You, clearly, are not one of the chosen ones.

I'm sorry.
Reply With Quote
  #5  
Old May 15th, 2012, 07:32 AM
phenom27's Avatar
phenom27 phenom27 is offline
Junior eCharchan
 
Join Date: Apr 2010
Posts: 128
phenom27 has a reputation beyond reputephenom27 has a reputation beyond reputephenom27 has a reputation beyond reputephenom27 has a reputation beyond reputephenom27 has a reputation beyond reputephenom27 has a reputation beyond reputephenom27 has a reputation beyond reputephenom27 has a reputation beyond reputephenom27 has a reputation beyond reputephenom27 has a reputation beyond reputephenom27 has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Quote:
2gud How to enter a newline within a Excel cell?
I have a workaround which I use to enter a newline within a cell in a excel sheet.. Is there a more easier and direct way to do this?
I dont know how seriously you brought up this question, but I have been wondering abt the same since years. and then I found this neat trick

Keep pressing space it goes on to the next line just as if you were to press enter Hope it helped
Reply With Quote
  #6  
Old May 15th, 2012, 09:13 AM
kkkk kkkk is offline
Senior eCharchan
 
Join Date: Sep 2008
Posts: 4,781
kkkk has a reputation beyond reputekkkk has a reputation beyond reputekkkk has a reputation beyond reputekkkk has a reputation beyond reputekkkk has a reputation beyond reputekkkk has a reputation beyond reputekkkk has a reputation beyond reputekkkk has a reputation beyond reputekkkk has a reputation beyond reputekkkk has a reputation beyond reputekkkk has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Quote:
Originally Posted by Dead On Arrival View Post
What's this thread Man!! I always see some guest viewing it.. Always!!!
Is this such an important question???!!

how do you know who is viewing what thread?
Reply With Quote
  #7  
Old May 15th, 2012, 09:29 AM
Dead On Arrival's Avatar
Dead On Arrival Dead On Arrival is offline
Love Saneless
 
Join Date: Sep 2011
Posts: 1,490
Dead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Quote:
Originally Posted by kkkk View Post
how do you know who is viewing what thread?
Who's online!
Reply With Quote
  #8  
Old May 15th, 2012, 09:39 AM
sunnykode's Avatar
sunnykode sunnykode is offline
Life is BEAUtiful
 
Join Date: Jan 2006
Posts: 5,520
sunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Many search for Excel help or something like that. That might bring them to this page.
__________________
Life is fleeting as the butterfly, beautiful yet transient.

Reply With Quote
  #9  
Old May 15th, 2012, 09:42 AM
Dead On Arrival's Avatar
Dead On Arrival Dead On Arrival is offline
Love Saneless
 
Join Date: Sep 2011
Posts: 1,490
Dead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond reputeDead On Arrival has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Quote:
Originally Posted by sanjayt View Post
It be a trick question, Behena.

Embedded into that question are some essential truths about the human condition, revealed only to the chosen few who can unravel the code.

You, clearly, are not one of the chosen ones.

I'm sorry.
Are you saying.. am stupid?!
Reply With Quote
  #10  
Old May 15th, 2012, 09:50 AM
Premi's Avatar
Premi Premi is offline
Senior eCharchan
 
Join Date: Feb 2009
Posts: 11,761
Premi has a reputation beyond reputePremi has a reputation beyond reputePremi has a reputation beyond reputePremi has a reputation beyond reputePremi has a reputation beyond reputePremi has a reputation beyond reputePremi has a reputation beyond reputePremi has a reputation beyond reputePremi has a reputation beyond reputePremi has a reputation beyond reputePremi has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Quote:
Originally Posted by Dead On Arrival View Post
Are you saying.. am stupid?!

shit.... she read the fine prints.

__________________
Reply With Quote
  #11  
Old May 16th, 2012, 06:04 AM
krantikari's Avatar
krantikari krantikari is offline
Senior eCharchan
 
Join Date: Jul 2000
Posts: 4,612
krantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

I am surprised nobody tried "Alt + Enter" yet. If it solves your pain in the astirx, give me a crown. Reps are useless these days anyways !
__________________
Ab ki baar Modi sarkar !
Reply With Quote
  #12  
Old May 16th, 2012, 06:07 AM
krantikari's Avatar
krantikari krantikari is offline
Senior eCharchan
 
Join Date: Jul 2000
Posts: 4,612
krantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond reputekrantikari has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Ow! I noticed the thread starter already answered this in a post. Never mind, go launch a rocket.
__________________
Ab ki baar Modi sarkar !
Reply With Quote
  #13  
Old May 16th, 2012, 07:44 AM
swami's Avatar
swami swami is offline
Senior eCharchan
 
Join Date: Mar 2009
Posts: 11,216
swami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

So you are with me against Charchila
Quote:
Originally Posted by krantikari View Post
I am surprised nobody tried "Alt + Enter" yet. If it solves your pain in the astirx, give me a crown. Reps are useless these days anyways !
__________________
Laws to Bones,I break them all
Reply With Quote
  #14  
Old May 16th, 2012, 10:44 AM
sunnykode's Avatar
sunnykode sunnykode is offline
Life is BEAUtiful
 
Join Date: Jan 2006
Posts: 5,520
sunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond reputesunnykode has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Quote:
Originally Posted by swami View Post
So you are with me against Charchila
we are all with you against Charchila
Charchila hai hai
__________________
Life is fleeting as the butterfly, beautiful yet transient.

Reply With Quote
  #15  
Old May 16th, 2012, 09:42 PM
AmthaLal's Avatar
AmthaLal AmthaLal is offline
Chaiman Of the Board.
 
Join Date: May 2004
Location: .
Posts: 10,351
AmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond repute
Re: How to enter a newline within a Excel cell?

Quote:
Originally Posted by swami View Post
So you are with me against Charchila
Quote:
Originally Posted by sunnykode View Post
we are all with you against Charchila
Charchila hai hai


Tum log aage badho.
Mai tumhaare pichche hu.


















































Pichche se gaand pe laat maarne ke liye.
Penchow, mere bhatije kee hai hai bulaawte ho. Kamino.
__________________
Sansaar chhe.....Chalyaa kare..........
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Subbu SoapBox 2 July 28th, 2010 06:10 PM
Excel help... Rakhi How to 13 January 22nd, 2010 05:17 AM
Excel Help chitrala Computing 2 August 29th, 2009 07:41 AM
forecsting in excel? loverboy260 SoapBox 1 February 10th, 2003 09:29 AM
Cell-to-cell incoming calls to be free aalia Taaza Khabar - Current news 21 January 28th, 2003 07:37 PM


All times are GMT -7. The time now is 04:30 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Site Copyright © eCharcha.Com 2000-2012.