Freezing/Splitiing Cells

andrewb90

Well-known Member
Joined
Dec 16, 2009
Messages
1,067
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

MrExcel MVP
Joined
Mar 18, 2010
Messages
8,787
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

Well-known Member
Joined
Dec 16, 2009
Messages
1,067
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.
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,511
Office Version
2010
Platform
Windows
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.
 

Jerry Sullivan

MrExcel MVP
Joined
Mar 18, 2010
Messages
8,787
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,309
Office Version
365
Platform
Windows
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

Well-known Member
Joined
Dec 16, 2009
Messages
1,067
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.
 

Forum statistics

Threads
1,082,478
Messages
5,365,783
Members
400,850
Latest member
Raj_Jpr

Some videos you may like

This Week's Hot Topics

Top