E
Elle Tee
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?
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?