Forum Discussion
Switch Panes Using F6 not working
I am using split panes to type a formula and I want to reference something from the top of the worksheet. When I press F6 to send me to the top pane, instead, it is sending me to the bar on the bottom of excel and the top ribbon. It is so frustrating because this worked for me before and now it is not working and is slowing me down greatly. I was wondering if anyone could help? Thank you.
4 Replies
According to the Microsoft document Keyboard shortcuts in Excel (the Windows tab):
F6
- F6 alone: switches between the worksheet, ribbon, task pane, and Zoom controls. In a worksheet that has been split, F6 includes the split panes when switching between panes and the ribbon area.
- Shift+F6: switches between the worksheet, Zoom controls, task pane, and ribbon.
- Ctrl+F6: switches between two Excel windows.
- Ctrl+Shift+F6: switches between all Excel windows.
Maybe the list of destinations has included the ribbon, etc., for some time (and you did not realize this because the sequence started with "other pane"), but the sequence of destinations has perhaps recently changed. (?)
Use Ctrl + Page Up / Page Down to switch between worksheet panes. Or, click directly on the pane you want to activate.
Thank you for your reply, the Ctrl method unfortunately didn't work and using the mouse would be the last resort. I appreciate the help and have a good day.
Hey CeeJayFTS18 - did you ever find a solution to this? Experiencing the same problem now. Let me know if you have - would appreciate if you could share. Thanks!
