Keep First Column from Scrolling

**AllanTheCowboy** · 07-11-2015, 08:03 PM

I want Column A not to scroll vertically. It has several summary statistics of the data in Column B, and I want these to remain visible as one scrolls down Column B. So, I want A1-~A20 to remain visible, while the user scrolls down the rest of the page. How can I do this?

**FDibbins** · 07-11-2015, 08:18 PM

If you mean you want rows 1-20 to remain visible at all times, select a cell 1row BELOW where you want them "fixed", click the View tab/windows/freeze panes

If you mean you want A1:A20 fixed, but B1:zz20 etc to be scroll-able, this is not (to my knowledge) possible, not even if you split the screen

**popipipo** · 07-12-2015, 07:10 AM

Maybe this way wil help.

**FDibbins** · 07-12-2015, 10:56 AM

Willem, that still scroll up when you scroll?

**Richard Buttrey** · 07-12-2015, 12:21 PM

Originally Posted by AllanTheCowboy

I want Column A not to scroll vertically. It has several summary statistics of the data in Column B, and I want these to remain visible as one scrolls down Column B. So, I want A1-~A20 to remain visible, while the user scrolls down the rest of the page. How can I do this?

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.