8

I have just purchased my first Mac and am having problems with Numbers. I want to jump to 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. – elixenide Nov 7 '17 at 1:42
  • 1
    @EdCottrell, yep, sometimes Numbers feels like demoware at times, especially compared to Excel. – jxramos Jan 16 '19 at 21:34
1

use this AppleScript ▼

--finds next next blank (or non-blank) cell in column
--select starting cell, and run
property searchFor : missing value
tell application "Numbers"
  set t to front document's active sheet's first table whose selection range's class is range
  tell t's selection range
  set currentRow to its first cell's row's address
  set searchCol to its first cell's column's address
  end tell
  tell t's column searchCol
  repeat with i from currentRow + 1 to count cells
  if cell i's value is searchFor then --add not if want to find non-blank
  set t's selection range to cell i
  return
  end if
  end repeat
  end tell
end tell

from →
how do I move/find the next non empty cel… - Apple Community_2019-09-25

  • This is not an answer. I’m not asking how to navigate within a sheet programmatically; I’m asking whether there is a keyboard shortcut built-in that does this. – elixenide Sep 25 '19 at 3:16
  • No shortcut but this script for now. – Alice Shi Sep 25 '19 at 3:21
  • But, you can use some automation software such as Automator or Keyboard Maestro to create a shortcut for that. – Alice Shi Sep 25 '19 at 3:28
  • I understand I could do that, but that's still not what I'm asking for. – elixenide Sep 25 '19 at 3:30
  • Welcome to Ask Different and thank you for your answer. :) Unfortunately, short answers such as this don't really provide enough detail or context to help many users. I know you've provided a link, but this isn't very helpful as it may no longer work in future. If possible, it'd be good if you could add some more info on how a user would actually go about using the script you're referencing. This will make your answer more self-contained and help preserve it for other users in future. – Monomeeth Sep 25 '19 at 4:27

You must log in to answer this question.

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