How do I JUMP from pane 1 to Pane 2?

K

Ken Jarvis

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?
 
C

Chip Pearson

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]...
 
C

Chip Pearson

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
 
P

PCLIVE

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...
 
Top