Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Numbers: edit existing data without using the mouse Apps
Here's how to edit a cell in Numbers that already has data in it, but without moving your fingers from the keyboard to the mouse.

Select the cell, then press Option+Return. The blinking insertion point should be placed at the end of the cell's text.

I don't know if Excel has this feature, but I've wanted something like this for years!

[crarko adds: I tested this, and it works as described. It's kind of an odd key combination, but it works. I tried it in an old version of Excel, and Option+Return simply moves down a cell in it.]
    •    
  • Currently 3.43 / 5
  You rated: 2 / 5 (7 votes cast)
 
[11,014 views]  

Numbers: edit existing data without using the mouse | 12 comments | Create New Account
Click here to return to the 'Numbers: edit existing data without using the mouse' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Numbers: edit existing data without using the mouse
Authored by: odaiwai on Feb 25, '11 07:54:20AM

If you're using Excel for Mac, then ctrl-U will edit the current selected cell. On Excel for Windows, F2 will do this.

If you have a bunch of cells selected, and you are editing the text in one cell, then ctrl-Enter will copy your text to all of the selected cells. This will work with formulas too, and can be an easy way of filling a table with a formula without changing the formatting.



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: usovalx on Feb 25, '11 08:01:46AM

Excel for windows uses F2 for it.



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: berliboy on Feb 25, '11 08:36:44AM

You can do that in Excel by CTRL + U



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: dschneiderch on Feb 25, '11 09:05:10AM

Coudn't find anything similar to work in Excel 2011 :(



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: teetee on Feb 25, '11 09:23:06AM

In windows version of excel, you'd hit the F2 key



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: jsturtridge on Feb 25, '11 09:37:32AM

In Excel - to edit a cell, you use Ctrl + U



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: wallybear on Feb 25, '11 09:44:24AM

Remembers me vaguely the good old AppleWorks shortcut that triggered cell editing mode using option-arrow down.



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: NaOH-Lye on Feb 25, '11 09:57:19AM

It may be different in newer versions of Excel, but the shortcut as of Excel 2004 was Control-U.



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: auntchilada on Feb 25, '11 10:00:27AM

control-U (^U) will put excel in cell edit mode.



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: rhowell on Feb 25, '11 11:36:28AM

F2 on Windows, if you care.



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: gstahara on Feb 26, '11 07:19:13PM

Yes, in Excel Control-U has worked "forever". Still works the same in Office 2011. I've been using that for as long as I can remember using Excel ;) Oddly, the shortcut does not seem to appear anywhere, either in the menus, or even when looking under Tools/Customize Keyboard. But it is listed in Excel's help section under "Working in cells or the Formula bar".

Cheers!



[ Reply to This | # ]
Numbers: edit existing data without using the mouse
Authored by: hankk on Feb 28, '11 07:11:10AM

Note that the original hint works in all of the iWork apps: Pages, Numbers, and Keynote. (In Pages and Keynote, you must be in a table, of course.)

And also, Option-Enter does another handy thing: inserts a carriage return within a cell. Again, this works in tables in all three apps.



[ Reply to This | # ]