Help on Microsoft Excel (on Mac) please!

Discussion in 'Mac Apps and Mac App Store' started by MXM, Jun 24, 2009.

  1. MXM macrumors member

    May 23, 2009
    Does anyone know if there are key shortcuts for the following functions?

    1). changing a cell reference in a formula to $..$ (e.g. $A$1) format. When I copy a formula containing this cell, this cell will be treated as "absolute" i.e. its value won't be changed following the change of column or row etc. In windows, I can type A1 and then press F4 to turn "A1" to "$A$1"

    2). recalculate the whole sheet. In windows, I can press F9

    The problem with these key shortcuts is that they've been used by Mac already and I can't find a way to reset them.

    Thanks a lot!
  2. BobZune macrumors 6502a

    Oct 26, 2007

Share This Page