Professor Excel

Comments 1

  1. Chris

    Thanks for the tutorial and VBA samples. Do you have any recommendations on speeding up a file during expand all or collapse all on groups? I have a spreadsheet with 835 columns that are grouped in sections of roughly 5-20 columns. I can expand/collapse individual sections without a problem, but when I try to expand all or collapse all it takes forever and the file appears to the user that it is locked up. Any ideas on how to speed it up?

Leave a comment