Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Can I use VBA to freeze detached horizontal and vertical panes?
For example, is it possible to force Excel to freeze-pane Columns A:B, Columns Z:Y: and Rows 1:2 ?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If I try and put additional arguments into the cell select to freeze A:B & Y:Z and rows 1:2 I get a too many arguments error.
Again, I'm trying to freeze A:B, Y:Z, AND rows 1:2 simultaneously.....
It would be like Selecting cell C3 and AA3 and then freezing panes. Basically if a user were to scroll to the right past Y:Z both A:B and Y:Z would appear on the left side of the screen.
Again, I'm trying to freeze A:B, Y:Z, AND rows 1:2 simultaneously.....
It would be like Selecting cell C3 and AA3 and then freezing panes. Basically if a user were to scroll to the right past Y:Z both A:B and Y:Z would appear on the left side of the screen.
No, you cannot do that. You can select either the leftmost columns or the topmost rows or both. Any other selection does not apply to freezing
You could get round it with a manual tweak.
In the View tab select new Window and then Arrange All and choose Vertical and tick box for Windows of Active Workbook.
This will show the same sheet twice. Resize the left hand Window so that you can see only columns A & B and stretch the right hand window to fill the rest of the screen. Scroll the right hand window so that column Y is first column on sheet and then select AA3 and apply Freeze Panes.
In the View tab now select "View Side by Side" and "Synchronous Scrolling". The two windows will now scroll vertically in sync and to an extent horizontally; scrolling right on the Right hand pane won't scroll the left hand pane until after several scrolls.
Thanks
Rob H
In the View tab select new Window and then Arrange All and choose Vertical and tick box for Windows of Active Workbook.
This will show the same sheet twice. Resize the left hand Window so that you can see only columns A & B and stretch the right hand window to fill the rest of the screen. Scroll the right hand window so that column Y is first column on sheet and then select AA3 and apply Freeze Panes.
In the View tab now select "View Side by Side" and "Synchronous Scrolling". The two windows will now scroll vertically in sync and to an extent horizontally; scrolling right on the Right hand pane won't scroll the left hand pane until after several scrolls.
Thanks
Rob H
Premium Content
You need an Expert Office subscription to comment.Start Free Trial