Forum Discussion

SPJKK's avatar
SPJKK
Copper Contributor
Mar 20, 2024

Ctrl + [ not working across sheets

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!

 

excel
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Mar 21, 2024
    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.

Resources