Why is there no Menu item or Ribbon button for toggling between relative and absolute?
Yesterday, I spent a good 2 hours trying to change a table's references from relative to absolute. I couldn't find any Menu item or Ribbon button to perform this action, so had to resort to Google.
That lead me to the support.office.com page for Mac keyboard shortcuts (https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd), which told me that I could use CMD+T (which creates a table) or F4 (which is a Redo shortcut).
So I called 365 support, where I hand to help the agent understand how to use several aspects of Excel (nothing is more frustrating than talking to an "expert" who knows less than I do), and she kept insisting CMD+T and F4 were the keystrokes to do what I wanted to do.
After going around in circles with her for 30 minutes — "No, sir. You need to use CMD+T or F4." "No, those create a table and Redo." Isn't there a button somewhere on a Ribbon for this function." "No, sir. You need to use CMD+T or F4." — I finally stumbled onto the fact that CMD+T and F4 do work, but only if you've double-clicked the cell and highlighted the formula. Those two keystrokes perform completely different actions depending on whether you're inside the cell, or have just selected the cell.
Really, Microsoft? Really?!?
Why isn't there a button in the Formulas toolbar to toggle relative/absolute/mixed? Why are users required to somehow just know a keyboard shortcut to perform this action?
And why does it only work when inside the cell?