keep rows in view

Topic

New Reply

What I need:
Columns A to J; Freeze pane at row 2 so when I scroll down, rows 1 & 2 remain visible.
OK, that is easy.
But I also need to see “columns L to V; rows 1 to 27” [which scrolls off the screen after I scroll past row 27], leaving only rows 1 & 2 from the freeze pane.

Can I split the sheet at column K to either have 2 different freeze panes, split at column K, or just have a vertical split to have 2 vertical scroll bars/areas, one for column A to J and one for columns to the right of column J, so “columns L to V; rows 1 to 27” remain fixed/visible as I scroll down columns A to J past row 27?

Is this possible?

Reply | Quote

Replies

You can set up a couple of windows each with a freeze pane. You can also shlow them side-by-side and sync them if desired

Steve

Reply | Quote

Steve,
Thanks for reply. How would I synch them?

Reply | Quote

In xl2010
View – New Window
Then select “View Side by Side” and “Synchronous Scrolling”

Steve

Reply | Quote

Skipro,

Here is a macro that I recorded then modified to setup the sheet the way you want. I also created a second macro to return to normal view. You can take the macros and add them to the “Quick Access Toolbar” so you can toggle back and forth between views. Note: you may have to adjust the Top, Left, and Height properties in the code for your resolution. I does not matter what the name of the file is, the code adjusts. Just remember that WorkbookName:1 is the main pane while WorkbookName:2 is the added pane. If you close one manually, you should close the added pane. If you close the main pane instead, the once added pane becomes the new main pane and the next time the code is run, the pane will open with the name WorkbookName:3 and the code will fail. If you open and close with the macros, this problem will always be avoided.

35939-ScreenView1

35940-ScreenView2

Code:

Sub DualScreenSetup()
WbName = ThisWorkbook.Name
    [COLOR=”#008000″]’CREATE A NEW PANE AND FORMAT[/COLOR]
    ActiveWindow.WindowState = xlNormal
    ActiveWindow.NewWindow
    With ActiveWindow
        .Top = 0
        .Left = 466.75
        .Width = 493.5
        .Height = 600
    End With
    ActiveWindow.SmallScroll ToRight:=11  [COLOR=”#008000″]’SET TO COLUMN L[/COLOR]
    [COLOR=”#008000″]’FORMAT MAIN PANE[/COLOR]
    Windows(WbName & “:1”).Activate
    Range(“A3”).Select
    With ActiveWindow
        .Top = 0
        .Left = 0
        .Width = 466
        .Height = 600
        .SplitColumn = 0
        .SplitRow = 2
        .SplitColumn = 0
        .SplitRow = 0
    End With
    ActiveWindow.FreezePanes = True
End Sub

Sub SingleScreenSetup()
WbName = ThisWorkbook.Name
     Windows(WbName & “:2”).Activate
     ActiveWindow.Close
     ActiveWindow.WindowState = xlMaximized
     ActiveWindow.FreezePanes = False
End Sub

To add them to the Quick Access Toolbar (QAT),
1. Click on the arrow to the right on the QAT and select More Commands…
2. In the Customize the QAT window, select Macros from the “Choose Commands From:” drop down box.
3. in the selection window, select the macro then click the Add button
4. repeat for the second macro
5. Click OK

35941-ScreenView3

35942-ScreenView4

HTH,
Maud

Reply | Quote

Maud,
How would I get this to split at column “U”?

Reply | Quote

It is splitting after the nth column (20=T) so the U is the first column of the second pane

Reply | Quote

Change the following line to 20

ActiveWindow.SmallScroll ToRight:=11

Reply | Quote

Maud,
I had tried that before and no number change had any effect. Still split at “K”. Got idea to rerun macro manually and that did it. Previously it was just loading the saved file.
Duh..
Thanks.

Reply | Quote