Share via

need to lock a cell, in Excel 2010 used key F4, what to use in Excel 2011

Anonymous
2012-09-29T19:47:22+00:00

I need to lock a cell and in a PC I used key F4 and it made §marks for that cell. But what makes that same in Mac?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2012-09-29T21:24:33+00:00

    To clarify, this question has nothing to do with "lock a cell" -- In Excel that term has an explicit meaning.

    What you're looking to do is express a cell reference as Absolute rather than Relative. In Mac Excel the keystroke for toggling through Relative/Absolute/Mixed references is Command+T, rather than F4. That as well as most other keyboard shortcuts are identified in Excel Help.

    Also (although I suppose it may vary dependent on Regional/Language/Keyboard settings) the symbol used to represent absolute reference to a cell is $ rather than § -- just in case you decide to type it :-)

    8 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest