Automate Collapse/Expand Areas

Unfortunately, the collapse/expand status of areas can’t be manipulated by advanced controls as of the current release.

The closest thing to an expansion shortcut is trying to use the find feature; it will open all non-password protected areas underneath your current clicked position on the worksheet when you try to find something. But there isn’t a way to (re)collapse them all in one go. (Nor can you multi-select areas and collapse or expand them all at once.)