Share via

PROBLEM: Jump To A Cell Reference Within An Excel Formula

Anonymous
2024-04-23T22:34:15+00:00

Hello,

Is there a way to follow formulas to referenced cells similar to CTRL+ [ in Excel? The shortcut is not working. I changed the keyboard language but without sucess. I appreciate any help.

Microsoft 365 and Office | Excel | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2024-04-25T03:12:27+00:00

    Hello, Markus G1

    Ctrl+[ is a valid keyboard shortcut to trace cell references in Excel for Microsoft 365 on Windows. However, it doesn't work in the web version of Excel.

    Yuhao Li

    Microsoft Community Technical Support

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2024-04-24T10:53:16+00:00

    Thanks very much but the technical team has already isolated the issue. It is not a technical problem with the software etc. It is rather a purely functional problem. Is it possible to get the shortcut with a certain add-in or a specific software version?

    2 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2024-04-24T07:10:06+00:00

    Hello, Markus G1

    Welcome to Microsoft Community.

    If you're using Excel on the web, this shortcut may not be available. Excel on the web has a more limited set of keyboard shortcuts compared to the desktop application. Some shortcuts might not work if they're not supported in the web version, or they might work differently depending on the browser you're using. If you frequently need to use this feature, you might find it more convenient to use the Excel desktop application. If that's not an option, you can manually click on the cell references in the formula bar to navigate to the referenced cells.

    Ctrl+[ is a shortcut key used in Excel to trace cell references. For Excel desktop version, you can use the built-in option in Excel called "Trace Dependents" to accomplish this task instead. Select the cell that contains the formula for which you want to find precedent cells. To display a tracer arrow to each cell that directly provides data to the active cell, on the Formulas tab, in the Formula Auditing group, click Trace Precedents **** . Details about this option can be found here:

    Display the relationships between formulas and cells - Microsoft Support

    Yuhao Li

    Microsoft Community Technical Support

    1 person found this answer helpful.
    0 comments No comments