Skip navigation
This discussion is archived

How do I set up Keyboard shortcuts to match Windows Excel?

2880 Views 3 Replies Latest reply: May 21, 2010 8:44 AM by KOENIG Yvan RSS
DJH2007 Level 1 Level 1 (10 points)
Currently Being Moderated
May 21, 2010 4:59 AM
At work I use MS Excel on Windows and I use the keyboard shortcuts a lot.

eg. Alt+= for sum the cells above
Alt+I, Alt+R for insert a row
Alt+D for downfill

How do I set this up on iWork numbers?

Also, where could I go to find out how to do this on MS Excel 2008 for Mac?

Thanks,
iPhone 3GS 16GB (3.1) / iMac 2.8ghz 3GB/ MBP 13" 2009, Mac OS X (10.6), 2xAE(g) 1xAE(n) 1xAEBS (dual band)
  • Level 8 Level 8 (41,760 points)
    You take care of what is written in the available System's Help :



    Every existing menu item may be given a shortcut.

    Such menu items are available in the menu "Table":
    Table > Add Row Above ( already alt + up_arrow)
    Table > Add Row Below ( already alt + down_arrow)
    Table > Add Column Before ( already alt + left_arrow)
    Table > Add Column After ( already alt + right_arrow)

    Sum is available as Insert > Function > Sum

    Fill down is available as Insert > Fill > Fill Down

    Yvan KOENIG (VALLAURIS, France) vendredi 21 mai 2010 14:38:07
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
  • Badunit Level 6 Level 6 (10,760 points)
    As Yvan said, it is in the help files. The procedure is

    1) Open System Preferences and navigate to the Keyboard section then keyboard shortcuts.
    2) Hit the + to add a new shortcut
    3) Having it apply to All Applications is the default. You may want to use that because otherwise you'll have to do this once for Numbers and once for Excel. On the other hand, it might screw up an existing shortcut in another application if you are using a key combination assigned to something else in that application.
    4) Type in the menu title EXACTLY as it is in the menu. Capitalization and punctuation are important. You don't need to put Insert/Function/Sum, just Sum.
    5) Choose a key combination. Note that some key combinations cannot be reassigned. For instance, Alt+ (actually this is Option=) does not work; it inserts a not equal to symbol. Nor does Command+ (Command=) because it is assigned by Numbers to something else. Control+ will work. You can, however, make a different shortcut for the existing Command= shortcut (Format/Font/Bigger) so there is no conflict.
    6) Click Add.

    Message was edited by: Badunit
    Mac Pro 2008, Mac OS X (10.5.6)
  • Level 8 Level 8 (41,760 points)
    Here are my own shortcuts :



    In the descriptions saved in the Preferences file,
    @ means : command key
    ~ means : alt key (French keyboards) option key (English keyboards)
    $ means : shift key
    ^ means : control key

    Graphical symbols are the navigation arrows.

    Yvan KOENIG (VALLAURIS, France) vendredi 21 mai 2010 17:43:14
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.