Forum Discussion
Problems with scrolling tables
Georgepc22 I found an example on line that uses a scroll bar and OFFSET.
https://www.bluepecantraining.com/create-a-scrolling-table-in-excel/
That's probably what you are trying to use as well. Since you mention to have Office365, use a structured table in combination with a spinner (or scroll bar) and the FILTER function. Then, the filtered data range will expand automatically and you don't get the zero's like when using the OFFSET function when you set the maximum number beyond the current size of the data set. See attached, in Sheet1. The other sheets are from the on-line source.
Georgepc22 I found an example on line that uses a scroll bar and OFFSET.
https://www.bluepecantraining.com/create-a-scrolling-table-in-excel/
That's probably what you are trying to use as well. Since you mention to have Office365, use a structured table in combination with a spinner (or scroll bar) and the FILTER function. Then, the filtered data range will expand automatically and you don't get the zero's like when using the OFFSET function when you set the maximum number beyond the current size of the data set. See attached, in Sheet1. The other sheets are from the on-line source.
- Thank you Mr. Riny van Eekelen, helps a lot working with the structured table. the FILTER function is very good too.
