Forum Discussion
Shortcut to jump to formula bar in Excel 365
I would like to know if there is a keyboard shortcut to jump to the formula bar in MS Excel 365.
The shortcut used to be F2 + Ctrl A in previous versions of Excel, but it is no longer working in Excel 365.
I know that I could turn off "Allow editing directly in cells", but that is not what I'm looking for. I want to edit formulas directly in the cell, but be able to switch to the formula bar if needed.
Would really appreciate it if someone could help me out with this one.
Thanks!
8 Replies
If the cell is empty, F2 to edit cell, followed by Ctrl+A to add "=" and jump to formula bar.
If the cell is not empty, F2 to edit cell, followed by Ctrl+F2 to jump to formula bar.F2, followed by Ctrl+F2 also works on a blank cell but it will not add the "=".
Version info: Microsoft 365 Excel version 2505 (Build 18827.20140)If the cell is empty, F2 to edit cell, followed by Ctrl+A to add "=" and jump to formula bar.
If the cell is not empty, F2 to edit cell, followed by Ctrl+F2 to jump to formula bar.F2, followed by Ctrl+F2 also works on a blank cell but it will not add the "=".
Version info: Microsoft 365 Excel version 2505 (Build 18827.20140)- Lets vote! https://feedbackportal.microsoft.com/feedback/idea/5e019432-db31-ee11-a81c-6045bd8534ad
shipen770, in my laptop, Fn+F2 followed by Ctrl-A is working in Excel 365, desktop version. However, it only works in empty cells. Also, it starts the new cell with an equal sign, which is not what I always want. But it is the only way I found to jump to the formula bar without using the mouse.
There currently doesn't seem to be a keyboard shortcut for that. You might use File > Feedback to submit a suggestion or send a frown.
- Thanks for the answer, Hans. I've sent feedback from the app. Let's hope the developing team takes my suggestion into consideration. In the meanwhile, if anyone happens to know if the functionality has migrated to another shortcut, please let me know, I would really appreciate it.
Thanks!F2 will take you to editing in cell directly. Then if you edit formula, starting with "=" do Ctrl-Home followed by Ctrl-A
