Slider

How to Quick Hide or Unhide Rows/Columns in Excel

Date:2019-7-17 Author:Cordelia

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.

How to Quick Hide or Unhide Rows/Columns in Excel

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.

How to Quick Hide or Unhide Rows/Columns in Excel

Right-click selected area and choose Hide in the menu.

How to Quick Hide or Unhide Rows/Columns in Excel

Then these 3 columns will be hidden while a mark with double vertical lines appears.

How to Quick Hide or Unhide Rows/Columns in Excel

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.

How to Quick Hide or Unhide Rows/Columns in Excel

Then these previously hidden columns will show again.

How to Quick Hide or Unhide Rows/Columns in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *