ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to fix a number of rows below the selected cells? (https://www.excelbanter.com/excel-discussion-misc-queries/258361-how-fix-number-rows-below-selected-cells.html)

sk

How to fix a number of rows below the selected cells?
 
I am working with Excel such that I need to see the values 10 rows below the
current selected cell.

But whenever I proceed down the worksheet, I eventually left with last row
on the screen before the worksheet scrolls and stay there.

How can I set a minimum number of rows to always appear below my selected
cell?

Currently the scroll lock has the desired effect, only the scroll lock never
move the selected cells in response to the keyboard.


All times are GMT +1. The time now is 06:52 AM.

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