Share via

What is Mac equivalent of the F4 shortcut that converts cell references, ie B5 to $B$5

Anonymous
2011-12-08T18:58:24+00:00

Hello,

When using Excel in Windows, I frequently use the F4 key to convert a cell reference from... for example... B5 to $B$5.

However, I can't find any shortcut that does the same thing in Excel for the Mac.

In Windows, the steps are like this....

  1. using a mouse, click on any cell where you want data to be displayed.
  2. type the equals sign
  3. now using the mouse, click on the cell that will be the source of data
  4. Press F4
  5. press enter
  6.  the first cell will now show the reference to the source cell as a constant, with dollar signs before both the letter and the number, as in $B$5

Surely there is an equivalent on the Mac, but I've been unable to find it.

Thank you,

Keith

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

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-07-02T21:20:08+00:00

    In my understanding we have to try to give useful answers and not academic ones. For me the answer is "COMMAND + T" it works fine.

    Thx

    400+ people found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2013-11-09T22:32:48+00:00

    Cmd-T is the ticket.  The other guy was trying to teach us how to fish.  Sometime the fish is faster.

    70+ people found this answer helpful.
    0 comments
  4. Anonymous
    2015-02-03T20:15:02+00:00

    Unless you have changed this in keyboard preference setting:

    You do this you don't have to use the fn Key. 

    _________

    Disclaimer:

    The opinions & replies are solely mine, and do not reflect upon my position as a Community Moderator.

    40+ people found this answer helpful.
    0 comments
  5. Anonymous
    2011-12-08T22:11:49+00:00

    Thank you very much.  It is interesting that wasn't my experience when I searched for "F4" in a number of sources including the two you mentioned and I appreciate your help.

    9 people found this answer helpful.
    0 comments