How to Hide Columns and Rows in Excel . Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide.

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 ...

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.