When you click the minus sign, those columns will be temporarily hidden, and the minus sign turns into a plus sign (+), which you can click to re-expand those columns. How to Create Subgroups in Excel ...

To unhide or hide multiple rows and columns in Excel, you need to follow the same method as above. That said, you need to choose the columns or rows, right-click on it and select the Hide option.

You can also click the minus (-) button to remove the column action entirely, and start over by creating a new instruction. Click the plus (+) button and then "Options…" to specify ordering by row.

To hide row 5, click the minus sign. (You can also click the Hide Detail icon in the Outline group.) We hid a row, but using the same technique, you can hide a block of rows, or a single column or ...