Freezing/Splitiing Cells

[andrewb90]

Hello All,

I have been searching for answers to this and have not found anything helpful, so I am not sure if what I want is doable, but I'll see if anybody has some good Ideas. In the range A2:D18 I have some information I would like on the screen at all times. The user part of the worksheet is in columns E:L and it goes down to row 1000. Now I would like to be able to scroll down through the rows, while still keeping that data visible, but I do not want the first 18 rows frozen above. This takes up too much of the screen.

Thanks,

Andrew

 

[Jerry Sullivan]

Hi Andrew,

From the View Tab of the Ribbon you could make a New Window then Arrange All > Vertical to show two windows for the same worksheet side by side.

Resize the windows to make the one with A2:D18 as small as possible (you can even change the zoom of that window to make it smaller than cells in the window showing E:L).

 

[andrewb90]

Hi Jerry,

Thanks for the idea, but it's not exactly what I am looking for. The person using the worksheet would get confused with 2 windows. Plus when you switch to a different sheet, you would need to do that in both windows, and the same thing would apply to running any macros.

 

[Peter_SSs]

Try using the Watch Window

 

[Rick Rothstein]

Another possibility... press ALT+WNWAT+Enter to create a copy of the worksheet and tile it. Now, resize one of the windows to display A2:D18 and resize the other window to fill the remainder of the Excel window.

 

[Peter_SSs]

Another possibility...

As opposed to Jerry's possibility?

 

[Rick Rothstein]

As opposed to Jerry's possibility?

I guess I read over his message just a little bit too quickly, didn't I?

 

[Jerry Sullivan]

Peter, I've never tried the Watch Window before. I like the way it can be docked or floating modeless; however seeing the values in list form next to the addresses would take some getting used to.

Thanks for sharing that, and for keeping Rick on his toes.

 

[Peter_SSs]

Peter, I've never tried the Watch Window before. I like the way it can be docked or floating modeless; however seeing the values in list form next to the addresses would take some getting used to.

I must admit I have not used it much, partly because of its layout and generally go for FreezePanes or (less often) a Split Window. However, its layout is what makes it useful, particularly if you want to watch cells that are spread throughout the sheet, workbook, or workbooks.

 

[andrewb90]

Try using the Watch Window

This sounds like you would have to select what cells you need each time you select a new sheet. Additionally, the user would have to setup the watch window right? Sadly the person using my sheet will not be able/willing to do that.