6

I have just purchased my first Mac and am having problems with Numbers. I want to select the next cell in a given direction that is non-empty (or jump to the end of a contiguous chunk of cells that are non-empty). In Excel (on Windows, anyway), you can do this with Ctrl + An Arrow Key. For example, in this little spreadsheet:

    A    B    C    D
1   x              x
2        x         x
3   x    x    x
4   x    x    x    x

if you selected cell A1 and pressed Ctrl+, you would jump to A3. If, instead, you pressed Ctrl+, you would have gone to D1. If you were in A3 when you pressed Ctrl+, it would take you to C3.

On my Mac, Control + Option + Arrow Key does what I want in Google Spreadsheets. I tried that combination in Numbers, but it adds a row or column, instead.

Surely there is a way to do this in Numbers; I just can't figure it out. Are there keyboard shortcuts like this in Numbers? If not, is there a way to map a keyboard shortcut to this functionality?

  • Did you ever figure it out? – Collin Anderson Nov 7 '17 at 0:46
  • 2
    Nope. I've actually just gone back to using Excel; there were too many features there that I missed. – Ed Cottrell Nov 7 '17 at 1:42
  • 1
    @EdCottrell, yep, sometimes Numbers feels like demoware at times, especially compared to Excel. – jxramos Jan 16 at 21:34

You must log in to answer this question.

Browse other questions tagged .