I have a spreadsheet that contains 200 Rows for data entry (and several columns) - ideally I only want to show 20 lines at a time. Can a scroll bar embedded into the spreadsheet allow me to do this - if so how can this be achieve.
Firstly welcome to the Chandoo's forum. Its really easy using offset() formula. See this file. The scroll bar is connected to a cell, the cell's value is used to determine to offset row.
