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?
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
"Ken Jarvis" <Ken [email protected]> wrote in
message
news:[email protected]...
>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?
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
"Chip Pearson" <[email protected]> wrote in message
news:[email protected]...
> 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 [email protected]> wrote in
> message
> news:[email protected]...
>>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?
>
>
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?".
"Ken Jarvis" wrote:
> 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?
I believe this is supposed to be ctrl+F6
"Gary L Brown" <gary_brown@ge_NOSPAM.com> wrote in message
news:[email protected]...
> 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?".
>
>
> "Ken Jarvis" wrote:
>
>> 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?
Nope. You were correct Gary. Ctrl+F6 will switch between excel windows.
Paul
"PCLIVE" <[email protected]> wrote in message
news:[email protected]...
>I believe this is supposed to be ctrl+F6
>
> "Gary L Brown" <gary_brown@ge_NOSPAM.com> wrote in message
> news:[email protected]...
>> 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?".
>>
>>
>> "Ken Jarvis" wrote:
>>
>>> 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?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks