How do I JUMP from pane 1 to Pane 2?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I split a worksheet into 2 panes.
Pane 1
Pane 2
What keyboard keystrokes can I use to JUMP from
pane 1 to pane 2?
 
As far as I know, there is no shortcut key for this. You could
assign the following macro to a shortcut key:

Sub SwapPanes()
If ActiveWindow.ActivePane.Index = 1 Then
ActiveWindow.Panes(2).Activate
Else
ActiveWindow.Panes(1).Activate
End If
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...
 
A bit more robust:

Sub SwapPanes()
If ActiveWindow.Panes.Count > 1 Then
If ActiveWindow.ActivePane.Index = 1 Then
ActiveWindow.Panes(2).Activate
Else
ActiveWindow.Panes(1).Activate
End If
End If
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I believe this is supposed to be ctrl+F6

Gary L Brown said:
F6 and Shift-F6
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".
Click to expand...
 
Nope. You were correct Gary. Ctrl+F6 will switch between excel windows.
Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Freeze Panes loss 3
Un-Synchronous Panes 3
How do I stop Excel from automatically resizing my row height? 0
How do I NOT get synchronous scrolling in multiple panes in Excel 2
User controlled Freeze Pane while protected 3
Excel filtering of split panes 1
Text search and "Go To"... 1
Freeze Panes 8

Back
Top