0

The official docs say to use Option-Up/Down

enter image description here

I tried that - as well as Option-Left/Right and Command-(any arrow keys) and they all do different things than the page right/left.

So is there any way to get this functionality short of point and click?

Update By playing around a bit more an answer was discovered: the Command-Left|Right Arrow will page left/right to the next non-empty cell. I had been seeing it page to the beginning/end since the particular rows had few entries.

Hold on .. So the behavior is that the `Command-Left|Right Arrow will move to the next non-empty cell if there were other intervening empty cells. So in the case of a row with all entries filled - e.g. the Header Row - a single invocation puts you at beginning/end of the entire row: so in that case it behaves like Row Home/Row End.

This is not acceptable behavior: is there any workaround?

enter image description here

|improve this question
  • Just to be sure, are you pressing the fn key along with the combo as per your screen shot? – bjbk Jun 18 '17 at 20:44
  • @bjbk I tried with fn as well .. no difference. in any case that would be a problem given I use an external keyboard often as not. – javadba Jun 18 '17 at 20:47
  • Ok, one more question: which version of Excel? – bjbk Jun 18 '17 at 20:49
  • @bjbk updated OP – javadba Jun 18 '17 at 20:51
  • Thanks. I can't seem to duplicate your issue, sorry. FN + OPTION + UP ARROW / DOWN ARROW work as expected on both external and internal keyboard. Your screenshot does not say to use right of left arrow unless I'm missing something. Hope you find a solution. Cheers! – bjbk Jun 18 '17 at 21:03
1

Although it seems counter intuitive not to use the left/right arrows, (that is a subject for giving Microsoft some feedback) using the following key combinations work for Excel 15.xx for Mac:

Using Built-in MacBook Keyboard:

Page Right: fn+⌥ option+↓ down arrow
Page Left: fn+⌥ option+↑ up arrow

Using External Apple Wired Keyboard:

Page Right: ⌥ option+page down
Page Left: ⌥ option+page up

As noted in the OP's screenshot.

|improve this answer

You must log in to answer this question.

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