editing in cell

i just switched from pc/excel to mac/Numbers, and i can't figure out how to (a) change my preferences so that the cursor doesn't move down a cell after i press return and (b) edit in cell. in excel and lotus, you pressed f2 to edit in cell (and to switch between editing in cell and moving the cursor around the sheet); in Numbers i can't find that option.

iMac, Mac OS X (10.5.1)

Posted on Jan 26, 2008 4:42 PM

Reply
3 replies

Jan 26, 2008 7:11 PM in response to dre1973

Hi dre1973,
Welcome to Numbers forum.

1. Regarding the cursor movement: Enter or Return moves it down Tab moves it to the right. As in other programs there isn't any way to make a change.
2. In cell editing: double click on the cell.

If those answers are not satisfactory please contact Numbers development team: At the top of the screen to the right of the blue apple click Numbers > Provide Numbers Feedback. Your request goes directly to the Numbers team. Then hope your request is implemented in the next version of Numbers.

Because of different design philosophies MS and Apple do things differently, neither is incorrect.

Sincerely,

RicD

Jan 28, 2008 9:59 AM in response to dre1973

dre,

There is some amount of control that you have over the result of hitting the Return key. You adjust this in the Inspector > Table > Table Options (way down at the bottom of the pane.) There you will find a check box option titled: "Return Key Moves to Next Cell." If you uncheck this option, hitting the Return key will result in placing a line-feed in the cell text, rather than moving the cell focus down.

Jerry

Feb 4, 2008 3:32 PM in response to dre1973

I know what you mean. You don't want to take your hands off the keyboard while you are editing a cell. Suppose you have a formula =SUM(B1:B3) and you just want to edit one or both of the references. You can press Option-Enter to start editing the cell (or Alt-Enter in PC speak). But then to replace the cell reference, in Excel you would press F2 and it releases the keyboard into a 'cell selection mode' which only finishes when you press Enter. In Numbers, you have to pick up the mouse and select the cell or cells, or you have to type them in literally 'B2:B5' for example. I miss this feature a lot, too.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

editing in cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.