Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Problems in Excel for No Return Spacing

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 04-11-2010
Member
 
Join Date: Oct 2010
Posts: 39
Problems in Excel for No Return Spacing
  

I have been using the Excel since long time, but recently having the problems of the no return spacing. I have no idea what is basically called the no return spacing. This is causing me a problem for using the Excel properly and the error is arising continuously with no working of the space bar properly. I had also tried with the Alt+Return key but the problem is that it gets in to the next cell. Please suggest me the solution for this as this is causing me a problems for all the work that I am performing in the Excel.

Reply With Quote
  #2  
Old 04-11-2010
Member
 
Join Date: May 2008
Posts: 3,308
Re: Problems in Excel for No Return Spacing

For removing the problems for the no return spacing you can apply the format cell option that will help first to format the cell that will help you in the case of no return spacing. So whenever you press the Alt+return key the cursor will go to the corresponding cell and not or the next cell. to format the cell in the Excel sheet you got to right click the format cell option and then make the corresponding cell.
Reply With Quote
  #3  
Old 04-11-2010
Member
 
Join Date: Jan 2008
Posts: 3,755
Re: Problems in Excel for No Return Spacing

The other option for solving this problem is by using the Control+Option+Return, this happens when you are trying to insert the new line character. The problem is that whenever you try to enter the next key the cursor jumps to next cell, with out going to corresponding cell and causing the problem of the return spacing.
Reply With Quote
  #4  
Old 04-11-2010
Member
 
Join Date: Mar 2009
Posts: 1,585
Re: Problems in Excel for No Return Spacing

I just got solved the return spacing but the problem is that I wanted to replace the space with the carriage return and specify that how it can be performed. The problem is that whenever I try to replace the carriage return space something else happens. The return spacing in Excel can be solved easily but the replacing of the space to carriage return is causing me a lot of problem. If possible please suggest me the solution for the replacement of the space to the carriage return.
Reply With Quote
  #5  
Old 04-11-2010
Member
 
Join Date: Apr 2008
Posts: 4,092
Re: Problems in Excel for No Return Spacing

For the problem that you have said regarding the space to carriage return can be done in the following steps:
  • Go to the Edit menu.
  • Then from that go to the Replace option.
  • In the Replace option type space with what you wanted it to replace it with.
  • Then after that type CNTRL-j in the replace menu and type with waht you wanted to replace in that replace option.
It should work properly and then your problem of carriage return will be solved without any further queries.
__________________
Ram requirement for various OS
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Problems in Excel for No Return Spacing"
Thread Thread Starter Forum Replies Last Post
Finding replace text or symbol with carriage return in Excel DEvOTeEL MS Office Support 5 23-02-2012 11:19 AM
Need help to adjust line spacing in a Cell of Excel Garsen's MS Office Support 2 16-02-2012 06:11 PM
Microsoft Excel 2007 Character Spacing Sachi Trivedi MS Office Support 4 24-01-2012 01:21 PM
Return To Castle Wolfenstein Enemy Territory server problems Nauset Video Games 5 08-12-2010 09:21 AM
Excel Look up one value and return multiple corresponding values mellisahi Windows Software 5 27-10-2009 12:40 AM


All times are GMT +5.5. The time now is 11:26 AM.