Many users of Excel have known to use F4 to change relative/absolute references on Excel for Windows. However, as more and more people come to use Office for the Mac, people want the Mac equivalent for some keyboard shortcuts, including relative/absolute cell references. From a student suggestion, the shortcut for Excel for Mac is CMD T. After the reference to the desired cell has been either typed or selected, hit CMD T to toggle between the different ways to make the reference absolute.
Hope this helps someone out.
2 comments:
randomly just helped me out... thanks for posting.
glad it helped.
Post a Comment