Slow scroll with auto filter on

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top