Shortcut to move one screen to the right/left in Excel

keyboardms office

The official docs say to use Option-Up/Down

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?

Best Answer

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.

Related Solutions

MacOS – Command+right/left stopped working

I've noticed that certain applications seem to trap the gestures, even when they're no longer active.

The only time I've been able to 100% narrow down something trapping various shortcut keys was with either Apple Remote Desktop (the built in screen sharing functions), or Microsoft Remote Desktop.

Even though I clicked outside of the app and started using something else, something caused notably my ctrl+←/→ to stop working.

I unfortunately do not remember the specific steps I took to resolve the issue. Whether it was explicitly sending focus into the remote connection window, and then (with the mouse only) explicitly out of the window, and onto another app that is not just the Desktop, might have fixed the problem. Otherwise, I may have just closed the window in frustration.

Either way, this issue is one that you may have to do some personal diagnosing to figure out. Check for any running apps that are notably not native (Java, AIR-based, etc.), or have some other form of deep integration (trapping keyboard events and sending them to another computer is pretty deep), that may be causing this issue.

Why isn’t KeyRemap4MacBook’s “PageUp/PageDown to Left/Right (only in iPhoto)” setting working

I posted my question on the KeyRemap4MacBook Google Group, and got a reply from Takayama Fumihiko, the creator of KeyRemap4MacBook. He had me send him the vendor ID and product ID for the device, and sent me back a private.xml file with a new setting that worked. (The pre-defined "PageUp/PageDown to Left/Right (only in iPhoto)" setting only works with the vendor ID and product ID for the Kensington K33374 USB remote.)

Here's the private.xml file contents:

<?xml version="1.0"?>
<root>

  <devicevendordef>
    <vendorname>Tenx_Technology_Inc</vendorname>
    <vendorid>0x1130</vendorid>
  </devicevendordef>

  <deviceproductdef>
    <productname>Tenx_wireless_USB_gadget</productname>
    <productid>0x6604</productid>
  </deviceproductdef>

  <item>
    <name>PageUp/PageDown to Left/Right (only in iPhoto)</name>
    <appendix>(This is effective only with "Tenx_wireless_USB_gadget")</appendix>
    <identifier>private.pageupdown2leftright_iphoto</identifier>
    <only>IPHOTO</only>
    <device_only>DeviceVendor::Tenx_Technology_Inc,DeviceProduct::Tenx_wireless_USB_gadget</device_only>
    <autogen>--KeyToKey-- FROMKEYCODE_PAGEUP,   KeyCode::CURSOR_LEFT</autogen>
    <autogen>--KeyToKey-- FROMKEYCODE_PAGEDOWN, KeyCode::CURSOR_RIGHT</autogen>
  </item>

</root>

See the "How to add new settings" section in the KeyRemap4MacBook documentation for instructions on what to do with the private.xml file (except replace the file instead of editing the original one with a text editor).