ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Keep the scrollbar at position (https://www.excelbanter.com/excel-programming/331719-keep-scrollbar-position.html)

Man Utd

Keep the scrollbar at position
 
I want the keep the scrollbar at position from cell G5 to G20.
Then when I scroll the scrollbar, it will scroll the cells on its left only.
ie. A5 to the bottom row of the work sheet. But the scrollbar still in the
G5 to G20.



Bob Phillips[_7_]

Keep the scrollbar at position
 
I THINK that you need to select A5, and then goto menu WindowFreeze Panes.

--
HTH

Bob Phillips

"Man Utd" wrote in message
...
I want the keep the scrollbar at position from cell G5 to G20.
Then when I scroll the scrollbar, it will scroll the cells on its left

only.
ie. A5 to the bottom row of the work sheet. But the scrollbar still in the
G5 to G20.






All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com