1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

CTRL + [ shortcut has stopped working

Our take

Navigating legacy spreadsheets can be challenging, especially when they come with outdated formulas and hidden complexities. If you're facing issues with the CTRL + [ shortcut, which should take you to source cells but instead redirects you elsewhere, you're not alone. Many users encounter similar frustrations with long-standing files that require maintenance without a complete rebuild. The F5 shortcut's failure to return to the original cell only adds to the challenge. Let’s explore potential solutions to restore your functionality and streamline your workflow efficiently.

Help me… I have a file that I inherited that is a million years old, but my boss is committed to keeping the same file, same format, just rolling it over year after year after year. As such, there are formula names, references, hidden tabs, all sorts of junk that are clogging up the file and causing me all sorts of issues. I’m muddling through and fixing what I can, but this new issue is a real pain that I need solved asap.

The file has stopped letting me use the CTRL + [ shortcut to go to the source cell - this is now bringing me to the last tab of the workbook.

The F5 shortcut to return to the original cell is also no longer working.

I don’t have the time right now to rebuild this file from scratch, so I’m hoping someone on here knows more about this issue than I do.

Help me r/excel. You’re my only hope.

submitted by /u/miss_kp
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#real-time data collaboration#real-time collaboration#rows.com#AI formula generation techniques#formula generator