Numbers 3.2, any way to edit this keyboard shortcut? It's not convenient to use alt-enter all the time? Such a simple thing to ask, I can't actually believe this app does not have this feature.
MacBook Pro (Retina, Mid 2012), OS X Mavericks (10.9)
hold the option key while pressing the enter key
Have you found this "simple and basic" feature in Excel?
BTW, Numbers is not really suited to be a "database app." It's a spreadsheet. As such, it's good at, well, numbers.🙂 It's not designed to be an environment for entering a lot of multiline text.
SG
Well, yes, modifying keyboard shortcuts is a basic feature of every computer program I ever used. And especially since the previous versions had this feature, it seems to be super annoying to take it off.
I've looked but am having trouble finding a preference or some other setting in Numbers 2 (the previous version) that allows remapping this key.
You can easily modify keyboard shortcuts for Numbers 3 for any menu pick just the way you can for any other OS X application via System Preferences > Keyboard > Shortcuts.
But what you are discussing here is not a keyboard shortcut. It's entering a specific character into text, not executing a command. Remapping your keyboard may do the trick for you. Have you tried?
SG
P.S. We're all just fellow users here. If you wish to communicate with Apple, choose Numbers > Provide Numbers Feedback in your menu.
In Numbers '09, there is an checkbox (under Table Options in the Table pane of the inspector) to have "Return Key moves to next cell". If this is unchecked, I believe the Return key inserts a paragraph return (not a new line; and not the Enter key). No remapping of keys required.
Thanks, Jeff. I remembered something about altering the "moves to next cell" behavior, but couldn't find it in the old interface, probably because I never used it. Option-return does fine for me to get a new line (or paragraph or whatever). I'm think (though I haven't tried it) that temporary key remapping when using Numbers 3 can do the trick for those who are entering a lot of multi-line or multi-paragraph text and feel it's essential just to be able to hit the return button.
SG
First of all, thanks for all help. I'm aware of that you're all users who are trying to help me, and I really appreciate that. And yes, I indeed sent a feedback to apple.
I tried to figure out how to do it with the app you linked here for the remapping but could not understand.
How big and complicated are your tables? Tables in Pages behave the way you want, which probably makes sense in a more text oriented application.
It might be possible to do what you need in Pages, or to use a table in Pages as an "entry form" from which you can Copy/Paste into the Numbers table.
That is an impressive table!
From the part that is visible in your screenshot, it seems you aren't doing calculations. As Jeff suggests, wouldn't Pages be better suited for this kind of data entry?
I don't have Pages but I do use OneNote, which is convenient for tables with a lot of formatted text in them.
SG
I am indeed considering trying OneNote for my next project, but from a quick look, you can't add graphs there (the math plug-in is for windows only). It's keep more and more frustrating. I am a medical student and I really need to find a good, esthetic, functional way to organise my data for the exam. I need a tool that deals well with text, photos, big tables, graphs, links, etc.
Yes, it is frustrating that no one app seems to do it all. For graphs and equations (to place in OneNote or elsewhere as a pdf or image) don't forget Grapher, hidden in plain sight in your Applications > Utilities folder. A short description of what it can do is here.
SG
Break lines on Excel - macbook
to those who CAN NOT use
* Option + ENTER
OR
* Control + option + enter
please use
CONTOL + COMMAND + ENTER
source : http://apple.stackexchange.com/questions/84609/how-to-add-a-line-break-in-a-cell -in-excel-for-mac
I deal with very big tables. Just to give you a clue:
and this is just about 10% of my table. I tried pages before, as you said it is convenient, but for smaller tables.
As I wrote, it's not convenient, I want to use the ENTER key and not the ALT-ENTER key. I use this function a lot and it's bothering to have to use the option key all the time.
Hi idankor,
No, you cannot edit this keystroke.
quinn
Using the enter key to break the line
