Skip navigation

Press "Return"

2497 Views 7 Replies Latest reply: Dec 30, 2011 8:36 AM by Anthony Curcio RSS
Anthony Curcio Level 1 Level 1 (25 points)
Currently Being Moderated
Apr 5, 2011 2:02 PM
I know this is simplistic but when I enter a value in a Numbers 09 spreadsheet and press "Return" the cursor moves to the next box. Can I set it so it stays in the same entry?
Macbook Air, Mac OS X (10.6.7)
  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Apr 5, 2011 7:07 PM (in response to Anthony Curcio)
    Anthony Curcio wrote:
    I know this is simplistic but when I enter a value in a Numbers 09 spreadsheet and press "Return" the cursor moves to the next box. Can I set it so it stays in the same entry?


    Inspector > Table Inspector > uncheck the box at the bottom of the Inspector window.

    Regards,
    Barry
  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Apr 6, 2011 6:59 AM (in response to Anthony Curcio)
    On my Mac with the setting unchecked, the Return key does not move out of the cell. The Enter key moves down one row, though. I don't have a Macbook Air to test with.

    On my Mac with the setting checked, the Return key moves down one cell or down one row and left to the first column in which I started entering data. The Enter key moves down one row in the same column.

    With the setting unchecked, the Return key puts a carriage return/line feed in the cell. It does not "enter" the data. In other words, you cannot type in a number then press return then type in a different number and press return, etc., you'll end up with a bunch of numbers on multiple lines in the same cell. Command Return is the command to do this task and it works the same regardless of the setting.

    Message was edited by: Badunit
    Mac Pro 2008/Intel iMac 2009/Macbook Pro, Mac OS X (10.6.6)
  • uselessSABOTAGE Level 4 Level 4 (3,680 points)
    Currently Being Moderated
    Dec 29, 2011 11:26 AM (in response to Anthony Curcio)

    I have a MBP and I tried it and it worked.

  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Dec 29, 2011 7:28 PM (in response to Anthony Curcio)

    I assume you first tried this a while ago and are just now getting back to responding, 8 months later.  Now I understand your question.

     

    Use Command-Return.  But after entering the data, make sure you only do it once. If you do it twice it will select the table.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.