While editing a table in Excel, there may be some less important content you can't delete but also don't need to keep an eye on all the time. Hiding these rows or columns could make the table looks more compact without substantial impact for the data, and that's exactly what I want to share in this post.
Take this table as an example. If I only want to compare the price and profit of each product, I can totally hide column C, column D and column E.
Select them by dragging the cursor from C to E in the area of column header, or you can hold down Ctrl key and click C, D and E in the column header separately.
Right-click selected area and choose Hide in the menu.
Then these 3 columns will be hidden while a mark with double vertical lines appears.
To view these columns again, just select the columns on both sides of the mark (In my case they are column B and column F). Right click your mouse and choose Unhide.
Then these previously hidden columns will show again.