Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Quick Hide or Unhide Rows and Columns in MS Excel

Date:2020-4-13 Author:Cordelia

When editing data in Excel spreadsheet, 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 hide column C, column D and column E.

How to Quick Hide or Unhide Rows and Columns in MS Excel

1. Select these columns 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 on the column header separately.

How to Quick Hide or Unhide Rows and Columns in MS Excel

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

How to Quick Hide or Unhide Rows and Columns in MS Excel

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

How to Quick Hide or Unhide Rows and Columns in MS Excel

4. 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 and Columns in MS Excel

5. Then these previously hidden columns will show again.

How to Quick Hide or Unhide Rows and Columns in MS Excel

You can also hide/unhide specific rows in the similar way.

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 *