Forum Discussion

Hannah31's avatar
Hannah31
Copper Contributor
Mar 11, 2020

Excel on a Mac cell reference

I'm working with multiple sheets in the same workbook, and when I click in the formula bar of a cell referencing a cell in another sheet it should take me to that sheet so I can confirm I'm pulling the correct cell, but it does not. When I click in the formula bar it just shows me the text and doesn't take me to that sheet. I need to be able to confirm without actually having to go to each sheet and look up the cell individually. Please help! On a Windows computer I would check cells like this without problem.

 

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Perhaps if you click the "Fx" button to the left of the formula bar?

Resources