Question

In Excel if you want to hide some rows or columns without applying filter then what will you do? ? Answer guys ❤❤✌✌

Answer 1

Click /select the column which you want to hide. Right click and then select the option to hide. The column will hide and show only single to indicate that the column is hidden. To unhide, select the column showing single line, right click and then click on unhide.

In a similar way, we can do the same for row. Select the row and then right click and then click on hide and unhide accordingly.