Posted: 5/5/2010 4:15:04 PM EDT
| is it possible to freeze both the horizontal and vertical cells at the same time? |
|
Quoted: Quoted: Yes. Instead of selecting a row or column, just select a single cell at the freeze point and then freeze the pane. yea that just freezes a big square in the top right of the sheet unless i did something wrong At the top of the vertical scroll bar is a small horizontal block that you can use to turn the scroll bar into two scroll bars. When you do this, then freeze panes, it locks the top few rows on the screen. I don't think you can easily do the same thing on the horizontal scroll. You can use VBA to define a scroll zone, but it doesn't work as well as you'd like. |
|
Quoted:
Quoted:
Yes. Instead of selecting a row or column, just select a single cell at the freeze point and then freeze the pane. yea that just freezes a big square in the top right of the sheet unless i did something wrong You need to pick a cell other than A1. |
|
Quoted:
Quoted:
Quoted:
Yes. Instead of selecting a row or column, just select a single cell at the freeze point and then freeze the pane. yea that just freezes a big square in the top right of the sheet unless i did something wrong You need to pick a cell other than A1. This. It works fine when I do it on my 'puter. -SleeperShooter |