Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Mary H

macrumors regular
Original poster
Oct 11, 2007
136
2
Canada
I recently updated to Maverick and then updated my iWork programs. One of the things I am trying to figure out how to do is to edit the content of a cell in Numbers. So far all I have been able to figure out is how to delete and re-enter all of the data. I am sometimes just wanting to correct a spelling or number error not re-enter all of the information. It can be very frustrating especially if there is a lot of data in the cell.

Thanks,
mary
 
Double clicking doesn't allow me to edit the content, only replace it completely.

For clarification: Say I put in the cell "The location of the stores are in Winnipig, Steinback and Morrow" - Winnipig, Steinback and Morrow are spelling errors and should be Winnipeg, Steinbach and Morris. When I double click, the only option I have is to retype the entire content not just correcting the typos.
 
Double clicking should put the caret in the cell and then you can use the cursor keys to move it around and backspace/delete/select text and edit.

Screen%20Shot%202014-10-24%20at%2017.01.40.png


A second double click after the first will select the current word under the mouse pointer.

Screen%20Shot%202014-10-24%20at%2017.02.21.png


If you initially do a triple click it will select the whole contents of the cell. Could this be what you are seeing?

Screen%20Shot%202014-10-24%20at%2017.04.04.png


Simply typing will replace all selected text.

However, at this point you can still use the cursor keys to bring back the caret, or single click to deselect all the text and edit the text however you want.
 
Hopefully then once I update to Yosemite, the error that is not allowing me to do that will be fixed with the new updates to the apps.

Thanks
mary
 
With the cell highlighted hold Option and press Enter. You will now be in editing mode, retaining the original cell contents.

Hope that helped. :)
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.