I inherited a huge spreadsheet and if I filter part of it, I can only scroll
at turtle speed. One querk about this spreadsheet is that column A is a
list, then based on the results of A, Columns B to L are indirect lists that
will give a different dropdown based on A. My major slow down is when the
auto filter is on, when I try to arrow over to the right, it takes 10 seconds
to go past each cell. Any ideas on how to fix this or speed up?