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!



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.