Ctrl + [ not working across sheets

Copper Contributor

Hi, I get the error message "No cells were found" when I try to use Ctrl + ] across sheets, it works for dependents within the same sheet. Weirdly, Ctrl + [ works across different sheets.

 

Also, I ensured that the referencing was correct, workbook is set to automatic calculation mode, no circular references, and the worksheet is unprotected. 

 

Thanks in advance!

SPJKK_0-1710953827403.png

 

1 Reply
Control+] only works for cells on the same sheet. To get off-sheet references, click the Dependents button on the ribbon and then double-click the dashed arrow.