• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cmd+T does not work for toggling absolute/relative in Excel Mac 2008

M

mymeeshell

New Member
I know that Cmd+T can be used as an equivalent to F4 in a PC to toggle absolute vs. relative cell references. However, even when I am in edit mode, if I click command + T, nothing happens. It just stays the same. It doesn't seem that this shortcut is assigned to any function at all.

My question is, has anyone else experienced this and 2) can I manually assign a shortcut to this function? After looking through "Customize Keyboard" where you set up shortcuts, I don't really see anything that refers to the absolute toggle. How is it referred to? Can you even find it in the Customize Keyboard section?

Thanks in advance to the community!
 
I assume by Command + T you mean Press
314f2d55-e8b8-4417-9d4b-b3908c1ebd0c.gif
+ T ?

That is the correct keyboard shortcut
https://support.office.com/en-us/ar...ferences-981f5871-7864-42cc-b3f0-41ffa10cc6fc

The cursor has to be on or next to the Reference for it to work

Have you installed any other software that could have grabbed the
314f2d55-e8b8-4417-9d4b-b3908c1ebd0c.gif
+ T combination as a keyboard shortcut, I am thinking like Screen Capture utils etc
 
Thank you Hui! I didn't know that you had to put the cursor inside/next to the reference. I had a very long formula and so just had my cursor toward the beginning, which explains why it wasn't having any effect. Thanks again!
 
Each reference is seperate and can be toggled individually to suit your needs
 
You must log in or register to reply here.
Back
Top