Question about Freezing Panes

[menor59]

Can i have Row A22 Frozen above and row A173 Frozen below which would leave me with Rows A23:A172 as the scrolling area...The scrolling area would be say 20 rows.

Can this be accomplished?

 

[nuked]

No.

 

[menor59]

You would think that would be a feature... my Workbook contains totals from all sheets in the workbook in A1:a23. In range A24:A172 is the sum up of material from the Other worksheets in the workbook. In A173 thats the totals on the said Worksheet. What a shame.

 

[Smitty]

You can hide the rows below what you want to see.

You can also use the Camera tool to fix a dynamic image of the total row.

 

[menor59]

You can hide the rows below what you want to see.

You can also use the Camera tool to fix a dynamic image of the total row.

Hi Smitty,

Never heard of that...how does it work with what im trying to accomplish?

 

[Smitty]

If you goto the QAT options-->More Commends-->All Commands you'll find the Camera tool and you can add it to the QAT. It essentially takes a dynamic snapshot of another sheet or area out of view on the same sheet. It may or may not help with your issue, but it might be worth taking a look at.

 

[menor59]

If you goto the QAT options-->More Commends-->All Commands you'll find the Camera tool and you can add it to the QAT. It essentially takes a dynamic snapshot of another sheet or area out of view on the same sheet. It may or may not help with your issue, but it might be worth taking a look at.

ahh i got it...so is there a way to LOCK it so it stays there where i position it while i scroll up and Down?? i dont want it to move when i scroll

 

[Smitty]

You should be able to right-click it and set it not to Move or Size with Cells.

 

[CodeNinja]

Split the window...

Activerwindow.splitrow = 20

Then display everything at the bottom in the split window while allowing you to freeze the top frame. You can then scroll through the middle with the first window.

 

[menor59]

Split the window...

Activerwindow.splitrow = 20

Then display everything at the bottom in the split window while allowing you to freeze the top frame. You can then scroll through the middle with the first window.

\Sorry code ninja,

im trying to understand how this works...I got the code in..

Activewindow.splitrow = 20

That splits the row.where am i going to freeze the pane, when i do the Split row disappears...maybe im not doing something right...


Please see the attached Jpg, what im trying to accomplish....is there a variant i can use to try to accomplish this goal>???