Another way to edit cells in Numbers is to move to the cell you want to change and hit Option+Enter. This will put your cursor in the cell for editing. You can navigate to any point in the cell by using the arrow keys or arrow keys + the option key. Once I discovered this, working with Numbers got a whole lot more manageable.
-Greg On Feb 23, 2012, at 6:39 PM, Tim Kilburn wrote: > I have not tried Tables in eons so I'm not sure if it will work the same as > in for me in Numbers but, in Numbers, if I Interact with the Formula entry > field, then arrow (just arrow, no VO keys) right. VO will announce as it > goes past characters and you can edit along the way. The only limitation is > that cell references are imbedded so you can't change the reference from, > let's say, c2 to c5 by simply deleting the 2 and replacing it with 5. What > you need to do is hit the Backspace twice and re-enter the entire cell > reference. Note that it's just the specific cell reference, not the entire > formula. So, editing simple text entries within the cell is straight forward > as long as you do it from within the Formula Entry field. Actually, this is > standard practice even for sighted users. > > Later... > > On 2012-02-23, at 3:34 PM, Gigi wrote: > >> Y hi guys >> I have had some success with attitude on the end of a sale on what I do to >> make sure that I don't erase the whole thing, is to press command right >> arrow on my MacBook Pro, and then I can backspace out on the end and delete >> text-only in. A few instances have I been able to successfully edit in the >> middle of a sale in numbers >> Regards >> Gigi >> >> Sent from my iPhone >> >> On Feb 23, 2012, at 1:47 PM, Jürgen Fleger <apple-engl...@fleger.net> wrote: >> >>> OK, that's interesting. I thought you might do it this way. So it is not >>> possible to change just a part of the content of a cell. You have to change >>> the whole content. >>> I opened an excel file with several sheets in Tables and tried to switch >>> between the sheets by pressing CMD + Option + arrow right or left. It >>> didn't work. Tables was always busy. Do you have experiences with switching >>> sheets in Tables? Did it work for you? >>> >>> Jürgen >>> Am 23.02.2012 um 17:51 schrieb Bejarano, Rafael P.: >>> >>>> When I want to change the contents of a particular cell, I position the >>>> cursor on the data-entry field. Then, I arrow over to the cell that I >>>> want to edit. Next, I press the delete (back-space) key to delete the >>>> cell's contents. Finally, I type in the new information that I wish to >>>> store in that cell. >>>> ________________________________________ >>>> From: macvisionaries@googlegroups.com [macvisionaries@googlegroups.com] On >>>> Behalf Of Jürgen Fleger [apple-engl...@fleger.net] >>>> Sent: Thursday, February 23, 2012 12:47 AM >>>> To: Mac Visionaries Visionaries >>>> Subject: Tables [was:] Re: numbers >>>> >>>> No Rafael, that's not what I asked for. I know how to enter data. But I >>>> want to change existing data in the cells. >>>> Imagine you have an address of a friend in a cell. His telephone number >>>> changes and you want to change just the number. How to do this in Tables? >>>> I don't see this important possibility accessible with VoiceOver. >>>> Again: how to change specific data in a cell? >>>> Not entering data in an empty cell. That's easy. >>>> Hopefully my question is clearer now. >>>> Jürgen >>>> Am 22.02.2012 um 16:26 schrieb Bejarano, Rafael P.: >>>> >>>>> Tables has a data entry field. That is where data are entered into each >>>>> cell. If you cannot find the data entry field on your own, you may >>>>> benefit from sighted help to find it the first time. Place your cursor >>>>> in the field, making sure VO is not locked. You can then type or paste >>>>> in data and formulae. If you type in the data entry field, press the >>>>> return (enter) key to get the data into the cell. The arrow keys are >>>>> used to move between c >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To post to this group, send email to macvisionaries@googlegroups.com. >> To unsubscribe from this group, send email to >> macvisionaries+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/macvisionaries?hl=en. >> > > Tim Kilburn > Fort McMurray, AB Canada > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To post to this group, send email to macvisionaries@googlegroups.com. > To unsubscribe from this group, send email to > macvisionaries+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/macvisionaries?hl=en. > -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To post to this group, send email to macvisionaries@googlegroups.com. To unsubscribe from this group, send email to macvisionaries+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/macvisionaries?hl=en.
