Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I 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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
How do I 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" wrote in message ... 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? |
#4
|
|||
|
|||
How do I JUMP from pane 1 to Pane 2?
|
#5
|
|||
|
|||
How do I JUMP from pane 1 to Pane 2?
I believe this is supposed to be ctrl+F6
"Gary L Brown" wrote in message ... F6 and Shift-F6 HTH, -- Gary Brown 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? |
#6
|
|||
|
|||
How do I JUMP from pane 1 to Pane 2?
Nope. You were correct Gary. Ctrl+F6 will switch between excel windows.
Paul "PCLIVE" wrote in message ... I believe this is supposed to be ctrl+F6 "Gary L Brown" wrote in message ... F6 and Shift-F6 HTH, -- Gary Brown 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change from copy & paste task pane (yuk) to c&p little box | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Discussion (Misc queries) | |||
Remove template help task pane from startup | Excel Discussion (Misc queries) | |||
Task Pane | Setting up and Configuration of Excel | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |