SOLVED

HEEELP: Shortcut to jump to precedent (Ctrl+[) not working

Copper Contributor

Hi there, I just changed computer and the shortcut "jump to referenced cell" Ctrl+[ does not work. I'm desperate because this is a very common function I use as I constantly audit formulas.  

 

Any suggested solution?

Thanks

1 Reply
best response confirmed by Risperio (Copper Contributor)
Solution

@Risperio 

 

It's frustrating when a commonly used shortcut stops working. Let's troubleshoot this issue and try to resolve it:

  1. Check the Keyboard Language Settings:
    • Make sure that the keyboard language settings on your new computer match the settings on your previous computer. Inconsistent settings might cause some shortcuts to behave differently.
  2. Test the Shortcut in a Different Workbook:
    • Open a new workbook and test the Ctrl+[ shortcut. If it works in the new workbook, there might be an issue with the specific workbook you are working on.
  3. Check Excel Options:
    • Open Excel and go to the "File" tab.
    • Click on "Options" and navigate to the "Formulas" category.
    • Ensure that the "Transition formula evaluation" option is checked.
  4. Custom Shortcut Conflict:
    • Check if there are any custom shortcuts that conflict with Ctrl+[.
    • Go to "File" > "Options" > "Quick Access Toolbar."
    • Check if any other function is assigned to the same shortcut.
  5. Update or Repair Microsoft Office:
    • Make sure that your Microsoft Office installation is up to date. You can check for updates in the "File" tab under "Account."
    • If updating doesn't resolve the issue, you may consider repairing your Office installation.
  6. Check Regional and Language Settings:
    • Ensure that your computer's regional and language settings are correctly configured.
  7. Test on a Different User Profile:
    • If possible, test the Ctrl+[ shortcut on a different user profile on your computer to see if the issue is user-specific.
  8. External Software Interference:
    • Check if any third-party software or antivirus programs are interfering with Excel shortcuts.
  9. Try a Different Shortcut:
    • If Ctrl+[ continues to be problematic, you might consider using the "Trace Precedents" button in the "Formulas" tab as an alternative.

If none of the above solutions work, please provide more details about the version of Excel you are using, the operating system, and any recent changes or updates to your system. The steps were created with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.

1 best response

Accepted Solutions
best response confirmed by Risperio (Copper Contributor)
Solution

@Risperio 

 

It's frustrating when a commonly used shortcut stops working. Let's troubleshoot this issue and try to resolve it:

  1. Check the Keyboard Language Settings:
    • Make sure that the keyboard language settings on your new computer match the settings on your previous computer. Inconsistent settings might cause some shortcuts to behave differently.
  2. Test the Shortcut in a Different Workbook:
    • Open a new workbook and test the Ctrl+[ shortcut. If it works in the new workbook, there might be an issue with the specific workbook you are working on.
  3. Check Excel Options:
    • Open Excel and go to the "File" tab.
    • Click on "Options" and navigate to the "Formulas" category.
    • Ensure that the "Transition formula evaluation" option is checked.
  4. Custom Shortcut Conflict:
    • Check if there are any custom shortcuts that conflict with Ctrl+[.
    • Go to "File" > "Options" > "Quick Access Toolbar."
    • Check if any other function is assigned to the same shortcut.
  5. Update or Repair Microsoft Office:
    • Make sure that your Microsoft Office installation is up to date. You can check for updates in the "File" tab under "Account."
    • If updating doesn't resolve the issue, you may consider repairing your Office installation.
  6. Check Regional and Language Settings:
    • Ensure that your computer's regional and language settings are correctly configured.
  7. Test on a Different User Profile:
    • If possible, test the Ctrl+[ shortcut on a different user profile on your computer to see if the issue is user-specific.
  8. External Software Interference:
    • Check if any third-party software or antivirus programs are interfering with Excel shortcuts.
  9. Try a Different Shortcut:
    • If Ctrl+[ continues to be problematic, you might consider using the "Trace Precedents" button in the "Formulas" tab as an alternative.

If none of the above solutions work, please provide more details about the version of Excel you are using, the operating system, and any recent changes or updates to your system. The steps were created with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.

View solution in original post