To configure Excel Connector add-in, please open "Settings" (1)
Directly after clicking it, you should notice a prompt (2)
Settings prompt is divided into four sections:
...
When you disable "Resize columns automatically", then the columns width will not be adjusted automatically, so similar view as above is to be present (1↖).
"Group subtasks and parents automatically" enables to present subtasks in a cloaked or uncloaked way so that you know certain issue is connected with other(s). When this option is enabled then you get such view:
...
It can be changed (cloaked/uncloaked) for all grouped subtasks and parents by one click on a square with "one" or "two" present as a digit (1↖) or manually for a particular one(s) - thos emarked with "+" sign(2↖)
After pressing + sign you can see which issue type is linked to a subtask:
...