Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lock-out rows from scrolling
how to lock an upper set of consecutive rows to remain visible while the
rows below them scroll out of view? example: rows 1-5 always visible rows 6-bottom scroll up "behind" rows 1-5 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lock-out rows from scrolling
John,
Select cell A6 Window/Split Window/Freeze Panes Depending on what cell you're on when you do this, you can lock the lefthand columns too. John John A Grandy wrote: how to lock an upper set of consecutive rows to remain visible while the rows below them scroll out of view? example: rows 1-5 always visible rows 6-bottom scroll up "behind" rows 1-5 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
lock-out rows from scrolling
manually:
Select cell A6 (or another cell in row 6 if you want to lock in column(s) too). Choose Window/Freeze Panes Programmatically (since this is the programming group): Range("A6").Select ActiveWindow.FreezePanes = True In article , "John A Grandy" wrote: how to lock an upper set of consecutive rows to remain visible while the rows below them scroll out of view? example: rows 1-5 always visible rows 6-bottom scroll up "behind" rows 1-5 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
lock-out rows from scrolling
John
No need for Window/Split. Freeze Panes will suffice. Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Sat, 12 Jul 2003 18:08:58 -0400, John Wilson wrote: John, Select cell A6 Window/Split Window/Freeze Panes Depending on what cell you're on when you do this, you can lock the lefthand columns too. John John A Grandy wrote: how to lock an upper set of consecutive rows to remain visible while the rows below them scroll out of view? example: rows 1-5 always visible rows 6-bottom scroll up "behind" rows 1-5 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
lock-out rows from scrolling
Gord,
I've been using that Split/Freeze sequence ever since I started using Excel and have no idea why I started doing it that way. For some reason, I thought that's how it had to be done. Oh well, learned something new yet again. Thanks, John Gord Dibben wrote: John No need for Window/Split. Freeze Panes will suffice. Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Sat, 12 Jul 2003 18:08:58 -0400, John Wilson wrote: John, Select cell A6 Window/Split Window/Freeze Panes Depending on what cell you're on when you do this, you can lock the lefthand columns too. John John A Grandy wrote: how to lock an upper set of consecutive rows to remain visible while the rows below them scroll out of view? example: rows 1-5 always visible rows 6-bottom scroll up "behind" rows 1-5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lock scrolling? | Excel Discussion (Misc queries) | |||
How do I lock a screen to prevent scrolling? | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
How do I lock options and scrolling in Excel? | Excel Discussion (Misc queries) | |||
how to lock a row so that it stays on top when scrolling | Excel Discussion (Misc queries) |