How do you hide some rows or columns without applying filter in MS Excel?
Rajesh Pathak
There are two ways to hide row or columns.

First method is to select the target rows or columns that you want to hide, right click on any of the selected row or column, and then click on 'hide'. Selected rows or columns will be hidden from normal view.

Second method is to use 'Group' feature of Excel which you can find in 'data' ribbon tab. To do so, first select the target rows or columns that you want to hide. Then go to 'data' ribbon tab. In outline group, you will find 'group'. Click on group. Excel will show minus sign. Click on that. Selected rows or columns will be hidden from normal view. Click on plus sign to view the hidden rows or columns.

Homepage​​​
MS EXCEL TRAINING​​​