Select the row/column/cell you want to hide
In the Home tab, under Style, click on Show/Hide icon
Click on eye icon to hide
Using the Show/Hide feature, you can easily hide irrelevant cells, rows and columns.
To hide row/column/cell follow these steps –
Select the row/column/cell you want to hide
In the Home tab, under Style, click on Show/Hide icon
Click on eye icon to hide
To un-hide/show cell follow these steps –
Click on the dropdown to display rows
To un-hide row(s)/ column(s) follow these steps –
In the Home tab, under Style, click on Show and Hide drop down, select Show all rows/ Show all columns
Click on dropdown to show hidden rows/columns