Results 1 to 5 of 5

Thread: Problems in Excel for No Return Spacing

  1. #1
    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.

  2. #2
    Join Date
    May 2008
    Posts
    3,319

    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.

  3. #3
    Join Date
    Jan 2008
    Posts
    3,758

    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.

  4. #4
    Join Date
    Mar 2009
    Posts
    1,591

    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.

  5. #5
    Join Date
    Apr 2008
    Posts
    4,089

    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.

Similar Threads

  1. Finding replace text or symbol with carriage return in Excel
    By DEvOTeEL in forum MS Office Support
    Replies: 5
    Last Post: 23-02-2012, 11:19 AM
  2. Need help to adjust line spacing in a Cell of Excel
    By Garsen's in forum MS Office Support
    Replies: 2
    Last Post: 16-02-2012, 06:11 PM
  3. Microsoft Excel 2007 Character Spacing
    By Sachi Trivedi in forum MS Office Support
    Replies: 4
    Last Post: 24-01-2012, 01:21 PM
  4. Replies: 5
    Last Post: 08-12-2010, 09:21 AM
  5. Replies: 5
    Last Post: 27-10-2009, 12:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •