View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default How do I 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


"Ken Jarvis" <Ken wrote in
message
...
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?