Add or Remove the Ability to Expand or Collapse Items You can add or remove the ability to expand and collapse items on a report. To add or remove this ability, complete the following steps: Click the Options tab. In the Show/Hide group, click +/- Buttons. Parent Topic: Procedures - Formatting Custom Reports in Excel