-1

This is the key combination I would use in MS Excel to jump to the last contiguous cell in the current column. Similarly, cmd+shift+down would perform the same jump while selecting all the cells along the way. Is there any way to do the same on Numbers through the keyboard? I am on a MacBook and don't have a numeric keypad on the extreme right of my keyboard.

P.S. Please DO NOT suggest links. I need a solution that works. So please be sure you have SUCCESSFULLY tried it YOURSELF before you post a solution here. The following link, by the way, is full of anomalies and discrepancies and obviously didn't help:

http://support.apple.com/kb/PH14849?viewlocale=en_US&locale=en_US

As an illustration of this source' unreliability, check out this example:

Move to the bottom of the current text area: Command+Down Arrow

Move to the end of the spreadsheet: Command+Down Arrow

Two different functions for the same key combination? Not very reliable, is it?

  • Good q. Have you explored: apple.com/fi/support/numbers/shortcuts – njboot May 19 '14 at 4:27
  • Did you? Coz I did (again) and didn't find any reference to this situation there. – TheLearner May 19 '14 at 4:32
  • I scrolled through it, but couldn't find an answer for you, which is why I didn't post one. I just referenced it as a helpful link. Regards. – njboot May 19 '14 at 4:33
  • Well if you already did scroll through it and didn't find my answer, you already know that link isn't helpful in this context, don't you? But thanks anyway. :) – TheLearner May 19 '14 at 4:35
  • 1
    I browsed through it. Added the link because I thought it may be helpful. As I said, I don't know the answer, but it's a good question. Have a drink...cheers. – njboot May 19 '14 at 4:50
4
+50

This is currently not possible. Numbers provides no method for moving between contiguous cells, whether that be through a menu option or through a keyboard shortcut.

Excel lets you move between contiguous cells as the spreadsheet extends beyond your data so scrolling to the actual end of the sheet would serve no purpose. Conversely, Numbers works with limited tables, so you are expected to limit the end of the table to the end of your data and move through the data in this manner.

You can provide feedback to Apple regarding this at the following page:

  • 1
    Thank you...finally a concrete answer! Though not what I was hoping to hear. This sure is a massive bottleneck for those who are too keyboard dependent. Thanks for your answer again. – TheLearner Jun 1 '14 at 9:29
1

While not editing the cell press cmd ⌘ key along with an arrow key to jump to column or row start, end... Thus adding the shift ⇧ key will select the cells between.

Note that shift ⇧ + click will select everything between as well. (the only way to achieve what you want with iWork 09')

If you edit the cell the cmd ⌘ key along with up or down arrow will jump to respectively start and end of the cell.

The alt ⌥ along with an arrow key will insert a column or a row.

Use fn to scroll the page although in edit mode ctrl will do the same.

This works with Numbers 3.2 (iWork 13') I therefore suppose you use iWork 09' and I thank you for at last having found a positive thing about the latest version !

*Remember you may change some (those accessible from the menubar) keyboard shortcuts inside System Preferences > Keyboard > Shortcuts tab for other behavior you should consider getting http://www.keyboardmaestro.com/ *

  • If you want to change keyboard shortcuts, you can do it with Keyboard preferences: navigate to shortcuts, then select App Shortcuts and add shortcut you want. – Eir Nym Jun 1 '14 at 8:37
  • 1
    Well I am using 3.2 (latest) and command+down combination doesn't do what I need it to do. It's not the equivalent of command+down on MS Excel. It jumps to the last cell in the spreadsheet whereas I need it to jump to the last "contiguous" cell in the spreadsheet (that's the Excel behavior). This is something I have already mentioned in the question; that's the whole point of looking for an equivalent of Excel's cmd+arrow functionality in Numbers. – TheLearner Jun 1 '14 at 9:27
  • I believe there's something I'm not getting... With Excel 2011 and Numbers 3 I press return I go to the cell underneath (to go up I also press shift ⇧). When I press tab I go to the closest cell on the right (the opposite adding shift ⇧). If I respectively add cmd ⌘ I go to the last row or column (which is not working with the previous versions of Numbers)... – llange Jun 1 '14 at 17:29
  • Ok finally got it just tell "contiguous cell containing data" ! – llange Jun 1 '14 at 17:35
  • thats what it means. – TheLearner Jun 1 '14 at 17:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .